Diana_Apple
Well Known Member
This is weird. Maybe someone can tell me what happened.
A taxable sales order was entered about 6 days ago.
There was one line item on the order with a unit price of 5.0400 and an extended amount of 5.04.
The ship ticket was printed on that same day.
Then someone realized the item number was incorrect, deleted the line item from the order, and added a new line with the correct item #. The unit price for this item was 4.7700 and the extended price was 4.77. Another ship ticket was printed.
Then yesterday, the unit price was changed from 4.7700 to 5.0400 and according to our audit (F42199), the extended amount was changed to 5.04. So far so good. Then the order was confirmed and invoiced with the new item & price.
But last night our sales order update program (P42800) created the invoice record with 5.47 (5.04 plus .43 tax) which is correct, but the G/L entry showed a distribution amt of 4.77 and sales tax payable amt of .43. Can someone tell me how JDE got the 4.77 for the G/L distribution amt? It should have been 5.04!
Fortunately it was easy to fix the wrong amount. But I still would like to know how it happened. I did try to find out if this type of error has been addressed before in this list, but gave up after an hour of searching.
A taxable sales order was entered about 6 days ago.
There was one line item on the order with a unit price of 5.0400 and an extended amount of 5.04.
The ship ticket was printed on that same day.
Then someone realized the item number was incorrect, deleted the line item from the order, and added a new line with the correct item #. The unit price for this item was 4.7700 and the extended price was 4.77. Another ship ticket was printed.
Then yesterday, the unit price was changed from 4.7700 to 5.0400 and according to our audit (F42199), the extended amount was changed to 5.04. So far so good. Then the order was confirmed and invoiced with the new item & price.
But last night our sales order update program (P42800) created the invoice record with 5.47 (5.04 plus .43 tax) which is correct, but the G/L entry showed a distribution amt of 4.77 and sales tax payable amt of .43. Can someone tell me how JDE got the 4.77 for the G/L distribution amt? It should have been 5.04!
Fortunately it was easy to fix the wrong amount. But I still would like to know how it happened. I did try to find out if this type of error has been addressed before in this list, but gave up after an hour of searching.