How Is Unit Cost Computed For FIFO Items Within MAS90 Sales Order Invoice Entry?

Here is an interesting tidbit that I just learned (or maybe I knew it before but re-learned it).

The cost field in the MAS90 Sales Order Invoice data entry may not be the true cost so long as the invoice is unposted.

A Client was using FIFO costing for an item that they sold. Noticed that the data entry cost didn’t match with the gross profit journal cost. Turns out the way that the cost is assigned is MAS90 and MAS200 may use last cost within the invoice data entry cost field. (see this link for the Sage explanation)

When the transaction is posted the cost is assigned properly to the invoice history file.

This came about because the client wanted to provide a file of sMAS90 Sales Order invoice data entry transactions (including line item costs) to a third party. My thinking was just take MAS90 Sales Order Invoice Data Entry and do an export.

That worked — except the client noticed the cost per the export I had created did not match to the cost per the Cost Journal for FIFO (and possibly other) cost types.

Here’s the Sage KB that explains it better than I probably have.

MAS90 Online Early Adopters Wanted

Looking for Early Adopters for Sage ERP MAS 90 Online

Sage ERP MAS 90 Online is scheduled to launch in October 2011. Sage is currently looking for clients and partners to participate in an Early Adopter program. We are specifically looking for clients to go “live” in September to help Sage ensure the system is ready to go. Sage will cover the first two months of the Sage ERP MAS Online subscription fees for clients participating in the Early Adopter Program.

If you have a (prospective) client who would be interested in the Early Adopter program for Sage ERP MAS 90 Online please contact me at jamie.kandola@sage.com.

Note: As of now only new users are being accepted. In the future this program may open up to existing users of Sage ERP MAS90 or 200.

SageCRM Training Guides For Accpac, MAS90/200, ProcessPro/SagePro

The question of whether SageCRM training manuals were available for users and consultants just came up in my 90 Minds consulting group. Fortunately the answer to that question is yes as my friend Peter Wolf of Azamba Consulting just pointed out:

I do sell the classes in conduction with other Sage Partners. Pricing is available on my web site and I have a bundle of a two hour training session that is included with most course guides. This session allows for about 30-45 minutes of questions and answers. One of my Azamba SageCRM senior consultants conducts the training.

Here’s a sample of the guides:

sagecrm training guides.jpg

More information: SageCRM Training Guides

MAS90 Users Off Maintenance? September 8, 2011 Could Be Your Last Day To Reinstated Inexpensively

My fellow 90 Minds collaborator Beth Bowers dropped this into the group a few days ago. I think it’s worth sharing.

I’ve not seen an official memo on this from Sage but the reinstatement folks are advising:

On September 8 (I believe the magic of that date is when 4.5 is slated to be available for new sales) those users on version 4.1 or earlier who are OFF SAGE MAINTENANCE will no longer have the option to reinstated for the price of the penalty.

Instead those users on 4.1 and earlier who are also off maintenance and wanting to come back on will have to re-purchase the package – which depending upon configuration – could be two or three times the reinstatement cost.

Sage ERP MAS 90 and MAS 200 Extended Solutions Advisory

If you’re using Extended Solutions Sage have stopped providing any updates for versions that might be needed in instances where you are forced to install a product/service update (example – payroll tax table update that also requires a service update).

This has been in effect since 4/30 though they make exceptions. I just had one granted today.

While I was on the phone with Sage they mentioned that these exceptions are going away – with no stated date on when that will occur.

If you’re still using Extended Solutions — especially if you are a payroll users — please be aware that some tax table updates or forms changes that are issued by Sage require that you install up to a certain service/product update level or the fixes won’t load.

I had a customer using a payroll enhancement and they had to install a service update in order to load the latest Connecticut tax tables. In the process the latest version 4.20 service update broke their PR-1068 Extended Solution. I had to call Sage to ask for an update.

Just a warning that in the not too distant future Sage will no longer be sending out these upgraded Extended Solutions even though you are still on a supported version of MAS90/MAS200.

Sage Branding North American Roadmap

I was of the impression that these items were under embargo however they seem to have appeared in public and most of the details being shown privately to select partners has been reposted on LinkedIn.

sage rebranding linkedin.jpg

Here’s what we understand so far about the Sage re-branding.

On stage at the Sage Summit 2011 conference incoming CEO Pascal Houillon surprised the audience of Sage Business Partners with an announcement that most of the products in Sage’s North American portfolio would be rebranded with a numbering scheme similar to that used in Sage Europe.
YouTube Preview Image

What followed was apparent confusion for some in the Sage channel as evidenced by this very lengthy 130+ message LinkedIn message thread.

Sage have been meeting privately with select VARS to roll out their concept of re-branding and solicit private feedback. When asked if he’d be going on the road to do a general listening tour with the entire channel, EVP Marketing Dennis Frahmann paused before stating that Sage had no plans to gather general feedback from partners.

As conversation continued on LinkedIn around this re-branding efforts Sage seemed to move into position to participate in the conversation (too late in my opinion) and issued several general statements to clarify their branding.

According to Sage EVP of Corporate Marketing Dennis Frahmann, not all product names will be reduced to a numbering system as per this post he made on August 24, 2011:

The current straw case naming architecture that has been shared with a number of partners and advisory groups for comments proposes that the name of Sage ERP X3 be untouched. There are other products as well that would not get renamed. Our intent is to publish the complete naming architecture to our partner community later this fall.

Frahmann also followed up in a post here with further reasoning on why certain products might not be renamed:

Second, as noted in an earlier FAQ to partners, not every product is being renamed. Some programs and products, currently designed to support all of Sage, already have generic names that will remain the same or change only slightly. Other products, due to either specific business plans or limited intent to acquire new customers, will not change their names. Only a limited set of numbers will be used to create families of offerings; each renamed product will not have a distinct number.

