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 23 days ago
    Edited by Mohammad BakhshayeshiBaygi 23 days ago
    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?

    Thanks

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

    ------------------------------
    Mohammad BakhshayeshiBaygi
    PSP Investments
    Montreal QC
    ------------------------------


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

    Posted 19 days ago
    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 15 days ago

    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