Running OE 8.1c (100507), AR 9.0a (100504), and IC (100504), we are accumulating Data Integrity Checking errors in OE that are tax related after the recent update to IC. They all occur on invoices with taxes (a minority of our orders). In fact the invoices flagged as not matching have no problems and all of the arithmetic shown on the invoices is correct. Most of the errors are for $0.01 and are on invoices with only 1 tax and we get an error of $0.04 on an invoice with 3 taxes. If I have DIC rebuild the data, it changes the correct original Total Dollar Value to the incorrect total shown on the left side below. Because of this, I am not using the rebuild function and leaving the errors without modification. The data has been copied to my home computer with the same Adagio installation running on a local drive and the errors are reported on the second computer also. In addition the problem can be duplicated consistently on the home computer by creating a new invoice with the same items as a problem invoice. See the bottom 4 errors reported below. One was done using the original customer, then 2 different customers and all had the same tax code with 3 taxes. The final one was done with a different customer and the tax code for only 1 tax was used and the error was reduced from $0.04 to $0.01 like the other errors reported.
Although it doesn’t seem likely that the IC update (100504) would have caused the errors, they started to occur almost immediately after the update. The problem does not occur on all taxed orders and we can't identify any particular inventory items as causing the problem. The data has consistently passed DIC in all modules for years with any problems. IC DIC reports no errors now and never has.

Application Integrity Phase

Document I 118491 invoice total 217.80 does not match expected 217.79
Document I 118496 invoice total 189.74 does not match expected 189.70
Document I 118499 invoice total 39.81 does not match expected 39.82
Document I 118523 invoice total 356.46 does not match expected 356.47
Document I 118530 invoice total 85.61 does not match expected 85.60
Document I 118534 invoice total 438.55 does not match expected 438.56
Document I 118566 invoice total 135.84 does not match expected 135.85
Document I 118567 invoice total 189.74 does not match expected 189.70
Document I 118568 invoice total 189.74 does not match expected 189.70
Document I 118569 invoice total 189.74 does not match expected 189.70
Document I 118570 invoice total 187.55 does not match expected 187.54
Orders/Invoice headers ... 11 error(s) found
Items ... Checked OK
Special Prices ... Checked OK
Archived Order Totals ... Checked OK

Application Integrity Phase ... 11 error(s) found

Are there any other similar reports and any suggestions for a solution? At the present time it is being ignored.

Rick McLeod
Sunbeam Specialties, Inc.

Rick:
OE taxes can be calculated on 1 of 2 bases: Line-by-Line or Invoice Total. In the first case, tax is calculated on each line and then added together at the end. In the second case, taxes are calculated only on the pre-tax total. Using the first method I have seen cases where the tax appears wrong by a penny or two when compared to the pre-tax total. It's not wrong, just different based on rounding (or absence of rounding).

The factors that make this difference apparent are number of lines on the invoice, dollar amounts and tax rates. For instance, an invoice with 1 line and an even dollar amount (ie. $100) is always going to have the same tax amount regardless of the selected method. The tax rate(s) also matter. For instance, a 5% tax usually has the same calculation regardless of the method selected. However a 7% tax (which doesn't divide into 100 evenly) can result in a total tax figure which varies depending on the method selected.

The setting is contained in the OE Company Profile on the "System Options" tab. Look for "Calculate tax amount by".

Try changing the setting and trying your tests again.

Having said all of that, I wouldn't expect that the Data Integrity Check would find a problem. Nor can I see why IC 8.1C would make a difference. Has a tax rate changed lately? Please let us know your results.

Hello Bruce,

Thanks for your quick reply. Changing the tax calculation method from Invoice Total to Detail Line did result in the invoice being calculated with the amount expected in the DIC. This means that OE is now calculating the tax in 2 different ways if you choose the Invoice Total method in the company profile. It is using 1 method for the Invoice and then the Detail Line method for the DIC and reporting the difference between the 2 methods as errors. It seems strange that we have never had a problem until now within a day of installing the IC update. We have had no tax rate changes since the beginning of the year.

Of course the easy solution is to leave the profile set for the Detail Line method which we will do. I am sure this little glitch will be fixed in due course.

Thanks,

Rick

It will be fixed. Now, if only we could convince people not to take vacations!