Results 1 to 2 of 2

Thread: Pastel Partner GRN correction

  1. #1
    Email problem
    Join Date
    Jun 2016
    Cape Town
    Thanked 0 Times in 0 Posts

    Pastel Partner GRN correction

    Hi There

    I have a situation with a client where a GRN was processed at zero cost. When the supplier invoice arrived a second GRN was raised and linked to the supplier invoice. So now the stock items have a larger quantity than they should have and the average costs have been messed up. Plus there have been additional transactions since including where the tried to reverse it at a cost of R1.
    I've attached an inventory sequence where I've shown what the average cost is and what it should be.

    As I see it the only way to fix it is to reverse out the stock quantity and then adjust it back in at the correct average cost. (I know in this example that it's the same cost but I'm just clarifying the principle)
    I would then need to process general journal entries to ensure that the Inventory Control Account agrees with my Inventory Valuation report.

    Is there someone who knows of a better way of doing this so I don't have to process general journals?

    Attached Files Attached Files

  2. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Westville, Durban
    Thanked 452 Times in 397 Posts
    Hi David,

    I can assist you in fixing the problem via the backend of the database, with my database editor. If this is done sooner, rather than later, we can avoid having to fix any further incorrect cost of sales transactions arising from customer invoices processed since the error.

    Please send me an email if you want my assistance and we can take it from there.
    Neville Bailey - Sage Pastel Accounting Consultant
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  3. Thanks given for this post:

    David Irish (27-Oct-16)

Similar Threads

  1. Replies: 3
    Last Post: 19-Jul-18, 11:49 AM
  2. [Question] Pastel Partner V12.1.6
    By Anita Swart Olivier in forum Accounting Forum
    Replies: 2
    Last Post: 10-May-16, 08:31 AM
  3. Pastel Partner and POS
    By Helizel in forum Accounting Forum
    Replies: 1
    Last Post: 18-Feb-16, 06:35 PM
  4. Pastel Partner to Pastel Express
    By vieome in forum Accounting Forum
    Replies: 2
    Last Post: 19-Feb-13, 12:45 PM
  5. [Question] Pastel Partner
    By Goop in forum General Business Forum
    Replies: 5
    Last Post: 15-Aug-10, 06:58 PM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts