Format a field with a currency amount

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.

select sopnumbe, docamnt,
        mc.crncysym + LTRIM(STR(h.docamnt,100,2))
    from sop10100 h
        join dynamics..mc40200 mc on mc.curncyid = h.curncyid

RealWorldCode gives developers practical, real‑world solutions with clean, working code — no fluff, no theory, just answers.
Links
Home
Knowledge Areas
Sitemap
Contact
Et cetera
Privacy Policy
Terms and Conditions
Cookie Preferences