...
In order for the report to pick up items and expenditure the following UDF's need to be filled in Sage
On Account
ulGLAccGroup
Determines in what section of expenditure the account should be included.
Options: Admin & IT; Catering; Logistics; Marketing; Production; Sales; Sales - Rebates
ulGLGroupType
Determines if the accounts is categorized as fixed or variable (Note that are no calculation differences based on this field, just grouping/categorisation.)
Options: Fixed; Variable
ulGLCriteria
Determines how the expenditure should be allocated to the various segments.
Options: Budget; Direct; Litre; Packs; Pcs;
| Options | Calculation | ||||||
|---|---|---|---|---|---|---|---|
| Budget | |||||||
| Direct | Allocated the full GL balance to the indicated Segment. The segment to allocate to is specified in the UDF ucGLChannelSegment (segment relates expenditure) or ucGLLineSegment (production line based expenditure) . Thevalue inside these fields should be build as followed two examples:
| ||||||
| Litre | |||||||
| Packs | |||||||
| Pcs |
ucGLLineSegment
ucGLChannelSegment
ulGLWarehouse
ulGLRebate
ulGLBudgetCalculationOption
On Item
ulIIItemReportGroup
...