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
Inquiry->Inventory->Item Transaction
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,558
Super User 2024 Season 2
#2
Martin Dráb
228,645
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (