When importing sales orders into Exact Online via App4Sales or Portal4Sales, the discount percentage on the order lines may appear higher or lower than expected, even though the final net amount is correct.
This issue occurs due to a mismatch in the VAT base between the unit price in Exact Online and the net price provided by the connector:
VAT Base Mismatch: The default catalog price (unit price) of an item in Exact Online is set including VAT, whereas the connector transmits the agreed net price excluding VAT (or vice versa).
Automatic Recalculation: Exact Online takes the default unit price from the system and compares it directly with the received net price. To bridge the gap between these two amounts, Exact Online automatically calculates a new discount percentage.
The Result: Because Exact Online is comparing a price incl. VAT against a price excl. VAT, the mathematical ratio is skewed, causing a deviating discount percentage to display on the order.
This can be resolved by aligning the connector's VAT handling settings for net prices with the pricing setup in Exact Online:
Go to CMS > Administration > Settings > Connector Settings
Search the setting:
Net Price Including Vat.Enable this option if your Exact Online environment shows prices incl. VAT
Disable this option if your Exact Online environment shows prices excl. VAT
Save the changes and synchronize your CMS
Verification: Submit a new test order and verify that the discount percentage in Exact Online now matches the expected pricing agreement.