Sage 100

VI calculation question: Does the PRC function round correctly if you specify to 2 decimals? Here's the original calculation: {PR.DATAENT:HOURS_RECPT_AMT}*{PR.DATAENT:RATE}*1.5 which can lead to more than 2 decimal amounts, thus out of balance PR registers. I'm thinking it should be this: prc({PR.DATAENT:HOURS_RECPT_AMT}*{PR.DATAENT:RATE}*1.5,2) Thoughts/comments/alternatives?

Yes I believe I have used that in the past as well.

I believe @JeffSchwenk is pretty familiar with this, so maybe he'll chime in.

Thanks @DawnAnastasi and @BrettZimmerman. I tested it and it seems to work correctly. Now the problem is, this company has been importing PR for a couple of years and apparently, they never noticed the out of balance registers. When I tried correcting it - by doing one-sided journal entries - it DOESN'T correct it due to the previous entries in the GL_DetailPosting file (which I'm assuming is used for the trial balance and other reports?).

That is the same rounding formula I use in several Payroll VI jobs and it came from @JeffSchwenk

@ThereseLogeais - Not following you. What are the previous entries int he GL_DetailPosting File that you are referring to?

As far as syntax and usage goes... that looks correct to me. As far as your GL_Detail Posting File, I would bet that if you look at the detail in DFDM - or even dump it to Excel - you will find un-rounded, (is that a word?), amounts that are causing all the grief.

Yes, that is the dilemma @RandyMarion. The file has 3 decimal amounts in it. Your suggestion is what @JeffSchwenk suggested as well. Since it's a matter of cents and the customer is trying to stay afloat, I don't think they want to spend ANY money trying to fix it. But thanks!