...
| 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 |
ucGLLineSegment
Determines how the balance for the ulGLCriteria option direct should be allocated.
...
Note that this field is ignored if the ulGLCriteria is not direct.
ulGLWarehouse
ulGLRebate
Determines how the balance for the ulGLCriteria option Litres/packs should be allocated.
Options: 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.
ulGLBudgetCalculationOption
...
The budgets are stored in the table called _as_RayyanBudgets. This table contains a per month per item budget for the indicated options
On Item
ulIIItemReportGroup
ufIIPACKLTR
On Manufactures
ulMANULineSegment
ulIIItemType
Determines they type of the item. If selected either of the 2 options below, the item will be includes in the report and in all calculations
Options: Rayyan; Private label
ufIIPACKLTR
Determines total litres in 1 pack
Options: Float number
uiIIPCSPERPACK
Determines the total pieces per pack
Options: Float number
On Manufactures
ulMANULineSegment
Determines the line for the specific manufacture
Options: Float number
On Invoice
SalesRep.Address3
All invoices are linked to a Salesrep. The Address3 field determines to what segment the sales is considered.
This value is needed to allocate the costs when the option Litre,Pc,Packs
SalesRep.Bank_Account
All invoices are linked to a Salesrep. The Address3 field determines to what segment the sales is considered.
Pages
1) Production expenses
...
Sales detail
1) Sales detail
TO DO
Check PCS on Production vs Packs on Logistics