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. Audit trail is maintained as 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
Lets us say 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 Supplier - Office Depot, site - NY is merged with supplier - Office Supplies, site - NY. Supplier - Office Depot, Site - NY has the following control balance records in 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 |
Office Depot |
NY |
||
|
1 |
200 |
4/20/2021 |
01-110-2240-0000-000 |
2030 |
Office Depot |
NY |
|||
|
1 |
200 |
5/20/2021 |
01-000-1210-0000-000 |
1000 |
200 |
Office Depot |
NY |
||
|
1 |
200 |
5/20/2021 |
01-000-1220-0000-000 |
500 |
100 |
Office Depot |
NY |
Supplier - Office Depot is acquired by Office Supplies. Supplier - Office Depot, Site - NY is merged with new supplier - Office Supplies, site - NY. You can use the Adjust Control Balances ADFdi spreadsheet to transfer control balances to the new supplier - Office Supplies, site - NY.
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 |
Office Depot |
NY |
||
|
1 |
200 |
4/20/2021 |
01-110-2240-0000-000 |
2030 |
Office Depot |
NY |
|||
|
1 |
200 |
5/20/2021 |
01-000-1210-0000-000 |
1000 |
200 |
Office Depot |
NY |
||
|
1 |
200 |
5/20/2021 |
01-000-1220-0000-000 |
500 |
100 |
Office Depot |
NY |
||
|
1 |
200 |
4/20/2021 |
01-110-2210-0000-000 |
1000 |
Office Depot |
NY |
|||
|
1 |
200 |
4/20/2021 |
01-110-2210-0000-000 |
1000 |
Office Supplies |
NY |
|||
|
1 |
200 |
4/20/2021 |
01-110-2240-0000-000 |
2030 |
Office Depot |
NY |
|||
|
1 |
200 |
4/20/2021 |
01-110-2240-0000-000 |
2030 |
Office Supplies |
NY |
|||
|
1 |
200 |
5/20/2021 |
01-000-1210-0000-000 |
1200 |
Office Depot |
NY |
|||
|
1 |
200 |
5/20/2021 |
01-000-1210-0000-000 |
1200 |
Office Supplies |
NY |
|||
|
1 |
200 |
5/20/2021 |
01-000-1220-0000-000 |
400 |
Office Depot |
NY |
|||
|
1 |
200 |
5/20/2021 |
01-000-1220-0000-000 |
400 |
Office Supplies |
NY |
Adjust Control Balances for a Party and Site
Let's say that you haven't enabled control accounts initially but at a later point of time you want to initialize control balances for a party and site Or you already maintain control account balances in 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 supplier - Advanced Devices, site - San Jose 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 |
Advanced Devices |
San Jose |
|
|
Vision Operations |
Payables |
6/20/2021 |
01-110-2240-0000-000 |
2030 |
Advanced Devices |
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 the supplier - Advanced Devices, site - San Jose.
As in the initialize case, the journal entry that gets created doesn't have party information for both sides. So in this example, it gets created as follows:
|
Period |
Account Combination |
Accounted (Debit) |
Accounted (Credit) |
Supplier |
Site |
|---|---|---|---|---|---|
|
6/20/2021 |
01-120-2210-0000-000 |
12654 |
Advanced Devices |
San Jose |
|
|
6/20/2021 |
01-120-2210-0000-000 |
12654 |
|||
|
6/20/2021 |
01-110-2240-0000-000 |
2030 |
Advanced Devices |
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 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 |
Advanced Devices |
San Jose |
|||
|
1 |
200 |
6/20/2021 |
01-110-2240-0000-000 |
2030 |
Advanced Devices |
San Jose |