Asset Drill Down
Dears,
I'm working on Asset Drilldown query from GL batches into invoices in asset source lines,
I've a problem as asset transaction history table "FA_TRANSACTION_HISTORY_TRX_V" is linked with the asset source lines table "FA_INVOICE_DETAILS_V" by "INOVICE_TRANSACTION_ID" which mean that multiple lines in the source lines are linked to one transaction, therefor the cr & dr amount form XLA lines table "XLA_AE_LINES" are duplicated because the XLA transactions are linked with the asset transactions table based on transaction number.
so please advise if there is any way to link each invoice in asset source lines with it's accounting events (cr & dr amount) in SLA.