Set up default dimensions

Completed

You can assign default dimensions for a specific account. The dimensions and dimension values are copied to the journal or document when you enter the account number on a header or a line, but you can delete or change the codes if appropriate. You can also specify which dimension values are allowed for an account.

Default dimensions can be entered for a single account or for multiple accounts. Setting up default dimensions for multiple accounts will save setup time.

For example, if you use an area, region, or country dimension instead of entering the default dimension on a customer per customer (Dimensions - single) basis, you can first apply a country/region code filter on the Customers page, select all the customers, and set the default dimension for all customers combined (Dimensions - Multiple).

You can use the Value Posting field to make dimensions and/or dimension values mandatory.

The value posting rules options are:

  • Blank - There is no posting restriction. This default dimension for this account can be posted with any dimension value or without a dimension value.

  • Code Mandatory - The default dimension for this account must have a dimension value when you are posting, but any dimension value is acceptable.

  • Same Code - The default dimension for this account must always have the same dimension value code as the one that was selected in the Dimension Value Code field.

  • No Code - Dimension value codes must not be used with this account.

If an account is used in the Adjust Exchange Rates batch job or the Post Inventory Cost to G/L batch job, do not select Code Mandatory or Same Code. These batch jobs can't use dimension codes.

In the Allowed Values Filter field, you can enter the dimension values that are allowed for the account you are assigning default dimensions to. The result is that users can pick from a predefined list of allowed dimension values on journals and documents.

To assign a default dimension to a customer, follow these steps:

  1. Select the Search for Page icon in the top-right corner of the page, enter customer, and then select the related link.

  2. Select the customer to which you want to assign the default dimension, for example customer 10000.

  3. On the action menu, select Customer and then Dimensions-Single.

  4. On the Default Dimensions page, in the Dimension Code field, select a dimension, for example DEPARTMENT.

  5. In the Dimension Value Code field, select a dimension value, for example SALES.

  6. If this dimension is now mandatory for customer 10000 and LARGE is the only possible dimension value, go to the Value Posting field and select Same Code.

  7. If you also want to allow department ADM but not PROD as possible dimension values for this customer, select the Allowed Values Filter field.

  8. Place a checkmark in the Allowed field for the SALES and ADM dimension value codes.

  9. Close the Default Dimensions page.

Screenshot of the Default dimensions page.

Set up default dimensions for multiple accounts

You can also assign default dimension to multiple accounts at once, for example, to all customers of the same region of to all items of the same product group.

  1. Select the search for page icon in the top-right corner of the page, enter customer, and then select the related link.

  2. Select the customers to which you want to assign the default dimension, for example customers 10000, 20000, 30000, 40000, and 50000.

  3. On the action menu, select Customer and then Dimensions-Multiple. If these customers already have default dimensions, they will appear in the Default Dimensions-Multiple page, but you can overwrite them to assign the same default dimensions to every customer in your selection.

  4. On the Default Dimensions-Multiple page, edit or enter a new line for the AREA dimension by doing the following:

    1. Select Edit List.

    2. In the Dimension Code field, make sure AREA is selected.

    3. In the Dimension Value Code field, select a dimension value, for example 70.

  5. In the Value Posting field, select Code Mandatory.

  6. If you also want to allow region 80 as possible dimension values for these customers, select the Allowed Values Filter field.

  7. Place a checkmark in the Allowed field for the 70 and 80 dimension value codes.

  8. Close the Default Dimensions page.