How toe enter the opening balances gl/ap/ar.

[tirumal]

How toe enter the opening balances glap/ar?. for newly implementd

[hiszaki]

Hi Sir,

I have an idea to enter the opening balance for financial modules:

1) Upload in the G.L all balance accounts in specific period (like Feb-08) then start the transactions in both AP & AR module in the next period (Like Mar-08) then make all transactions in AP & AR transfer to GL at the end of each period. This way is simply way to opening balance but the problem will be in AR & AP modules because the balances in each module (AP / AR) will not equal the balance in GL.

2) Upload in the G.L all balance accounts in specific period (like Feb-08) and replace the accounts which should be come from AR & AP (Supplier account, customer account, cash account, expenses account,?.ect.) with Intermediate accounts in G.L opening balance. Then make opening invoices, payments for each module (AP / AR) then transfer these transactions to G.L to make the balance in G.L equals the balances in AR & AP.

You can use the macro sheet or data loader to load the balance sheet.

Hope I understand your request & hope I get you the right answer.

Thanks
Hisham

[Murthyoracle]

Hi Hiszaki,

Your idea is good. a bit confusing and i am not getting link. If u enter balances in Gl First how will u match the Traial balances. And you told that by using Control Accounts load the balalnces in Gl . How is it?

Can you or anybody brief me. In Fact this is a good question as far as Interview point and Real time issue.

Hope with answer.

Regards
Murthyoracle

[hiszaki]

Dear Sir,

For the idea which I told you before, I was meant we can upload all accounts in GL with the final balances then make posting transaction for these accounts to become the beginning balances in GL.

If we will use the second solution, It must be handle all accounts which you can get it from sub modules like AP/AR when you upload the accounts in GL.

For example: suppose you have in the supplier?s account 1000$ as a total of suppliers accounts for specific period (beginning balance period).
You upload your trail balance with the real accounts in G.L module except supplier?s account you can upload the details of amounts 1000$ in AP for each supplier then you transfer the supplier?s account from AP to GL.
This step will make the supplier account in GL = the supplier account in AP & you can make your drill down function.

You can use this way for all accounts which related to each module AP/AR.

Hope I can help you & make your confuse become clear.

Thanks
Hisham

[mhpkokgc]

Problem Description
-------------------

You have installed Oracle Applications and would like to load your beginning
balances into Oracle General Ledger by populating the GL_BALANCES table with
data from your Legacy system.


Solution Description
--------------------

You can not directly update the GL_BALANCES table. All balance data coming
into General Ledger (GL) should come through either the GL_INTERFACE
or the GL_BUDGET_INTERFACE table.

These two tables can be populated in one of the following ways:

1. Use the Application Desktop Integrator (ADI) to create a Journal/
Budget spreadsheet and upload amounts to the last non-adjusting
period previous to the planned live period.

- OR -

2. Use SQL*Loader or any other tool of your choice to populate the interface
tables in accordance with the specifications described in the Oracle
Financials and Oracle Government Financials Open Interfaces Manual.
Enter your transactions for the last non-adjusting period previous
to the planned live period.


After you populate the interface tables, run the Journal Import or the
Budget Upload process to bring the data into General Ledger.

Open the planned live period in General Ledger, and the beginning balances
for this period will be populated in the GL_BALANCES table.

Example:

Your go live date is January 1, 2000.
January 1, 2000 is in period JAN-00.
The last non-adjusting period prior to JAN-00 is DEC-99.

1. Populate the interface tables with one of the methods described above.
To load actual balances, populate the ACCOUNTING_DATE column of
GL_INTERFACE with a date that falls into the DEC-99 period.
To load budget journals, populate the PERIOD_NAME column of GL_INTERFACE
with 'DEC-99'.

2. Open the DEC-99 period in General Ledger. Open the Budget Year if you
are bringing Budget Journals/Amounts from GL_INTERFACE or
GL_BUDGET_INTERFACE table.

3. Run Journal Import or Budget Upload depending on the data you are
uploading.

4. Open the JAN-00 period in General Ledger.

The ending balances for Actuals from DEC-99 will roll forward to the beginning
balances of the next period.

NOTE: Revenue and Expense balances will be rolled into the beginning balance
of the Retained Earnings account in the first period of the fiscal year.

[hiszaki]

Dear mhpkokgc

This is right way to upload the trial balance for specific period by upload all accounts into GL then start all transaction from sub modules but in this case the sub modules will not include the details for the opening balances in AR / AP.

This is my opinion & every one can choose the suitable way for him.

Hisham

[ramsabi]

[quote]Dear Sir,

For the idea which I told you before, I was meant we can upload all accounts in GL with the final balances then make posting transaction for these accounts to become the beginning balances in GL.

If we will use the second solution, It must be handle all accounts which you can get it from sub modules like AP/AR when you upload the accounts in GL.

For example: suppose you have in the supplier?s account 1000$ as a total of suppliers accounts for specific period (beginning balance period).
You upload your trail balance with the real accounts in G.L module except supplier?s account you can upload the details of amounts 1000$ in AP for each supplier then you transfer the supplier?s account from AP to GL.
This step will make the supplier account in GL = the supplier account in AP & you can make your drill down function.

You can use this way for all accounts which related to each module AP/AR.

Hope I can help you & make your confuse become clear.

Thanks
Hisham


<i><div align="right">Originally posted by hiszaki

[hiszaki]

ramsabi,

First Thanks for your comments about my suggested solution.
I would like to inform you that I just think if we can determine the all distribution lines details in AP to be as a opening balance & keep the function of drill down in GL & the total balance in both AP and GL are the same.

Let me show you an example:

My suggest is that when I upload the trial balance in GL I'll not upload these accounts on their GL code combination, but let then empty then I upload as you told a standard invoices with distribution lines with the real GL code combination then I make the transfer to GL. This way I'll transfer to GL from AP & keep the drill down function & the balance in both modules are equals.

This way I used before & it's not the right but it's just an idea and there are a lot of ways to open the balances in all modules.

I wish I can explain my suggested solution & thanks again for your comments.

Hisham