Dear All
Can any one define the procedure to transfer data from inventory to GL.
Pls define steps by step procedure for validation, accounting and transfer of data.
Regards,
Sajjad ahmed
Transfer to GL
-
mpdhas@gmail.com
- Posts: 64
- Joined: Mon May 14, 2007 9:47 am
- Location: India
Hi,
The accounting information related to transactions in INV module is transferred to GL by running the ?Transfer Transactions to GL? concurrent program. This is part of ?Period End Process' . However, you can run explicitly any time during an open period. When you run this process and in case if more than one period is open, all the transactions from the earliest open period to the date up to which the process is run (Transfer Date) are considered for transfer to GL.
When you run this program all the accounting information is inserted into gl_interface table. ?Journal Import? and ?Post Journals? processes in Oracle General Ledger can then be used to post the information in General Ledger.
The level of detail that is transferred to GL for the accounting information related to these transactions depends on the value chosen in the Organization Parameters Screen
Navigation: Oracle Inventory > Setup > Organization > Parameters
Each parameter has there own significance.
Organization Code : This is one of inventory organization, for which the gl transfer has to be done.
Date :A date in any open period.
Current Period
GL Description
The possible values for the ?Transfer to GL? field (in Organization Parameters Screen) are ? Detail, Summary, None.
When Summary is selected :The accounting information pertaining to the transactions is summarized and the summary entries are posted to GL. One of the advantage of running the process in 'Summary' mode over 'Detail' mode is minimising the posting times.
When ?Detail? is selected :The detailed accounting entries are transferred to GL. In this case, the posting times are larger due to a larger number of records. The advantage of this mode is creation of detailed accounting records in GL for every transaction in Inventory/WIP.
When none is selected: This case no transfer of accounting information to GL is done for this organization.
Running ?Transfer to GL? process
You can run Transfer Transactions to GL process can be run from Oracle Inventory
Navigation:Accounting Close Cycle .. General Ledger Transfers
Regards,
Dhas
The accounting information related to transactions in INV module is transferred to GL by running the ?Transfer Transactions to GL? concurrent program. This is part of ?Period End Process' . However, you can run explicitly any time during an open period. When you run this process and in case if more than one period is open, all the transactions from the earliest open period to the date up to which the process is run (Transfer Date) are considered for transfer to GL.
When you run this program all the accounting information is inserted into gl_interface table. ?Journal Import? and ?Post Journals? processes in Oracle General Ledger can then be used to post the information in General Ledger.
The level of detail that is transferred to GL for the accounting information related to these transactions depends on the value chosen in the Organization Parameters Screen
Navigation: Oracle Inventory > Setup > Organization > Parameters
Each parameter has there own significance.
Organization Code : This is one of inventory organization, for which the gl transfer has to be done.
Date :A date in any open period.
Current Period
GL Description
The possible values for the ?Transfer to GL? field (in Organization Parameters Screen) are ? Detail, Summary, None.
When Summary is selected :The accounting information pertaining to the transactions is summarized and the summary entries are posted to GL. One of the advantage of running the process in 'Summary' mode over 'Detail' mode is minimising the posting times.
When ?Detail? is selected :The detailed accounting entries are transferred to GL. In this case, the posting times are larger due to a larger number of records. The advantage of this mode is creation of detailed accounting records in GL for every transaction in Inventory/WIP.
When none is selected: This case no transfer of accounting information to GL is done for this organization.
Running ?Transfer to GL? process
You can run Transfer Transactions to GL process can be run from Oracle Inventory
Navigation:Accounting Close Cycle .. General Ledger Transfers
Regards,
Dhas
Who is online
Users browsing this forum: No registered users and 0 guests