Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
Points: 6709

7/29/2016 1:40:58 PM

ddf_FormatNumeric - formats a dollar value

* This article, and all our great SQL (General) documentation, Is available on the SQL (General) menu

This is a function that will take a numeric amount and format it as text, adding (optionally) a currency symbol and commas or the text 'hr' after the number; again with commas.

This screen shot shows how to call it with the optional dollar/hour parameter


Editors note:

Do you have a cool function that you use all the time? Why not post it, and let us put it in the SQL Menu along with our library?
Version: All
Section: SQL Scripts

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables