Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Unanswered

Electronic Reporting - Lines sales tax mapping in Sales invoice format

Posted on by 85

Hi, 

I have configured the sales invoice report in Electronic reporting. I need help in mapping invoice lines sale tax. Does anyone know which field I have to use to map lines sale tax in the sale invoice report?  I am using Microsoft-derived Invoice model mapping and already tried all fields relate to the line sale tax (examples of some are below). I tried fields mapping with custinvjoiceour then custinvoicetrans, and lastly Salesline tables but it didn't work.

1663.pastedimage1624516537743v2.png

Some examples of fields I used to map with line sale tax:

lineAmountInclTax(): Real ()
The amount in the accounting currency(LineAmountMST): Real
Sales tax included in amount(LineAmountTax): Real
taxAmountMST_MY(): Real ()
TaxAmount
The amount in the accounting currency(LineAmountMST): Real
The sales tax amount, in the accounting currency(TaxAmountMST): Real
The sales tax, in the accounting currency, that is included in the amount(LineAmountTaxMST): Real

Thanks

  • Stephen Howard Profile Picture
    Stephen Howard 10 on at
    RE: Electronic Reporting - Lines sales tax mapping in Sales invoice format

    Did you ever get an answer to this?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,513 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,862 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans