Skip to Content
0
Former Member
Nov 08, 2012 at 08:12 PM

Goods Receipt Amount less than Purchase Order Value

4965 Views

Hello,

I apologize if this topic has already been raised/answered, however my search terms returned nothing useful. The problem that has occured is (very) long and (very*100) convoluted. The basic gist is that the Goods Receipt amount was less than the purchase order value. The image below is a spreadsheet I made to recreate what happened.

A purchase order was created and receipted, accounts payable received and paid three invoices (with amounts including tax - 71,582.33 was the total amount of the invoice paid). In Sept purchasing needed to change the value of the purchase order - they unreceipted the PO, and the amount included the tax that was originally on the invoices, so the goods receipt balance was -12,155.49. They changed the purchase order price, re-receipted and the amount came in as 313,918.77, 79% of the total purchase order value (396,687.13). They then needed to change the purchase order price again, un-receipted, changed the amount, re-receipted and it again came to 79% of the total value (397,785.55) which was 314,193.38. Accounts payable then received an invoice for 195,194.05, but MIRO told them they were only able to pay 99,446.38. The difference between the amount of the invoice (195,194.05) and the amount MIRO would allow them to pay (99,446.38) was 95,747.67, which is the difference between the total amount of the PO and the total amount of the GRs (so: 397,785.55 - 302,037.88).

At this point, the issue becomes: 1) how/why did this happen? specifically, why didn't the GRs come in as the total of the purchase order (so 396,687.13 & 397,785.55); 2) how do we keep this from happening again? Is there a configuration change or a programming change that will stop whatever screwed up from doing so again?

Please let me know if you need any clarification, and thank you in advance for your help.

-Alex

Attachments