Previous  Next          Contents  Index  Glossary  Library

Creating User-Defined Formulas

Use the Multiple Tax Distributions window to build a user-defined formula that lets you define rebate capabilities for a set of tax names as well as automatically distributing the tax lines for your invoices. See Canadian Sales Taxes for more information about rebate tax codes and how to setup parameters in the Tax Names window.

To create a user-defined formula:

1. Navigate to the Multiple Tax Distributions window (Canadian Globalization: Setup > Tax > Distributions)

2. In the Group Name field, pick a group name from the list of values that is representative of the multiple tax codes in the Tax Distribution region.

The tax type and rate are both displayed for the group name that you enter.

3. Enter the dates that you want the group name to become effective or inactive in the Effective Date fields.

4. Enter a description for your group name in the Description field.

Suggestion: Establish a naming convention to distinguish group names from individual tax codes.

5. In the Distribution Tax Name field, enter the tax code that represents a portion of the composite tax amount.

The tax rate percent is automatically displayed in the % field.

6. In the Rule Type field, enter the Rule Type from the poplist. There are three choices:

Name
Poplist
Example
Base
Base
Tax code that the rebate can draw from, such as GST or TPS
Debit
DR
The tax value account that is submitted for rebate
Credit
CR
The account that offsets the base tax rule (reduces the base account)
7. Check the rebate check box to indicate that a rebate is applicable to this tax name. The rebate check box should always be checked when used in conjunction with a base rule type that has a rebate.

8. Choose the Distribution Tax Name and corresponding Tax Number that applies to your rebate in the Rebate Tax Name field.

The Tax Number is automatically displayed in the Tax Num field.

9. Check the Use Item Account check box to control which account code combination is used for automatic tax line generation.

10. Enter a description for your Distribution Tax Name line in the Distribution field.

Warning: Disabling a MTD formula by entering an end date could result in incorrect tax being calculated. To avoid calculating incorrect tax, inactivate the formula in the Distributions window as well as the corresponding Tax Names in the Tax Names window.

         Previous  Next          Contents  Index  Glossary  Library