How to get Sub Ledger accounting lines for Inventory
Dear All
I want to get Sub Ledger accounting lines for Inventory. Query is almost done but there is one in join condition. I am using a table named XLA.XLA_TRANSACTION_ENTITIES in which there is a column named SOURCE_ID_INT_1. I am confused how to join it to RCV_TRANSACTIONS or MTL_MATERIAL_TRANSACTIONS. If I join this column to RCV_TRANSACTIONS then no of records become less which results into incorrect sub ledger balances.