Amount Rounding

WearAllHats

I have a client where we setup a separate company in their database for payroll. Somehow the "Amount Rounding Precision" and “Unit Amount Rounding Precision” fields in the general ledger setup were not set to the usual 0.01 value, but to 1. My client has been processing payroll for a couple of months and the entries in the general ledger and check ledger entries etc. are rounded to the nearest dollar. Payroll Ledger rounds to 0.01. Client is trying to do a bank rec and is frustrated that the amounts are all rounded to the nearest dollar. I wrote a script to change the "Amount Rounding Precision" and “Unit Amount Rounding Precision” value in the General Ledger Setup table and in the Currency table (just in case – but they are not using currencies) to 0.01. This did not fix the problem. I even went into codeunit 1, ApplicationManagement, and hard coded 0.01 in the AutoFormatTranslate and ReadRounding functions. No luck, still did not work. I next went to table 81, and changed the AutoFormatType property on the "Amount" field from 1 to 0. This allowed me to input a decimal amount to 0.01, which it did not before. I posted the transaction and when I went to the general ledger to view it, it had rounded it to the nearest dollar. No matter what I do it posts to the nearest dollar. I contacted Microsoft with the issue and the consultant acted like he didn’t even read the case and told me to change the setup fields to 0.01. He also said they don’t deal with payroll issues. I don’t believe this is a payroll issue. In a Cronus database, he set the value at 1, posted some general journal entries, then changed it to 0.01, and says that it works fine after you change it. I’m not getting that result. I've got to get this system to round to the nearest penny not the nearest dollar. Any ideas?

WearAllHats

Nevermind. Microsoft just responded with the correct answer. There is a bug when setting up a new company. "Amount Rounding Precision" and “Unit Amount Rounding Precision” fields in the general ledger default to 1. The "Amount Decimal Places" and "Unit-Amount Decimal Places" default to blank. Once I fixed the "Amount Decimal Places" and "Unit-Amount Decimal Places" fields to 2:2 and 2:5 it works now.