Custom RDP: CustDueDetailReportDP

(0) Share

Report

Posted on by Willy Andrian

Hello master, I have a problem. I got request to add Customer name and invoices description to Detailed Due Day Report. You can access the report in AX with this steps: AR (Account Receiveable) > Report > Status

I checked and i found that report use CustDueDetailReportDP as the RDP. But i'm stuck about how to relate tables inside that RDP with another table that contains customer name and invoice description. I think i have to relate it to CustInvoiceJour or CustInvoiceTrans.

I already create 2 more columns to the temporary table for the report with "String" as the type but dunno how to relate the tables inside the RDP.

Can you show me how to relates the tables? You don't have to write the column name exactly like mine, you can use random name and i'll rename it according to my needs. Any help will be appreciated :)

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Martin Dráb 239,381 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Customer name is trivial - the initialization from CustTable is done in CustDueReportDetailDP.updateCustDueReportDetailTmp(), where you can simply call custTable.name() to get the name.

Regarding invoices, you can call custTrans.custInvoiceJour_RU() (or just look inside it and borrow the logic from there) to get the related custom invoice record.

Was this reply helpful? Yes No