Invoice Discount Calculations (Rounding Issue)

Kinetic ERP
1

Hello folks!

I’m researching an issue between an offline transaction made by our ecommerce platform and the integrated order in Epicor.

The ecommerce order issued a 10% discount to the order. Normally you would calculate a discount using rounding. For example, a $10.08 subtotal at a 10% discount would mathematically calculate to $1.008 – but you can’t hand the customer 80% of a penny, so you only give the customer a $1.00 discount – thereby transacting the order for $9.08 ($10.08 - $1.00).

Makes sense, right?

Well Epicor processes a $10.08 at a 10% discount for a discount amount of $1.01 (it gave the customer too much money by rounding up that 8/10 of a penny to a whole penny. So the invoice results in an amount different from the ecommerce transaction total.

Thus our reconciliations between the creditcard settlements and the invoices are off by pennies very regularly.

Is this a Epicor config issue or a known “thing” ?

Thoughts anyone? Thanks! :+1:

2

Discounted invoices represented an issue with outbound EDI invoice transactions for customers requesting two-decimal unit prices. This would be less of an issue if three-decimal unit pricing were accepted by external customers.

3

Not really applicable to my situation since our creditcard company has already transacted totals, but noted.