Announcements
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
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.
Inquiry->Inventory->Item Transaction
I responded a week ago, can I get a follow up? Thanks
In the smartlist Sales Line Items, are these fields I should be looking for?
QTY ordered
QTY fulfilled
Thank you Becky for the response
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
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156