Rounding errors when Posting Sales Invoices

John_Dickey

Reputable Poster
Has anyone else had problems when posting sales invoices (batch type I) with
rounding differences?? I would say that about 0.25% of our invoices will
somehow end up a penny or two out of balance, causing the batch to not post.
So not a real frequent error, but compounded because the JDE posting edit
report does not tell you the invoice number (RI) in error, so a real pain to
find the bad invoice(s).

John Dickey
JDE Financial Systems
Administrator/Programmer/Analyst
White-Rodgers, Division of Emerson
St. Louis, MO
314-577-1466
 
John

Do you have multicurrency turned on? At a previous company, we had the
same problem, and we were running with multicurrency on cum 9. Extremely
frustrating. A JDE SAR existed for the problem, but it was a 6 digit
SAR-extremely old. All we could do was locate the invoice in error, and
use DFU or EZVIEW to fix it.




Chuck Bower
VP of IS
Coachmen Industries, Inc.
A73C8
 
Re: RE: Rounding errors when Posting Sales Invoices

We are on Cum 7, having multicurrency, with ECS Order Processing switched on. (those days, ECS is separate from normal Sales Order Processing) Usually, Foreign Values balance and Base Currency values are out of balance.

If you are not on ECS, try repricing the orders P42950 (if acceptable) before final Sales Update. This might help.
 
I have the same issue now.
I thought to do as below ( as the difference is 0.01)

- Post the batch out of balance
- Adjust the difference using journal entry.

Is there any better solution ?
 
Back
Top