Beware of Migrating to MAS v4.4 if you have A LOT of 00-NOF Vendor Checks

By Wayne Schulz • August 5th, 2010

I recently began the process of migrating a client from Sage ERP MAS 90 v4.1 to V4.4. The client didn’t have a lot of modules (and none of the modules rewritten for 4.4) nor any customizations so I thought it would be a relatively painless upgrade.

Wrong!

The first test conversion ran over the weekend before I stopped it. After several more attempts (different workstation, different server) I was going nowhere fast. Since I was jumping up three versions, I tried migrating to v4.2 (no problem) to v4.3 (again no problem) and finally to v4.4 (stopped dead again).

I contacted a fellow member of the 90Minds group who was able to troubleshoot the problem for me.

He traced the problem to the AP_OpenInvoice table changes made to support the new A/P Electronic Payments enhancement. The conversion works well until it encounters hundreds — if not thousands — of records that have the same Div/Vendor/Non-Blank CheckNo combination, namely 00-NOF vendors.

This client has a tremendous number of 00-NOF transactions in the AP_CheckHistoryHeader table.

I submitted the files to Sage for their review and hopefully code correction.

In the meantime, this client will have to wait a while longer before upgrading from v4.1 to v4.4.

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
Share
Comments(0) Bottom Line Software, Sage MAS 200, Sage MAS 90
 

Leave a Comment

You must be logged in to post a comment.

« | Home | »