Concepts
- Journal template and batch. The Advanced Allocations worksheet always works on one General Journal template and batch - at QUALIA Technik the template
ADVALLOCwith the batchFACILITY- and posts the allocated lines in that batch. The batch also carries the allocation source. - Source and target. The source is what the allocation is built from; the target is the G/L account the allocated lines are booked to. When Monika Vogel shares the January electricity, the source is G/L account
6510Electricity and the target is6800Allocated Costs. - Allocation source type. Each General Journal batch decides where its allocation comes from: Statistical (posted statistical entries such as headcount), G/L Account (actual posted G/L entries) or Allocation (a Quick Key template). Allocation is the source type that carries a Quick Key template, for distributing lines over the template with Distribute Lines; for the Advanced Allocations worksheet choose Statistical or G/L Account, and use a Quick Key template directly with Distribute Lines on purchase and sales documents and journals instead (chapter 2). The source fields - Source No., Source Dimension 1 Code, Source Fund, Target G/L Account and others - are filled in on the batch; the Advanced Allocations worksheet only shows them, read-only.
- Posting Date and Document No. you enter on the worksheet before you run Calculate Allocation: they go on the allocated lines that the worksheet creates and posts. Monika Vogel enters posting date 31.01.2026 and document number JAN-ELEC-2026 for the January electricity.
- Source Fund and Source Fund 2 are the fund dimension values of the source, for example the fund an entry was booked under; you fill them in only when you allocate from fund entries.
- Dimensions are the Business Central values you group transactions by, here DEPARTMENT with the values
PROD,SALES,ADMINandIT. An allocation is calculated by a source dimension: the January electricity amounts, already split by DEPARTMENT, give one line per department on account6800. - Statistical entry: a quantity, not money - how many employees, how many square metres. Timo Schulz posts the January headcount (PROD 12, SALES 8, ADMIN 5, IT 3) to the statistical account
HEADCOUNT. Posted entries are kept in the Statistical Ledger Entries list. - Quick Key allocation: a saved template that splits one amount over several G/L accounts and dimensions; using a template instead of typing the split each time removes data entry errors.
IT-SUPPLIESgives account6800PROD 40 %, SALES 25 %, ADMIN 25 %, IT 10 %. Each template line has a G/L Account No., dimensions and an Allocation %; make the template's lines add up to 100 %. A blocked template can't be used on new lines. - Allocation percentage: on a template or a worksheet line, Allocation % says how much of the amount the line receives. The Total Allocation % at the bottom of the Advanced Allocations worksheet is the total of the lines' Allocation % and reaches 100 before you post. The Total Allocation % on the Quick Key card is read-only, so you can't enter a value in it; it may also show nothing at all, so don't rely on it: make the template's lines add up to 100 %.
- Analysis view: a standard Business Central view you use when the allocation reads its source amounts through dimensions; its code is entered on the journal batch's Analysis View field.
- The lines the worksheet posts are ordinary General Journal lines, marked as advanced allocation, so you can recognize them later in the journal and in the G/L entries. A line distributed over a Quick Key template carries the template's number on the journal line.
