Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Contact

Act! Mobile Live (beta) unveiled at Sage Insights 2009

May 14, 2009 by Wayne Schulz

act mobile live.jpg

CompanionLink Software has an interesting post on a demonstration of Act! Mobile Live (beta) at Insights 2009. ACT! Mobile Live is a mobile service for ACT! that lets you do away with synchronization cables. Using ACT! Mobile Live a user can wirelessly synchronize Act! data with a number of different mobile devices.

Items of note from their post:
– Supports iPhone, BlackBerry, Windows Mobile, Symbian)
– Does NOT support Android or Palm Pre (which is not yet released)
– Recommended to sync 1000 or fewer records

More

Filed Under: Sage 100 ERP Tagged With: "insights 2009", act!, companion link, mobile live, Wayne Schulz

MAS 90 and MAS 200 – The Road Ahead (Notes from Insights 2009 Session)

May 13, 2009 by Wayne Schulz

roadThese are  raw unadulterated notes  I just received from Robert Wood of DDF Consulting who is  a Sage Business Partner and MAS 90 consultant from Starke Florida which summarize the popular “Road Ahead” session given yesterday at Sage’s Insights 2009 Business Partner Conference in Nashville.

I may have missed something or misinterpreted something. Since I’m typing this pretty late, I may have mistyped something.

Wayne Note: References to Erika and Roberta are for Erika Jelovsek and Roberta Vigil of Sage who while they may have held different titles through the years have always been there patiently answering the annoying questions of Business Partners like Robert and me. A great amount of thanks goes to Erika and Roberta  for putting up with us answering questions like these which I’m sure they are asked thousands of times during the course of Insights.

IMPORTANT:

The information below is preliminary and based on expected features for product(s) that have yet to ship. Therefore all timelines and features are preliminary and tentative — and subject to change without notice.

Use this information as a guideline and not an authoritative list of features. The summarized information is believed accurate but if we’ve missed something or stated it wrong – blame Schulz Consulting – and not Sage – as this is our summary of the session.

Changes in MAS 90/200 4.4:

Customer number will be 20 characters. For existing users there is a setting to convert from seven characters, but once that setting is changed, there is no going back.

All new implementations will have 20 character customer numbers. This is in addition to the two digit division.

Item numbers will be 30 characters. Same deal as customer numbers (once changed there’s no going back). Existing users can choose to move up. New implementations will be 30 characters.

Inventory transactions can now go up to four decimal places to match work orders. If you use the decimal places you no longer lose digits to the left of the decimal. This setting will be in Common Information. Also, CI_Item will be the item table whether inventory items, miscellaneous items, or saved comments.

MAS 90/200 4.4 will be the completion of the Framework.

What will happen to unconverted modules like payroll, work orders, and job cost? Sage is not sure yet. There was some discussion of “replacing” job cost with either a project accounting module or adding project accounting functionality to the core in some form.

WAYNE: I heard the same feedback from walking the trade show floor and talking to developers. In the product planning session for Sage MAS 90 and 200 I was left with the impression that Sage is not indicating that the remaining modules will NEVER be updated to the framework but rather the timeline is undetermined.

The Payroll modules seems like a slam dunk to upgrade since Sage indicated 50% (or slightly more) fo all Sage MAS 90 implementations use Payroll. The issue with a Payroll upgrade (both from stated reasons and behind the scenes chatter) is that it’s complex and the code being updated is from many years ago.

Several other changes with 4.4 are the addition of web services (more on that below), customizer enhancements (also more below), and parallel migrations. Not in the road ahead, but in the 4.4 preview session immediately afterward, Roberta Vigil demonstrated the parallel migration functionality. It’s basically the same steps we went through when converting from 3.71 to 4.x. The wizards all look the same. The logic is the same.

It (version 4.4) is scheduled to be released Q1 of 2010. (This is new release information as the prior date was Q4 2009).

Customizer enhancements:

They are adding scripting functionality to specific MAS 90/200 events that no longer require user interactions (no buttons).

