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
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
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
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,333
André Arnaud de Cal... 846 Super User 2025 Season 2
Sohaib Cheema 681 User Group Leader
