I am using ax 2009. my reqirement is for eg :
select Amount from PayrollLedgerTable where PayrollLedgerTable.PeriodFrom == _PeriodFrom && PayrollLedgerTable.PeriodTo == _PeriodTo && PayrollLedgerTable.PeriodId == _PeriodId && PayrollLedgerTable.EmplId == _employee;
For single employee id we have so many columns(amount) which is basic, allowance etc…
i need to displsy in text file for single employee id amount(001, 25000,1000,2345,3434,etc)
How to achieve this in dynamics ax 2009? a new to dynamics. pls reply ASAP.
already generated the text file with all requirement. now remaining is i need to include this data by row wise format in that file.