Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

General Ledger Tables in AX

Posted on by Microsoft Employee

Hello, 

I am new to working with Microsoft AX. Prior to now, I worked with SAP. I would like to know the equivalent tables in AX for the BKPF and BSEG tables in SAP.

Typically in SAP, I would join the BKPF and BSEG tables to get the full general ledger with full transactional data. I want to know how I would go about this in AX please.

Thanks

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: General Ledger Tables in AX

    Hello iamthejedi,

    What AX/D365FO version do you work with?

    Can you let us know what the abbreviations BKPF and BSEG stand for and what those tables include in detail?

    Many thanks and best regards,

    Ludwig

  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,645 on at
    RE: General Ledger Tables in AX

    Please take a look at link below to get started. It explain detailed steps on what to do to extract the information. Hope this helps.

    community.dynamics.com/.../dynamics-365-finance---leverage-data-management-to-extract-data

  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,645 on at
    RE: General Ledger Tables in AX

    Hi iamthejadi,

    There is concept of Data Entities. The data entity to extract GL transaction is 'General journal account entry'. You have to just extract data from this entity, don't have to join any further tables. Will post more details soon.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans