D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Get Cancelled quantities on a PO line

  • 1.  Get Cancelled quantities on a PO line

    Posted Jul 30, 2019 09:25 AM
    Edited by Mohammad BakhshayeshiBaygi Jul 30, 2019 10:04 AM
    Hi all,

    We are having a requirement where we want to capture the cancelled quantity for PO lines on an SSRS report in the database. When we want to cancel a PO line, we select the line and use "Update Line> Deliver Remainder", update "Purchase Quantity" and then use OK button to make changes effective. However the total number of cancelled items on the line doesn't seem to be stored anywhere in the DB. Any ideas how to capture this?


    #purchaseOrder #po #FinanceandOperations ​​​​​​​

    Mohammad BakhshayeshiBaygi
    PSP Investments
    Montreal QC

  • 2.  RE: Get Cancelled quantities on a PO line

    Posted Aug 03, 2019 12:56 PM
    Hi Mohammad,
    You can find ordered quantity of POs on the Purchase tab, Journals,Purchase Order Confirmations. This solution is not ideal but it worked for us.

    Reza Pakdel
    Methods Improvement Supervisor
    Ofogh Koorosh Chain Stores


  • 3.  RE: Get Cancelled quantities on a PO line

    Posted Aug 06, 2019 07:22 PM

    Hi Mohammed,
    The cancelled quantity is not stored in DB anywhere.. If you need to show this on the report, you need to do some calculation.

    PurchLine.Quantity column - Invoiced total (get this from the invoice tables) - Purchline.RemainPurchFinancial - PurchLine.RemainPurchPhysical column.

    Satish Panwar
    Senior Manager
    Hitachi Solutions America, Ltd.
    Irvine CA


If you've found this thread useful, dive deeper into User Group community content by role