web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Line-level Sales Tax A...

Finance | Project Operations, Human Resources, ...

Suggested Answer

Line-level Sales Tax Adjustment on Purchase Order / Invoice in D365FO

(2) Share

Report

Report

Posted on by Muhammad Haroon

2,373

Hi Experts,

I have a requirement in Microsoft Dynamics 365 Finance & Operations related to purchase invoice posting through X++.

Scenario:

Purchase order contains multiple line items
Sales tax group is already correctly assigned at the line level
Invoice data is first stored in a custom table via a third-party API
This data is then used to post the invoice programmatically through X++

Requirement:

I need to adjust the calculated sales tax amount per line item (not at the total/document level).

For example:

Line 1 calculated tax = 96.512, required = 96.52
Line 2 calculated tax = 170.403, required = 170.41

So the requirement is to override the calculated amounts coming in from third-party API to ensure correct tax posting based on each line’s ledger configuration.

Challenge:

Standard functionality allows adjustment only at the total tax level, not per line
Since posting is done via X++ using external data, manual adjustment is not an option
Line-level rounding/override of tax amounts does not seem to be supported out of the box

Question:

Is it possible in standard D365FO to adjust/override sales tax per line during invoice posting?
If not, is there any supported customization approach to achieve this requirement?
Or is this a limitation of the tax framework where such control is not feasible even with customization?

Any guidance, suggestions, or real-world experience would be highly appreciated.

Thanks in advance!

Categories:

Dynamics 365 Finance

Microsoft Dynamics AX

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

Suggested answer

André Arnaud de Cal... 303,988 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Muhammad,

The tax is initially calculated per PO line. You can, with a customization, try to add a record in the table TaxTmpWorkTrans with a reference to the PO line with the actual tax amount. I'm not sure if that will work as functionally, there is no support to override the tax amount on the PO line.

Was this reply helpful? Yes No
Suggested answer

Syed Haris Shah 1,613 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Muhammad Haroon,

Are the default tax rounding method and rounding precision not helping you achieve your requirement? Assuming the third-party API is sending tax information to D365 and not bypassing the standard tax engine to calculate tax (unless heavily customized), shouldn’t the standard rounding logic apply?

If not, then you probably need for customization?

Regards,

Syed Haris Shah

Was this reply helpful? Yes No
CU10040815-0 2 on at

Like (0)

Report
Copy link

Link copied!

Thanks to share this real breakdown !

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

Giorgio Bonacorsi 653

#2

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

#3

Syed Haris Shah 317 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans