Remove cancelled PO lines from PO confirmation report

(1) Share

Report

Posted on by D365 beginner

618

Hi Experts,

I have a requirement that not to show canceled lines in the PO confirmation report. currently it is printing all the lines from the PO. Can anyone help to write COC for PurchPurchaseOrderDP class to add this validation in order to include all lines except canceled. Thanks.

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Vahid Ghafarpour 11,993 Super User 2025 Season 2 on at

Like (1)

Report

Remove cancelled PO lines from PO confirmation report

You can use Chain of Command (CoC) to extend the PurchPurchaseOrderDP class and add the validation to exclude canceled lines from the PO confirmation report.

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/extensibility/method-wrapping-coc

Was this reply helpful? Yes No
André Arnaud de Cal... 299,782 Super User 2025 Season 2 on at

Like (0)

Report

Remove cancelled PO lines from PO confirmation report

Moved the question from the General to the Supply Chain Management forum.

Was this reply helpful? Yes No
D365 beginner 618 on at

Like (0)

Report

Remove cancelled PO lines from PO confirmation report

Thank you Andre & Vahix for the response,

Actually I was trying to amend the class PurchPurchaseOrderDP using coc to achieve the same. but it didn't work.

protected PurchPurchaseOrderTmp initializeOrderLine(
PurchPurchaseOrderHeader _purchaseOrderHeader,
boolean _highlightUpdated,
PurchPurchaseOrderDPOrderLineQuerySelection _orderLineSelection)
{
PurchLine purchOrderPurchLine;
PurchLineAllVersions purchLineAllVersions = _orderLineSelection.parmPurchLineAllVersions();

PurchPurchaseOrderTmp purchPurchaseOrderTmp = next initializeOrderLine(
_purchaseOrderHeader,
_highlightUpdated,
_orderLineSelection);

purchPurchaseOrderTmp.PurchStatus = purchLineAllVersions.PurchStatus;

if(purchLineAllVersions.PurchStatus != PurchStatus::Canceled)
{
purchPurchaseOrderTmp.ItemId = purchLineAllVersions.ItemId;
}

return purchPurchaseOrderTmp;
}

Was this reply helpful? Yes No
D365 beginner 618 on at

Like (0)

Report

Remove cancelled PO lines from PO confirmation report

I believe we need to extend the class PurchPurchaseOrderDPOrderLineQuery to avoid canceled lines. It would be great if someone can confirm this and shows how to achieve it.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 299,782 Super User 2025 Season 2 on at

Like (1)

Report

Remove cancelled PO lines from PO confirmation report

Hi D365 beginner,

The standard coding will insert all PO lines and the SSRS report is not aware of ranges you set in coding. What you would need to do here is either creating a full new data provider class or in an extension class try to delete several lines from the purchPurchaseOrderTmp table.

Was this reply helpful? Yes No
D365 beginner 618 on at

Like (1)

Report

Remove cancelled PO lines from PO confirmation report

Hi Andre, Thank you for your suggestions. Is there any chance to extend below methods in the DP class to control it.

Was this reply helpful? Yes No
D365 beginner 618 on at

Like (1)

Report

Remove cancelled PO lines from PO confirmation report

It worked, Managed to delete the cancelled lines from PurchPurchaseOrderTmp using a class extension as Andre suggested. Thanks a lot.

Was this reply helpful? Yes No