To display qty in integer when we export it to excel

Hi All,

Request your suggestions/ Quick Solutions.

When I export the data into excel from any form in ax(Eg: on hand form in inquiries), I need to display the quantity field in integer format/hide the decimals.

Currently it shows up decimal, as qty is of real type.

Any real quick suggestion appreciated.

Thanks in advance,


For your solution, please edit the method formatColumn in \Clases\SysGridExportToExcel

Play with this code and it should help.

_column.numberFormat(’#’ + thousandSep + ‘##0’ + decimalSep + ‘00’);