...
| Options | Calculation | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Budget | Allocated the full GL balance based on the selected calculation option of ulGLBudgetCalculationOption. The dashboard page "9) Budget overview" contains an overview of the budget table content and the calculations for allocating to Segments per calculation option. It calculates the % of the grand total of the selection option as a percentage to use for the expenditure allocation. Note that this option is not available for production/line based expenditure | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | Allocated the full GL balance based on the percentage litres sold per segment for the selected period. Based on the SalesRep.Address3 field Sales is allocated to a specific segment. Based on this field a % of total is calculated per segment. These percentages are available in the page "10) Sales & Production overview"
Note that Logistics requires an additional value in the UDF ulGLWarehouse : SDW;SDWII;Both Based on the selected option it includes/exclude sales made via the SDW or SDWII in the percentage of total litres/packs sold. This field corresponds with the value SalesRep.Bank_Account on the invoice. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Packs | Same as litres, however it looks at packs sold instead of Litres sold. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Pcs | Allocated the full GL balance based on the percentage of pcs manufactured per line for the selected period.
Currently Note only available in Production/line option |
...
All invoices are linked to a Salesrep. The Address3 field determines to what segment the sales is considered.
Sage data
All data is loaded via a SQL connection with views/functions to calculate the figure.
GL Balance
The Sage GL balances are calculated by summing all transactions per GL account per financial period. These balances will correspond with an user running a Trial balance from the Sage UI.
Sales data
The Sales is loaded into the report consolidated per day, meaning it is not available per invoice (this to lower the amount of data to compute in the report). This information is however available in the "Sales detail" Dashboard.
Sales consists of archived documents of the type: Case invoice (0), Credit note (1) and Sales Order (4)
Only the lines that contain stock items of the type "Rayyan" and "Private label" are loaded in the data.
Manufacture data
The manufacture data is loaded per manufacture transaction. Only the manufactures that contain a value on the UDF ulMANULineSegment and which are processed are loaded into the report.
Pages
1) Production expenses
...