Results 1 to 2 of 2

Thread: Pastel Partner GRN correction

  1. #1
    New Member
    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
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Morningside, Durban
    Thanked 346 Times in 304 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 - Pastel Accounting Consultant and Photographer
    View Neville Bailey Photography

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

Similar Threads

  1. [Question] Pastel Partner V12.1.6
    By Anita Swart Olivier in forum Accounting Forum
    Replies: 2
    Last Post: 10-May-16, 08:31 AM
  2. Pastel Partner and POS
    By Helizel in forum Accounting Forum
    Replies: 1
    Last Post: 18-Feb-16, 06:35 PM
  3. Pastel Partner to Pastel Express
    By vieome in forum Accounting Forum
    Replies: 2
    Last Post: 19-Feb-13, 12:45 PM
  4. Replies: 2
    Last Post: 14-Apr-11, 11:22 AM
  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