This is extended controlling template for SAP Business One
Expand SAP Business One controlling functions.
This template's specialiszed function shows allocation for a dimension P/L.
The latest allication and profit simulation is calculated according to allocation definition by controlling.
Dimension
Dimension will be updated for the journaling item category if the following condition has met.
- Journaling entry is created by purchase management, sales management and inventory transfer.
- One unit is set for one dimension for each original documents such as purchase management, sales management and inventory transfer.
- Dimension field is NULL on journaling entry.
Journaling Dimension check
- NULL check.
- Unconformity check.
Budget Management
Export data to SAP Business One from dimension budget on an Excel sheet.
This process can support making a budget for a next year.
- Dimension budget data import.
- Dimension budget data export.
Output data
Data will be displayed by each dimension as follows:
Dimension B/S
Dimension P/L
Dimension Accounting Data List
Dimension Account Receivable Balance List
Dimension Account Payable Balance List
Dimension Sales Budget Results Comparison List
Allocation
Calculate allocation for each designated field.Sum up allocation fields and put data into one field.