You can establish validations on any column and works with the user interface, visual integrator, the business objects, and presumably the new web services.

You will be able to automatically total detail numeric UDFs to the header object and create cumulative calculations on multiple records and save to table or UDT during update. Example given was if you are totaling quantity sold by salesperson, you could have them update to a UDT or to a UDF in the salesperson table when the invoices are updated.

Going forward all VB scripting customizations will survive upgrades.

Small Business Edition will include Payroll as an option and Sage SPS Credit Card will be provided at no charge.

What are web services? Web services are the Business Objects optimized for use with the web. The demonstration was a website developed by ISM Barsa for Moonstruck Chocolatier (thanks Moonstruck for the free samples. No I’m not sharing.). It’s not online yet. The rep from ISM Barsa said the most difficult part of implementing the web services elements of the new website was ripping out the existing Business Objects code so they could implement with the new web services.

WAYNE: The go to person for web services is Angela Goldsmith of ISM Barsa – angela@goism.com – LinkedIn – ISM Barsa Web Site. I spoke to Angela several times about the web services and her company is providing some assistance to get this all running.

The first phase of web services will include Sales Orders, Contacts, Customers, and Credit Cards. Phase II will include Inventory Items and more. Again the stated purpose was to optimize the Business Objects for the next generation of e-commerce.

Stated benefits of web services: scalability and separate front end from back end. My interpretation was they were further splitting up the programming of the MAS 90/200 interface from the data layer for use in third party applications.

Challenges for implementing web services: knowledge for back end development and data mapping in and out is complex.

The Business Object interface was not designed for direct over the net communication and Web Services is designed for direct over the net communication.

WAYNE: My interpretation of the Web Services is that they’re cool new extensions for linking to third party shopping carts. In the product planning session for Sage MAS 90 and 200 I was left with the impression that while eBusiness will remain for the foreseeable future that these Web Services may become the “going forward” primary e-Business connection.

On the front page to MAS 90/200 Sage is adding links to the new Sage MAS Community forum and to their new hosted feedback solution, Ideascope. When you submit an enhancement request from Ideascope it will try to match your recommendation up with existing recommendations and allow you to say that your request matches one that already exists and add your vote to the tally or you can add yours as a new request. With the link to Ideascope on the front page in MAS 90/200 and not having to log into a website to make requests, it should make it easier for customers to submit their suggestions. Ideascope will be available soon. Erika did not give a date.

Applianz appears to be Sage’s solution for SAAS/Cloud Computing. Applianz appliances are currently available and supported by Sage for MAS 90/200 and MAS 500. EES should be supported with version 1.3 which is supposed to be available this summer. The holdup is apparently an issue with SageCRM’s incompatibility with Terminal Services, which is supposed to be corrected with version 1.3.

WAYNE: John Shaver – LinkedIn – Twitter – @john_shaver – over at Aries Technology Group goes through a local hosting company for those clients who don’t want to setup Sage MAS 90 on their servers. He likes this due to the benefits of having the software securely hosted off-site.

Other attendees discussed a standalone web enabled server such as Applianz which is another solution that allows for some remote configuration and might be thought of as “Sage MAS90 in a box”.

An Applianz System Internet-enables almost any Windows-based software allowing our customers to run the best selling business software applications. Popular software applications can be used on any PC or Mac, from the office, home, or from anywhere in the world in seconds.

With our 1-click instant access technology, workers can use software from any off-site location without the expense and hassle of a VPN, Citrix, or Terminal Services

What’s happening with FRx?

Sage hasn’t made a decision on a replacement and appears to be early on in their search for a replacement. Most customers prefer using Excel and want drill down, wizards, real time data, and simple conversions. While development has discontinued, Microsoft will continue to support FRx until December 2011, so Sage doesn’t feel huge pressure to make a decision.

