Schulz Consulting

Consulting and Upgrades

Sage 100 ERP Webinar Schedule: Sage CRM, Version 4.5 New Features, BizNet

by

Learn more about Sage ERP, CRM, and integrated business management software products through our free webinars and recorded, on-demand webcasts and demos.

Here are our upcoming live events:

How Integrating Sage MAS 90 | 200 With Sage CRM Drives Business Growth
Tuesday, March 6, 2012, 10:00a.m. PT / 1:00p.m. ET
Free Webinar – If your business lags in responding to customer needs…if you’re plagued by a lack of visibility into customer buying habits…or if your front- and back-office teams aren’t seeing the same information…help is at hand! Read what you’ll learn in this information-packed webinar. Learn more…

What’s New in Sage MAS 90 | MAS 200 Version 4.5
Wednesday, March 7, 2012, 10:00a.m. PT / 1:00p.m. ET
Free Webinar – Sage ERP MAS 90 and 200 version 4.5 is here, and everything you’ve heard about the new features and benefits are all true and ready for you when you upgrade. We will be taking a broad look at the main points that everyone should know about, such as National Accounts for Account Receivable, integrated Customer Relationship Management, and the Reporting Tree capability for financial reports. We’ll also discuss the option to migrate to Sage ERP MAS 200 SQL. Learn more…

Discover Excel-Based Financial Reporting for Sage ERP!
Thursday, March 8, 2012, 10:00a.m. PT / 1:00p.m. ET
Free Webinar – Are you looking to enhance your reporting and analytics capabilities for any of these Sage software systems: MAS 90/200, MAS 500, or Accpac? Meet the next generation excel-based reporting solution. BizNet’s award winning Excel® Business Information Suite is the most innovative and intuitive reporting solution on the market. It is a business reporting and analytics platform that provides real-time access to your business data from Microsoft Office Excel®. Learn more…

Sage 100 ERP Webinar Schedule

Schulz Consulting Participates in Two Day 90 Minds Collaborative Meeting

by

During February 10 and 12, 2012 Schulz Consulting was represented by Wayne Schulz during a two day collaborative session held by the 90 Minds Consulting Group in San Diego California.

 
The 90 Minds Consulting Group is a private independent collaboration of approximately 100 Sage Software Business Partners, members share knowledge around technical product information, as well as best business practices. Members are connected from across the country and share knowledge in real time 24 x 7 environments. 90 Mind members provide coverage to virtually the entire United States and collectively employ well in excess of 415 consultants.

Wayne Schulz is one of the members of 90 Minds and participates regularly in sharing technical information concerning Sage 100 ERP (Forerly Sage MAS 90 ERP and MAS 200).

The 90 Minds Group has a wide variety of like-minded Sage Business Partner who independently collaborate to share knowledge which in turn helps their respective customers make smarter decisions about software technology, software implementations and improving their ERP and CRM systems.

 

 

 

Read more

What’s New in Sage MAS90 and 200 4.5 Webinar – 2/1/12 12pm ET

by

Sage ERP MAS 90 and 200 4.5 is packed with compelling value, new features and functionality, and even more flexibility. The enhancements in this exciting release are inspired by you—our customers—mainly in Accounts Receivable, Payroll, Purchase Order, and Sales Order.

Register Now

Customers upgrading to 4.5 will receive a FREE fully functional SageCRM 7.1 user and server license, and one Sage ERP MAS Intelligence Report Manager License. Intelligence now includes new Reporting Tree capabilities and enhanced report distribution. 4.5 is so flexible, you can choose to remain on your current system, or move to Sage ERP MAS 200 SQL*, running on a Microsoft SQL Server database.

Also incorporated in 4.5 are the 37 enhancements provided through downloadable Product Updates since Sage ERP MAS 90 and 200 4.4 shipped last year, in Accounts Payable, Accounts Receivable, Bank Reconciliation, Inventory Management, Job Cost, Paperless Office, Payroll, Sales Order, as well as additional system-wide features and functionality.

Register Now

Double Posting From Sage 100 ERP (Formerly Sage ERP MAS 90 and 200) Sales Order – Fixed

by

Sage have issued program fix SO4081-T which resolves a rather serious Sales Order double posting issue which my 90 Minds Consulting Group first spotted back in December 2011.

The program issue was:
Daily Transaction Register doubles the amount of one or more invoices from Sales Order Invoice Journal

 

Until Sage issued their program fix the only workaround was to preview the posting registers before updating.
Possible Workaround:

  • Expand Modules, Sales Order, Main, Daily Sales Reports/Updates
  • Preview the Daily Sales Journal and exit.
  • Answer No to Print the other reports (Gross Profit, Sales Recap, etc..)
  • Answer No to Update the Daily Sales Journal

 

  • Expand Modules, Sales Order, Main, Daily Sales Reports/Updates
  • Print the Daily Sales Journal as well as all subsequent reports
  • Answer Yes to Update
  • Print the Daily Transaction Register – it should reflect the correct detail and total information.

More

64 Bit ODBC and Sage 100 ERP (Formerly Sage ERP MAS 90 and 200)

by

An interesting question was just asked on the MAS 90 LinkedIn Group. One of the users posed the question:

When a customer has 64-bit OS systems, they naturally want to install 64-bit versions of MS Office. All seems fine until one decides to connect to their 32-bit ODBC and are greeted by the “Specified DSN contains and architecture mismatch”. This happened to me – from a 64-bit version of Excel running on a 64-bit OS, selected Data, Other Sources and then selected SOTAMAS90*. (Note the asterisk). Once selected the message displays about the mismatch.

Is there any way around this? It seems that you need a method to tell the 64-bit programs that when they want to use a specific 32-bit ODBC they need to go through SYSWOW64 and call the ODBCAD.EXE. However, I’ve not found any options to force it to the 32-bit ODBC.

 

The short answer is that 64 bit ODBC drivers are not yet available for Sage 100 ERP .

What most users have done is uninstall any 64 bit apps (usually Microsoft Office 64 Bit) and installing their 32 bit versions.

Our 90 Minds Consulting Group has been tracking this issue since August 2011 and have the following feedback:

 

– Might be able to in MAS 5.0 but probably pushed to 5.1
– PVX Plus may have a 64 bit ODBC to offer (for a fee) at some point (I think they’re testing)

The present resolution has been to uninstall 64 bit Microsoft and install 32 bit.

Would gladly welcome updates from anyone with different workarounds.

 

UPDATE: The 64 Bit ODBC Drivers are available from PVX Plus per the following post on the MAS90 LinkedIN group:

 

 

The driver could be installed on select workstations. If a workstation needed both the 32 Bit and 64 Bit they would have to have different DSNs (logical Data set name) in order to have the system identify which driver to use.
To order the driver you can contact sales@pvxplus.com or call us at 1-888-975-7587 and press 1 for sales.If you want to give it a try it can be downloaded from
http://www.pvxplus.com/pgsrvr.pvp?pg=dl_optional
(select the 64 bit version — second from the top). It should work using a key of DEMO for testing.

Contact Us

Schulz Consulting
Connecticut Office
Click Here To Contact Schulz Consulting
Phone: 860-657-8544
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.
Schulz Consulting