Sage 100

VI Fix for Payroll Rate I am attempting to import a Payroll and the VI will only import a 2 digit decimal for the Payroll Rate even though in data entry it used 3 digits. (This is an issue on calculationx of a hourly rate for Salaried employees.) Does another have notes on changing VI Data Dictionary to 3 digit decimal? PR V5.20 V2015

I don't have notes on changing to a 3 digit decimal, but I know that 3 digit decimals on imports have been causing out of balance conditions in data entry. I also had a problem with the data entry report not showing an out of balance and then having the numbers on the data entry report not matching the employer expense summary. The best one was the spelled out amount on a check not matching the digit amount. I round everything on import now to 2 digits using the PRC function.

I need 3 decimal for the Salary recalculations

Would it work to pull the Salary rate from the employee record into VI job instead of having it on the import file? Does it behave differently?

Maybe use a temp field to pull the 3 decimals and then set the rate equal to the temp field?

Tried that. It rounds to 2 digits. Causes different salary. I think there is an entry in the vi dictionary sy0dct that can be tweaked

Can you skip importing the Rate and instead import the Amount?

Maybe change Rate to be a calculation of Amount divided by hours?

That's the issue. The rate in vi is always rounded to 2 digits of it touches it.