Adjust Control Balances
The volume of transactions to be processed using control balance transfer is significantly lower as journals are created in summary mode to transfer the balance.
Irrespective of which transactions are updated; the Unpaid Invoice, Paid Invoices or Historical transactions, you have the flexibility to choose for which period and account combination you want to transfer balances. An audit trail is maintained because existing journals in final status aren't impacted, for control account balance transfer operation new SLA journals are created. You can adjust control balances as needed using the spreadsheet interface regardless of accounting period status since entries aren't transferred to GL.
Transfer Control Balances due to Party Merge
Suppose a party merge was triggered and you want to transfer control balances from the old party and site to the new party and site. In this example, let's assume Vision Corporation, NY site is merged with Big Computers, NY site. Vision Corporation, NY site has the following control balance records in the SLA control balances table.
|
LEDGER_ID |
APPL_ID |
PERIOD |
CCID |
BEGINNING_BALANCE_DR |
BEGINNING_BALANCE_CR |
PERIOD_BALANCE_DR |
PERIOD_BALANCE_CR |
PARTY |
PARTY_SITE |
|---|---|---|---|---|---|---|---|---|---|
|
1 |
200 |
4/20/2021 |
01-110-2210-0000-000 |
1200 |
2200 |
Vision Corporation |
NY |
||
|
1 |
200 |
4/20/2021 |
01-110-2240-0000-000 |
2030 |
Vision Corporation |
NY |
|||
|
1 |
200 |
5/20/2021 |
01-000-1210-0000-000 |
1000 |
200 |
Vision Corporation |
NY |
||
|
1 |
200 |
5/20/2021 |
01-000-1220-0000-000 |
500 |
100 |
Vision Corporation |
NY |
Vision Corporation is acquired by Big Computers. Vision Corporation, NY site is merged with Big Computers, NY site. You can use the Adjust Control Balances ADFdi spreadsheet to transfer control balances to the new supplier, Big Computers, NY site.
The journal entries created for transferring control balances are created in Final status but not transferred to GL. The control balances table is updated as follows on transfer:
|
LEDGER_ID |
APPL_ID |
PERIOD |
CCID |
BEGINNING_BALANCE_DR |
BEGINNING_BALANCE_CR |
PERIOD_BALANCE_DR |
PERIOD_BALANCE_CR |
PARTY |
PARTY_SITE |
|---|---|---|---|---|---|---|---|---|---|
|
1 |
200 |
4/20/2021 |
01-110-2210-0000-000 |
1200 |
2200 |
Vision Corporation |
NY |
||
|
1 |
200 |
4/20/2021 |
01-110-2240-0000-000 |
2030 |
Vision Corporation |
NY |
|||
|
1 |
200 |
5/20/2021 |
01-000-1210-0000-000 |
1000 |
200 |
Vision Corporation |
NY |
||
|
1 |
200 |
5/20/2021 |
01-000-1220-0000-000 |
500 |
100 |
Vision Corporation |
NY |
||
|
1 |
200 |
4/20/2021 |
01-110-2210-0000-000 |
1000 |
Vision Corporation |
NY |
|||
|
1 |
200 |
4/20/2021 |
01-110-2210-0000-000 |
1000 |
Big Computers |
NY |
|||
|
1 |
200 |
4/20/2021 |
01-110-2240-0000-000 |
2030 |
Vision Corporation |
NY |
|||
|
1 |
200 |
4/20/2021 |
01-110-2240-0000-000 |
2030 |
Big Computers |
NY |
|||
|
1 |
200 |
5/20/2021 |
01-000-1210-0000-000 |
1200 |
Vision Corporation |
NY |
|||
|
1 |
200 |
5/20/2021 |
01-000-1210-0000-000 |
1200 |
Big Computers |
NY |
|||
|
1 |
200 |
5/20/2021 |
01-000-1220-0000-000 |
400 |
Vision Corporation |
NY |
|||
|
1 |
200 |
5/20/2021 |
01-000-1220-0000-000 |
400 |
Big Computers |
NY |
Adjust Control Balances for a Party and Site
Suppose you didn't initially enable control accounts but afterwards you want to initialize control balances for a party and site. Or you already maintain control account balances in a legacy system and want to bring in those balances while upgrading to Oracle Fusion Cloud ERP. Let's assume control balances are to be initialized against First Software, San Jose site as follows:
|
Ledger |
Subledger |
Period |
Account Combination |
Accounted (Debit) |
Accounted (Credit) |
Supplier |
Site |
|---|---|---|---|---|---|---|---|
|
Vision Operations |
Payables |
6/20/2021 |
01-120-2210-0000-000 |
12654 |
First Software |
San Jose |
|
|
Vision Operations |
Payables |
6/20/2021 |
01-110-2240-0000-000 |
2030 |
First Software |
San Jose |
The Application Implementation Consultant (ORA_ASM_APPLICATION_IMPLEMENTATION_CONSULTANT_JOB) configures the natural accounts 2210 and 2240 as control accounts in the FND setup and submits the Inherit Segment Value attributes program. You can use the Adjust Control Balances ADFdi spreadsheet to initialize control balances for First Software, San Jose site.
As in the initialize case, the created journal entry doesn't have party information for both sides. So in this example, journal entries are created as follows:
|
Period |
Account Combination |
Accounted (Debit) |
Accounted (Credit) |
Supplier |
Site |
|---|---|---|---|---|---|
|
6/20/2021 |
01-120-2210-0000-000 |
12654 |
First Software |
San Jose |
|
|
6/20/2021 |
01-120-2210-0000-000 |
12654 |
|||
|
6/20/2021 |
01-110-2240-0000-000 |
2030 |
First Software |
San Jose |
|
|
6/20/2021 |
01-110-2240-0000-000 |
2030 |
The journal entries created for initializing control balances are created in Final status but are not transferred to GL. The control balances table is updated as follows on initialization:
|
LEDGER_ID |
APPL_ID |
PERIOD |
CCID |
BEGINNING_BALANCE_DR |
BEGINNING_BALANCE_CR |
PERIOD_BALANCE_DR |
PERIOD_BALANCE_CR |
PARTY |
PARTY_SITE |
|---|---|---|---|---|---|---|---|---|---|
|
1 |
200 |
6/20/2021 |
01-120-2210-0000-000 |
12654 |
First Software |
San Jose |
|||
|
1 |
200 |
6/20/2021 |
01-110-2240-0000-000 |
2030 |
First Software |
San Jose |