Offline Apportionment Combinations (CTBA281 - SIGACTB)

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:

Reference Date

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.

Lot Number

Enter the lot number to identify entries to be generated by the apportionment.

Sub-lot number

Enter the lot number to identify entries to be generated by the apportionment.

Document Number

Enter the lot number to identify entries to be generated by the apportionment.

Code of Standard History

Enter code of standard history to be used in entries generated by the apportionment.

From Apportionment

Code of initial apportionment to be considered for processing.

To Apportionment

Code of final apportionment to be considered for processing.

Currencies

Indicate "All" to process all currencies or "Specific" to process a single currency.

Which 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.

Balance Type

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.

Initial Origin Account

Code of initial ledger account that must be considered for the apportionment.

Final Origin Account

Code of final ledger account that must be considered for the apportionment.

Initial Origin C. Center

Code of the initial cost center to be considered for the apportionment.

Final Origin C. Center

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.

Initial Origin V. Class

Code of initial value class to be considered for the apportionment.

Final Origin V. Class

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.

Child pages

Offline Apportionment Combinations (CTBA281 - SIGACTB)