We set up a percentage miscellaneous charge that is added to the header of each order we create.
When the order is invoiced, because a charge is created for each line on the invoice, it can introduce rounding differences in the amounts shown on the order versus the invoice.
Is there any way to avoid this? I’m thinking the answer is no, except for adding the charge to each order line instead of the header, which clutters the order acknowledgement form with a bunch of extra charges.
Regardless, this could still happen with orders that spawn multiple invoices.
The easiest way to avoid this in my experience is to simply train staff to convert the percentage to a flat amount so that the charge is not split into multiple. (The whole amount will go on the last line of the invoice since there are still no invoice header charges.)
The problem with that approach is that it applies the entire amount on the invoice, even if it’s for a partial order shipment. There’s no way to split that amount across all the invoices for an order (that I know of, at least).
rounding is something that always happens… take sales tax for instance… if you print the order with sales tax, you will get one value, but then if you do a bunch of partial shipments, the tax rounding will cause the total sales tax between all the invoices to be different than the sales order when printed initially. This is easy to explain, and sometimes that is the only way to counter this.. we are typically talking about a few cents here and there… In the end, the GL will balance, but customers may need to accept that their order will be off a few cents.