Sub Total does not match the line item totals
Check the tables, I have a feeling you are running into the fact that Smart Connect will allow 5 decimals and if you brought anything in without rounding the numbers you have hidden values underneath.
the numbers are all whole numbers… so i'm not doing any rounding or anything like that.
You should be able to see what the values are within the file for each line and compare them to the value in the header section of the xml file and see what is causing the discrepancy.
I have one source file with two rows for each invoice to handle the line item distributions and I am getting the same Subtotal error message. The subtotal matches the Extended price because there is only one line item per invoice. but there are 2 rows in my spreadsheet for the sales and receivables distribution. How do I get around this error?
Is there a place in the data source where I can defiine the cost as decimal?
If you would like to submit an answer or comment, please sign in to the eOne portal.