Finally, while this is a North American-led initiative, we are working closely with our international colleagues. If a product is renamed, it will be renamed for all regions in which it is sold.

Sage will around the end of 2011 announce final plans for their new branding initiative. Implementation will follow at the start of 2012 with full branding rollout presently scheduled for the end of 2012.

Product names for some (but not all) products will go away. Instead of referring to product names you’ll refer to them as follows (tentative and preliminary examples – not complete):

Sage 50: Sage Simply, etc.

This will also roughly describe products used by companies with 50 or fewer employees and under $50 million of sales.

Sage 100: Sage ERP MAS 90, etc.

This will also roughly describe products used by companies with 100 or fewer employees and under $100 million of sales.

Sage 300: Sage ERP Accpac, etc.

This will include mid-market applications that also are distributed outside North America.

Sage 500: Sage ERP MAS 500

This will also roughly describe products used by companies with up to 500 employees and $500 million of sales.

It appears Sage ERP X3 will retain its name. As of right now there’s not much information on whether Peachtree will rebrand. Earlier reports has Sage stating that Sage Peachtree would be referred to as Sage 50. Also later in the year watch for a new SaaS offering which Sage CEO Houillon briefly announced from the podium. While details were not announced it’s likely that Sage will leverage some of their overseas product technology for this.

Sage MAS Intelligence (SMI) Free Web Demonstration Schedule

smi sponsors.jpg

As you know the FRX Financial Reporting tool included with Sage ERP MAS 90 and 200 General Ledger is no longer supported by the software publisher (Microsoft).

Sage have issued prior notices on this which you can review here.

FRX remains compatible with prior versions of Sage ERP MAS 90 and 200. Sage have also indicated it will be compatible with the next version 4.5 slated for release 9/8/11 – though the only assistance Sage can provide is with integration to Sage ERP MAS 90 and MAS 200. All bug fixes and patches have ceased to be readily available for the FRX program.

For new custom financial reporting projects involving more than a few hours of efforts you may wish to evaluate which reporting tool you should use to create new reports.

Moving forward users of FRX will eventually need to migrate to another reporting solution. Sage have provided Sage MAS Intelligence (SMI) as their recommended solution.

SMI is Microsoft Excel based and draws data not only from your financial data but also data from other MAS 90 + MAS 200 data files such as Accounts Payable, Accounts Receivable, etc.

Sage published this PDF which provides many tips and online links showing how to get started with SMI. Those of you with immediate reporting needs may find it helpful to review the information which goes into greater depth on available resources.

On Wednesday August 24, 2011 Sage will sponsor a free one hour look (30 minute demo and 30 minute question and answer) at creating financial statements using SMI Report Designer. The session starts at 1pm PDT or 4pm EDT. You can sign up here to attend this overview or review the schedule of future SMI web seminars.

Sage MAS Intelligence.jpg

Sage’s MAS90 and MAS200 Support Fee Structure – August 2011 Edition

I’ve had a few inquiries from users of MAS90 and MAS200 about the fee structure for Sage’s maintenance.

Sage offers three levels of maintenance for MAS90 and MAS200:

Bronze – no phone support , product updates only (required entry level plan to get upgrades or buy new modules or licenses)

Silver – 5 calls to Sage per year

Gold – Unlimited calls to Sage per year

More detail on the exact Sage plan benefits :

Pricing is as follows:

Sage is automatically invoicing any MAS90/200 customer who was on Silver last year as Gold this year.

Any customer who was on silver last year is automatically invoiced for Gold.

The reason for this is because with Silver this year, you don’t get unlimited support. Silver this year only gets you 5 cases. The pricing structure has also been modified.

There is no longer a flat fee of 1500(silver) or 2400(gold) for support.

It is now based on a percentage of SLP.

For instance: if a customer has a 10,000 dollar SLP, their maintenance/support would be calculated as follows:

Bronze: 18% or $1800
Silver: 20% or $2000
Gold: 25% or $2500

For more information please contact wayne@s-consult.com

Various MAS90 and MAS200 ALE lookups that filter by customer number are blank or do not filter correctly (FIXED).

Several users have reported in MAS90 or MAS200 version 4.4.x.x that the customizable lookups sometimes were returning blank records. One example was when a customer lookup was done in sales order INVOICE data entry that the SHIP-TO code lookup was returning blank data.

Some consultants were able to fix this by running the ALE rebuild utilities. Others found that the utility did not resolve the open issue. At first Sage reportedly promised a fix for Product Update 7. Now it seems cooler heads have prevailed and Sage published an independent hot fix last night on their web site.

Download (Version 4.4.0.6)

Sage Summit Pascal Houillon Keynote, Branding Announcement, Panel Discussion

Sage have just posted the keynote address from their Sage Summit 2011 conference that was held in July 2011. Interesting topics covered include significant branding changes for Sage North America.

Following the keynote is a Q&A session with Sage Executives.

YouTube Preview Image

How’s The Accuracy Of The New MAS90 – MAS200 CT Payroll Tax Tables?

I have completed about half a dozen MAS90 payroll upgrades for clients with Connecticut employees.

So far I’ve received feedback that the computations need to be manually reviewed and in some cases adjusted (be sure to read the instruction sheet that I left because Sage indicates that with the update you may not longer simply add an additional amount to CT withholding but instead should force the ENTIRE computed CT withholding).

If you need this, here is a link to the tax table update as well as the important instructions on configuring CT tax withholding.

http://infosource.sagesoftwareonline.com/sw_attach/sso/mas90/90ttu.htm

Please let me know how you are finding the computation of CT tax and if you’re encountering any issues.