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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Sales Invoice report field mapping

(0) ShareShare
ReportReport
Posted on by 406

HI, im trying to map the field SourceBaseAmountCur from taxTrans table to my field Ex_TaxBaseCur in salesInvoicetmp table. but for some reason its not showing data on the report, i debugged the code, and the tables have data.

what i am trying to do is to show the taxable amount of each item under the field taxable amount

anyone can provide me the correct code, also note that im doing extension on the salesinvoiceDP.

I have the same question (0)
  • Komi Siabi Profile Picture
    13,190 Most Valuable Professional on at

    Can you tell us more about the extension you are doing on the salesinvoiceDP?

    Did you try the debugging option to see  what's happening yet?

  • D365FO DEV Profile Picture
    406 on at

    pastedimage1683894177287v1.png

    as u can see in the picture above, i did an extension on salesinvoicedp class for the method populatesalesinvoicetmp.

    by using this class, i was able to show the tax value of each item on the sales invoice report.

    so now i want to show the taxable amount which is the field 'sourcebaseamountcur; in the taxtrans table. i used the same logic but the field is coming blank for some reason.

    if u got any other method that will let me get the data from the sourcebaseamountcur field; in the taxtrans table, plz let me know.

    the field that i am using is the EDT of sourcebaseamountcur field and i named it Ex_TaxBaseCur.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 558 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 402

#3
Diego Mancassola Profile Picture

Diego Mancassola 261

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans