Hi, has anyone experienced DR an CR side being off by 0.01 due to rounding? We have GL control set up for rounding to go to FX Realized, but it doesn’t pick up this on one particular invoice. I can’t adjust any values on the invoice since they pull from a sales order (partial shipment), discount field would put an adjustment to the CR side, but I need to adjust the DR side. There is no point of adjusting the cash receipt by one cent, as this invoice was only partial invoice and there is remaining balance on this sales order for the next shipment. How do I solve this?
Did you setup GL Controls correctly in Book master for rounding?
If I remember accurately, I think we ran into this recently for supposedly the first time in our 5.5 years on Epicor, though it was some kind of COS transaction and not AR.
But either way, I’m not sure that you could avoid it, but there is a way to give it a place to go.
There are places on the GL controls for rounding and yours may be blank (like ours is for AR apparently…).
I was going to say to consult the AR Tech ref, but there is no mention of “round” in the entire thing.
When the rounding is generated at the posting engine, meaning you don’t see it in AR Invoice Entry, it goes to the account defined in GL Book Maintenance.
But if you can see the rounding in the entry, try enabling Logging for the “AR Invoice” GL Transaction Type and review the edit list transactions in PE Log Viewer to see why that cent is not going anywhere.
Thanks, Jason! Yes, I have found out that GL controls were not set up for this customer and this would normally go to Default account (like you suggested above), and this Default account we have never specified what should happen with rounding. So, this is a good idea to define it there as well to prevent this happening in future. Thanks for taking the time!
Yes, in the GL maintenance for AR rounding was set up, but the customer set up was missing the GL link to AR, this was the problem. Thank you!