WAYNE: General feedback was that FRX hasn’t broken in the last 5 years and probably will continue to work another 5 years – so there’s not a huge sense of urgency to move existing FRX users though certainly after 2010 (when FRX new sales end) there will need to be a different financial reporting solution bundled with General Ledger. We’ve received no indication on what the replacement for FRX will be though F9 or Biznet BizExcelarator are two leading candidates in my opinion.

Another big issue is PA-DSS compliance or Payment Application Data Security Standards. These are the rules that require credit numbers to be stored only in encrypted form and standards designed to protect consumers from credit card fraud. Sage has engaged an audit firm to get them certified by later this year.

International Financial Reporting Standards (IFRS) compliance is something Sage is looking into and has in the works, but they are looking for feedback.

Some new features with MAS 90/200 EES (Extended Enterprise Suite) version 1.3 are:

  • salesperson mapping to allow for divisions
  • one salesperson in CRM can be mapped to the different required salespeople in MAS 90/200
  • opportunities can be entered on the fly from CRM
  • copying of orders from selected company will be allowed in CRM
  • FAS will be updated to reflect the changes in the American Recovery and Reinvestment Act
  • Fixed Asset Snapshots; Terminal Services support for SageCRM
  • based on the MAS 90/200 4.3 code.

Planned features for MAS 90/200 EES 2.0 are:

  • MAS 90/200 info in CRM User Interface
  • Opportunities on the fly from MAS
  • copy orders to/from any customer in CRM
  • Fixed Assets 2010.1
  • Role Based landing page in CRM
  • CRM to support IE 8
  • based on the MAS 90/200 4.4 code.
  • scheduled to be released Spring 2010 or about a year from now.
  • order entry screens in CRM will be the JavX screens from MAS 90/200, so they will have the dual entry lines in order entry and customizations from MAS 90/200 can be added to the JavX screens.

After MAS 90/200 EES 2.0: additional roles supported including purchasing agent and customer service (RMA); Multiple company support (one SageCRM database can update to multiple MAS 90/200 companies); and mobile solutions (Blackberry and iPhone), and business intelligence.

Future requests from customers for Sage MAS 90 and 200 enhancements are:

  • electronic payments
  • electronic bank reconciliations
  • sales history for drop ships (ROBERT: which I thought they also said would be in 4.4)
  • one click journal entry reversals.

Sage MAS 90/200 from 2010 and beyond:

  • multi bin
  • expand other IDs (Vendor Numbers, etc)
  • positive pay
  • include other Extended Solutions when/where appropriate,
  • vertical functionality
  • more business intelligence
  • DB upgraded to SQL (undetermined as of Insights 2009 whether this will be MYSQL or MS SQL)

SQL was seen as very important to partners, existing customers, and new prospects. The biggest reasons were reporting and easier data transportation/warehousing/extracting. Why now? The Business Framework makes it possible. What about modules not being brought up to the Framework? SQL is projected to be in beta three to six months after MAS 90/200 4.4 is released.

Questions:

Job Cost?

Erika: Next question. Sage is probably moving to more of a project accounting model than job cost. Suggestion from the audience was Sage should survey existing job cost customers to see what they thought.

Payroll? No decision has been made yet.

With EES having three different databases, could we see some consolidation toward a single platform (i.e.: move FAS to SQL instead of Sybase).

Afterwards I asked Erika what was the migration path for existing MAS 200 SQL users. Her answer was none. They would either have to convert from MAS 200 SQL to current 4.4 or use a tool like the DSD SQL to MAS 3.71 conversion utility and then upgrade.

WAYNE: During Insights 2009 we learned that Sage is in negotiations with DSD Business Systems to purchase their MAS200 SQL Migration Utility. The game plan appears to be that Sage will discuss migration with each MAS 200 SQL 3.74 customer on an individual basis to get them to the MAS 90 4.x platform. There likely will not be one broad migration announcement for thos customers still using MAS 200 SQL 3.74.

There were several inventory features covered in the MAS 90/200 4.4 preview that was immediately after the Road Ahead session. Standard cost adjustment register and update. This will be patterned after automatic cost/price change and includes adjustments to GL. Removed ability to change from Inventory Maintenance unless quantity on hand is zero. System Activity Log will indicate the start, finish, and number of items updated. There will be no more having to enter a journal entry after standard cost is changed.

