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

Notifications

Announcements

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

(0) ShareShare
ReportReport
Posted on by 98
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,026 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

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 843 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 408 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 324 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans