Finance | Project Operations, Human Resources, ...

Add custom table in Salesinvoice report

(5) Share

Report

Posted on by VM-02050213-0

134

Hi,

I want to ada a custom table in salesinvoice report in the datasource section. eg. INGSalesDetail

It seems that we need to make it regular and createdtransactionid as yes.
I would like to know what all other settings are required at code level in salesinvoiceDP class to make sure that same record is shown to the user for the custom table INGSalesDetail.

eg.
the temp table is selected with transaction id in code
[SRSReportDataSetAttribute(tablestr(INGSalesDetail))
and COC of setconnection needs to be done.

Thanks,

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (6)

Answers (0)

Vahid Ghafarpour 12,168 Super User 2025 Season 2 on at

Like (1)

Report

Did you check this thread?

https://community.dynamics.com/forums/thread/details/?threadid=fe923d36-24cd-4893-9064-441b68950b93

Was this reply helpful? Yes No
Suggested answer

Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

In order to modify a standard SSRS report, you need to create new report (Duplicate of the standard one), create COC class for the DP class, and modify the new design.

Check the following link for more details: SSRS_Report_Modify

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
Suggested answer

Vishal Tiwari 393 on at

Like (1)

Report

Hi,

To add a custom table to the Sales Invoice report, you may follow these steps (however I'm unaware of your exact requirement):

1. Ensure to check the table settings - table type(regular), CreatedTransactionId, Primary Index & SaveDataPerCompany

2. Extend SalesInvoiceDP Class - modify using coc to include custom table in the data provider.

3. Modify set connection using coc : (something like below)

[ExtensionOf(classStr(SalesInvoiceDP))]
final class SalesInvoiceDPExtension
{
public void setConnection(SrsReportRunContext _srsReportRunContext)
{
next setConnection(_srsReportRunContext);
this.INGSalesDetailTmp.setConnection(this.parmReportContract().parmtransDataContract());
}
}

4. Populate custom table data : Override processReport() to insert records in the table.

and finally you can change the report design based on datasource fields etc.

Thank you!

*****If this was helpful, please mark it as "Verified" so others with the same issue can benefit.*****

Was this reply helpful? Yes No
Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Is your issue resolved? If yes, mark the answers that helped you as verified.

Thanks,

Waed Ayyad

Was this reply helpful? Yes No
Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Is your issue resolved? If yes, mark the answers that helped you as verified.

Thanks,

Waed Ayyad

Was this reply helpful? Yes No
Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Is your issue resolved? If yes, mark the answers that helped you as verified.

Thanks,

Waed Ayyad

Was this reply helpful? Yes No

Join the conversation

Community site session details

Add custom table in Salesinvoice report

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Add custom table in Salesinvoice report

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates