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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to transfer codes (FOB, Ship via, etc) from one company to another?

Status
Not open for further replies.

mlbechard

Programmer
Jun 22, 2009
87
CA
I am using Macola ES. We have created a second company and we would like to know the best way to transfer FOB, Ship via, Ship-to and PO Form No codes (all codes in Purchase order) from our first company to the new one.

Do we also have to change any settings in Package Settings to make PO works the same in both companies?

Any help would be appreciate.

Thank you
 
You can export forms from the form designer, then import it in the new company.

For tables, you can use SQL to do a INSERT INTO SELECT statement to copy tables from one database to another.

Peter Shirley
Macola Consultant, PA and surrounding states.
 
All that stuff is in the systems codes table, sycdefil_sql.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools:
 
The sycdefil_sql table contain the data for the FOB and Ship via codes but not for the "PO Form No".

Which table contain "PO Form No" data?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top