We currently have a PO from last year showing up on our Received Not Invoiced report. When looking into it I was able to determine that there isn't a PO Number attached to the receipt and the PO Line Number field is 0 in the POP10500 table. The quantity match for the receipt line in question is 0, with a value of 55 in the quantity shipped and quantity reserved fields.
I have ran Check Lists for Purchasing Transactions, which did not correct our issue. I'm assuming that we'll have to remove the Receipt and perform the 3-way match again?
Any information on how to resolve this and get it off of our RNI report would be greatly appreciated.
*This post is locked for comments
If we have already 3-way matched. Would you suggest creating a new receipt for the line in question and matching the receipt with a dummy invoice? I've discussed with our accounting department and they don't see an issue with performing a return to correctly receive the line that was mistakenly received, but I'm not 100% sure how we should invoice it since it has already been invoiced.
This is quite common in GP..as Mario suggested..we try and fix with the return transaction and receive again. It usually fixes it...although you can run into issues when using lot or serial number tracking
It sounds like someone was in a hurry and entered a receipt without a PO in GP, which is entirely possible. To get rid of this, you will probably want to create a return transaction (Purchasing > Transactions > Returns Transaction Entry) of type Inventory. If you are still expecting an invoice, you can mark the Invoice Expected for Returned Goods checkmark. Then, you would simply select the item, and point to the receipt in question. Post the return to update inventory.
I strongly suggest you take a copy of your production data and restore in a test environment. Complete the procedures above in test as this may have more implications than one. Since this receipt was entered last year, it means now that inventory will be off (or maybe not, depending on your expectations) by the value of the goods being returned. If you already sold or consumed the items received, it will also affect cost of good sold. So please discuss with your accounting team.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156