web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Custom sales invoice report

(0) ShareShare
ReportReport
Posted on by 406

Hello everyone,

I need to customize a sales invoice report and add the tax ratio to the lines.
using the original SalesInvoiceTmp table, but it does not contain a line number in order to filter the TaxTrans table to retrieve a tax value.

did anyone solve this particular issue or found another more optimal method?

thanks in advance

I have the same question (0)
  • Suggested answer
    Anton Venter Profile Picture
    20,345 Super User 2025 Season 2 on at

    You will have to use the standard classes to calculate the tax for you and add it to the tempory table in the SalesInvoiceDP class. From the top of my head: look in the SalesTable(ListPage) form, there is a button to show the Tax amounts, have a look how that form calculates the tax amount and do the same.

  • D365FO DEV Profile Picture
    406 on at

    hi, can u explain more please

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    14,677 Super User 2025 Season 2 on at

    Hi MounirDev,

    We use business document and add tax amount and tax rate via ER config to the model (i.e. via LineBase.TaxTrans.TaxAmount)

    For more info please check: learn.microsoft.com/.../er-business-document-management

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 512 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 291 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans