Dynamics Community Forum Thread Details

Dynamics 365 CRM to Business Central Integration – Freight Amount Showing with GST in Quote Line

Hello Everyone,

I am currently working on the integration between Dynamics 365 CRM and Business Central, where Sales Quotes are being synced from CRM to Business Central.

I am facing an issue related to the Freight Amount field.

In CRM:

Freight Amount is entered separately
GST % is also maintained separately

However, after synchronization to Business Central, the Quote Line is displaying:

Freight Amount + Calculated GST Amount (combined value)

My requirement is:

Only the Freight Amount should be displayed in the Business Central Quote Line
GST calculation and setup will be handled separately within Business Central

Has anyone faced a similar issue during CRM and Business Central integration?

Could anyone please guide me on:

Why Business Central is receiving/displaying the combined amount
Which mapping, calculation, or configuration should be checked to avoid adding GST into the Freight Amount

Any guidance would be greatly appreciated.

Thanks in advance.

WhatsApp Image 2026-05-27 at 9.26.53 PM (1).jpeg

WhatsApp Image 2026-05-27 at 9.26.53 PM.jpeg

Categories:

Dynamics 365 Business Central

Hello,

This behavior usually occurs because Dynamics 365 CRM is sending the Freight Amount as a tax-inclusive value or the integration mapping is transferring the total extended amount instead of only the base freight amount.

In standard CRM to Business Central integrations, fields such as freight charges, line amounts, tax amounts, and totals can sometimes be mapped through calculated fields or integration transformations, which causes GST to be included before the record reaches Business Central.

You should specifically check the Dataverse/CRM field mapping, integration table mapping, Power Automate flow (if used), and any custom plugins or codeunits handling quote synchronization. In Business Central, GST/VAT calculation is normally handled separately through VAT Posting Setup, so ideally only the base freight value should be synced from CRM.

Hope this helps!

Regards,
Mansi Soni

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS