Hosea
4Penny.net
Points: 7050

4/14/2017 9:53:49 AM

Format a field with a currency amount

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

This is a quick little adaptation that shows how to add a currency symbol to an amount in Dynamics GP/SQL. It's really only useful in a multicurrency situation, but it's worth remembering that it's here.

Just look up, and remember what menu it's on so you can find it later.

4Penny.net
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
3