MAS90 and MAS200 Tip: V4.4 Visual Integrator to Upload Inventory Item Numbers for Delete and Change Items Utility

After six months of waiting patiently, Sage included in their last month’s v4.4 Product Update 2, the ability to import item #’s that had been renumbered. When I saw the news release, I did a little jump for joy as I have several clients holding back on renumbering items. It is so much easier to do with Visual Integrator!

Yesterday, I was on site at one of these clients so I decided to create the VI job to renumber inventory. Took about 10 minutes as it is straight forward.

Simple right?

Wrong!

The import fails on the NewItemCode line. The number is not file.

Of course it isn’t as I am creating a new number.

The utility works well from the MAS 90 menu as I threw up my hands and just rekeyed the 50 new numbers. The client has waited long enough.

I submitted the case to Sage this morning. To their credit, they were quick to respond with a possible resolution “Remove the “NEW_MRG_Item_NO” validation record in the Validation tab of the import job. I gently reminded the Senior Analyst that the new business framework did not have this flexibility.

I hope that it is not another six months before this issue is resolved. But if it is, it will be a welcomed Christmas present…….

Jeff Schwenk
Bottomline Software, Inc.
Jschwenk@btmlinesoft.com
Jschwenk@90Minds.com

© 2010, Wayne Schulz. All rights reserved. Formed in 2005. the 90 Minds Consulting Group is a collaboration of 100 Sage partners who independently join together online in a 24 x 7 private communication network to solve difficult issues for their customers. The group is not affiliated with Sage and our collaboration provides for unparalleled member access to early warnings of bugs and other issues which members in turn are encouraged to use to provide an exceptional customer experience.

Wayne is a Glastonbury CT based MAS 90 and MAS 200 consultant specializing in advanced support, training and implementation. He started working with the software in 1986 as a staff CPA at a local accounting firm. He moved onto his own firm in 1995 and has been annoying the members of 90 Minds ever since.

Wayne Schulz

View all posts by Wayne Schulz
Wayne's website

« How To Find The Number of SageCRM User Licenses With Sage ERP MAS 90 or MAS 200 EES | Home | Beware of Migrating to MAS v4.4 if you have A LOT of 00-NOF Vendor Checks »

• 
  
  
  
  
  
  
• Ask a Question on Ask The 90 Minds Group