btamulis 9/9/2026 7:43:07 AM

SQL Question Cast Amounts

Good Morning -

I am integrating Vendor Invoices from external application.

Application gives me invoice amounts with no decimals.

I need to cast with the decimals, and my SQL syntax is just a little off. My script returns .00 - always. See below.

Need a ROUND somewhere in here?

 

Version: All
Section: Dynamics GP, 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