Inventory To GL Reconciliation

 

Inventory To GL Reconciliation Step

Inventory R12conciliation process in R12  is a two-step process.

1.  Costing to SLA. 
2.  SLA to GL.
3. Costing team is only responsible for the Costing to SLA
4. Check the inventory material distributions have been accounted in SLA. 
5. To confirm the integrity between SLA and GL, we need to go to a Financials referrals

/*------- Verify that all Material Transaction Account distributions accounted in SLA -----

 If the following query returns any rows then that means there are distributions in MTA which have not been created in SLA ,This may indicate a problem in SLA create accounting process if it is a R12 transaction, If it is a historical 11i transaction, it may tell you that the accounting has not been upgraded to SLA

 

SELECT *

FROM mtl_transaction_accounts a

WHERE a.transaction_date between TO_DATE('&&from_dt','DD-MM-YYYY')

AND TO_DATE('&&to_dt','DD-MM-YYYY')+0.99999

AND a.accounting_line_type<>15

AND a.reference_account =&&Account_id

AND a.organization_id = &&organization_id

AND NOT EXISTS (SELECT NULL

FROM xla_distribution_links

WHERE source_distribution_type =

'MTL_TRANSACTION_ACCOUNTS'

AND application_id = 707

AND source_distribution_id_num_1 =

a.inv_sub_ledger_id);

Input Paramaeters : 

1. From Date

2. To Date

3. Account ID

4. Organization ID

 

The account_id is the GL account identifier. It is called CCID frequently.It is stored in the GL_CODE_COMBINATIONS table.If the user does not know the GL account ID, they can run a query against GL_CODE_COMBINATIONS where they can see the segments that build up the CCID

---------------------------------------------------------------------------------------------------------------------------