Thursday, July 28, 2016

Hi Daxer's

Today i come up with a small post but important and useful trick to save time for the developer,when we are exporting data from Ax to Excel sheet,if any record is having data staring with zero (i.e 00021).
Excel will read it as "21" to over come this issue use below code

  xlsWorkSheet.cells().range('A:A').numberFormat("@");
  xlsWorkSheet.cells().item(row,1).value(strFmt("%1",worker.PersonnelNumber));


Export a copy of the standard user acceptance testing (UAT) database

 Reference link: Export a copy of the standard user acceptance testing (UAT) database - Finance & Operations | Dynamics 365 | Microsoft ...