Notifications
Announcements
No record found.
How do I remove receipts posted thru purchase order without a PO received/ not invoiced report?
*This post is locked for comments
Normally, when a PO Receipt is posted, an entry is made in a table and that record shows on the Received Not Invoiced report. Later, when the Invoice is matched to the receipt, the entry is removed. If you performed a receipt and did NOT match the invoice to the receipt, you have dollars remaining in the Received Not Invoiced GL account as well and this money needs to be removed from that account. You need to find out, if someone posted an invoice without matching, where they expensed the invoice and move the RNI funds to that account since the PO Receipt has already expensed the amount once.
As for the entries in the report, when you close the PO, they will be removed from the report, even if you have not matched the invoices. Closing POs prevents invoice matching and should not be done until the matching is performed normally. However, again if the invoice is already posted without matching, closing the PO (Edit PO Status function under Transactions) will clear the list.
If you have a different situation and this does not clear things up for you, post back.
Also, we have a book called Understanding Purchase Order Processing that explains this process in detail. Check out our web site to see that book
So now that I have Receipts WITHOUT PO numbers, is there a process to eliminate them?
In that case, you'll need to do a Returns Transaction Entry to back out the receipt. Note that if you have a bunch of these across periods and your financials are audited, they will want a lot of detail about why you reversed them. Make sure you document well. -Trevor
I know this thread is a few months old but I just ran across it. We have old unmatched receipts that we have verified that need to be cleared. However, we have an issue with receipts related to inventory. If our cost accountant does an inventory adjustment, it will clear the receipts from the from the inventory (we are on FIFO). So, when we go in to try to clear the receipt using the Returns Transaction Entry, the receipt may not be there to clear or the quanities will not be correct. The receipt is still showing up on the Received Not Invoiced report as it's still available to be paid against through AP. Any advise on how to clear these? In my former life in SAP there was a GR/IR Clearing Transaction. Is there something similiar in Great Plains. We are using GP 2010.
I could use some help on this as well. We have multiple receipts across broad time that I would like them to just show matched so that our smartlists are correct to what should be in accrued purchases. Thanks
if you're just clearing transactions, you could do a dummy invoice match. What I've done is create a single invoice match per vendor and go cleanup every outstanding receipt for them. Then, I put the grand total on the trade discount line so the net invoice is $0 and doesn't hit AP. This assumes you've already corrected the financials elsewhere.
-Trevor
This may help you : sandipdjadhav.blogspot.com/.../remove-transactions-from-reports.html
Thanks
Sandip
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
