The routine of offline apportionment by combinations is meant to avoid the need to register repetitive apportionment when the same rule is applied to several entity combinations.
The system considers the same register used by the offline apportionment routine; however, it searches for all entry occurrences of entities filled in the column Origin, combined with any entity authorized in Management Accounting environment (Account, Cost, Item, Value Class) which corresponds to codes left blank in the column Origin of the apportionment.
See the example of functioning comparison, considering an Apportionment Register in which authorized entities are "C. Center" and "Accounting Item" and, in the column Origin, only codes of Account and Accounting Item are filled.
Example of entry in Accounting:
Account | C. Center | Item | Value |
41101 | 1000 | 100 | 20.00 |
41101 | 2000 | 100 | 100.00 |
41101 | 3000 | 100 | 1000.00 |
41101 |
| 100 | 10000.00 |
Apportionment Register - Column Origin:
Account | C. Center | Item |
41101 |
| 100 |
Apportionment register - Column Balancing Item (Items in the Offline Apportionment File):
Account | C. Center | Item | % |
41101 | 4000 | 100 | 25.00 |
41101 | 5000 | 100 | 25.00 |
41101 | 6000 | 100 | 50.00 |
Apportionments generated through Combinations (CTBA281):
Account | C. Center | Item | Value |
41101 | 4000 | 100 | 5.00 |
41101 | 5000 | 100 | 5.00 |
41101 | 6000 | 100 | 10.00 |
41101 | 4000 | 100 | 25.00 |
41101 | 5000 | 100 | 25.00 |
41101 | 6000 | 100 | 50.00 |
41101 | 4000 | 100 | 250.00 |
41101 | 5000 | 100 | 250.00 |
41101 | 6000 | 100 | 500.00 |
41101 | 4000 | 100 | 2500.00 |
41101 | 5000 | 100 | 2500.00 |
41101 | 6000 | 100 | 5000.00 |
Apportionments generated by Offline Apportionment (CTBA280):
Account | C. Center | Item | Value |
41101 | 4000 | 100 | 2500.00 |
41101 | 5000 | 100 | 2500.00 |
41101 | 6000 | 100 | 5000.00 |
Procedures
Generating the offline apportionment by combinations:
- In the Offline Apportionment by Combinations maintenance window, the routine description is displayed.
- Click Parameters.
The routine parameters window is displayed.
- Pay attention to the following information:
Enter date to be considered in order to obtain balances/transactions to be apportioned. If the type "transaction" is indicated in the Apportionment Register, all transactions carried out from the first day of the month indicated in the reference date till the indicated date are considered.
Enter the lot number to identify entries to be generated by the apportionment.
Enter the lot number to identify entries to be generated by the apportionment.
Enter the lot number to identify entries to be generated by the apportionment.
Enter code of standard history to be used in entries generated by the apportionment.
Code of initial apportionment to be considered for processing.
Code of final apportionment to be considered for processing.
Indicate "All" to process all currencies or "Specific" to process a single currency.
If this is indicated as "Specific," the code of currency to be processed must be filled. If it is indicated as "All," this parameter is ignored.
Type of balance to be considered to obtain balances in apportionment processing.
Note: For entities left blank in the Apportionment Register, the following filters shall be applied. If filters below are indicated in the existing combinations of entities in balance tables, only those that are part of the range indicated shall be considered.
Code of initial ledger account that must be considered for the apportionment.
Code of final ledger account that must be considered for the apportionment.
Code of the initial cost center to be considered for the apportionment.
Code of the final cost center to be considered for the apportionment.
- Initial Origin Accounting Item
Code of initial accounting item that must be considered for the apportionment.
- Final Origin Accounting Item
Code of final accounting item that must be considered for the apportionment.
Code of initial value class to be considered for the apportionment.
Code of final value class to be considered for the apportionment.
- Reproc. Before|Between|After
You can select in which phase the processing for balance update must be performed: before the apportionment, between apportionments, or after apportionments.
This configuration has three numeric positions, XXX, one for each processing phase:
1st position - represents the phase prior to the beginning of apportionment;
2nd position - represents the phase between apportionments;
3rd position - represents the final phase of apportionments.
Each position must be filled with content 1 to reprocess or 2 not to reprocess.
Example:
111 = Reprocess balances in all phases: before start of apportionments, between them and by the end of them.
222 = Does not perform update of balances in any phase.
211 = Reprocess balances in the phase between apportionments and in the phase at the end of apportionments.
- Check parameters and confirm them.
The system goes back to the routine description screen.
- Confirm it again.
A window is displayed to confirm the operation.
- Upon confirmation, the processing is started.
See Also
Topic Apportionment Methods.