Get Cancelled quantities on a PO line

(0) Share

Report

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

All responses (4)

Answers (1)

Verified answer

Satish Panwar 14,655 Moderator on at

Like (1)

Report

RE: Get Cancelled quantities on a PO line

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.
Andrew Xu 3,877 on at

Like (0)

Report

RE: Get Cancelled quantities on a PO line

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?
MohammadBB 325 on at

Like (0)

Report

RE: Get Cancelled quantities on a PO line

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?
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

RE: Get Cancelled quantities on a PO line

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