I have huge requirement and cannot seem to understand how to go about it
kindly guide me how should i begin there Ax version AX 2012 R3
For Statutory compliance, to report the FINANCIAL statements, a separate system is maintained. Client is planning to copy some transaction data from AX to the external system through mutually designed interim data base. In the external system, it requires to include and exclude certain transactions. This is planned to do every quarter.
A new button is required to be provided in the General Ledger > Periodic > Legal books integration. There should be a date field ‘End Date’ which should be considered to push the data When clicked, the data from Ax to be transferred to the above tables listed. Also data transferred should be flagged in Ax tables. The data which is pushed to Integration database should be flagged as 1, and which is not integrated[P1] should be flagged as 0. For any update of the master files, the same should be again pushed to integration table and the flag should be set to 0 after update in Ax.
Now should manually create a Database in SQL and create class to establish connection with newly created Database ? has anybody done such kind of work kindly reply thanks in advance !!!