We have AX 2009 SP1. We recently bought a third party pay roll from Menaitech. We need a minimal integration with AX 2009 and the above payroll (One way integration only)
On every month end from the payroll program they will move the summary to a temporary table or let us say Interim table. The structure of the data will suit the format of LedgerJournalTrans table. The above task will be done by the 3rd party company. After this I have to do the AX part.
(a) I assume that we have to run a job which will look into the interim table and fetch the records from the interim table and populate the LedgerJournalTrans table and also create one record in LedgerJournalTable.
(b) My assumption is that the Interim table will be created via AOT. Is this a nice idea?
Please advise me on the above points.