x Want to participate? Join the group to interact
Options
  • State Not Answered
  • Replies 1 reply
  • Subscribers 25 subscribers
  • Views 937 views
  • Users 0 members are here
Browse Forums
Announcements
149
topics
113
replies
General Discussion
5k
topics
13k
replies
Payroll & Tax
630
topics
885
replies
Reporting and Analytics
570
topics
1k
replies
Service Alerts
1
topics
0
replies
Software Development Kit (SDK)
434
topics
671
replies
Year End
83
topics
128
replies
FormerMember

HOW TO ADD A NEW TABLE TO SAGE 50 US

Posted By FormerMember

I RECENTLY DOWNLOADED THE SAGE 50 SDK WITH THE INTENT OF MAKING SOME MINOR MODIFICATIONS TO THE APP FOR MY CLIENT. 

I CAN FIND NO REFERENCE MATERIAL ON HOW TO ADD THE NEW TABLE.

THE NEW TABLE WILL RECORD LOT NUMBERS WHICH ARE NOT PART OF THE SAGE DB AND UPDATE LOT QUANTITIES WHEN A SALES ORDER IS ENTERED.

CAN ANYONE POINT ME TO DOCUMENTATION ON HOW TO DO THIS?

  • 0

    Hello Mr. UpperCase,

    You cannot add tables to the Sage 50 database as it is a closed system. It's designed this way for the very good reason of preventing folks from 'boogering up' the referential integrity of the system. No using this approach could result thousands of hours of non-productive support calls for people that played the song, "Ooops, I did it again, I played with your database...I'm not that innocent!"

    You will need to manage any lot-based functionality externally to accomplish the work.

    Scott

*Community Hub is the new name for Sage City