There was some invoices and PO that were for returns that we believe have been processed incorrectly. A receipt was sent back for rework, but credited by a credit note. The credit notes that went on were put on at zero quantity. These seem to have left an amount on the received not yet invoiced report but not show in the GL.
We have now reversed these and put the value on, but it has now flipped so it is in the GL but not on the report.
We would like to know whether this was due to a incorrect posting of returns or why there were imbalances in GL after the following was done to reverse the impact.
One example scenario.
The original invoice
Credit note with zero quantity .Which led the imbalance between GL and GRNI report (GRNI was not tallying)
To correct the GRNI report another invoice was posted with the qty (negative quantity that was missing in the above credit invoice)
Which led to the GL not tallying with GRNI.Is there a way to track why there is a balance in GL regardless of the above actions. Your comments on the above is highly appreciated.
Page 1 / 1
Hello, From this screenshot it is not clear how the first credit note was matched with return. You can see details in “Query-invoiced purchase order” window. You did not mention as well how your part is valuated (and if invoice variance is considered in stock valuation).
Hi,
In general, the answer to the question is yes. If hypothetically, you have AP matching issues the way AP does the matching can have issues with RNI and GL. For example if you have goods received of 10 for 10 per unit that’s 100 value and quantity 10 in goods received. If the matching process changes data (for example price / quantity) they can match 100 yet only affect RNI by a quantity 1. The receipt quantity remains in the RNI report (quantity 10 - 1 or 9). Similarly of we don’t process returns correctly, you can still cause differences.
When processing of the AP invoice and matching, quantity is very important, just as important as the value.
So… Yes, bad processing will / can cause differences. Often times you can see these in the RNI report (for example partial quantities when we know it should have been matched infill).
You can correct GL via manual voucher. You can correct RNI, by going into the receipt and entering a close date. The close date actually removes the receipt from being on the report (no GL effect).
Best regards,
Thomas.
Thanks a lot for your kind advices . I will check.
The customer’s main intention from us to perform an audit as to where it had gone wrong in the returns as they have done many returns and to prevent it happening in the future. This is another order which has a difference. (They will settle the GRNI difference through a voucher)
Is there any way we could find (backtrack) causes as to what had gone wrong in the return flow .
Hello, From this screenshot it is not clear how the first credit note was matched with return. You can see details in “Query-invoiced purchase order” window. You did not mention as well how your part is valuated (and if invoice variance is considered in stock valuation).
You did not mention as well how your part is valuated (and if invoice variance is considered in stock valuation). -I will check it.