Announcements
No record found.
Hello everyone, i am trying to add the tax rate to my sales invoice report. so i need to map the value to show on my report.
so here i will show u my extension in the data provider class, i have created a field Ex_TaxRate to map the field TaxValue from the taxTrans table. but for some reasons, the field is coming blank on the report
Hi Mounir, Please try the code in this thread
community.dynamics.com/.../d365-get-sales-tax-values-of-sales-order-per-line-in-x
hi
can u show me how to add it based on the field i created and when to add it?
Please share the path for this Posted Sales Tax form. I can see other dialogs for tax on sales order.
to get the path for this sales tax for, u need to select a sales order -> invoice(action pane)
->posted sales tax --> options --> record info --> show all fields.
Hi MounirDev,
Debug it. check to see if the table is select.
Thanks,
i debugged, only the salesinvoicetmp is showing data while taxtrans and custinvoicetrans is not showing data
Check in SSMS having record in custinvoicetrans for "Select custinvoiceTrans where custinvoicetrans.recid == journalRecid (salesinvoicetmp.journalrecid)".
custinvoice trans is not getting data
Please check this thread
community.dynamics.com/.../741651
In SalesInvoiceTmp, JournalRecId field is linked with custinvoicejour table, not custInvoiceTrans.
There is a standard field for TaxAmount in SalesInvoiceTmp, if you comment your code, isn't the standard logic working?
In above figure, custinvoiceJour is in relation with salesinvoicetmp, not with custinvoicetrans table.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 512 Super User 2026 Season 1
Giorgio Bonacorsi 386
Adis 259 Super User 2026 Season 1
