Item Not Showing in Select Purchase Order Items

(0) Share

Report

Posted on by Community Member

Hello:

I went into Edit Purchase Orders and changed the status of a line item from "Cancelled" to "Change Order". The line item had already been received in.

The item does not appear, within the Select Purchase Order Items window, upon trying to conduct Enter/Match Invoices.

What is the fix?

Thank you!

John

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Tim W 2,925 on at

Like (0)

Report

RE: Item Not Showing in Select Purchase Order Items

I don't think changing line status on the PO relates to whether you see a line in the match window. When you say received in I'm assuming you have received qty on a shipment (not shipment/invoice) and you are looking for the line in the match window.

Two typical things come to mind: The receipt was done on a Shipment/Invoice rather than as a Shipment or the Shipment itself has not yet been posted.

I'd look at Purchasing -> Inquiry -> Purchase Order Documents then put in the PO and see what comes back, this will also show posting status on the documents.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Item Not Showing in Select Purchase Order Items

Hi Tim:

It's very weird. Since posting my "question" here, I have taken a look at the "Receivings Line Items" SmartList. It shows both a QTY Shipped of 0 and a QTY Invoiced of 0.

Yet, upon drilling into this historical Shipment document, the Receivings Transaction Inquiry Zoom window says that a quantity of 2 was both Previously Shipped and Previously Invoiced.

Next, when drilling back on the line item on this Shipment document, the Receivings Item Detail Inquiry Zoom window displays 15 for Previously Shipped and 0 for Previously Invoiced.

And, if you divide the Extended Cost of $2,052.00 by the Unit Cost of $6.84, you indeed receive a quantity of 300. This is, indeed, the purchase order's Quantity Ordered.

Now, in both the Receivings Transaction Inquiry Zoom window and the Receivings Item Detail Inquiry Zoom, Quantity Shipped displays as 0, just as the "Receivings Line Items" SmartList reports.

Again, this Shipment is classified by GP as historical.

Despite the oddities of the two Receivings Zoom windows, it sounds like a quantity for this item was never received at all. Would you agree?

John

Was this reply helpful? Yes No
Suggested answer

MG-16101311-0 26,225 on at

Like (1)

Report
RE: Item Not Showing in Select Purchase Order Items

You will want to make a backup of your company database before trying these recommendations - preferably, try in a test environment first.

Unfortunately, the only way to correct this issue is via SQL. Run the following query against your company database:

update POP10100 set POSTATUS = 4 where PONUMBER = 'PO2075' update POP10110 set POLNESTA = 4 where PONUMBER = 'PO2075'

Of course, replace the PO number above with the correct PO number for your case.

Was this reply helpful? Yes No
Tim W 2,925 on at

Like (1)

Report

RE: Item Not Showing in Select Purchase Order Items

Two thoughts.

side note--Shipment or Shipment/Invoice is either work or hist, so in hist and not matched is valid, does not have a stop in open.

One) thought was maybe a PO Return has happened and that accounts for the diff, I've always had trouble matching those up so maybe that's something to look at.

Two) Look at quantity shipped/matched details to see if they add to line value. POP has a table to just manage quantities and it's POP10500 (POP10600 holds the qty values for the invoice match of those quantities).

If you select * from POP10500 where ponumber = <your po> you will return the details of what adds to qty shipped for a po line.

Was this reply helpful? Yes No