...
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
Contains the GL accounts that have the value "Production" filled in the UDF ulGLAccGroup.
This overview will split the expenditure over the various lines. Meaning this overview is not segment based. In report 7 & 8 you will only see this split between Fixed and Variable.
Note that this Expenditure is split over the items based on either "% of total litres sold" or "% of total revenue" (Based on the selected option in the menu on report 7 & 8)
The sum of all the lines (in the columns) will add up to the total of all lines (most bottom right figure). This figure will correspond with the sum of all Fixed and Variable costs allocations per item if you were to export the report to Excel.
2) Logistics expenses
Contains the GL accounts that have the value "Logistics" filled in the UDF ulGLAccGroup.
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.
This overview will split the expenditure over the various segments.
Note that this Expenditure is split over the items based on either "% of total litres sold" or "% of total revenue" (Based on the selected option in the menu on report 7 & 8)
The sum of all the Segments (in the columns) will add up to the total of all segments (most bottom right figure). This figure will correspond with the sum of all Fixed and Variable costs allocations per item if you were to export the report to Excel.
3 - A) Sales expenses
Contains the GL accounts that have the value "Sales" filled in the UDF ulGLAccGroup.
This overview will split the expenditure over the various segments.
Note that this Expenditure is split over the items based on either "% of total litres sold" or "% of total revenue" (Based on the selected option in the menu on report 7 & 8)
The sum of all the Segments (in the columns) will add up to the total of all segments (most bottom right figure). This figure will correspond with the sum of all Fixed and Variable costs allocations per item if you were to export the report to Excel.
3 - B) Sales expenses - Rebates
Contains the GL accounts that have the value "Sales - Rebates" filled in the UDF ulGLAccGroup.
This overview will split the expenditure over the various segments.
Note that this Expenditure is split over the items based on either "% of total litres sold" or "% of total revenue" (Based on the selected option in the menu on report 7 & 8)
The sum of all the Segments (in the columns) will add up to the total of all segments (most bottom right figure). This figure will correspond with the sum of all Fixed and Variable costs allocations per item if you were to export the report to Excel.
4) Marketing expenses
Contains the GL accounts that have the value "Marketing" filled in the UDF ulGLAccGroup.
This overview will split the expenditure over the various segments.
Note that this Expenditure is split over the items based on either "% of total litres sold" or "% of total revenue" (Based on the selected option in the menu on report 7 & 8)
The sum of all the Segments (in the columns) will add up to the total of all segments (most bottom right figure). This figure will correspond with the sum of all Fixed and Variable costs allocations per item if you were to export the report to Excel.
5) IT & administration
Contains the GL accounts that have the value "Admin & IT" filled in the UDF ulGLAccGroup.
This overview will split the expenditure over the various segments.
Note that this Expenditure is split over the items based on either "% of total litres sold" or "% of total revenue" (Based on the selected option in the menu on report 7 & 8)
The sum of all the Segments (in the columns) will add up to the total of all segments (most bottom right figure). This figure will correspond with the sum of all Fixed and Variable costs allocations per item if you were to export the report to Excel.
7) Costing and pricing overview
8a) Performance overview - per SKU
8b) Performance overview - per channel
9) Budget overview
10) Sales & Production overview
11) Stock % per Line
Sales detail
This dashboard is made for reconciliation purposes. While the sales data is loaded group per day in the main dashboard, here it will be loaded per invoice, making it easier to trace inside Sage.
...