How To Edit Lot/Serial UDF Fields in Sage 100 ERP

lotserialudf

Starting with v4.4 of Sage 100 ERP you can create user defined fields (aka UDFs) without needing third party enhancements. What you cannot do is edit those fields from your Sage 100 ERP main panel. If you need to edit the Lot/Serial user defined fields you’ll need to use Business Objects Interface (BOI) scripting or purchase IM Lot/Serial UDF Edit from DSD Business Systems.

This enhancement also has a great manual which will walk you through the UDF setup process step by step – including screen shots of each custom office screen you’ll need to edit.

Download Manual or Visit Main Enhancement Page

Last Day For MAS90 Extended Solution Updates is April 29, 2011

Sage have just sent a notice that any users on Sage ERP MAS 90 or MAS 200 version 4.3 who need an Extended Solution updated (often required if  a service update is being installed) to the latest version have until April 29, 2011 to request this.

As you probably know Sage stopped supporting Extended Solution (a catalog of enhancements for Sage ERP MAS 90 and 200) back in 2009. For a period of time they were still allowing some orders of the solutions but had noted that all updates (within the same version) would cease in 2010. That date has been extended through April 29, 2011.

If you are using an Extended Solution on version 4.3 and have a need for an updated version 4.3 copy of that solution (for example if you’re installing a v4.3 service update ) then you should contact your business partner prior to 4/29 and arrange to receive an updated copy of the Extended Solutions.

via Sage:

Last Chance to Request a Customer’s Extended Solutions v4.3-Compatible Extended Solutions Titles. On November 30, 2010, Sage sent you a list of your customers and the Extended Solutions titles they own. Please reference this list and contact the sales advisor team at salesadvisor@sage.com to place your clients’ orders. Sage has granted a grace period to request v4.3-compatible titles until April 29, 2011

 

How Can We Help ?


Sage 100 ERP (Formerly MAS90 or MAS200) support issue?
ERP upgrade?
Second opinion?
Need a Crystal Report written?


Since 1986 we've supported all versions of Sage 100 ERP accounting software (plus most common add-ons like Crystal Reports, Business Alerts, Starship, Credit Cards).

Schulz Consulting is located in Glastonbury CT and we have a nationwide network of consulting firms through our affiliation with DSD Business Systems and the 90 Minds Consulting Group.

We consult nationwide via remote connect.

Concerned about consulting costs?

Our services are provided on a fixed fee basis. No surprise bills. No hourly rates. No engagement work starts before we both agree on what the outcome of the work is to be.

Ready to start?

Please provide some information and we'll reply to your inquiry within one hour. Your email information is kept private and not shared with any other company.

Thank You,

971DF4E0-4EB6-449D-B904-32D51F79FAC1.jpg

Wayne Schulz
SCHULZ CONSULTING, LLC

New Customer Support - Information On Becoming A Subscriber:
860-516-8990

Note: Due to the volume of requests we regret that we are unable to provide free consulting advice.

Here are our Sage 100 ERP diagnostic options



  • Please describe in detail any issue that you are experiencing or which you would like assistance with.

Decimal Place Precision For MAS 90 & MAS 200 4.4

dsd extended solutions.jpg

Is 4 digit decimal precision too small for your company? With the recent decision by Sage to discontinue Extended Solutions your alternatives are to either live with less precision – or review solutions from third party developers (Extended Solutions Preferred Providers).

DSD Business Systems is one such provider. Last night I noticed they’re offering the following Extended Solutions with no additional upgrade fee (beyond regular maintenance):

BM-1005 – Expanded Mask for Quantity/Cost – $960 (subsequent maintenance = $265)
IM-1114 - Expanded Numeric Mask for Price/Cost/Quantity (subsequent maintenance = $265)
IM-1115 – Six Decimal Precision for Inventory (subsequent maintenance = $265)
PO-1085 – Six Decimal Precision for Purchase Order (subsequent maintenance = $265)
WO-1015 – Extended Decimal Precision in Work Order (subsequent maintenance = $265 )
WO-1016 – Six Decimal Precision in Work Order (subsequent maintenance = $ 265)

