We are in the process of converting from GP 9.0 to GP 2010 and it seems that some of the sql server tables (specifically GL00100) have different fields in 2010 than in 9.0. Is this the case? Has Microsoft decided to change the table structures in 2010 vs. 9.0? Any help is appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL server table structure changes from 9.0 to 2010 1
- Thread starter hedgracer
- Start date
-
1
- #2
VictoriaYudin
IS-IT--Management
Typically with any version upgrade you will see table changes, however, typically those changes will be to add new columns. They should all be detailed in the SDK (Software Developer Kit) for the new version. Since you're going from 9.0 to 2010 (skipping 10.0), you may actually need to check changes for 10.0 and for 2010 separately.
Specifically for GL00100, I believe the only change was with GP 10.0 and added a new column called DEX_ROW_TS which is a timestamp of the last change. There were many tables that got this new column in GP 10.0.
Victoria Yudin
Dynamics GP MVP 2005 - 2010
Use Crystal Reports and SSRS with GP:
blog:
Specifically for GL00100, I believe the only change was with GP 10.0 and added a new column called DEX_ROW_TS which is a timestamp of the last change. There were many tables that got this new column in GP 10.0.
Victoria Yudin
Dynamics GP MVP 2005 - 2010
Use Crystal Reports and SSRS with GP:
blog:
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question