Remove cancelled PO lines from PO confirmation report

(1) Share

Report

Posted on by D365 beginner

572

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.

All responses (7)

Answers (1)

D365 beginner 572 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.
D365 beginner 572 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.
Verified answer

André Arnaud de Cal... 291,431 Super User 2024 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.
D365 beginner 572 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.
D365 beginner 572 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;
}
André Arnaud de Cal... 291,431 Super User 2024 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.
Suggested answer

VaHiX 3,323 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