web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Question on Migrating Transactions Between Legal Entities: GL, AR, AP

(3) ShareShare
ReportReport
Posted on by 110
Hi everyone!
 
I've been researching methods of migrating basic financial transactions (GL transactions, open AR, open AP) between legal entities, but I can't find an answer to how the migration will be impacted by the subledgers and the general ledgers automatically interacting. 
 
Let me explain - so far I've gathered that I can migrate the GL and AR transactions using the "General Journal" data entity, and for AP I can use "Vendor invoice journal header" and "Vendor invoice journal lines". However, I'm confused about the sequencing of the data for import.
 
For example, when I extract the General Journal from the source legal entity, aren't the AP transactions already in the General Journal data entity since sub ledgers post to the general ledger? Would I then be duplicating AP transactions if I imported the entire General Journal file from the source legal entity in addition to the "Vendor invoice journal header" and "Vendor invoice journal lines" data entities? And would using the General Journal data entity be enough to process any open AR in the target legal entity?
 
It seems like every post I read has a different perspective on how best to import these scenarios. YOUR thoughts would be much appreciated. 
Categories:
I have the same question (0)
  • Suggested answer
    Giorgio Bonacorsi Profile Picture
    1,618 on at
    Hello,
     
    If you need to migrate exclusively the general ledger entries, you can use the General Journal data entity even for AP, AR and GL transactions.
    Here are the key considerations:
    - For AR and AP transactions, remember to select the Approved flag and enter the approver.
    - Each due date must be entered on a separate line
    - Include the payment condition (method and term) so that the payment proposal works correctly.
    - I recommend creating one migration journal per type of transaction, plus one dedicated offset account.
    - the cost and revenue are migrated separatly on a dedicate journal as main account balance (not on the same time of AP, AR load)
     
    Good luck!  
    Giorgio
  • William Benning Profile Picture
    110 on at
    @Giorgio Bonacorsi Thank you for the response! I have just a few follow up questions I would love your input on:
     
    1. Will only using the General Ledger entity populate the subledger? I read that not populating the subledger leads to processing issues later on of the open AR/AP invoices.
    2. For this comment "- I recommend creating one migration journal per type of transaction, plus one dedicated offset account." Can you explain more about how to use the offset account? Are we plugging in the source legal entity's balance in the offset to make sure the target legal entity balances after migration?
    3. Can you expand more on this comment? "- the cost and revenue are migrated separatly on a dedicate journal as main account balance (not on the same time of AP, AR load)"
  • André Arnaud de Calavon Profile Picture
    303,362 Super User 2026 Season 1 on at
    Hi William,
     
    Can you explain why you have the requirement to move transactions between legal entities? Do you need all or some transactions?
  • Suggested answer
    Giorgio Bonacorsi Profile Picture
    1,618 on at
    Hello William,

    Here is the answer to your questions:
    1) Yes, the general ledger can post into the ledger and subledger. Into the journal line select the type of account, and therefore the customer/vendor master data;
    2) Concerning the offset, it's not a technical but an accounting concern. During the migration or integration we use clearing accounts, and the best practice is to use dedicated ones based on the transaction type.
    3) To load easily the invoice, we break the document into two entries: one to load the invoice into the balance sheet and subledger, and the second to load pure GL cost/revenue.
     
    The topic is not difficult but can create serious issue if it design improperly. Hence to have deep dive information I suggest you contact a financial consultant to design your integration.

    Thank you,
    Giorgio
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 509 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 375

#3
Adis Profile Picture

Adis 268 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans