web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Get Cancelled quantiti...
Finance forum

Get Cancelled quantities on a PO line

(0) ShareShare
ReportReport
Posted on by MohammadBB 325

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

Categories:
Financial Management
Development / Customization / SDK
I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi

    When you say cancel, do you still see the lines on the PO or are you deleting them?

    If you are not deleting them then you should be able to grab them either in a SSRS report or alternatively in an electronic report.

    Best regards,

    Ludwig

  • MohammadBB Profile Picture
    MohammadBB 325 on at

    Hi Ludwig,

    Thanks for the answer.

    Sorry my question was erroneous, I just updated my post I actually want to cancel items on the purchase order, say cancel 4 items out of 10.  So yes I do see the line after. What I want to know is that the quantity I cancelled, in my example 4, is it somewhere in DB?

  • Andrew Xu Profile Picture
    Andrew Xu 3,877 on at

    Hi Pop,

    In your example, if your cancel 4 out of 10 (6 remainders) and then change the purchase qty back to 11, and then cancel 3 out of 11, should the cancllealtion qty be 3 or 7 (4 +3) or 2 (10 - 8)? To be clear, what's your definition of cancelled qty?

  • Verified answer
    Satish Panwar Profile Picture
    Satish Panwar 14,673 Moderator on at

    Hi Pop,

    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.

    Thanks,

    Satish Panwar

    Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans