Grid: Format columns, currency etc

[Former Member]

Hello Forum,

is it possible to format grid columns? For example currency with a currency sign and only two decimal places?

What control can I use instead in SAP B1 9.0, if the Grid does not support this feature.

Thanks

Mark

[pedro_magueija · Accepted solution]

Hi Mark,

There is no native column type (Money) so what you would have to do is use a regular TextColumn and implement all the necessary functionality by hand.

---

Best regards,

Pedro Magueija

[Former Member · Accepted solution]

Ok thanks. I have modified the SQL Stmnt, the DB gives me now the values in currency format. But the Format command seems to differ between MS SQL 2008 and MS SQL 2012.