Rounding Total Sales Invoice Amount after taxes

Carmen_S

The one-cent coin is scheduled to go out of circulation in Canada.
This means that for all cash sales, we need to round the
Total Sales Invoice Amount to .00 or .05
after the sales taxes are calculated.

If anybody has done something like this before,
any advice would be appreciated.

Thanks,
Carmen

Carmen_S

Well, here is what we are doing, in case anyone is interested:

1. Added a new "Cash Payment Rounding Acct. No." field to the sales and receivables setup
to define the account that will get the payment rounding for cash payments.
2. Changed the "PostBalancing" Function in codeunit 80 as follows:
- It normally posts the total invoice amount to the bank. - we changed it to post the to post the rounded amount to the bank. We used the round function with a 0.05 precision.
- post a second gen. jnl. line to the customer and balance to the "Cash Payment Rounding Acct. No." for the difference between the total invoice amount and the rounded total invoice amount.
- this of course only happens for a payment method of cash
3. Changed the Sales Invoice and Sales Credit Memo reports to add the cash rounding amount if necessary so that the Total Amount to pay is rounded.

This works well for us.
Let me know if you have any questions.

Regards,
Carmen