In physical count you can have the current quantity print on the worksheets and have it prepopulate current quantity on hand in physical count entry. Print current or historical standard cost on inventory valuation report. Because of this change, the Inventory Valuation by Period works. The Inventory Detail Transaction Report, Inventory Valuation Report by Period, and Inventory Trial Balance can be printed either portrait or landscape.

Standard cost items can be valued at zero. They will be relieved from inventory at zero cost. IM account will be untouched while standard cost is zero. The purchase cost will be offset in GL at the time of receipt.

Reminder: All planned features that we’ve discussed (as well as shipping deadlines) are preliminary and tentative. Until the product ships you should not assume that the feature will be included. While we strive to maintain this information so that it is as accurate as possible we cannot be responsible for features that are (or aren’t) added but which we’ve discussed here.

via: DDF Consulting – Starke Florida – Sage MAS 90 and MAS 200 Consultants

Filed Under: Sage 100 ERP Tagged With: "insights 2009", ddf consulting, mas200, road ahead, robert wood, sage, Sage 100 ERP, Wayne Schulz

MAS 90 SQL coming natively in v4.4+ – possibly no support for legacy modules

May 12, 2009 by Wayne Schulz

sage-insights-2009-conference.jpgAs an update to the morning announcement by Motasim Najeeb that MAS90 would now have a native SQL database starting soon after version 4.4 we have the following information:

Q1 2010 is release of 4.4

Beta of 4.4 SQL 3 to 6 months post release of 4.4

Still undetermined is whether legacy (non-framework) modules will be useable under the new SQL database. It appears that Sage does not yet have a definitive answer.

Also undetermined is the fate of MAS 200 SQL 3.74 but we would expect a life cycle announcement prior to the end of Insights.

Filed Under: Sage 100 ERP Tagged With: "insights 2009", mas200, sage, Sage 100 ERP, sql, Wayne Schulz

Sage MAS 90 and 200 version 4.4 delayed – now due Q1 2010

May 11, 2009 by Wayne Schulz

roadNews is trickling out at the Insights 2009 reseller conference that the timeline for release of Sage MAS 90 and MAS 200 version 4.4 will be delayed. The original due date as reported by several Sage Business Partners who I spoke with was year end 2009.

This new release is slated to upgrade Inventory, Bill of Materials and Purchase Order (as well as Custom Office enhancements).

Participants in a general MAS 90 version 4.4 session this morning were told  they should no longer expect to see Sage MAS 90 or MAS 200 version 4.4 in 2009 – rather to expect it by the end of Q1 2010.

We verified this delay with Sage.

While unexpected delays can be aggravating, we think the wait for version 4.4 will be worth it.

Rumor is that part of what’s being looked at for the 4.4 release could include removal of the long standing 2 GB file size limitation that has caused problems for sites with extremely large Sage MAS 90 data files.

There is a session tomorrow on The Road Ahead for Sage MAS 90, 200 and 500 which will inevitably  bring more information as well as possible news for MAS 200 SQL users and those users of modules not yet on the framework (PR, WO, MRP, etc).

Filed Under: Sage 100 ERP Tagged With: "insights 2009", mas200, sage, Sage 100 ERP

Sage Insights 2009 Tip: You Do Have A Better Web Strategy Than THIS – Right?

April 23, 2009 by Wayne Schulz

schulz-consultingIs buying expensive Google Adwords  your only web strategy?

I probably should keep my mouth shut and let the competition keep wasting their money.

It’s sad to see companies  so lost in a lack of any web strategy that their only apparent online plan is  to finance a bunch of random Google AdWords hoping that a big lead randomly lands in their lap.

If you’ve ever tried to sell to a raw Web lead then you know they are almost always using you for a discount, third bid or free advice can be some of the least qualified (and most expensive) types of potential customers.

