Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Answered

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

Posted on by 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:
  • VinhTon Profile Picture
    VinhTon 100 on at
    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 Profile Picture
    Richard Wheeler 75,730 on at
    RE: Where in GP's User Interface do I find the quantity of items ordered and shipped by item?

    Inquiry->Inventory->Item Transaction

  • VinhTon Profile Picture
    VinhTon 100 on at
    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 Profile Picture
    VinhTon 100 on at
    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
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans