How subtotal dimensions are determined at the top level

For transactions that are entered at the top level in a multi-entity environment, the value of the dimensions in the subtotals depend on how the application is configured.

The following 2 options control the dimensions in the subtotals at the top level:

  • Use line-item dimensions in the subtotals at the top level
  • Edit subtotal dimensions at the top level

Neither option is selected

When you do not select Use line-item dimensions in the subtotals at the top level and Edit subtotal dimensions at the top level, users cannot affect the dimension values in a transaction's subtotals at the top level.

Only Use line-item dimensions in the subtotals is selected

When you select only Use line-item dimensions in the subtotals at the top level, Sage Intacct uses the dimension values that are set in the line items for the subtotal lines for transactions entered at the top level.

Subtotal amounts are distributed in proportion to the line-item amounts in each transaction. The corresponding line-item dimensions are posted to Accounts Receivable and the General Ledger.

This option makes it easier to enter transactions in which the dimension values vary across the line items and automatically assign the same dimensions to the subtotal lines.

Assume you have a PO purchase invoice that posts to Accounts Payable. The invoice has two line items and subtotals with a line for discounts. For the line items, you set different values for the Class dimension:

Line item entries Class dimension
Item 01 Class 1
Item 02 Class 2
Subtotals Class dimension
Discount Cannot be set

When you view the corresponding AP supplier invoice, you see that the Class dimension for the discount is set from the line items:

Account Item Class dimension
6300 Supplies Item 01 Class 1
6300 Supplies Item 02 Class 2
7501 Discounts Item 01 Class 1
7501 Discounts Item 02 Class 2

Only Edit subtotal dimensions is selected

When you select only Edit subtotal dimensions at the top level, users can select the dimension values for any subtotal line in a transaction entered at the top level. Any dimension values set in the line items are ignored in the subtotal lines.

Assume you have a PO purchase invoice that posts to Accounts Payable. The invoice has two line items and subtotals with a line for discounts. For the line items, you set different values for the Class dimension:

Line item entries Class dimension
Item 01 Class 1
Item 02 Class 2
Subtotals Class dimension
Discount Class 3

When you view the corresponding AP supplier invoice, you see the Class dimension for the discount subtotal, Class 3, is used:

Account Item Class dimension
6300 Supplies Item 01 Class 1
6300 Supplies Item 02 Class 2
7501 Discounts Item 01 Class 3
7501 Discounts Item 02 Class 3

Both options are selected

When you select both Use line-item dimensions in the subtotals at the top level and Edit subtotal dimensions at top level, users can select the dimension values for any subtotal line in a transaction entered at the top level. However, the dimension values from the line items will override the values selected in the subtotal lines.

Assume you have a PO purchase invoice that posts to Accounts Payable. The invoice has two line items and subtotals with a line for discounts. For the line items, you set different values for the Class dimension:

Line item entries Class dimension Project dimension
Item 01 Class 1  
Item 02   Project 2
Subtotals Class dimension Project dimension
Discount Class 3 Project 3

When you view the corresponding AP supplier invoice, for the discount, you see the Class dimension for the first item (Class 1) overrides the Class dimension that was set in the subtotals (Class 3) and the Project dimension for the second item (Project 2) overrides the Project dimension that was set in the subtotals (Project 3):

Account Item Class dimension Project dimension
6300 Supplies Item 01 Class 1 --
6300 Supplies Item 02 -- Project 2
7501 Discounts Item 01 Class 1 Project 3
7501 Discounts Item 02 Class 3 Project 2