Sage 100

Is their an easy way to gather a listing of Table Names and Fields that may have changed between Sage 100 v2018 and Sage 100 v2021?  I'm doing a "go live" tonight for a client that suddenly shares that they have all of these custom scripting processes behind the scenes reading data through the SOTAMAS ODBC connection and they need to know if "any" fields in 50+ tables, have changed in any way?  Or course,. when i begged them to test this ... it fell on deaf ears.

Is there a "trick" or a "listing" somewhere of what has changed in the data dictionary?  Other than saving the File Layout to a PDF and manually comparing, is there a way to export a file of Data Dictionary Definitions?

------------------------------
Madeline Stefanou
RKL eSolutions, LLC
------------------------------

If you like in the admin guide for Sage 2021, they are all listed by version there:

Here are the ones I know changed that are common ones for import jobs.

1. Vendor name
2. Customer name
3. Customer Po number field
4. All the address line fields


Sent from my iPhone

That should say look. Speed typing.

Sent from my iPhone


Original Message:
Sent: 10/22/2021 5:10:00 PM
From: Tara Schinkel
Subject: RE: Data File Names and Changes between versions

If you like in the admin guide for Sage 2021, they are all listed by version there:

Here are the ones I know changed that are common ones for import jobs.

1. Vendor name
2. Customer name
3. Customer Po number field
4. All the address line fields


Sent from my iPhone

thank you @Tara Schinkel let me see if that is what they want.
​​

------------------------------
Madeline Stefanou
RKL eSolutions, LLC
------------------------------

Original Message:
Sent: 10-22-2021 17:10
From: Tara Schinkel
Subject: Data File Names and Changes between versions

That should say look. Speed typing.

Sent from my iPhone



Original Message:
Sent: 10/22/2021 5:10:00 PM
From: Tara Schinkel
Subject: RE: Data File Names and Changes between versions

If you like in the admin guide for Sage 2021, they are all listed by version there:

Here are the ones I know changed that are common ones for import jobs.

1. Vendor name
2. Customer name
3. Customer Po number field
4. All the address line fields


Sent from my iPhone

Thanks @Jim Woodhead.  That may help him.

--
​

this can be moved out of the urgent community.  thank you

------------------------------
Madeline Stefanou
RKL eSolutions, LLC
------------------------------