DSD Business Systems is also offering the same bundled pricing previously offered by Sage on these Decimal Precision Extended Solution Bundles:

DP-1000 – IM-1114, IM-1115, PO-1085 – $ 2,030 (subsequent maintenance = $535)
DP-1001 – BM-1005, BM-1078 – $1,460 (subsequent maintenance – $265)
DP-1002 – WO-1015, WO-1016 – $1,460 (subsequent maintenance – $ 265)

The following parts are listed as obsolete:

BM-1078 – obsolete as of v4.4 since Bill of Materials for MAS 90 and MAS 200 already uses 6 decimals in v4.4
SO-1160 – obsolete after MAS 90 v4.05

Extended Solutions For MAS 90 and MAS 200 Updated As Of August 2010

DSD Business Systems of San Diego is a Gold Development Partner for Sage Extended Solutions. As such they have access to the source code for the Extended Solutions which Sage have discontinued.

If you’re not familiar with Extended Solutions they are pre-written customizations (sold separately) that once installed work seamlessly within MAS 90 and MAS 200.
For years Extended Solutions were sold directly by Sage and considered to be the “secret sauce” that Sage consultants used when they implemented new systems for customers.

During any ERP software implementation there’s usually a tiny bit of missing functionality that’s needed. For example finding a fixed cost Extended Solution that for example performed ACH Payments for Accounts Payable (not a core MAS 90 feature) was significantly cheaper and easier than hiring a programmer to modify the software to perform that task.

Beginning with version 4.4 of MAS 90 and MAS 200 Extended Solutions will not be sold separately. Instead Sage have taken the list of available solutions and intends to cull out the most popular ones for inclusion in future releases of MAS 90 and MAS 200.
Extended Solutions not selected for inclusion will have their source code made available to a number of select programmers (Preferred Development Partners) so that customers can have their enhancements upgraded.

On August 17, 2010 DSD Business Systems reported their progress on which solutions they’ve already upgraded.

Extended Solutions Recently Released

And they also reported on which solutions are in progress with a “soon to be released” date:

Extended Solutions Currently in Development

Unincorporated Extended Solutions Stop Receiving Support & Upgrades February 1, 2011

Sage has just issued an update that outlines when certain Extended Solutions that they’ve announced as being added to Sage MAS 90 and 200 will make it into the product.

In addition they’ve indicated that as of October 1, 2010 an additional 24 solutions will stop being sold. On February 1, 2011 the support and upgrades for those 24 will cease.

More information is available from their official statement – which appears to be a draft of one that’s soon to be sent directly to end users.

Sage MAS 90 and 200 Extended Solutions Update – BP 7-19-10

Sage MAS 90 Extended Solutions Incorporation Plan Updated

Sage Software today released an updated Business Partner FAQ to clarify how they’re dealing with the 56 solutions that are being incorporated into MAS 90 and MAS 200 4.4x – as well as to explain whether anyone can buy a solution at a level earlier than 4.3 (In a word – no).

What Are Sage Extended Solutions?

Sage MAS 90 and 200 Extended Solutions were originally developed by one of Sage’s leading development partners to meet the specialized needs of the Sage MAS 90 or 200 customer base. Sage acquired this library of over 1,000 titles in January 2004. Because they are so specialized, most of the individual Extended Solutions titles are currently owned by only one or two customers. The more popular titles with broader appeal, such as Paperless Office, contain features and functionality that have high market value. Those titles were evaluated and many of those features began to be incorporated into Sage MAS 90 and 200 4.3.

What is the go-forward plan for Extended Solutions?

