Skip to main content
Solved

Inventory Part Currently on Hand - Purchase Order total supply

R
Hero (Customer)
Forum|alt.badge.img+16
  • ronhu
  • Hero (Customer)
  • 622 replies

Community,

 

I have a question about  total supply for purchase order in window Inventory Part Currently on Hand, Total Supply Purchase Order, quantity 54402.

Purchase Order Total Supply
​​​​

meantime, i did a query for all active purchase order lines for the part, see below query

Purchase order line query for part active status

then I get total purchase order lines, which sum total qty for 52000

Active purchase order lines

just wondering where the rest of qty 54402-52000=2402 are??

 

Thank you.

Best answer by Kanishka Dilana

Hi @ronhu You can’t simply exclude “Arrived” or “Received” Purchase Order Lines from the above Count. This is because, “Arrived” or “Received” Purchase Order Lines could have some ‘To be Received’ Quantity against them. See below,

 

 

So, to get an accurate Supply figure, you should consider the Purchase Order Lines of those two Statuses also if there is a Non-Zero ‘Due at Dock’ value.

 

 

I hope that would have caused the Difference in your case. Please check that and let us know if there is still a discrepancy and I’m happy to help.

 

View original
Ron
    Did this topic help you find an answer to your question?

    5 replies

    R
    Hero (Customer)
    Forum|alt.badge.img+16
    • ronhu
    • Author
    • Hero (Customer)
    • 622 replies
    • March 7, 2023

    the screenshot for part current inventory on hand

    1 Attachments
    Ron
    MikeCH
    Hero (Employee)
    Forum|alt.badge.img+13
    • MikeCH
    • Hero (Employee)
    • 146 replies
    • March 7, 2023

    Hi Ron,

    Do you get the same result if you filter the purchase order lines by "PO Line Status"?

    Mike

    R
    Hero (Customer)
    Forum|alt.badge.img+16
    • ronhu
    • Author
    • Hero (Customer)
    • 622 replies
    • March 7, 2023

    @MikeCH Thank you for your reply. I have done the filter for purchase order line,  I filter out the status “Received”, “Closed”, “Arrived”, ”Cancelled”, then I got total qty of 52000, still not sure where are these 2402 qty from. Thank you.

    Ron
    Kanishka Dilana
    Superhero (Employee)
    Forum|alt.badge.img+16
    • Kanishka Dilana
    • Superhero (Employee)
    • 122 replies
    • Answer
    • March 7, 2023

    Hi @ronhu You can’t simply exclude “Arrived” or “Received” Purchase Order Lines from the above Count. This is because, “Arrived” or “Received” Purchase Order Lines could have some ‘To be Received’ Quantity against them. See below,

     

     

    So, to get an accurate Supply figure, you should consider the Purchase Order Lines of those two Statuses also if there is a Non-Zero ‘Due at Dock’ value.

     

     

    I hope that would have caused the Difference in your case. Please check that and let us know if there is still a discrepancy and I’m happy to help.

     

    MikeCH
    1 person likes this
    • MikeCH
      MikeCH
    R
    Hero (Customer)
    Forum|alt.badge.img+16
    • ronhu
    • Author
    • Hero (Customer)
    • 622 replies
    • March 8, 2023

    @Kanishka Dilana Bingo! i got exact what i am looking for. Thank you.

    Ron

    Reply


    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings