6.3.9.3.6.3.13 Management Ledger Table Processing

(Required) <Enter a short description here.>

The first step in the Ledger Migration Process with respect to the Management Ledger table is to clear all the information stored in the table with financial elements 170 and 450 (172 and 452 if remaining term pricing is being used) for the particular combination of dimensions being used in the process.

The next step is Management Ledger table accumulation: the Virtual Memory Table (VMT) is populated with the balance information stored in the Management Ledger Table. The following table represents the VMT after the Management Ledger Table accumulation has taken place. The updates are shown in bold.

Table 6-34 VMT Post Management Ledger Table Accumulation

ORG_UNIT_ID	PRODUCT_ID	Bal	Bal x TfrRate	LS Bal	LSBal x TfrRate
1	3	300.00	1000.00	250
1	4	125.00	562.50	200
1	5	200.00	600.00	100

Management Ledger table processing involves the calculation of the Weighted Average Transfer Rate (WATR). The WATR is calculated by prorating the WATR by the ratio between the Account tables and the Management Ledger table balances as follows:

(Bal x TfrRate / Bal) * LSBal = LSBal x TfrRate

For example, the WATR for Line Item 3 is calculated as follows:

(1,000.00 / 300.00) * 250.00 = 833.33

The following table represents the VMT after the WATR calculation has taken place.

Table 6-35 VMT Post WATR Calculation

ORG_UNIT_ID	PRODUCT_ID	Bal	Bal x TfrRate	LS Bal	LSBal x TfrRate
1	3	300.00	1000.00	250.00	833.33
1	4	125.00	562.50	200.00	900.00
1	5	200.00	600.00	100.00	300.00