Sage has made the decision to focus on continuing to build value into the base product, simplify our product portfolio, and begin phasing out Sage MAS 90 and 200 Extended Solutions. This phase-out process includes incorporating the main features and functionality of many of the top Extended Solution titles, adding market-driven features to the base product. All customers will receive the benefit of many new features with the new release and product updates as part of being on a current maintenance or support plan without the additional expense of each Extended Solution title. We’ll begin delivering that additional functionality over the next several releases and product updates. Those select titles will continue to be sold until the time they are included in the base product. Since the incorporation will be our focus, we will not be bringing Extended Solutions titles up to compatibility with the 4.4 release. The remaining titles will be provided to Source Code Development Partners so they can utilize their expertise to provide the specialized solutions for Sage MAS 90 and 200 customers. Combined, the above actions cover 96% of all titles and 75% of all customers. We hope you will support us by carrying through messaging that this is a great start to Sage’s goal of continuing to build value into the base product and simplifying our product portfolio

How do I know which of the Extended Solutions title(s)’ main features and functionality will be included in the core Sage MAS 90 and 200 products over the next few releases or product updates, and which will be available to customers only through me, working with Development Partners?

The main features and functionality of the titles that have broad market value, such as ACH Electronic Payment for Accounts Payable, will be incorporated into the core product over the next few releases and product updates. Please refer to the most current Extended Solutions information published on SageMAS.com to see the titles that have been selected for incorporation:
http://www.sagemas.com/products/sagemas90_mas200/extended_solutions

What about Extended Solutions titles that are no longer shown on the SageMAS.com Sage MAS 90 and 200 Extended Solutions Web page?

Extended Solutions titles that are no longer shown on the Extended Solutions page on SageMAS.com have been retired. You have several options that you’ll be able to use to meet specialized needs of Sage MAS 90 and 200 customers. You may determine that their needs can be met using the enhanced customization and scripting tools built into Sage MAS 90 and 200 4.4 Customizer. These tools can be used to provide customers with customizations that survive upgrades, so the customizations do not have to be reapplied to or recreated in a new release. In many cases, you’ll be able to create the modifications at your office, export them, and e-mail them to the customer to import. This will help streamline your deployment, reduce the time spent on this type of custom work, and allow you to do more with your development staff. If their needs surpass the abilities of those tools, you may decide that the best solution is to engage a Sage Development Partner, who can design product modifications outside of those parameters.

Customers not currently on version 4.3, but who have plans to upgrade, will be able to request their retired Extended Solutions 4.3 title updates through the Sage Sales Advisor team until 11/1/2010. Sage will no longer correct defects, or provide year end payroll changes for any retired Extended Solutions titles after 11/1/2010.

Listed below is the current schedule for when a solution is slated to be incorporated (at no cost) into a future release of MAS 90 or MAS 200.

Extended Solution titles are listed on the left, the part number is in the middle and on the right is the product update and estimated ship date when that solution should first appear.

If you are using a solution that isn’t slated for incorporation until 2012 — say for example SO-1530 Enhanced Sales Order Integration with Job Cost — you have the option of paying a developer to upgrade the solution earlier.

In the majority of situations customers using an Extended Solution slated for incorporation but not until 2011 or 2012 won’t have much of an option but to sit and wait for an upgrade to arrive.

Charts shown below are tentative and preliminary – as per Sage’s 3/24/2010 Extended Solution FAQ.

sage extended solutions incorporation 1.jpg
sage extended solutions incorporation 2.jpg

Sage Extended Solutions For MAS90 & MAS200 Sales Policy – Updated 2/23/10

I’ve just learned that Sage will now sell “kept” Extended Solutions for installation to MAS90/200 at level 4.3 AND EARLIER.

Update March 19, 2009:

Now you see it — now you don’t…

Sage initially told us that they would make their 56 kept solutions available on any supported version of MAS 90 or MAS 200 until the solution was incorporated to the next level of MAS 90/200.

Policy change by Sage.

Long story short — Sage won’t sell any of  the 56 kept Extended Solutions at any version prior to 4.3.

They’re no longer making them available at earlier levels.

The information above supersedes the post that we wrote below based on lengthy conversations with multiple Sage personnel – who ultimately reversed policy on us while we were mid-stream proposing their solution (with information they provided) to a customer.

Update March 29. 2010: We continue to have issues both ordering and obtaining the most basic of pre-sales support on any Sage Extended Solution sales. We recommend that you not purchase any of the 56 kept solutions and instead wait for them to be incorporated into a future version of MAS 90 and MAS 200.

As you probably know, starting with the release of MAS 90/200 v4.4 Sage announced in 2009 that they’d be doing away with their Extended Solutions catalog of what appeared to be 500 or more custom enhancements while keeping 56 of the most popular Extended Solutions for incorporation to versions 4.4+ of Sage MAS90 and 200.

Sage Extended Solutions in many instances replaced the need for custom MAS90 and MAS 200 programming.

Starting with release 4.4 of Sage MAS 90 and MAS 200 Sage  will incorporate  (add into the MAS product) 56 of their most popular enhancements on a two or three year rollout schedule.

Discontinued solutions are being provided under an open source license to Sage Preferred Development Partners (view the list here) who can upgrade them (possibly for a fee) and resell them.

In the interim there was considerable confusion about whether a licensed user of MAS 90 or MAS 200 could purchase any of those “kept” Extended Solutions at a level other than 4.3.

If you view the Sage Extended Solution web site you’ll see the issue is not entirely clear as the site states that the 56 kept Extended Solutions ” can be added to your Sage MAS 90 and 200 4.3 system“.

What about those customers on a version earlier than 4.3 who needed one of the 56 “kept” enhancements?

Until this policy shift they were being told by Sage that they must upgrade to version 4.3 before they could purchase any enhancements.

Before you suggest to me that I’m crazy – and that Sage was selling the 56 kept solutions for any version – read on.

The prior policy of the sales desk appeared to have been that kept Extended Solutions would only be sold at 4.3.

Sage Refused to Sell Extended Solutions at Versions Prior to 4.3

Here’s the email that I’d received as recently as last Thursday telling me that Extended Solutions that Sage was keeping for incorporation wouldn’t (then) be sold at any version other than 4.3.

From: xxxxx
Date: Thu, Feb 18, 2010 at 6:02 PM
Subject: FW: Selling older Extended Solutions to existing customers
To: Wayne Schulz

Hi Wayne

Please see the email below.

xxxx

title

Sage Business Solutions Division
(800)-854-3415 xxx
www.sagenorthamerica.com
Sage. Your business in mind.

From: xxxx
Sent: Thursday, February 18, 2010 2:59 PM
To: yyyyy
Subject: FW: Selling older Extended Solutions to existing customers

We can sell this to them since it’s one of the 56 extended solutions that will be eventually embedded into the product but it has to be for MAS90/200 version 4.3 only!!

Thanks,

yyy

Sage Changes Policy – Will Sell Kept Extended Solutions At Older Version Until Incorporated

Late last night I was told there is a policy shift.

Sage will now sell any of the 56 Extended Solutions that they are keeping (does not appear to apply to the Extended Solutions that they’ve open sourced to developers) at levels earlier than 4.3 – up into when those solutions are actually incorporated to 4.4.

This means if you are on version 4.1 and need a “kept” solution such as AP-1095 Paperless Office AP Checks & Direct Deposit Stubs that you can continue to buy it up until the time it’s rolled into V4.4+.

This is extremely good news for those existing customers on maintenance with  a supported version of Sage MAS 90 or MAS 200 prior to 4.3. It means that if their business conditions require them to adopt one of  the 56 kept solutions that they can purchase that solution today rather than upgrade to 4.3 solely to qualify for the purchase of an Extended Solution.

There are a myriad of valid reasons that customers don’t upgrade immediately to the latest versions. Some customers have extensive enhancements to MAS90/200 that require testing and custom programming prior to any upgrade. Other customers may be subject to stricter compliance regulations (lending institutions, auditors, Sarbanes Oxley, governmental regulation) that don’t allow for a hasty upgrade.

Here is the link to the list of Extended Solutions to which the policy applies:

http://www.sagemas.com/products/sagemas90_mas200/extended_solutions/