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

General Ledger in AX2009

(0) ShareShare
ReportReport
Posted on by 5

Hi, i have requirement like i need to sync back the Ax2012 General Ledger Balances to AX 2009.

So how can i do and which tables i need to use in ax 2009

I have the same question (0)
  • Suggested answer
    Satish Panwar Profile Picture
    14,673 Moderator on at

    Hi Suresh,

    You should use General Journal to post you balances and not write anything directly to tables.

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Suresh reddy,

    Why is that needed? Can you elaborate?

    Can you also specify whether you need GL account balances only or also other subledger balances to be synced back?

    Many thanks and best regards,

    Ludwig

  • Suresh reddy Profile Picture
    5 on at

    Our requirement is that we need to sync back the DB of AX 2012 to Ax 2009. I got AP and AR but GL Balances i did'nt get any idea, and i need only GL balances not subledger balances

    Thanks ,

    Suresh reddy

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Suresh,

    Please don't do this on the database level but rather use GL journals for posting and recording those balances.

    AX2009 and AX2012 are quite different and the best and safest way to do that is using journal postings.

    Once you have the AX2012 balances you can use them to fill the GL journals in AX2009 and post them as required.

    Please get in touch with one of your financial team members for the account and offset accounts that you need for those postings.

    Best regards,

    Ludwig

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 657

#2
André Arnaud de Calavon Profile Picture

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

#3
Martin Dráb Profile Picture

Martin Dráb 190 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans