When integrating Dynamicweb with ERP systems, handling price rounding and VAT calculations correctly is crucial. Rounding discrepancies can occur due to differences in how Dynamicweb and ERP systems (e.g., Business Central) handle prices, VAT, discounts, and rounding precision.
This article explains the different rounding methods available in Dynamicweb, how they affect pricing calculations, and considerations for configuring these settings when integrated with an ERP system.
Common Rounding Issues
ERP systems often perform rounding differently than Dynamicweb, leading to discrepancies in calculated totals and VAT. Common issues arise when:
- ERP calculates discounts and prices in a single line, whereas Dynamicweb separates discounts into their own order lines, causing double rounding.
- ERP rounds at different stages (unit price, line total, order total) compared to Dynamicweb.
- VAT rounding differs between systems, causing minor but problematic mismatches.
Dynamicweb Rounding Methods Explained
Dynamicweb provides several rounding methods configurable under Settings > Ecommerce > Advanced Configuration > Prices:
| Rounding method | How it works | Example calculation |
|---|---|---|
| Round only displayed price | Prices stored remain unrounded. Displayed prices to users are rounded for clarity. | (3 x 4.992 = 14.976) + (2 x 2.443 = 4.886) Total = 19.862 in database, displayed as 19.86 |
| Round order line total | Each order line total is calculated from unrounded unit prices, then rounded per line. | (3 x 4.992 = 14.976 ≈ 14.98) + (2 x 2.443 = 4.886 ≈ 4.89), Total = 19.87 |
| Round unit price | Each item's unit price is rounded first, then multiplied by quantity. | (3 x 4.992 ≈ 3 x 4.99 = 14.97) + (2 x 2.443 ≈ 2 x 2.44 = 4.88), Total = 19.85 |
Additional VAT Considerations
Dynamicweb can display prices either including or excluding VAT:
- When
PricesWithVAT=True, prices including VAT are rounded. - When
PricesWithVAT=False, prices excluding VAT are rounded.
The choice of rounding prices with or without VAT significantly impacts the final calculation. Ensure alignment with your ERP’s settings.
Additional Discount Considerations
Dynamicweb also provides additional settings related to discounts that can influence rounding outcomes:
Round orderline discounts per quantity: Forces discount calculations to be rounded per item before multiplying by quantity. This can cause slight differences compared to calculating a percentage of the entire orderline. For example, ordering 5 items priced at $8.99 each with a 20% discount would result in discounts rounded to $1.80 per item, totaling $9 instead of the exact calculation of $1.798 per item, totaling $8.99.
Add orderline discounts per quantity: Adds discounts as separate lines for each quantity ordered, potentially introducing additional rounding occurrences. For example, ordering 5 items at $8.99 each with a 20% discount would add 5 separate $1.80 discounts rather than a single $9 discount.
Adjust these settings based on your ERP's discount handling to minimize discrepancies.
Recommendations for ERP Integrations
To minimize discrepancies between Dynamicweb and ERP systems:
- Ensure consistency in rounding methods between Dynamicweb and the ERP system.
- Test each of the three rounding options in Dynamicweb against your ERP’s calculation methods.
- Be mindful that Dynamicweb separates discounts into separate lines, potentially causing additional rounding discrepancies. Adjust settings accordingly or consider handling discounts similarly in both systems.
- Adjust ERP rounding precision settings (e.g., from 0.01 to 0.001) if needed, to match Dynamicweb more accurately.
Best Practices
- Rounding Precision: Set ERP and Dynamicweb to use matching rounding precision.
- Rounding Method: Choose the rounding method in Dynamicweb (unit price, order line total, or displayed price) that aligns closest with your ERP's method.
- Testing: Thoroughly test with representative scenarios, including discounts and VAT variations.
- Documentation: Clearly document your chosen method and configuration to ensure consistency across integrations and future troubleshooting.
By carefully aligning and testing these settings, you can significantly reduce rounding discrepancies between Dynamicweb and ERP systems.