Suggested by Edvardt Saugen – New
When customer retention is set to decimals, the calculation fails somewhere. The project invoice total amount becomes a penny different than the revenue in calculated tax.
For example,
with customer retention 7,5% on a project invoice
Header
Invoice amount: 6,805,505.96
Gross margin: 5,444,404.77
Invoice proposal transaction summaries
Invoice line amount: 5,885,843.00
Retention: 7,5%
Customer retained amount: 441,438.23 (actually 441,438.225)
Amount less retention 5,444,404.78
Posted sales tax
Amount origin: 5,444,404.78
tax: 25%
Calculated sales tax amount: 1,361,101.19 (actually 1,361,101.195)
amount origin + calculated sales tax amount = 6,805,505.97
The problem is that this causes problems in in xml validation tools, which fails with the following error message:
Document not a valid Electronic invoice, failed in validation for document type.
The error message is due to amount + calculated sales tax is not equal invoice total amount.
To sort this out today, you need to 1) send to external provider for validation, 2) receive the error message, 3)re-invoice and manually adjust retained amount so the penny difference no longer appears, and 4) resend.
Alternatively, the XML-file can be adjusted manually, causing penny difference between actually invoiced and stated in Dynamics.
The cost of this issue for one of our clients is at least 10.000USD per year, due to increased validation and resending of invoices. This does not include the labour cost for adjusting manually the xml files and re-uploading a new file.
This was reported to Microsoft as an issue, but it was declined - as they deem it too complex to fix and they believed it is an uncommon issue. However, it happens every month for our client.