Hello, We have a 3rd Party multi-site financial consolidation dashboard that data is loaded into for all sites corporate wide. Therefore all sites need to extract ledger P&L, AP and balance sheet data so that it can be transformed (mapped) and loaded into this consolidation dashboard. We have written extract routines for our legacy system to extract this data to text files, then we use dts packages to pickup the text files and load them into SQL Server tables so that our transformation and mapping routines can run. With the implementation of AX, I am hoping that we can get away from the text files and go database to database. I have a couple of ways in mind to do this with the Biz Connector being one of them. I'm just not sure of the table(s) I need to use to get the information I need. Can anyone help?
So far I am investigating at the following tables: LedgerTrans LedgerJournalTrans LedgerClosingSheet LedgerClosingTable LedgerClosingTrans Thanks in advance for any help you can provide, Letron
