Microsoft Dynamics GP (Archived)

QTY Available and PO Linked Values

(0) Share

Report

Posted on by Bill Campbell

Background:

Item 1 has QTY 22

Item 1 has Allocated 37

Item 1 has Available - 15

Simple math - not confused yet.

Situation:

Client has Sales Order #1 that shows Item 1 for a QTY of 1. Looking into the detail there is a linked PO #22 attached to this item for a QTY of 1

Now we have Received the shipment for PO#22 - but not the INVOICE

The PO Link shows the Item number and the Commitment Status of Purchased and the correct PO number and Dates.

QUESTION:

The Quantity on Purchase Order shows 0

Is this why we can not allocate this item to the Sales Order and move the Sales Order from Backorder to Invoice?

Does the item link in PO happen when we try to move the Sales Order to Sales Invoice?

*This post is locked for comments

All responses (6)

Answers (0)

Heather Roggeveen 9,144 on at

Like (0)

Report

RE: QTY Available and PO Linked Values

Hi Bill

There is a SOP-POP Link table - SOP60100 - it may be in there.

I don't know what will happen if you update that table.

Can you delete the link and re-add it?

Cheers

Heather
Bill Campbell on at

Like (0)

Report

RE: QTY Available and PO Linked Values

Here is what I think is the problem : from the Purchase Order Processing Document Inquiry, open the PO in question and click on the line item with the error message - then click on the chain link

Note that the Quantity Committed and the Base Qty ( on PO ) both show ZERO

Here is a sample from the same PO that is working correctly

Note the QTY fields both show value of 1.

QUESTION

What is the table that this is found in? What are the field names?

What happens if I update those values?
Bill Campbell on at

Like (0)

Report

RE: QTY Available and PO Linked Values

Beat, sorry but I will have to wait until users are out of the system to do the reconcile as it tells me that I can not reconcile with users editing transactions.
Bill Campbell on at

Like (0)

Report

RE: QTY Available and PO Linked Values

Update

PO#22 has 3 line items - 2 of them are showing CLOSED and the one I want is showing Received - QTY Order 1 - QTY Shipped - 1 QTY Invoiced 0

Leslie - no this is not a DROP SHIP - all of the PO's are shipped to Warehouse first and then processed to job site and transported on company truck.

Leslie - there are no unposted batches in Purchasing - so I am assuming that yes the RECEIPT is posted.
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

RE: QTY Available and PO Linked Values

Hi Bill,

Was the receiving posted ?

Did you try to run a reconcile on this particular item ? sometimes the QTY adjustment in the OnHand inventory doesn't get updated rigth away after receiving and had to run INV reconcile quite a few times when stuff gets out of sync..
L Vail 65,271 on at

Like (0)

Report

RE: QTY Available and PO Linked Values

Hi,

Is this by any chance a DropShip? Also, has the Receipt for sure been posted?

Leslie