90 Minds Sponsor

Warehouse Management Solution Provider Scanco Releases Scanco Cloud for Sage 100 ERP

Scanco Cloud Highlights

90 Minds Meeting of the Minds Platinum Sponsor Scanco announces the release of Scanco Cloud.

Warehouse Management in the Cloud

Scanco Cloud, Scanco’s first Cloud platform, makes it possible for Scanco users to connect their Sage 100 warehouse management solutions to the Cloud via any iOS, Android, or Windows mobile device. With remote access to the Scanco Warehouse suite and seamless integration to Sage 100 ERP, Scanco Cloud enables users to access their warehouse at any time, from anywhere. The Cloud features true plug and play compatibility with barcode scanning attachments so users can experience full warehouse automation within their Sage 100 mobile apps. Hardware profiles are included in the application and can be configured in a few minutes.

Never “sync” again with 100% real time connection to Sage 100 and see why everyone is doing it the Scanco way.

Stay connected to your intelligent warehouse with Scanco Cloud. Seamless Sage 100 ERP integration is possible in a native iOS environment granting access to the Scanco Warehouse suite with hardware barcode scanning compatibility at your fingertips. Hardware profiles are included in the application and require mere minutes to configure. Scanco Cloud is designed around the user experience with a visually appealing interface that takes warehouse automation to a new level.

For over 20 years, Scanco has worked to provide Sage ERP users with the best in Warehouse Management technology. By offering their very own Cloud platform, Scanco places themselves far ahead of the competition and stays committed to their purpose of providing their customers with the latest in warehouse management technology.

Press Release

Sage 100 (fka MAS 90/200) Quick Tip from Zip: Restrict Date fields

If you’ve ever wanted to restrict any Date fields in Sage 100 (e.g., Invoice Date) so that only certain dates were allowed, there’s an easy solution.  (For example, if users are occasionally making keying errors.)

Assuming you have the Custom Office module, and depending what version of MAS 90/200 you’re running, you can go into the Advanced Field Settings for the Date field (Custom Office > Main > User-Defined Field and Table Maintenance:  then select the appropriate Module, double-click the appropriate Table > Advanced Field Settings) – and specify a Range of Values for the Validation (e.g., 20111201 through 20111231 – or whatever make sense).  And of course going forward you’ll need to edit this Validation Range as needed.

Sage MAS 90/200 Quick Tip from Zip: Searching Item Extended Descriptions

In previous versions of Sage MAS 90/200, you couldn’t simply search Item Extended Descriptions (1 option was to create a User-Defined field to additionally hold this data for being able to search via an Item lookup).  Well now it’s a snap.  At your Item lookup, click the Custom button to personalize your lookup.  In the Available Fields list, scroll down to the CI_ExtendedDescription file and add the ExtendedDescriptionText field.  That’s it!

Posted by Brett A. Zimmermanwww.brettzimmerman.com – Twitter: MAS90_Zip

Sage MAS 90/200 Quick Tip from Zip: 4.40 Upgrade – Open PO Report reconciliation

If you’ve upgraded to Sage MAS 90/200 4.40 and are having trouble reconciling the Open PO Report, be sure to take “Completed” Orders into consideration.  It appears this report in 4.30 (and likely prior versions) displays actual $$ for Completed Orders, whereas 4.40 shows $0.    

Posted by Brett A. Zimmerman – www.brettzimmerman.com – Twitter: MAS90_Zip

How Do I Add the User ID To My Custom Report in MAS 90? How Do I Show The Name Of The Person Who Printed This Custom Report in Sage MAS 90 / 200 4.40?


Photo via psanford

How can I add the user who printed a report to a custom report I added to the menu in Sage MAS 90 / 200?

In order to print the User ID on any Crystal Report being run from the MAS 90 menu, you have to create a new formula in the Crystal Report named PrintedByUser. Using Basic Syntax the formula would be: Formula=””’ (and using Crystal Syntax would be: “”).


You can use this tip on custom reports for both business framework modules and legacy modules.

There are number of variables that MAS 90 passes through to Crystal Reports that are run from within MAS 90 and can be used in the same manner:
CompanyNameCode (CompanyName + CompanyCode)

That’s great, but I want the user name on my custom report.

OK, that’s a little trickier. You still need to create the PrintedByUser field as above, however to get the user name you’re going to need to create a subreport.

Creating a Subreport to Add the User Name to a Custom Report

You have to use a subreport because you’re going to have to join the SY_User table by the PrintedByUser formula field you created.

From the Crystal Report, go to Insert | Subreport.

Create a name in New Report Name; I’m calling mine UserNameSub and click Report Wizard.


Using the Report Wizard you’re going to create a new report based on the SY_User table. Add the First Name and the Last Name to the subreport and click Finish.

On the Link tab, select the PrintedByUser formula as the field to link by and from the dropdown select UserLogon. Click OK.


Drop the subreport on your main report.

Now for a little cleanup. Right click the subreport and select Edit Subreport. I’d suggest suppressing any Headers or Footers in the subreport and if you want instead of having the FirstName and LastName fields, you can create a formula combining the two into one field.

Close the Subreport and save your report and run from the MAS 90 menu and you should get the user name on your report.