To Set Up Document Amount Rounding

Your company policy or local regulations may require that you round the amounts on invoices and bills. For more information, see Rounding of Document Amounts.

You set up the rounding rules and rounding precision for Accounts Payable bills by using the Accounts Payable Preferences (AP101000) form, and for Accounts Receivable invoices by using the Accounts Receivable Preferences (AR101000) form.

Before You Proceed

  1. On the Enable/Disable Features (CS100000) form, make sure that the Invoice Rounding check box is selected, which indicates that the feature is enabled. For details, see Preparing an Instance for Implementation.
  2. Make sure the rounding gain and loss accounts (and subaccounts, if they are used in your system) for the base currency are specified on the General Ledger Preferences (GL102000) form, and that the accounts and subaccounts for each foreign currency used by your customers and vendors are specified on the Currencies (CM202000) form.

To Set Up Rounding Rules for AP Bills

  1. Open Accounts Payable Preferences (AP101000) form.
  2. In the Rounding Rule for Bills box, select one of the following rules to be used to round the totals of AP bills:
    • Use the Currency Precision: To round the total amount of each document according to the precision of the currency of the document. With this option selected, the system will process the documents as if the document rounding feature is not enabled for AP documents.
    • Nearest: To round the total amount of each document to the nearest multiple of the smallest unit selected as the rounding precision.
    • Up: To round each total amount up to the next multiple of the smallest unit selected as the rounding precision.
    • Down: To round each total amount down to the previous multiple of the smallest unit selected as the rounding precision.
  3. In the Rounding Precision box, select the smallest unit (rounding precision) to which the totals will be rounded. Select one of the following precision options to be used for rounding:
    • 0.05: To round each total to a multiple of 0.05
    • 0.1: To round the totals to multiples of 0.10
    • 0.5: To round the totals to multiples of 0.5
    • 1.0: To round the totals to integers
    • 10.0: To round the totals to multiples of 10
    • 100.0: To round the totals to multiples of 100
  4. Click Save on the form toolbar.
Note:

The system will use the same rounding precision for all currencies. You can override the rounding settings specified on the Accounts Payable Preferences form for a particular currency by using the Currencies (CM202000) form.

To do this, you clear the Use AP Preferences Settings check box and specify the rounding precision on the Rounding Settings tab of this form.

To Set Up Rounding Rules for AR Invoices

  1. Open the Accounts Receivable Preferences (AR101000) form.
  2. In the Rounding Rule for Invoices box, select one of the following rules to be used to round the totals of AR invoices:
    • Use the Currency Precision: To round the total amount of each document according to the precision of the currency of the document
    • Nearest: To round the total amount of each document to the nearest multiple of the selected smallest unit selected as the rounding precision
    • Up: To round each document total amount up to the next multiple of the smallest unit selected as the rounding precision
    • Down: To round each document total down to the previous multiple of the smallest unit selected as the rounding precision
  3. In the Rounding Precision box, select the precision to which the totals will be rounded. Select one of the following available precision options as the smallest unit to which the amounts should be rounded:
    • 0.1: To round the totals to multiples of 0.10
    • 0.5: To round the totals to multiples of 0.5
    • 1.0: To round the totals to integers
    • 10.0: To round the totals to multiples of 10
    • 100.0: To round the totals to multiples of 100
  4. Click Save on the form toolbar.
Note:
The system will use the same rounding precision for all currencies. You can override the rounding settings specified on the Accounts Receivable Preferences form for a particular currency by using the Currencies (CM202000) form.

To do this, you clear the Use AR Preferences Settings check box and specify the rounding precision on the Rounding Settings tab of this form.