General Ledger & Intercompany

Get Involved. Join the Conversation.

Topic

    Raj Mohanraju
    Intercompany Transaction Tables
    Topic posted June 6, 2019 by Raj MohanrajuRed Ribbon: 250+ Points, tagged Financials, General Ledger, Intercompany, Payables, Receivables, Reports, Subledger Accounting 
    62 Views, 1 Comment
    Title:
    Intercompany Transaction Tables
    Summary:
    Intercompany Transaction Tables
    Content:

    We are uploading intercompany transactions via FBDI from a legacy system. Now we are looking for a way to reconcile the intercompany transactions to source to avoid transactions being lost in transit.
    So I'm exploring a report which will list of all impacted Intercompany Inbound and Outbound Transaction Tables [as I would see in the UI]
    a/ populate all intercompany transactions using the batch name [as entered in the FBDI]

    In addition to this I will also need to provide the end result of each intercompany transaction from invoice creation and accounting details as well. SO the report should also:
    b/ populate all intercompany receivables and payables invoice details created for these intercompany transactions
    c/ tables that relate to accounting entries created after intercompany receivables and payables invoices have been created

    Any advise will be greatly appreciated.

    Comment

     

    • Raj Mohanraju

      To summarise, I'm looking for a list of tables that affect intercompany transactions [after import] + tables that affect intercompany receivable and payable invoices + tables to obtain accounting entries.