Where in GP's User Interface do I find the quantity of items ordered and shipped by item?

(0) Share

Report

Posted on by VinhTon

100

IT gave me this code and I want to validate it directly with GP's interface.

I'm skeptical because I have orders that have more shipped than ordered. Thanks ahead

SELECT
B.ITEMNMBR
, B.QUANTITY * QTYBSUOM AS ordered
, B.QTYPRINV * QTYBSUOM AS shipped
,DOCDATE
,b.SOPNUMBE

FROM SOP30200 AS A WITH (READUNCOMMITTED) INNER JOIN
SOP30300 AS B WITH (READUNCOMMITTED) ON A.SOPNUMBE = B.SOPNUMBE AND
A.SOPTYPE = B.SOPTYPE

Categories:

Microsoft Dynamics GP

All responses (5)

Answers (1)

VinhTon 100 on at

Like (0)

Report

RE: Where in GP's User Interface do I find the quantity of items ordered and shipped by item?

Thanks. Is there one for items shipped?

I dont see an option for posting screenshot but it the item transaction only seems to have items ordered not shipped.
Verified answer

Richard Wheeler 75,730 on at

Like (1)

Report

RE: Where in GP's User Interface do I find the quantity of items ordered and shipped by item?

Inquiry->Inventory->Item Transaction
VinhTon 100 on at

Like (0)

Report

RE: Where in GP's User Interface do I find the quantity of items ordered and shipped by item?

I responded a week ago, can I get a follow up? Thanks
VinhTon 100 on at

Like (0)

Report

RE: Where in GP's User Interface do I find the quantity of items ordered and shipped by item?

In the smartlist Sales Line Items, are these fields I should be looking for?

QTY ordered

QTY fulfilled

Thank you Becky for the response
Suggested answer

Becky Berginski on at

Like (1)

Report

RE: Where in GP's User Interface do I find the quantity of items ordered and shipped by item?

Hello Vin,

Thank you for using Community Forums. My name is Becky and I will assist you.

You would be able to run the Sales Line Item Smartlist to determine the quantity on the order and the quantity previously invoiced on the order.

I believe your issue with the script is that the quantities are being reported in the base unit of measure (QTYBSUOM). It here is a quantity of 1 case on the order, and there are 12 items in each case, the script would show 12 items shipped and not 1 case shipped. You would need to remove the values * QTYBSUOM from the scripts to change it to reported in the UofM from the sales document.

Becky