Data conversion - Visual Manufacturing

[PhilPPhillips]

Has anyone ever tried to convert data from Visual Manufacturing (v6.2.8.009 MSSql)to Macola (V7.6.100a MSSql)? I am trying to create three tables from Visual data: inventory master, inventory master/location, BOM product structure.

The first problem I came across is that some of the Visual inventory items have item numbers with more than 15 characters. Can I extend the characters over 15 into the item_filler field? Is that what this field is for?

 

[dgillz]

Without modified source code you are SOL. Nothing will work properly.

However since Macola ES is a free upgrade (Provided that you are current on annual maintenance) I would take them directly to ES. ES has a 30 digit item number. I did this a couple of years ago.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz