In this article, we're going to look at using the SQL FORMAT function.
We'll cover the simple examples, and then looks at formatting using the Dynamics GP DECPLCUR/DECPLQTY fields, that varies the decimal places for each item