Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Upgraded to SQL Server version and column precision has changed.

Posted By Dwight 5 months ago

Moving from the Progress DB to SQL Server version discount percentage type columns are decimal(7,3) but in the old version it is decimal(8,3). Also a lot of other decimal columns went from (16,6) to (15,6).

How have people handled this? It is breaking some of our procedures.

Thanks

0 Kevin M 5 months ago

Databases for Sage 100 (ERP) are Providex and SQL... so I'm guessing you are using Sage 100 Contractor? (That is a separate software package, with a different forum).
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Dwight 5 months ago in reply to Kevin M

We use SAGE 100 2022 Premium on SQL Server. I guessed at the old db name.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kevin M 5 months ago in reply to Dwight

Recently I noticed an issue with decimal UDF's that use a numeric mask... where the numeric format in SQL changes depending on whether the mask has the "-" at the beginning or the end.

(Numeric mask does not affect the technical data structure in Providex, but it does in SQL).
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Upgraded to SQL Server version and column precision has changed.

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING