[Bob Lash]

We have a couple purchase orders that are completely received.  The vendor invoices have been processed against the receipts. The status of all lines are “closed” and the purchase order is “closed”.  The purchase orders are still on the Uninvoiced Receipt Report.  I have reconciled the purchase orders and they are still on the report.  What do I need to do to clear them from the report?  Thank you for your help.

——————————
Bob Lash
General Manager
Ti-SALES, Inc.
Sudbury MA
——————————

[Silver Subie]

Bob, it has been awhile but I believe trying to Remove Completed PO could help (It’s under Routines, Purchasing).  Of course your company must be okay with completed PO being removed.  I would try it in TEST first.

Good luck!——————————————-

[Matthew Arp]

You should not have to go thru this to get the items off your Received not Invoiced Report. Have you confirmed that each line on the PO has a POLNESTA of 5 or greater (Closed or Cancelled) and that the PO reflects the same. A trick I use is to go into the Edit PO under Purchasing > Transactions to look at the status of all the lines at once.

——————————
Matthew Arp
Business Systems Developer
Hunton Group
Houston TX
——————————
——————————————-

[Bob Lash]

Both purchase orders and all items on each are closed. What am I missing?

——————————
Bob Lash
General Manager
Ti-SALES, Inc.
Sudbury MA
——————————
——————————————-

[Matthew Arp]

Can you also confirm that the items show as fully received & fully invoiced. If you go into Purchase order Inquiry and on each line click on the white i in the row headers and verify that all quantities look correct (no un-posted, no remaining to receive or invoice).

——————————
Matthew Arp
Business Systems Developer
Hunton Group
Houston TX
——————————
——————————————-

[Bruce Strom]

Received not invoiced means that the inventory has been received (through receivings entry) but has not been invoiced.
To get it off the Received Not Invoiced report you need to either invoice it or issue a POP return, and there are several types of returns.
The purchase order itself does not affect the general ledger at all (unless you are a governmental entity with encumbrances).

——————————
Bruce Strom
Programmer Analyst
Associated Grocers of Florida
sunrise FL
——————————
——————————————-

[Matthew Arp]

Correct the PO does not impact the GL, but it does provide a place to verify that all of the lines have been fully closed and that none of the lines are stuck in la-la-land.

——————————
Matthew Arp
Business Systems Developer
Hunton Group
Houston TX
——————————
——————————————-

[Bob Lash]

I have followed most of the discussion of my problem.  I now see that the original AP entry did not match the receipt.  I tried to reenter a new invoice to pull in the receipt and the receipt with the open items is not there to attach to the new invoice.

I went into our test version and tried to unclose the items and GP wouldn’t allow that.
Thanks for bearing with me.

——————————
Bob Lash
General Manager
Ti-SALES, Inc.
Sudbury MA
——————————
——————————————-

[Matthew Arp]

Bob, instead of trying to use the Auto-Invoice feature, try simply entering in the PO number and Item number on the Enter-Match line.

——————————
Matthew Arp
Business Systems Developer
Hunton Group
Houston TX
——————————
——————————————-

[Beat Bucher]

Bob,
You seem to be a recent version of GP (2015 or 2016).. As it looks like there was a variance between the original PO amount and/or Qty and the receiving/invoicing, I think moving the PO to history will be the only way to get that one off your report.

For the future, there is a new option in GP (can’t recall when it was introduced, but I think it’s 2013) to allow for a certain tolerance in the receiving.. check the PO processing setup screen.

Purchasing >> Setup >> Purchase Order Processing
You may wanna look into it.

PS: here is an excellent blog post around the PO receiving and invoicing related GL process: http://gp2themax.blogspot.ca/2008/12/dynamics-gp-three-way-match-process.html

——————————
Beat Bucher
Business Analyst, Dynamics GP MVP
Ultra-Electronics Forensic Technology Inc.
Montreal QC/Canada
+1-514-489-4267
@GP_Beat http://dyngpbeat.wordpress.com/
Montreal QC GPUG Chapter Leader
GP2013R2 / MR2012 CU14
——————————
——————————————-

[Bob Lash]

I have to enter an invoice not using the Auto Invoice feature and the system won’t allow me to “receive against a closed po”.  I can’t find the routine or process to move the PO to history.  I have looked in the Purchasing module and Inventory and can’t find how to move the PO to history.  Thanks again for your help.

——————————
Bob Lash
General Manager
Ti-SALES, Inc.
Sudbury MA
——————————
——————————————-

[Matthew Arp]

Have you reconciled the PO? Purchasing > Utilities > Reconcile

——————————
Matthew Arp
Business Systems Developer
Hunton Group
Houston TX
——————————
——————————————-

[Bob Lash]

I did Reconcile and they haven’t gone away.

——————————
Bob Lash
General Manager
Ti-SALES, Inc.
Sudbury MA
——————————
——————————————-