Gen. Jnl. Allocation Table

Specifies recurring journal in the Gen. Jnl. Allocation table. You must be in a recurring journal to see the table.

The table is used to allocate the amount on the recurring journal line to several accounts and dimensions. That is, the allocation is a balancing account line to the recurring journal line.

Just as in a recurring journal, you need to enter an allocation only once. The allocation will remain in the allocation journal after posting, so you do not need to enter amounts and allocations every time you post the recurring journal line.

Here is an example in which a user has defined a global dimension as Department:

You pay rent every month, so you have entered the rent amount on the cash account on a recurring journal line. In the allocation journal you can divide the expense among several departments according to the number of square feet each one occupies. The calculation is based on the allocation table for each allocation journal line.

You can enter various accounts on every allocation journal line (if rent will also be divided among several accounts) or enter the same account, but with various dimension value codes for the dimension Department on each line.

Before you choose Allocation, click the recurring journal line to be allocated.

In the allocation table you must set up an allocation journal line for each part of the amount that will be allocated.

Important

The VAT fields can be filled in on either the recurring journal line or on the allocation journal line, but not on both. That is, they can be filled in on the allocation journal only if the corresponding lines in the recurring journal are not filled in.

If the Recurring Method in the recurring journal line is set to Balance or Reversing Balance, the program will disregard any global dimension value codes in the recurring journal when the account is set to zero.

That is, if in the allocation journal you allocate a recurring line to various global dimensions, only one reversing entry will be created. Therefore, if in the allocation journal you allocate a recurring journal line that contains a global dimension value code, you must not enter the same code in the allocation journal. If you do, the figures for the global dimensions will be incorrect.

List of Fields in the Table

To see the list of fields in this table, change to the Classic view. Choose the Choose View button in the upper-right corner, and then choose Classic.

Field Location
Gen. Bus. Posting Group Field, Gen. Jnl. Allocation Table General Ledger
Shortcut Dimension 1 Code Field, Gen. Jnl. Allocation Table General Ledger
Journal Batch Name Field, Gen. Jnl. Allocation Table General Ledger
Allocation % Field, Gen. Jnl. Allocation Table General Ledger
Shortcut Dimension 2 Code Field, Gen. Jnl. Allocation Table General Ledger
Dimension Set ID Field, Gen. Jnl. Allocation Table General Ledger
Account No. Field, Gen. Jnl. Allocation Table General Ledger
Gen. Posting Type Field, Gen. Jnl. Allocation Table General Ledger
Amount Field, Gen. Jnl. Allocation Table General Ledger
VAT Calculation Type Field, Gen. Jnl. Allocation Table General Ledger
Allocation Quantity Field, Gen. Jnl. Allocation Table General Ledger
VAT Prod. Posting Group Field, Gen. Jnl. Allocation Table General Ledger
Use Tax Field, Gen. Jnl. Allocation Table General Ledger
VAT Bus. Posting Group Field, Gen. Jnl. Allocation Table General Ledger
Journal Line No. Field, Gen. Jnl. Allocation Table General Ledger
Additional-Currency Amount Field, Gen. Jnl. Allocation Table General Ledger
Tax Area Code Field, Gen. Jnl. Allocation Table General Ledger
Tax Liable Field, Gen. Jnl. Allocation Table General Ledger
Account Name Field, Gen. Jnl. Allocation Table General Ledger
Journal Template Name Field, Gen. Jnl. Allocation Table General Ledger
VAT Amount Field, Gen. Jnl. Allocation Table General Ledger
VAT % Field, Gen. Jnl. Allocation Table General Ledger
Gen. Prod. Posting Group Field, Gen. Jnl. Allocation Table General Ledger
Line No. Field, Gen. Jnl. Allocation Table General Ledger
Tax Group Code Field, Gen. Jnl. Allocation Table General Ledger
Deductible % Field, Gen. Jnl. Allocation Table Italy Local Functionality

See Also

Reference

Recurring
Dimension
Recurring Method
Allocations