Of course, done right, a web lead doesn’t have to be difficult to close. Many of them can  turn into a $50,000 project. The key is to know the right way to market on the web so as to attract the quality leads – and repel the discount seekers, quick question askers and tire kickers.

Let me ask you this first  – because maybe I’m making some incorrect assumptions…

You do have a better strategy than buying Google AdWords – or waiting for someone like a software publisher to deliver free leads to you. Right?

There’s nothing wrong with Google Adwords. They’re a great way to supplement an online strategy.

There’s also nothing wrong with free leads from a software publisher (assuming you can get them). These supplement any marketing strategy quite well.

Notice I’ve used the  word “supplement”. It means “in addition to”

What’s your  strategy  online?

Have you developed any of the new tactics that people are talking about?

  • Twitter
  • Facebook
  • Friendfeed
  • Social Media Sites
  • Blogging

Or are you still talking with those in your office about how you “don’t get” some of these new tools?

How most of these new uncomfortable marketing tactics are huge wastes of time. You haven’t tried any of them for more than a day – but you’re pretty sure that they’re a waste of time.

Here’s another question.

How are  TRADITIONAL marketing efforts such as: Direct Mail, Telemarketing, Lead Buying (Findaccountingsoftware, et al) working for you?

If you have not become involved in other methods of marketing (many of them free) and you are located in the Connecticut area – then I advise and hope that you stay home from the Insights 2009 conference. Insights is expensive and there’s no big announcements expected. The economy is crappy. Stay home and plug away at a more productive marketing activity like telemarketing because if you just put more effort (and a lot more money) into these old school tactics you’ll surely turn better results. If that doesn’t work just buy AdWords against my company name on Google.

For those NOT in Connecticut – the choice is yours.

If you’re interested in some of the new marketing methods (many totally free) that people are using to get business – be sure to attend Beyond The Hype – Social Media Marketing for B2B on Wednesday May 13 from 1:30 to 3:oo pm.

Here’s the Agenda:

The way to reach business decision makers is migrating from traditional marketing efforts to the Web. More and more consumers are researching their next purchases online using search engines and social media sites. This session will explore how you can use social media to grow traffic to your Web site, make real connections, and join the conversations already happening on social networking sites. Find out which social media sites work best for business, how to develop a strategy for success, how to measure your campaign’s effectiveness, and where this rapidly evolving medium may be taking us next.

I’m planning on attending to answer questions that may come up during the session from a Sage Business Partner point of view. Note that I’m not leading this session – but after it’s over I plan to stick around and answer any questions. Unless of course you’re from Connecticut.

Filed Under: Sage 100 ERP, Sage software, schulz consulting Tagged With: "insights 2009", blogging, facebook, gen38, hall media, insights09, mas200, nashville, sage, Sage 100 ERP, sage business partner, Sage software, social media, twitter, Wayne Schulz

  • 1
  • 2
  • Next Page »
Access Sage 100 in the cloud today. 3rd party applications supported Available 24/7 from anywhere. Dedicated hosts

Call 1-888-244-6559 (toll-free)

Search Our Site

Sage 100 Newsletter

Sage 100 News

  • Error 15 CI_ eFilingCommon.pvc 247 when generating Aatrix Form
  • Sage 100 2023 e-File Payroll Tax Deadlines
  • Beware Fake Sage Support Sites
  • When Is Sage 100 Payroll 2.24 for 2023 Due?
  • Which Crystal Reports Versions Are Compatible With Sage 100 (As of October 2023)?
  • Windows Server 2012 R2 No Longer Supported with Sage 100
  • How can I see the tax tables being used for Payroll taxes?
  • Sage TLS 1.2 Change Deferred For Some Through March 2024
  • Sage 100 Updates for 2023: The Year-End Edition You Can’t Afford to Miss
  • Summit Hosting Rebrands as Summit

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.

Copyright © 2023 · Parallax Pro Theme on Genesis Framework · WordPress · Log in

 

Loading Comments...
 

You must be logged in to post a comment.