How To Convert Sage 100 ERP From PC Charge to Sage Payments

Here’s how to convert a #Sage100 ERP customer from #PCCharge to #SagePayments without tears.

1. Obtain a Sage Payments merchant account

2. Flip the switch from PC Charge to Sage Payments within Sage 100 ERP by going to Library Master – Main – Company Maintenance – 3. Servers tab.

3. Go to Accounts Receivable – Setup – Payment Type Maintenance

4. Change each of their existing CC payment types:

  • Merchant ID: Terminal ID from their sign up letter
  • Merchant Key: From their sign up letter (NOT same as Merchant ID)
  • Pre-Authorization Term: Change to 7 days

Note: If you do not change the pre-authorization term to 7 days (which matches Sage’s gateway) then you could see “Authorization Expired” messages.

Helpful resources:

Sage Payment Services KB:

http://goo.gl/4j25K

What Versions of Sage 100 ERP Are Supported?

One of the most frequently asked questions we hear from Sage users is whether their version of Sage 100 ERP (formerly Sage ERP MAS 90 or MAS 200) is supported by Sage.

Sage officially supports the current and 3 prior versions.

Since Sage 100 ERP 2013 is the present version they are offering support for:

  • Sage 100 ERP 2013
  • Sage 100 ERP v4.5
  • Sage 100 ERP v4.4
  • Sage 100 ERP v4.3

sage 100 supported versions

 

Enter For Chance To Win Free Sage Summit 2013 Conference And Hotel (Customers Only)

Sage have just posted a contest which is (terms and conditions) open to current or past Sage Software, Inc. or Sage Software Canada, Inc. customers  who are at least 18 years old and residents of the United States (including the District of Columbia) or Canada.

sage summit 2013

 

Enter to win

  • One complimentary customer conference pass to Sage Summit 2013
  • One room at the Gaylord National Resort for three (3) nights to be used between July 22-26, 2013

How To Enter

Watch this video

YouTube Preview Image

Submit your entry – here

 

 

Good Luck!!

 

 

 

Options For Integrated Credit Card Processing In Sage 100 ERP 2013?

Beginning with Sage 100 ERP 2013 the ability to use PC Charge from Verifone as a way to integrate your credit card merchant account of choice to your  Sage 100 ERP has been discontinued. Instead Sage now offers integration to their own Sage Payment Services as the sole available option for integrated credit and other payment processing.

This has caused customers and partners to wonder whether third party options which re-enable credit card integrations to providers other than Sage Payments might be forthcoming.

sage payments

At least one provider of such a solution had announced plans to upgrade their integration to work with Sage 100 ERP 2013.

Sage last night clarified their position on third party credit card integrations to Sage 100 ERP. In short they will not be allowed.

Starting with Sage 100 ERP Sage removed all credit card information from Sage 100 ERP and now stores it in the Sage Vault. From this location Sage can process integrated credit card transactions and does not need to subject each release of their Sage 100 ERP (including product updates) to an expensive PCI audit or review.

If you are using a credit card merchant other than Sage Payments and you wish to have integrated credit card processing in Sage 100 ERP 2013 then you will need to contact Sage Payments to obtain a merchant account through them.

 

via:

LinkedIn

Automatic Settlement Failure: -Action Recommended

If you are using Sage Payments Service (aka SPS) and you’ve received a message similar to:

ALERT!

Automatic Settlement Failure: Tuesday, April 23, 2013-Action Recommended

On Tuesday, April 23, 2013 at approximately 11:00 pm EDT, Sage Payments identified a potential issue with automatic settlement. You may notice that your automatic settlement did not run on Tuesday, April 23, 2013 and you may still have transactions from April 22 and April 23 in your open batch. To prevent any delay in your funding, we recommend that you settle your batch manually.

This apparently is the result of a problem with the automatic batch settlement process at Sage Payments / SPS and it is affecting customers that are using the Virtual Terminal for processing.

The work around is for them to manually settle the batches.

 Auto-Batch Issue Alert!

Note: This message was reportedly received by at least one customer on April 24, 2013. By the time you read this the situation may be resolved but we’ve posted this here just

Understanding The “Use” In “Sales and Use Tax” – Avalara Webinar Tuesday May 14, 2013

Unless you live in one of five states that don’t collect sales tax (for now), chances are sales tax is something you deal with regularly as a consumer. And while there are many intricacies businesses face when collecting sales tax (what rate to charge, when & where to file, etc.), most of us understand the concept in general.

Unlike sales tax, very few of us understand use tax regulations, let alone comply with them. Put simply, use tax (aka consumer use tax) is a sales tax that is collected and remitted by the buyer rather than the seller.

It is estimated that in the 45 states that have sales tax, and therefore also have use tax, only 1.6% of taxpayers actually pay it. While state governments don’t have the bandwidth to hunt down every penny individual consumers didn’t pay on tax-free (but not tax-exempt) online purchases, auditors are not shy about digging into purchase records to find use tax violations when auditing businesses.

There are a variety of scenarios that create use tax liability, and each of these situations, if not handled properly, can expose your organization to audit risk. Attend this webinar to learn how you can reduce your exposure by accurately self-assessing use tax.

Register today!

When: Tuesday May 14, 2013 2:30 pm EDT

Click Here To Register

Sales Tax Reseller Certificates Best Practices – Avalara Webinar May 9, 2013 – 1pm EDT

Avalara is a third party provider of outsource sales tax processing. This service integrates directly to your Sage 100 ERP and correctly computes sales tax based on geographic location and current tax rules and rates. In addition to computational services Avalara can also file your sales tax returns and manage the headache of compiling and updating reseller certifications which you’ve collected from your exempt customers.

avalara sage 100 resale

Join sales tax processing provider Avalara for a reseller certificate best practices for collecting and managing certificates to reduce sales tax audit risk. Ways to improve your processes while keeping cost of collection and amount of time managing certs to a minimum.

 

When: May 9, 2013 – 10:00 am PDT / 1:00 pm EDT

Cost: $ 0

Click here to register for Reseller Certificate Best Practices

Sage Pricing Changes Effective August 1, 2013

Effective August 1, 2013 most list prices are going up 3%. This in turn  means software maintenance pricing rises too  (Watch for this to roll out with renewal invoices generated May 2013 for renewals effective August 1, 2013+).

Concurrent user pricing for Sage CRM goes away  (existing users of concurrent users will stay as-is and can purchase additional concurrent licenses) and Sage CRM  per user licensing is going up from $795 to $ 995.

This is all effective August 1, 2013.

Sage Summit 2013 Agenda Builder Now Available

sage summit agenda builder

Confused about which sessions you should attend at the upcoming Sage Summit 2013 scheduled for July 23-26, 2013 in Washington DC?

Sage have released a handy Sage Summit Agenda Builder PDF which customers can use to map out the sessions which they want to attend as well as the exhibitors to visit.

Once you arrive at the conference things can start to move pretty quickly. A little advance planning helps to be sure that you achieve all your conference goals and return to the office with plenty of information and good ideas.

Sage Summit 2013 Agenda Builder (pdf)

Sage Summit 2013 Sessions In Evernote

sage summit course sessions

If you’re looking for an easy way to take a copy of the Sage Summit 2013 course catalog with you for later review – have a look at our Evernote link below which has the full catalog.

You can view the catalog online or add the note to your own Evernote collection for easy offline viewing.

Sage Summit 2013 Evernote Sessions List

Sage Summit 2013 Registration Now Live

sage summit registration

Registration for Sage Summit, Sage North America’s annual customer and partner conference, is now live.

YouTube Preview Image

The conference will be held July 21-26, 2013 at the Gaylord National Resort and Convention Center in National Harbor just outside Washington DC. Early bird pricing for partners starts at $895 and customers pay $995. The fee includes all sessions, scheduled activities and meals.

For more information visit – Sage Summit 2013 Online

Sage 100 ERP 941 Form Alignment Fix

sage 941 alignment

Sage have just issued a program patch for versions 4.3+ of Sage 100 ERP which corrects an issue some users have encountered trying to print the 2013 IRS form 941.

It appears the original issue relates to the report itself which would resize the fonts incorrectly when the workstation display settings were NOT set to 100% (default).

The two report files which are updated:

PR941A.RPT
PRSCHB.RPT

Depending upon the version of Sage 100 ERP (formerly Sage ERP MAS 90 and MAS 200) you can download the fix from:

Sage 100 ERP 2013 Product Update 2 – download link and instructions
Sage 100 ERP 2013 Product Update 1 – download link and instructions
Sage 100 ERP 4.3 to 4.5 – download link and instructions

Sage 100 ERP (fka MAS90 or MAS200) old knowledgebase is back with a new URL

sage 100 knowledgebase

Sage has an old knowledgebase which is no longer updated with current support topics. However it’s quite useful for looking up older problem reports (and their resolutions).

A few weeks ago this online knowledgebase appeared to be down for the count. An eagle-eyed 90 Minds member just spotted that the Sage 100 ERP old knowledgebase is back albeit at a slightly different URL.

Link:

http://infosource.sagesoftwareonline.com/infasp/search.asp

 

Sage 100 ERP Form 941 Alignment Problem (SOLVED!)

sage 941 alignment

Sage have just released the updated IRS form 941 for 2013 filing. This update is available for users of Sage 100 ERP on v4.30.23 and higher. In order to install the update you’ll need to download the program patch from Sage’s customer or partner site.

Partners can download the Sage 100 ERP form 941 update patch directly from – here (login required)

Why isn’t the form 941 aligning?

In some cases customers have observed that the form is not aligning properly. The cause appears to be that the computer from which they are printing the form has the default system font set to something other than 100%.

How to print  Sage 100 ERP form 941 properly aligned

Please change your computers display (DPI) settings to Smaller – 100%(default).

  1. Go to Control Panel and click Display
  2. Select Smaller-100%(default)
  3. Click Apply

NOTE: This will require a reboot for changes to take affect.

Sage 100 ERP Product Updates for Sage 100 ERP 2013 and 4.5 Now Available

sage 100 erp product updates

Sage have released product updates for Sage 100 ERP 2013 and v4.50.

These updates provide corrections to program issues as well as update the product for the latest payroll 941 forms.

Here’s what’s new in the v2013 PU2 – pdf

Here’s what’s new in the v4.50 – pdf

Sage 100 Product Update Page

Sage 100 ERP 941 Update for 2013 Now Available

sage100 form 941

 

The Sage 100 ERP 941 form update for 2013 is now available for download.

This update works with versions:

4.30.0.18 – 4.30.0.23
4.40.0.0 – 4.40. 0.10
4.50.0.0 – 4.50.5.0 (also included in 4.50.6.0)
5.00.1.0 (also included in 5.00.2.0)

 

Changes include:

 

  • The quarterly tax report variance calculation now includes the additional medicare rate of .9%
  • The employee totals verification report no longer prints a difference when an employee has additional medicare wages or tax.
  • Additional medicare wages field has been added to the quarterly 941 printing screen.
  • In federal eFiling and reporting the correct additional medicare wages populate to the 941 form

 

941 Form 2013 Changes

 

  • Quarterly 941 Printing has been updated for the 2013 IRS changes to the 941 Form (Rev. January 2013). This update has text, line number and calculation changes to the Report Formats, ‘Entire Form’ ‘Pre-Printed’ and ‘Worksheet’.
  • Schedule B has been updated

 

Note: The pre-printed 941 form and pre-printed schedule B formats have been designed based on the downloaded 941.pdf and schedule B pdf from the IRS web site. If you use the pre-printed form formats the alignment may need to be adjusted or the form may need to be modified.

 

Sage 100 ERP 941 Update

Sage 100 ERP Tax Table and 941 Changes Due Week of March 25, 2013

Tax_Table_Update

Sage is advising that a tax table update for Sage 100 ERP versions:

  • 4.4
  • 4.5
  • 2013

Will be available the week of March 25, 2013.

According to their recent email alert the update will include changes for Vermont married withholding tables. It is also expected to include an updated form 941.

Sage 100 ERP Tax Table Update

 

Global Software Inc Now Invoicing Some Business Alerts Customers Directly For Maintenance

global software letter

Have you received an invoice from Global Software Incorporated for your Sage 100 software and are unsure what this is for? The company appears to have recently begun invoicing users of the Business Alerts software directly which is the result of them no longer being the endorsed solution for workflow.

sage business alerts discontinue

Sage ceased re-distributing Global Software’s Business Alerts as of November 1, 2012.

 

global software contact info

Sage Updates Supported Platforms For Sage 100 ERP v4.5 with Windows 8, Windows Server 2012 Compatibility

Sage updated their Supported Platforms Matrix for Sage 100 ERP v4.50  on March 14, 2013 with the addition of Windows 8 (32 and 64-bit) support as well as support for Windows Server 2012 – 64-bit.

spm450march13

According to the recently updated document Windows 8(32 and 64bit)Professional and Enterprise are supported with Sage 100 ERP v4.5. Microsoft C++ 2008 SP1 has to be installed prior to Sage 100 ERP v4.5 Installation.

Supported Platforms

Payroll Checks will print but are not recognized as printed. (Fix)

Sage 100 ERP v2013 payroll checks print but are not recognized by the software as printed.

 

Note this only applies to Sage 100 ERP 2013.

You may not receive the “Remove checks from printer/ Do you want to update” prompt . You may receive “Checks must be printed” in Check/Register Update.

This Issue occurs only on Sage 100 Standard ERP 2013 Workstations.

 

Fix

Sage Summit 2013 Registration Opens April 9, 2013

sage summit 2013

Registration for the annual Sage Summit partner and customer conference is scheduled to open on April 9, 2013. This year’s event will be held July 21-26, 2013 at the Gaylord National Resort and Convention Center just outside Washington DC.

 

The tentative agenda:

 

Sunday July 21, 2013 – Business Partners

8:00 am to 7:00 pm – Registration

1:00 pm to 5:30 pm – Partner product-intensive sessions

3:00 pm to 3:30 pm – Networking break

5:30 pm to 6:30 pm – Expo partner meet and greets

6:30 pm to 9:00 pm – Expo welcome reception

 

Monday July 22, 2013 – Business Partners

7:30 am to 8:30 am – Breakfast

8:30 am to 10:00 am – CEO Business Partner Keynote

10:00 am to 10:30 am – Coffee break

10:30 am to 12:00 pm – Business partner super sessions

12:00 pm to 2:00 pm – Lunch

2:00 pm to 5:30 pm – Business partner breakout sessions

5:30 pm to 7:00 pm – Expo and reception

7:3o pm to 11:00 pm – Business partner party

 

Tuesday July 23, 2013 – Business Partners and Customers

7:30 am to 8:30 am – Breakfast

8:30 am to 12:30 am – Business partner breakout sessions

8:00 am to 3:30 pm – Support center

9:45 am to 11:00 am – Customer welcome with gourmet coffee

10:00 am to 3:00 pm – Expo

11:15 am to 12:30 pm – Customer first timers session

12:00 pm to 2:00 pm – Expo and lunch

2:00 pm to 3:30 pm – Business partner and customer breakout sessions

3:30 pm to 4:00 pm – Refreshment break

4:00 pm to 6:30 pm – Sage City

6:30 pm to 7:30 pm – Customer first timers meet-up

OPEN EVENING

Wednesdy July 24, 2013 - Business Partners and Customers

6:45 am to 8:00 am – National Harbor 5K Fun Run/Walk

7:30 am to 8:30 am – Breakfast

Various times – Partner hosted user meetings

8:00 am to 5:30 pm – Support center

8:30 am to 12:00 pm – Breakout sessions

10:00 am to 10:30 am – Coffee break

12:00 pm to 2:00 pm – Expo and lunch

2:00 pm to 4:45 pm – Breakout session

3:00 pm to 3:45 pm – Expo and refreshment break

5:00 pm to 6:30 pm – Expo reception

7:30 pm to 11:00 pm – Sage Presents: Night at the American History Museum

 

Thursday July 25, 2013 – Business Partners and Customers

7:30 am to 8:30 am – Breakfast

8:30 am to 5:30 pm – Presentation skills workshop/certification

8:00am to 5:30 pm – Support Center

8:30 am to 12:15 pm – Peer 2 peer breakout sessions

10:00 am to 3:00 pm – Expo

10:00 am to 10:45 am – Coffee break in expo

12:00 pm to 2:00 pm – Expo and lunch

2:00 pm – 5:30 pm – Breakout session

OPEN EVENING

Friday July 26, 2013 – Business Partners and Customers

7:30 am to 8:30 am – Breakfast and closing remarks

8:30 am to 12:00 pm – Breakout sessions

10:00 am to 10:30 am – Coffee break

 

 

Sage Summit 2013

 

 

Why I Dropped Unlimited Data For Share Everything

share everything

This month I dropped both my unlimited data plans in favor of a shared data plan on both Verizon (Galaxy Note 2) and ATT (Nokia 920).

What I paid before the plan change and what I pay after is about the same with the exception that the shared data plans allow me to add low data users (such as my Mom) to my contract without buying them a separate data plan (for data they’re likely to not fully consume).

There are some other reasons -

My reasoning:

  • Unless you’re regularly watching video via 3G/4G – you shouldn’t be coming close to going over any type of limit (I rarely went over 1 GB)
  • Shared data plans allow you to add up to 10 people who all share the data
  • Tablets can be added – typically for $10 per month (no contract so you can remove them at any time)
  • The shared plans on Verizon and ATT allow you to use your phone as a WIFI hotspot for NO extra charge. Yes, the data is all charged to your account but as someone who does not use that much data I find it VERY handy to be able to sometimes use my phone as a hotspot without having to pay $20-$30 extra per month for a separate plan.
  • The shared data plans also offer unlimited phone/text
  • With my ATT plan the cost was really close to the same as my shared data (4 GB) which is about $110/mo + fees.
  • LTE speeds on Verizon and ATT are now well over the speed of my home Internet (again YMMV for those who are blessed with fiber). Using these phones as a wifi hotspot is now very reliable and fast. Definitely a plus if you bring your laptop to a customer site.
  • Most of the “unlimited” plans have some type of soft cap in place where they have the right to throttle you somewhere in the 5 GB range. This doesn’t always happen but don’t fool yourself into thinking that unlimited means unlimited. There are lots of gotchas which mean you are probably not going to be tethering your unlimited plan phone from home and using 20 GB streaming HULU.

How To Allocate Sales Tax To Inventory Purchases In Sage 100 ERP

In some instances you may find that you would like to record the sales tax paid on your inventory purchases as part of the cost of inventory (consult your tax advisor on whether this applies to you).

Here’s how to do it in Sage 100 ERP fka MAS90 or MAS200:

  1. Open Library Master / Common and select Sales Tax Code Maintenance.
  2. Review the warning message and click ‘OK’.
  3. Select the desired Tax Code from the lookup or enter a new code if needed.
  4. Select the checkbox next to ‘Expense to Vendor/Item’.
  5. Select the Line for tax class TX.
  6. Make sure the ‘Purchases’ ox is checked.
  7. Confirm that the ‘Tax Rate’ is greater than 0.00.
  8. Set the Non-Recoverable % to 100.00%
  9. Click ‘OK’
  10. Accept
  11. Repeat for all tax codes needed.

How To Use Evernote To Share Sage 100 ERP Technical Information With Your Team

If you’re frustrated by the login process of the Sage portal and need to send a link to technical info that is behind “the wall”  (aka – requires a login) and you don’t want to become the Sage customer service rep for “how do I login” or “I forgot my password”  type questions – here’s a great solution which uses the popular note taking service called Evernote to share out technical content with your team and in most cases will avoid having to create a login..

evernote

a. If you’re not already using Evernote – start. You should use the paid solution ($45/year though free will work in most cases).

http://www.evernote.com/

 

PS – Yea I know they got hacked.

b. Download the Evernote extension which lets you capture web pages

http://goo.gl/n3h7N

 

c. Login to the Sage Portal

d. Capture the pages which don’t require further login (use the Evernote extension) once you are past the “front gate” — one example is the Supported Platforms matrix.

e. Share this page directly with your customer or IT consultant who is asking for it.

Here’s what they’ll see:

 

supported platforms sage100

 

Here’s what the Evernote share looks like.

Note that you can click through most of the links without being logged into Sage Atlas (at least you can for the links I tried).

Not all Sage pages allow you to click through without login - but you’ll be pleasantly surprised that many allow it once you’re “past the gate”

https://www.evernote.com/shard/s1/sh/c95c0c7c-1c1f-4852-b92c-b14ed6d2c636/a744ffec89b2847f0bdcfdbca9fc88b2

 

G/L Summary Drill Down Doesn’t Convert Properly when Migrated from Sage 100 ERP v4.50

I just spotted this problem report on the Sage knowledgebase. It’s not yet posted with the main program patches and unfortunately I don’t have a lot of information about what it fixes other than it seems like something you’d want to download and apply during your v2013 upgrade.

 

G/L Summary Drill Down Doesn’t Convert Properly when Migrated from 4.50

Link

 

glfix

Sage 100 ERP 2013 Accounts Receivable Finance Charges Mis-Calculate – Fixed

Users of Sage 100 ERP 2013 (earlier versions not impacted) may notice that their finance charges are incorrectly computed based upon the total of all invoices instead of those with a balance showing as due.

financecharges2013

 

Sage have issued a program patch which you may download and need to apply from your Sage 100 ERP 2013 server.

Important: This issue only applies to those users on Sage 100 ERP 2013.

 

Sage 100 ERP Accounts Receivable Finance Charge Fix

 

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

Unable to Update Payroll Check Register – Workaround

Unable to update PR check Register, is caused by a Sage 100 ‘Standard” workstation installation issue.

 

payroll check

3 of the Crystal Run Time DLL’s are being installed into an incorrect directory. ‘Standard’ workstation only, The fiull Standard install and Advanced workstation are correct..

Temporary Work Around
64 Bit Sage 100 Workstation
Copy
C:\Program Files (x86)\Business Objects\Common\3.5\Bin\U2LMAS90.DLL
C:\Program Files (x86)\Business Objects\Common\3.5\Bin\U25STORE.DLL
C:\Program Files (x86)\Business Objects\Common\3.5\Bin\U25TOTAL.DLL

To
C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86

32 Bit Sage 100 Workstation
Copy
C:\Program Files\Business Objects\Common\3.5\Bin\U2LMAS90.DLL
C:\Program Files\Business Objects\Common\3.5\Bin\U25STORE.DLL
C:\Program Files\Business Objects\Common\3.5\Bin\U25TOTAL.DLL
To
C:\Program Files\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86

We are working on a program correction it will be available soon.

MICR Fonts

Adobe Open Type MICR Fonts do not properly print with Sage 100 2013. The 2013 (5.0) Crystal Runtime .NET engine will only render True Type MICR Fonts. The font we used for testing/validation is http://www.micrfonts.com/index.htm

This is not a Recommendation – any True Type MICR font should work properly.

Sage Fixed Assets 2013.1 Available For Download

sage fixed assets 2013.1

Users of Sage Fixed Assets may download version 2013.1 from Sage’s online portal.

This new update includes provisions for meeting The American Taxpayer Relief Act of 2012 which was enacted in January 2013 and extends many expired (or about to expire) fixed asset related tax provisions.

sage fixed assets changes

The latest edition of Sage Fixed Assets incorporates detailed modifications to ensure you are aware of all current exemptions and deductions for which your organization may qualify. With this new version, you can quickly identify assets that may be eligible for extra depreciation under recently enacted tax laws.
The Audit Advisor in Sage Fixed Assets is now updated to run queries for your previously claimed assets and ascertain if they qualify for the 2012 extended or retroactive provisions, including those under Section 179 such as:

 

  • An extension of increased expensing limitation for Section 179 property to the 2011 $500,000 annual limit and the $2 million threshold limit.
  • An extension of eligibility to expense qualifying leasehold improvements, restaurant property, and retail improvement property up to $250,000.
  • An extension of expensing for off-the-shelf computer software.
  • An extension for the designation of an empowerment zone and expensing an additional $35,000 (or the cost of the qualifying property, if less).

Audit Advisor also checks your assets against other important provisions in the American Taxpayer Relief Act of 2012 to see if they qualify for
(among others):

 

  • A one-year extension of 50% bonus depreciation for qualifying property and equipment.
  • A one-year extension of $8,000 luxury vehicle deprecation for vehicles placed in service in 2013, including passenger automobiles, light duty trucks, and vans.

sage american taxpayer relief act 2012

Download Sage Fixed Assets 2013.1 

Sage Promotions Q2 2013 for Sage 100 ERP, Sage ERP X3

sage promotions

Sage released their first and second quarter price promotions for Sage 100 ERP, Sage ERP X3, Sage 300 ERP, Sage 500 ERP and Sage CRM.

Highlights include:

  • Sage Intelligence Reporting – Connector and Report Designer bundle
  • 0% Financing on Sage ERP, CRM and HRMS through March 31, 2013
  • In the Family Offer – migrations from one Sage product to another
  • Sage Trade-in Offer
  • Off-Plan Sage customers
  • Installed based subscription at 30% off first two years
  • Sage Payment Solutions
  • More

 

Read the full promotions list via our private Evernote notebook – here

 

Sage Pro ERP and Sage PFW ERP Product Retirement and Migration

sage pro pfw

 

In case you haven’t heard – Sage Pro ERP and Sage PFW ERP customers have until March 2014 to migrate to a new Sage product. Support for both of these products will cease as of that date and future upgrades and support will either be non-existent or very scarce.

From the Sage Pro ERP and Sage PFW ERP Frequently Asked Questions:

Software is retired for a variety of reasons. These reasons include lack of continued support by outside suppliers, as well as the obsolescence of the technology and level of functionality offered by the product.

In the case of Sage Pro and Sage PFW, we have seen many of our customers migrate to different Sage solutions to take advantage of the advanced functionality that these solutions offer. Sage 100, Sage 300, and Sage ERP X3 have deep
functionality already built in, interface with Sage Connected Services and Sage Common Solutions, and are supported by an eco-system of independent software vendors providing applications for virtually every business need.
We believe that products such as Sage 100, Sage 300, and Sage ERP X3 are better suited to fulfill our customer’s business needs, especially for those customers who are in the services industry, wholesale distribution, or manufacturing. Take a look at the portfolio of strategic Sage solutions and you will be amazed what they can do.

Read More

Quicker Way To Find When A New Feature Was Added To Sage 100 ERP

sage search

Have you ever had the unpleasant task of trying to figure out when a particular feature was added to Sage 100 ERP (formerly MAS 90 or MAS 200) ?

If so you’ve probably discovered that this link takes you to a “What’s New” site with individual URLS that can take hours to explore fully.

Instead of spending all day browsing (and backing up from links that don’t provide the answer) you can use a Google search command to narrow your search to only the documents on Sage’s “What’s New” site.

 

Here’s how.

 

First, navigate to Google search – http://www.google.com

Now in the search box type in SITE:services.sagesoftwareinc.com/mas/whatsnew/ followed by your search term. I’ve used quotes so that I’m returned only results where my keywords appear exactly as queried.

Your Google Search Box should contain:

SITE:services.sagesoftwareinc.com/mas/whatsnew/ ”job status”

Will yield only results from the site you specify matching the keywords:

search results sage100

 

Note: I have received different results when I put the keyword both in front of the Site: xxxx and at the end. You may find that your search works well based on placing the keyword either before or after the “Site:xxx” portion.

 

You can always use Google Advanced search which will guide you through every parameter:

Google Advanced Search

 

 

 

 

 

 

 

Which Sage FAS Fixed Assets Is Right For You?

Sage Fixed Assets Grid

Sage offers several varieties of fixed asset accounting software. Their three main choices are: Sage FAS 50 Fixed Assets, Sage FAS 100 Fixed Assets, and Sage FAS 500 Fixed Assets.

Do you know which variety is best for your company?

Generally the first qualifier may be the numbers of assets you need to depreciate. Sage FAS 50 Fixed Assets supports up to 1,000 assets, Sage FAS 100 Fixed Assets supports up to 10,000 and Sage FAS 500 Fixed Assets is appropriate for 10,000+ fixed assets.

Another important differentiator is that the Sage FAS 50 Fixed Assets will only work for singer user (non-network) environments – while Sage FAS 100 and 500 both work in Single Users/Multi-User or Client/Server (Sage FAS 500).

For more details download Which Sage FAS is Right For You?

Sage ERP X3 Live In 6 Weeks For RM Foods

RM Foods is a nearly 50-year-old food and beverage manufacturer and distributor. They recently replaced their accounting system with Sage’s ERP X3. What’s amazing is the implementation time was only 6 weeks from start to finish.

Our old system made even routine tasks cumbersome, so it was easier to outsource them,” said Michael Siegmund, president of RM Foods. “We hired a consulting team to help us evaluate our options, and Sage ERP X3 came out the winner. Sage ERP X3 has a clean intuitive interface, a solid reputation in the process manufacturing industry and is backed by a strong and reputable company

 

YouTube Preview Image

 

Sage

Sage 100 ERP News, Tips & Insights – February 2013

sage 100 feb2013

The February 2013 issue of our Sage 100 ERP (formerly Sage ERP MAS 90 and 200) newsletter is available for download.

In this issue:

  • Sage 100 ERP 2013 New Features: Increase productivity and workflow
  • CRM For The Entire Organization
  • Sage CRM Tips and Tricks
  • DSD Business Systems Office Locations

Link: Sage 100 ERP News, Tips & Insights – February 2013

FRX Replacement Options For Sage 100 ERP: RenovoFYI

renovoFYI

Sage 100 ERP 2013 was released during December 2012 and marks the last release for which Sage have indicated the popular FRX Financial Report Writer will be guaranteed to interact with your Sage 100 ERP financial data.

You may recall that Microsoft owned FRX and made a decision to stop development and sales of the product with the final support cutoff date being December 2012. While most users of FRX continue to use the product without interruption – there is no guarantee that a future release of Sage 100 ERP will remain compatible with FRX.

For this reason I think it’s time for FRX users to start researching the top alternatives and prepare to migrate your financial reporting.

The easiest and least costly way to migrate your data would be to begin using the standard financial statements included with Sage 100 ERP General Ledger. If you can make use of these “canned” statements then you can bypass any additional expenditure of time and money.

Realizing that most companies may not want to step back to less capable financial reporting – one other alternative is RenovoFYI.

RenovoFYI claims that they can convert FRX data (pricing starts at $800) with about a 90% accuracy rate. Their licensing for a single user version starts at $2,000 (one user / one data company) with a two user / ten data company version starting at $ 5,500.

Ongoing software maintenance is 20% for silver support and is added to the above costs and invoiced annually thereafter by RenovoFYI.

The company will take your FRX data (rows, columns, trees) and convert them and return the data to you. They also can install and train on RenovoFYI remotely for an added cost.

The program runs in a web browser and requires a SQL database (SQL Express supported).

Here’s a quick overview of the look and feel of RenovoFYI

YouTube Preview Image

Reminder: Sage Symposium Coming To A City Near You Through May 2013

sage symposium testimonial

Sage’s Symposium road show has already visited two cities (Houston, TX and Atlanta, GA) and their are 8 more cities to go. The feedback about this Sage educational session has been very positive from both customers and Sage partners.

 

[Read more...]

bly:Mobile Lite for Sage 100 ERP

blymobile ipad

Wish there were a way to run Sage 100 ERP on your iPad, iPhone or Android devices? You can use a remote desktop (RDP) connection but the screens often are too tiny to comfortably maneuver. Or the other alternative is bly:Mobile which resizes the Sage 100 ERP screens so they fit comfortably to your mobile device(s).

From the bly:Mobile site:

bly:Mobile Lite puts Sage 100 on your Smartphone, iPad, or across a web browser, with a new, simpler look and feel, more like the other mobile apps you are used to. No printing, no complicated navigation – just data, clean and simple. It’s available for Sage 100 4.4 and higher.

bly:Mobile Lite provides JUST the following inquiry capabilities:

  • GL Account Inquiry
  • AR Customer Inquiry
  • AR Invoice History Inquiry
  • AP Vendor Inquiry
  • AP Invoice History Inquiry
  • AP Payment History Inquiry
  • IM Item Inquiry
  • IM Lot/Serial Inquiry
  • SO Sales Order Inquiry
  • SO Sales Order/Quote History Inquiry
  • PO Purchase Order Inquiry
  • PO Receipt History Inquiry
  • RMA Inquiry

Best of all, bly:Mobile Lite is offered at a great subscription price – $99 per user per year.

 

Additional versions of bly:Mobile allow for full data entry capabilities within Sage 100 ERP

 

bly:Mobile Lite

 

Sage Symposium Kicks Off Today in Atlanta

sage symposium atlanta Today, April 17, 2013, is the day Sage travels to Atlanta Georgia with their Symposium series. Sage executives and product insiders will be on hand to share their vision, discuss trends, and answer your questions about product roadmaps.

[Read more...]

How To Install Sage 100 ERP to Windows 8

windows 8

Although the adoption rate has been low there are some users with Windows 8 computers who’ve been asking whether it’s possible to install Sage 100 ERP to Windows 8.

Here’s how.

How to install Sage 100 Standard on Windows 8

 

  1. Browse to the …mas90\wksetup\ folder through the mapped drive for the Sage 100 share (i.e. M:\….\mas90\wksetup).
  2. Right-click ‘Autorun.exe’ or ‘Sage 100 ERP 2013 Workstation’ and select ‘Run as administrator.’
  3. Click ‘Yes’, if presented with the User Account Control dialog box. NOTE: Skip to step 5 if you choose ‘Sage 100 ERP 2013 Workstation’ in Step 2.
  4. Click ‘Install Sage 100 ERP 2013 Workstation’
  5. Click ‘Next’ and follow Installation Wizard to complete installation.

How to install Sage 100 Advanced and Premium on Windows 8

 

  1. Browse to the …mas90\wksetup\ folder using the unc path to the Sage 100 share (i.e. \\servername\share\…\mas90\wksetup\).
  2. Right-click ‘Autorun.exe’ or ‘Sage 100 ERP 2013 Workstation’ and select Run as administrator.
  3. Click ‘Yes’, if presented with a User Account Control dialog box. NOTE: Skip to step 5 if you choose ‘Sage 100 ERP 2013 Workstation’ in Step 2.
  4. Click ‘Install Sage 100 ERP 2013 Workstation’
  5. Follow Installation Wizard to complete installation.

How to configure Sage 100 on Windows 8 (setup to ‘Run as Administrator’)

  1. Open Windows 8 Start Screen.
  2. Right-click the ‘Sage 100 ERP 2013′ icon.
  3. Click ‘Open file location’ from the Options list at the bottom of the screen.
  4. Right-click the ‘Sage 100 ERP 2013’ shortcut and select ‘Properties.’
  5. Click the ‘Compatibility’ tab.
  6. Check the checkbox Run this program as an administrator. Note: If multiple users use this workstation select ‘Change Setting for all users’ and
  7. Check the ‘Run this program as an administrator’ checkbox.
  8. Click OK to save changes

According to Sage’s Supported Platforms Matrix for Sage 100 ERP 2013 Standard (12/14/12) – Windows 8 is officially supported for that level provided it meets the requirements outlined in that document. Older versions may or may not work and we’ve yet to notice the older supported platforms indicate compatibility with Windows 8 for any level earlier than Sage 100 ERP 2013.

MAPADOC EDI Embraces Sage 100 ERP 2013 Visual Process Flows

mapadocEDI

Visual Process Flows are a new feature in Sage 100 ERP 2013 which was released in December 2012. This graphical menu system allows companies to simplify the Sage 100 ERP menu structures and reduce learning times for new employees by placing the most commonly used tasks into graphical menus. Process flows may also be exported and imported for easy sharing between Sage 100 ERP systems.

EDI developer SWK Technologies have just released a MAPADOC update which includes several Visual Process Flows which integrated directly into the latest Sage 100 ERP 2013 release.

 

Visual Process Flow for EDI Orders

The EDI Orders visual process flow is an interactive workflow diagram that shows the steps to complete for processing inbound EDI purchase orders.  All of the MAPADOC tasks to process purchase orders are show as well as links to Sales Order Data Entry, Sales Order Printing, and Picking Sheet Printing.  This visual process flow also contains links to all of the reports related to incoming purchase orders and links to the MAPADOC cross reference setup tasks that may be needed during processing.

mapadoc edi orders flow

 

Visual Process Flow for EDI Invoices

The EDI Invoices visual process flow is an interactive workflow diagram that shows the steps to complete for sending outbound EDI invoices. All of the MAPADOC tasks to process invoices are show as well as links to AR Invoice History Inquiry and Invoice History UDF Maintenance. This visual process flow also contains links to all of the reports related to outgoing invoices and links to the MAPADOC cross reference setup tasks that may be needed during processing.

mapadoc EDI Invoices flow

 

 Visual Process Flow for EDI ASNs

The EDI ASNs visual process flow is an interactive workflow diagram that shows the steps to complete for capturing ASN packaging information, printing labels, and sending outbound EDI advanced ship notices (ASNs).  All of the MAPADOC tasks to process labels and ASNs are show as well as a link to ASN History.  This visual process flow also contains links to all of the reports related to outgoing ASNs and links to the MAPADOC cross reference setup tasks that may be needed during processing.

mapadoc EDI ASN flow

 

For more information – see MAPADOC EDI

Fixed Asset Management Outsourcing

sage fixed assets

Tired of compiling data about your fixed assets? The data entry, depreciation and routine reconciliations required can take away valuable time that your accounting staff coule be spending elsewhere.

One option is to outsource the handling of fixed asset upkeep and depreciation to a specialized firm such as Fixed Asset Consulting.

They take your fixed assets and provide:

  1. Data Conversion – clean up and organize your asset listings
  2. Depreciation – calculate depreciation schedules and fixed asset registers
  3. Reporting – book, state, tax depreciation reports – plus everything you need for property tax reporting
  4. Reconciliation and updating – journal entries for depreciation and reconciliation back to your financials
  5. Year-end support – all the forms and reports you need for the annual audit or tax return – including form 4562, roll forward of assets, and other supporting documentation needed for tax purposes
  6. Ongoing maintenance – additions of new fixed assets and disposals

Fixed Asset Management Plans

  • Lite – Less than 1,000 assets
  • Standard – Less than 5,000 assets
  • Premier – Between 5,000 and 15,000 assets
  • Executive – More than 15,000 assets

More information - Fixed-Asset-Outsourcing-Services-2012FAQ

 

 

How To Reprint The Data From A Sage 100 ERP Accounts Payable Check Stub?

check

Have you ever printed an accounts payable check and for whatever reason the detail on the stub which shows the invoices paid is missing?

When printing accounts payable checks there is a field labeled “Stub Lines”

I have seen instances where setting this number TOO HIGH can cause a check to print with incomplete/partial invoice listings.

The resolution is generally to reduce the Stub Lines number to be the actual # of lines that can fit on that check. Also, remember that both stubs of the check may have different amounts of space for invoice listing depending upon whether customization’s have made to your check layout. In those cases select the # of lines which is the SMALLEST # which fits on either of the stub in order to prevent losing invoice details.

Unfortunately re-printing check stubs is not possible however you may wish to use the Payments History Report from the Accounts Payable – Reports menu or the Trial Balance report on the same menu. Both of these standard Sage 100 ERP (fka MAS90 or MAS200) reports will show the check invoice detail.

National Accounts for Sage 100 ERP : Overview

sage national accounts

First introduced in Sage ERP MAS 90 version 4.5 the National Accounts feature streamlines how you manage your customers who have corporate and branch accounts utilizing powerful National Accounts features. Efficiently track and bill the parent company for goods and services you sell and provide to the branch—while still keeping a unique customer account for each entity.

With National Accounts in Sage 100 ERP there’s no more manual tracking of invoices between branch office and parent. The relationship between the different offices is all tracked within the customer maintenance file within accounts receivable. The less manual processing = the less possibility of mis-billing.

Sage 100 ERP National Accounts

Sage 100 ERP (fka MAS90 + MAS200) File Layouts – v3.70 to 4.3

sage mas90 file layout

The Sage 100 ERP (fka MAS90 or MAS200) file layouts are available online in either PDF or help file format. Beginning with version 4.4 you should look for the file layouts within your Sage 100 (fka MAS90 or MAS200) program by going to Tasks – Resources – File Layouts.

Sage 100 ERP (fka MAS90 or MAS200) File Layouts v3.70 to 4.30

4 Easy Steps To Update Your Sage 100 (MAS90) Payroll Tax Tables 2013

easy mas90 taxes

Here’s a quick reminder of how you can download the updated payroll tax tables for Sage 100 ERP (fka MAS90 and MAS200). The tax tables are only available online. Sage does not send out disks/CD materials any longer.

Luckily the process is very simple. Before you begin have everyone exit your Sage 100 ERP system (expect the process to take 15 to 30 minutes depending upon computer speed).

On December 17, 2012 Sage updated the payroll tax tables for Sage 100 ERP 2013. This update works on versions 4.30.0.23 and higher and contains the latest released income tax schedules from the federal and state governments. Be aware that late breaking tax news ofte requires that these tables are issued multiple times for updated legislation. Be sure to check with your Sage partner or tax advisor for advice on when to update the tables.

 

  1. Login to your Sage customer portal here.  Sage partners login here. Then proceed to step 2
  2. Click this link to download the IRD for 2012 (required for .9% Medicare Surcharge in 2013) – version 4.30.18+ only. Older versions of Sage 100 ERP must upgrade in order to use the IRD (Interim Release Disk).
  3. Click this link to download the latest IRS payroll tax tables.
  4. Now install the IRD first, then the tax tables. You’ll click each of the files you downloaded and the actual install programs will be unzipped into a separate folder. Navigate into those folders to perform the IRD and then the tax table install. I like to use \MAS90\CONSULTANT\DOWNLOADS to store various Sage related downloads but you can put them anywhere you like.

 

Reminder: If you’re printing W2 forms in 2013 after you’ve closed your 2012 payroll year – you will need to reset your Social Security limits to the 2012 levels only while printing the W2. Once printed be sure to change the limits back to 2013 levels.

Reminder: Beginning with next year all form printing (W2, 941, 1099) happens through Sage Aatrix – eFiling. This is a free included component of Sage 100 ERP though it must be separately loaded to your local workstation(s) in order to work. Contact your Sage partner for assistance.  If you are using Sage 100 ERP 2013 and cannot find your form printing menu – see this post Where Are W2 Form Printing, Quarterly 941 Printing or 1099 Form Printing In Sage 100 ERP 2013?

 

IRS Percent Method Withholding Tables for 2013 (Notice 1036)

irs1036

As of January 1, 2013 the IRS have not yet released Publication 15 – Employer’s Tax Guide. This booklet typically includes the tax withholding rules as well as percent method withholding tables some use to update their computer withholding.

In the interim the IRS have released Notice 1036 which includes the social security limits and rate as well as percent method withholding that is presently in effect as of 1/1/13. Important: These rates may change as the government votes on pending tax legislation so be sure to check back with the IRS and update any rates as required.

IRS Notice 1036: Early Release Copies of Percent Tables for Income Tax Withholding for 2013 and IRS

IRS Frequently Downloaded Forms and Publications – 2013

With the government appearing to reach agreement on taxes for 2013 there should soon be an updated set of tax guides for use by employers in the new year. Publication 15 is the usual guide that companies use for their payroll withholding lookups and verification of employment rules throughout the year. Because of the uncertainty around the 2013 tax status many of these guides have not been updated (yet) for the coming year.

Check back at the link below as the updated tables should arrive soon in January 2013

 

IRS Frequently Downloaded Forms and Publications

CT Employer’s Tax Guide Circular CT – 2013

ct circular ct 2013

The State of Connecticut have just released their withholding tax guide for the year 2013. This booklet provides information on the amounts to withhold from CT employee payroll, a comprehensive frequently asked questions (FAQ) section as well as contact phone numbers for questions.

State of CT Tax Guide – Circular CT 2013

Additional CT Employment Forms

 

CT – W4 – 2013 – Employee’s Withholding Certificate

CT-941 -2013 – Connecticut Quarterly Reconciliation of Withholding

CT-W3 -2013-  Connecticut Annual Reconciliation of Withholding

Closing The Payroll Year in Sage 100 ERP (Reminders)

closed

It’s that time of year when companies using the Sage 100 ERP payroll module go through the routine of closing out their payroll year. The (somewhat) tricky part of closing payroll is that you must print your W2 forms prior to updating Sage 100 ERP tax tables and beginning a new payroll year.

What most users have found works well for them is to create a separate newly created backup company within Sage 100 ERP (fka MAS90 or MAS200) and copy their  live company to the backup company (here’s how).

Once the data is copied you can close the live company and load tax tables and IRD (where required) for processing in 2013.

When ready to print the W2 forms simply use the backup company code created above (remember that in most cases you must first restore any changed FICA/Medicare limits).

Closing Sage 100 ERP Payroll Year End

 

Sage 100 ERP 2013 Payroll and Tax Form Printing Tip

Sage-Install-eFile-300x199

Beginning with Sage 100 ERP 2013 (fka MAS90 or MAS200) printing for W2, 941 and 1099 tax forms is hidden with Sage suggesting that you use the eFiling which is included with Sage 100 ERP 2013.

If instead of using the included Aatrix Federal and State eFiling and Reporting (which BTW works very well and allows quite nice after-the-fact edits before printing forms) you wish to print the forms the “old fashioned” way from within Sage 100 ERP 2013 – you simply need to follow these instructions to unhide the tax form printing.

 

New installations of Sage 100 ERP will not have the 3 menu tasks listed. To enable these tasks, from the toolbar menu click File > Run and type the utility name *unhidetaxforms.

unhidetaxforms

When these menu options are unhidden, these installations will get the same warning message to say that ‘starting in 2014…no longer supported’.

Note: After the 2013 Tax Filing Year, Sage will no longer be providing W-2, 1099 and 941 form changes in the standard Sage 100 product. You will be able to use eFiling and Reporting feature, which allows you to either print W-2, 1099 and 941 forms directly to your printer and/or eFile directly to applicable tax agency through Aatrix.

 

via: Sage 100 ERP – 2012 Year End Frequently Asked Questions

 

Sage 100 ERP Electronic Filing

mas forms

Did you know that your Sage 100 ERP accounting software has the capability to submit electronic documents (W2, 1099, W3 – and more) directly from data already contained within your system?

The menu option for Federal eFiling and Reporting is found under Payroll Period End.

mas menu

No more worrying about:

  • Proper mailing addresses
  • Specific Federal and State due dates
  • Determining which filing format is required (MMREF, Magnetic Media, CD, ISCESA, FSET, etc)
  • Electronic filing requirements for Federal and State agencies
  • Reconciliation forms (may need to be mailed or uploaded to a different address or agency, included in electronic format, different due dates).
  • Uploading to website issues (location, method, file format)
  • Error handling of malformed electronic files
  • Lost filings in the mail
  • Fines for late filings (when submitted timely)

Comprehensive W-2 eFiling Includes:

  • Complete W-2 filing service including Employee mailing
  • Web hosted W-2s
  • Fed Filing and ALL State filing as well as many local filings
  • Fed, State and Local only filing service

For cost and additional information see Sage 100 ERP eFile Packages

Starship for Sage 100 ERP (fka MAS90) Upgrade Tip

Just a quick reminder for anyone using Starship shipping integrated with Sage 100 ERP (fka MAS90 or MAS200). If you have not upgraded in a few versions and are still on the Sage Starship Link then you will definitely need to get in touch with V-Technologies BEFORE you do any upgrades since the Starship Link will come off the menu (because Sage no longer provides the software).

Instead V-Technologies has to activate the link as part of your customer’s separate maintenance plan with V-Technologies.

This is a pretty easy thing to setup but you need to do it in advance if you do not want to be fielding calls from shipping about where their link went and why they can’t ship all the packages that backed up while you were upgrading.

More detailed instructions on the Starship Link process

Simplifying The New Medical Device Excise Tax (MDET)

Tax laws, boundaries and rates are always in flux, making it nearly impossible for businesses to ensure compliance. For medical device manufacturers and importers, a new law going into effect at the beginning of the New Year will make the calculation and remittance process even more complex and time consuming.

Passed as part of the 2010 Affordable Care Act, the Medical Device Excise Tax (MDET) includes significant tax reporting changes for manufacturers of medical devices. The law, which goes into effect on January 1, 2013, requires medical device manufacturers and importers to pay a 2.3% excise tax on the sale of certain medical devices after December 31, 2012.

avataxThe definition and taxability of medical devices lies heavily on the Food and Drug Administration’s definitions of a taxable device. Certain items are exempt from the tax, such as eyeglasses, contact lenses and hearing aids. There is also a retail exemption on items purchased at retail for individual use. See the safe harbor provision in §48.4191-2(b)(2)(iii) of the regulation for more information. Additionally, there is an exemption for installment sales of medical devices entered into before March 30, 2010. There are some instances which allow medical devices to be sold tax-free, however both parties in the sale must be registered with the IRS, see Form 637.

The medical excise tax will be reported like other excise taxes on Form 720, which is filed quarterly. The first return will be due on April 30, 2013. Semi-monthly deposits will be required if the tax liability exceeds $2,500 for the quarter, timing for these deposits are dependent on whether the taxpayer has elected to make deposits using the Regular Alternative method . Generally these deposits must equal 95% of the liability for the semi-monthly reporting period.

While the additional cost of the excise tax for many small to mid-sized businesses may be difficult to handle, the penalties for non-compliance are severe. Notice 2012-77 provides transition relief during the first three quarters of 2013 from failure to deposit, assuming a manufacturer makes an effort to make deposits on time. After that, manufacturers who fail to comply with filing and payment requirements may be subject to penalties and interest.

Training your staff to adhere to these changes in excise tax reporting is costly and error prone and takes away time that could be better spent focusing on your business. Avalara’s AvaTax simplifies your tax compliance process. AvaTax Calc will allow you to calculate medical device taxes and generate a report to assist with deposit calculations and completion of Form 720. In response to the changes in medical device excise tax, Avalara added two new entity/use codes specifically for medical devices to be used in combination with a tax code to support proper tax calculation.

Avalara’s cloud-based sales tax management solution works with your existing tax procedures to help you stay one step ahead of any tax rate changes. In addition to managing your medical device excise tax, AvaTax can help with sales tax calculations, filing and remittance and also exemption certificates. To learn more about the benefits of sales tax automation, watch a five minute video: “Sales Tax Automation: The Time Is Now”

The above is a guest post from Avalara who provide sales tax processing services which integrate directly to Sage (Also 150+ connectors. From ecommerce to ERP, accounting to mobile. And an API for everything else.) accounting systems and relieve companies of the burden of sales tax compliance. The concepts presented above are intentionally broad in nature and not mean to provide tax or accounting advice related to your specific situation. Please consult with your tax advisor – we take no responsibility for errors or misinterpretation of the concepts above.

Sage 100 ERP Support And Technical Links

sage 100 support

I’ve just completed a listing of helpful Sage 100 ERP (formerly Sage ERP MAS 90 and MAS 200) links which take you directly to the latest release disks (needed for upgrading) as well as administrator and user guides.

Links include:

Sage 100 ERP Tax Table Update

Sage 100 ERP 941 Form Changes

Sage 100 ERP v2013 Download Site

Sage 100 ERP Online Documentation

Sage 100 ERP Supported Platforms

Sage 100 ERP Integrated Solutions Compatibility

Sage 100 ERP Product Updates

Sage 100 ERP Road Ahead

Sage 100 ERP 2013 New Features

And more.

 

Sage 100 ERP Helpful Support Links

Sage 100 2013 Credit Card Processing Conversion – FAQ

sage credit card processing

Beginning with Sage 100 ERP 2013 (released December 2012) any user with stored credit card information will have all credit card data moved to the Sage Exchange Vault.

To provide a PCI-compliant method for securely storing credit card numbers and also eliminate the need for Sage to undergo extensive PA-DSS compliance audits – Sage 100 ERP 2013 no longer stores customer credit card numbers within the ERP database. Instead, sensitive credit card information will be stored in the integrated Sage Exchange Vault as part of the Sage Exchange connected service.

Sage 100 ERP customers who are currently storing ANY credit card information within their Sage 100 ERP system (whether integrated or not) will need to either convert their credit card data or purge it before starting to use Sage 100 ERP 2013.

This is applicable for all customers that are storing any credit card data within the software whether it is integrated with Sage Payment Solutions, PC Charge Payment Server or even if they are processing credit card transactions outside of Sage 100 ERP. If you do not store credit card numbers at all within Sage 100 ERP you will not need to undergo credit card data conversion.

For more information and answers to other common question – Sage 100 ERP 2013 Credit Card Processing Conversion Frequently Asked Question (pdf)

Additional Helpful Sage 100 ERP 2013 Links

What Does Sage Business Care Support Include?

sage business care

Included with Sage 100 ERP Silver Support – which is the lowest level of support you can enroll in with Sage – are 5 calls to their technical support department. These calls, as defined by Sage here, are primarily for troubleshooting and explanation of confusing procedures.

Customers enrolled in Silver Support for their Sage 100 ERP (formerly MAS90 and MAS200) also have access to the online knowledgebase where they can lookup answers to technical questions and error messages.

sage business care silver gold

For a more detailed explanation of the types of services included by Sage – see this summary of Sage Business Care Support Services

 

 

Where Can I Download Sage 100 ERP (fka MAS90 or MAS200) version 2013?

Sage has just turned on their landing page for the new release of Sage 100 ERP 2013.

This release of Sage 100 ERP 2013 is available entirely by download. There are no disks sent by mail.  Luckily the process for downloading the 2.29 GB  file is very simple (see instructions below) and takes under an hour (depending upon your connection speed).

Once downloaded you will have a single self-extracting EXE file which when clicked creates a folder holding the entire installation disk (including Crystal Reports). Separate downloads are needed if you use Sage CRM or Sage Intelligence reporting.

Once downloaded you can install your upgrade (we strongly recommend consulting your Sage business partner first) from the source files on your server.

Schulz Consulting / DSD Business Systems customers should not worry about downloading the file as we’ve already secured copies and will transfer this file (as well as all other files needed to upgrade) onto your servers via the use of Dropbox which will synchronize the files overnight for you.

This update introduces several enhancements to Sage 100 ERP (fka MAS90 and MAS200)

  • Visual Process Flows – Menu “maps” make navigating the system easier than ever.
  • Sage Exchange integration for credit cards now allows for use of credit card swipers (Important: Talk to your partner about the conversion process as it may be more time consuming if you have many years of credit card history. Also please recall that PC Charge is no longer supported on Sage 100 ERP 2013).
  • Customers and vendors may now be designated as inactive.
  • Cleared checks from Bank Reconciliation now show up in Account Payable vendor maintenance.
  • Multiple ERP companies can access a single Sage CRM database.
  • Sage Advisor notifies you when it’s time to upgrade
 

The Sage 100 ERP 2013 software may be downloaded from:

CUSTOMERS:

Sage 100 ERP customers on a Business Care plan can download your copy by logging on to the Customer Portal, and then clicking on www.Sage100ERP.com/download2013. Before you download, Sage recommends that you check with your certified solution provider to assist with your upgrade.

 

PARTNERS:

Sage 100 ERP certified Business Partners can download your copy by logging onto the Partner Portal, and then clicking on www.Sage100ERP.com/download2013.

 

Detailed Information On What’s New in Sage 100 ERP 2013  fka MAS90 MAS200

For a more in-depth description of new features in this release – please review either of  the PDF files

Sage 100 ERP – At-a-Glance Version Enhancements Version 2013 (PDF)

Sage 100 ERP 2013 Detailed Release Guide (PDF)

 

Need help understanding your upgrade options? Contact Us.

Sage Symposium Atlanta – January 17, 2013

Sage is bringing their symposium series of product updates and road map presentations to the Atlanta Marriott Northwest at Galleria in Atlanta Georgia on Thursday January 17, 2013 from 8:00 am to 4:30pm.

This free event features product roadmap sessions for:

  • Sage 100 ERP
  • Sage 300 ERP
  • Sage 500 ERP
  • Sage Pro and Sage PFW

 

In addition there are presentations on:

  • Sage CRM
  • Sage Business Intelligence and Reporting
  • Sage HRMS and Payroll
  • Sage ERP X3
  • Sage Payments Solutions
  • Sage Fixed Assets
  • Sage Alerts and Workflow
  • Forecasting and Budgeting
  • Sage Document Management
  • Sage Sales Tax
  • Sage EDI

 

We were contacted by one of the participants of the Houston TX Sage Symposium who had this feedback:
I attended the event in Houston today. Other than some verbal tripping over the name rebranding, the symposium was very informative. They had to pull in extra chairs for the business insights presentation.

It’s always good to have opportunities like yesterday to hear directly from the sages at Sage. And they fed us quite amply. I’m back on my diet today. Most of the participants stayed until the end for the possibility of winning an ipad.

I enjoyed the chance to visit at length with Lori Maloof, the Sage 100 (Mas90) brand manager. I emailed her to request a copy of her PowerPoint presentation, and received it before the end of the symposium.

It was a day well spent!

The future of Sage looks promising.

To register for this free event visit Sage Customer Symposium (Atlanta) by January 14, 2013

 

Sage 100 ERP 2013 Documentation (Manuals)

Looking for a manual for Sage 100 ERP v2013 – formerly Sage ERP MAS 90 or MAS 200?

Here is a quick link to a site which Sage appears to have created to provide a version of  online manuals  (help files, how to guides) for users of the latest release.

Covered modules include General Ledger, Accounts Payable, Payroll Accounts Receivable, Inventory Management and Sales Order plus by clicking on “View All Modules” in the upper left you will be able to review guides for the remaining Sage 100 ERP modules.

Within these sections are helpful instructions for performing frequent tasks as well as  printed copies of the online help files.

As of now this link may be accessed without a password though that could change in the future.

 

Sage 100 ERP Product Documentation

 

How to export the Sage 100 (fka MAS90) company code (sy_company) using Visual Integrator

Here’s a very interesting two step process to perform a task which at first seems impossible. A member of the Sage 100 ERP Linkedin Group asked:

 

Anyone know how to link SY_Company into VI Export so I can get the Company Code in an Export from AP?

 

The answer is a relatively easy change that you must make to Visual Integrator which includes adding a temp calculated field and then assigning that value to an unused standard Sage 100 field.

Apparently this is needed because Sage Visual Integrator won’t export temporary fields.

 

Read the entire solution here.

Federal Medical Device Excise Tax (MDET) for Sage 100 ERP (fka MAS90 and MAS200)

The Patient Protection and Affordable Care Act imposes an excise tax of 2.3 percent on the sale of certain medical devices. Recently the IRS issued TD 9604  (here) which spell out more of the guidelines for the MDET.

Deal or No Deal, Obamacare Taxes Poised To Hit Next Month

We recommend that you consult with a tax professional on how (or if) this new regulation may apply to your company.

Some users of Sage 100 ERP (formerly known as MAS90 or MAS200) have asked how to best change their software to account to capture any required excise tax.

One solution which is on the horizon is from Avalara who is a provider of integrated sales tax computation and reporting services. Their solution integrates to Sage 100 ERP and computes taxes during the order entry and invoicing process. They also offer tax reporting and filing services to help make the process manageable.

Avalara reports:
We want to update you on the next release of AvaTax Calc, which includes changes to the AvaTax WSDL (Web Services Definition Language), enhancements to the user interface and support of the new Federal Medical Device Excise Tax. The AvaTax Calc SDK-DEV environment will be updated on December 12, 2012 from 5:00-9:00pm and to the production environment on December 27, 2012 from 5:00-9:00pm. These enhancements will not affect your product usage or ability to access AvaTax Calc.

Medical Device Excise Tax

We have updated AvaTax Calc to support the Federal Medical Device Excise Tax (MDET) going into effect as part of the Health Care and Education Reconciliation Act of 2010 in January 2013. In support of this, AvaTax Calc will allow you to calculate medical device excise taxes and generate a report to file the appropriate federal IRS tax forms.
We are introducing a new report and two new Entity Use Codes. The Entity Use Codes, used in combination with a Tax Code, will support the proper tax calculation.

Federal excise tax summary report

MED1 – calculates excise tax only (exempt sales and seller’s use tax)
MED2 – calculates excise tax in addition to sales and seller’s use tax (taxable sales and seller’s use)

 

Avalara – Avatax

Year End Closing Tips for Sage 100 ERP (formerly MAS 90) – Special Newsletter

Our special year end newsletter for Sage 100 ERP (formerly known as MAS90 or MAS200) users is now available. In this issue we explore tips and tricks for closing every module – including the order in which they should be closed.

Are you following best practices by creating year-end archive companies? If not – we will show you how to use the built-in features that allow Sage 100 ERP to quickly create backup copies of your live data. These copies of data are especially helpful for anyone using the payroll module since you can refer back to the archived companies throughout the year as your employees request copies of W2 and other forms which they may have lost.

This issue also has information on the payroll tax updates and provides information about when and how to apply them to your system to meet new IRS and state tax guidelines.

Sage 100 ERP Year In Review – 2012 Closing Tips (PDF)

Sage 100 ERP (formerly Sage ERP MAS 90 or MAS 200) Payroll 2012 Year End FAQ

Sage have just released their annual frequently asked questions for year end payroll processing. This document provides links to the needed tax tables as well as IRD (interim release disks) which may be needed prior to running payroll for the last time on Sage 100 ERP.

There is also a handy list of every Payroll Extended Solution which needs to be updated after loading the 2012 IRD for Sage 100 ERP (formerly Sage ERP MAS 90 or MAS 200).

Tax Table Update, Payroll, Electronic Reporting, and Accounts Payable

2012 Year-End Frequently Asked Questions
December 17, 2012

IRD (Interim Release Download): Interim Release Download contains the Year End program changes for Payroll,
Accounts Payable and Electronic Reporting modules. It also contains necessary program changes for eFiling and
Reporting.

TTU (Tax Table Update): Tax Table Update contains changes to applicable Federal and State withholding tax tables and
wage limits, State Disability percentages and/or limits and State unemployment limits.

1. Do I need to download the 2012 IRD for AP 1099 Reporting?

Yes, customers running Accounts Payable must install the 2012 year-end IRD. There are AP 1099 form changes included
in 2012 IRD. The following are the minimum versions. If you are not at least on the minimum version, you must add the
required product update to get to the minimum before installing the year-end IRD.
• 4.40.0.1: must have last year’s (2011) year-end IRD installed or PU 8
• 4.50.0
• 4.50.0 SQL
Note: The 2012 IRD is included in versions 4.50 PU5 and 2013 PU1

2. Do I need to download the 2012 IRD for Payroll W-2 reporting?
Yes, even though there are no W-2 form changes in the 2012 IRD, you must install the 2012 IRD in order to use eFiling
and Reporting, also to install the necessary program changes required when 2013-Q1 TTU is installed. The following list
contains the minimum versions required. If you are not at least on the minimum version, you must add the required
product update to get to the minimum before installing the 2012 IRD.
• 4.30.0.18: must have last year’s (2011) year-end IRD installed
• 4.40.0.1: must have last year’s (2011) year-end IRD installed or PU 8
• 4.50.0
• 2013: or install PU 1
Note: The 2012 IRD is included in versions 4.50 PU5 and 2013 PU1, which are scheduled to be released around
December 10
th
. Customers running version 4.50 can install either the 2012 IRD or PU5 but are not required to install both.
Customers running version 2013 can install either the 2012 IRD or PU1 but not required to install both.
 

Download 2012 Sage 100 ERP Payroll FAQ (pdf)

 

Sage Summit 2013 – Call For Topics

Have you attended Sage Summit in the past and wondered why a specific session or topic was not offered? Well here’s you chance to propose the topic that you would like to see covered during Sage Summit 2013 in Washington DC July 21-26, 2012.

Past ideas for topics which have turned into great sessions:

  • Success stories around how you use Sage products – several customers described their use of shipping software, alerts, and other integrations on a panel session
  • Best practices for upgrading or installing particular types of Sage software – do you have shortcuts you’ve used such as storing master disks in the cloud for easier sharing, documenting setup via project management tools like Basecamp, etc.
  • How to migrate Sage 100 ERP from Standard to Premium (SQL)
  • Others?

If you have not presented before you can consider partnering up with a co-presenter. At Sage Summit 2013 the goal is to share information to increase the ROI for everyone in attendance and this starts by volunteering to either present or co-present a session that you feel would be valuable.

Chances are excellent that if you’ve wanted to see a specific session at Sage Summit there are dozens of other customers who feel the same way.

Ready to suggest a topic? – Submit your Sage Summit idea here

 

PS – In my opinion Washington DC is the BEST site for the conference. We’ve been here twice before and there is a bus route immediately outside the hotel which takes you right to the awesome DC metro public transportation (cheap, safe, clean) from where you can tour all of the nation’s capital for FAR less money than any other tourist destination I’ve ever been to. Getting from the airport to the Gaylord National is an easy and inexpensive public transportation route which I’ve taken each year and documented here.

 

 

Sage eFile – Electronic Filing for Sage 100 ERP Payroll Taxes

Many states are now requiring electronic filing of payroll taxes. Did you know that Sage offeres electronic eFiling as part of the Sage 100 ERP system?

Streamline your tax reporting process with Sage 100 ERP Federal and State eFiling and Reporting. Eliminate manual for creation and save time by choosing from over 250 federal and state forms for Unemployment, Withholdings, New Hire Reports, W-2, W3 and 1099.

Live Webinar: Learn How To Save Time & eFile Employee Forms with Aatrix

Wednesday December 12, 2012 – 1 pm ET – register

Wednesday December 19, 2012 – 4 pm ET – register

Sage Business Review

You may receive a phone call from a Sage representative in the next few months.

Sage is reaching out by phone to customers with the goal of offering a high level phone review of your business plans for the coming year.

The telemarketers will offer to share how Sage products can help in reaching your goals as well as share best practices that other companies use to implement these ideas.

Primarily Sage is discussing the following products:

  • Sage Payments – Credit card processing which integrates to most Sage products
  • Sage HRMS – Human Resources (Formerly branded Sage Abra)
  • Sage Intelligence – Business Intelligence software which Sage offers as their FRX replacement (financial reporting) as well as business intelligence
  • Sage FAS – Fixed asset reposting (depreciation, asset tracking)
  • Sage CRM – Customer Relationship Management software which allows for tracking customer proposals and conversation
  • Sage Sales Tax – Avalara sales tax processing integrates to most Sage products and helps insure compliance with ever-changing sales tax laws

 

We’re happy to provide real world feedback on any of the above solutions. Many of our customers (or those of other consultants in our group) have implemented these solutions and can offer their experiences.

 

 

 

 

Facebook Copyright Status Spam – Don’t Fall For It

If you’ve noticed your friends on Facebook starting to post lengthy status updates that ramble on about how posting such a rambling legalese type status update can render their content copyright protected and impervious to the legal actions of any government (or Facebook) official – don’t fall for it.

This status spam (which is the 2012 equivalent of chain letters) is not true.  This is a repeat of another spam that appeared in June 2012. You do not have to post a update to gain copyright protection against Facebook – though  if you like annoying your friends with lengthy rambling status updates – go for it.

 

Via: Slate and ERP Life

Microsoft Windows XP Support Expiration Date of April 8, 2014 Is Less Than 500 Days Away


April 8, 2014 is the expiration date on Microsoft XP — aka the last day (as of now) that you’ll be able to get support for the operating system that many companies have standardized on for the desktop.

The questions may become – will Microsoft extend the deadline, will Windows 8 become the new standard or will companies just ignore this altogether?

Retirement deadline for Microsoft’s longest-lived OS is ‘ticking time bomb,’ says migration firm

Sage Houston TX Symposium – 12/6/12

Sage ERP Customer Symposium
December 6, 2012 Houston TX

Join Sage North America for a complimentary one-day conference designed exclusively for Sage ERP customers on December 6, 2012, at the Houston Marriott North in Houston, TX. Attend and learn more about the value of your Sage investment and share with senior Sage leaders what else you need to make your business successful.
Registration is open!.

December 6, Thursday

During this one-day Sage customer event, customers will hear about Sage Software’s direction, learn what’s new, and have an opportunity to network with peers in the Sage community and product experts.
Don’t miss this exciting, education-packed conference being hosted exclusively for our valued Sage ERP customers. Register today!

 

 

Products To Be Discussed:
Sage 100 ERP
Sage 300 ERP
Sage 500 ERP
Sage ERP X3

Sage Add-On Products (Some 3rd Party) To Be Discussed:
Sage CRM
Sage ERP Alerts and Workflow (aka Knowledgesync)
Sage ERP Document Management (aka Altec)
Sage ERP EDI (?)
Sage ERP Payroll (Sage HRMS?)
Sage ERP Sales Tax (Avalara)
Sage ERP Shipping (Smartlinc)
Sage ERP X3
Sage Intelligence
Sage Payment Solutions

How to remove graphical Sage 100 ERP forms which don’t appear in Report Manager

Have you ever had this happen in Sage 100 (formerly Sage ERP MAS 90 or MAS 200)?

You create any number of graphical forms – only to find that over a period of time some of them never get used. In an effort to clean up your system you try to delete the form(s) via the standard Report Manager process.  Upon navigating to the Report Manager you find that your form(s) for some reason (typically we see this with customers who’ve been using the software for quite some time) the form(s) you wish to delete are not present.

Wish there was a way to delete these wayward forms once and for all?

There is — and here’s the answer:

 

Version(s):

4.10+

Problem / Description:

How to remove graphical forms (checks, invoices, etc) which do not show in the Sage 100 ERP Report Manager and therefore cannot be removed via standard functionality

Resolution:

 

* References to the form code must be removed manually:

* Expand Modules, Library Master, and Utilities. Double-click Data File Display and Maintenance (DFDM).

* In the File Name field, select the …\MAS_SYSTEM\SY_ReportSetting.M4T file.

* Delete the key associated with the form code. Repeat this step for the following files:

* SY_ReportOption.M4T

* SY_LastFormUsed.M4T

* In Windows Explorer, browse to the …\MAS90\MAS_xxx\Reports\ folder.

* Delete the folder associated with the form code.
Note: Review the SY_Company file in DFDM and match the Company Key with the company name to determine the correct records to delete. As always, make a backup prior to making changes to files in DFDM.

 

 

Date Created: 11/10/12

Created By: WES

 

 

 

Sage Payments QuickBooks Integration

I just stumbled across this literature from Sage which indicates their Sage Payments credit and debit card processing integrates to QuickBooks.  We don’t have any direct experience with this integration though their literature claims that the integration will “seamlessly flow back into your accounting software”.

Sage Releases Hurricane Sandy Support Relief Information

About two weeks after Hurricane Sandy wreaked havoc through New England Sage have released some information about how impacted customers can get a free support case.

Sage Hurricane Sandy Site

 

If you are a customer – whether on support or not – you may be eligible to call Sage directly at one of the numbers listed below for some support assistance.

Sage Payment Processing – Authorization and Settlement Outages – 10/30/12 *RESOLVED*

According to reports from customers who have integrated their Sage 100 ERP with Sage Payments for credit card processing – the link to Sage may be down as of 10/30/12.

UPDATE 10/30/12 4pm – Sage indicates that this issue has been resolved and systems are back functioning as normal.

Here is Sage’s suggested workaround until their connection is functioning:

We first took reports early this morning in the aftermath of Hurricane Sandy. The symptom that two customers reported was a blank “OK” button when attempting to process credit cards.

 

Sage Payments Status Page

Hurricane Sandy Update: CT Roads Closed – Sage 100 Support Continues to Be Available

The Governor of the State of CT has ordered all roads in Connecticut to be closed at 1pm today (Monday October 29, 2012).

The offices of Schulz Consulting will remain open for as long as the power stays on in our area.

 

Customers of Schulz Consulting can contact us at:

Office – 860-657-8544 or via email – support@s-consult.com

In the event of a total power outage – our backup support services include the 90 Minds Consulting Group who with over 100 members have offices all across the United States and provide backup technical support for members in situations such as this. If you are a Schulz Consulting support customer and you are unable to reach our offices due to power or phone issues in our area – you may submit a support ticket directly to our 90 Minds Group and it will generally be responded to within the hour — Submit 90 Minds Sage 100 ERP Support Ticket

F9 for Sage 100 ERP Pricing

Here’s the latest list pricing that we have for F9 v4.x to 5.x for Sage 100 ERP.

Please verify these with your Sage business partner. If you are an existing user of F9 for Sage and are not presently on maintenance you may have to provide your licensing information to Infor in order to qualify for upgrade pricing.

Windows 8 Upgrade: First Thoughts

Anyone load Windows 8 yet? I spent a couple hours loading the upgrade from Windows 7 to Windows 8. Pretty interesting change. I was very surprised that I did not have many problems navigating. Admittedly I did not try to use it in a network environment (home vs office are two very different work situations).

 

I like (and hope they continuously improve) the Metro (modern) UI which displays what are essentially a bunch of live tile widgets.

My concerns are:

a. Microsoft will leverage their monopoly to be sure their native apps are the primary ones which work well on Windows 8

b. The settings are going to be tough for people to get their arms around.

c. I’m not sure that I am sold on touch and laptops but I could be persuaded

d. The Microsoft Surface — especially Surface RT v Pro are two very different animals (one only runs Windows 8 apps the other full Windows apps) and I think will be a little to complex to explain to most users. I can see the RT going away quickly in favor of full Window 8 tablets (which honestly are just compact laptops by my view).

I did not put Sage 100 through any type of rigorous testing – other than to see if it started and I could log in. There is a separate desktop that looks just like Windows 7 (hidden behind Metro UI) which is pretty easy to start up and use.

Time will tell but I was more favorably impressed than I though I would be.

Sage 100 ERP Hotfix For Payroll Deductions Calculated Above Standard Limit

In Deduction Code Maintenance when the Deduction Type is Employer Contribution and the Calculation Method is set to Percentage of Deduction, the deduction amount is calculated after reaching the Standard Limit.

SAGE 100 Standard and Advanced ERP PROGRAM FIX

Product Affected:
PR 4.50.4.0 for SAGE 100 Standard and Advanced
Program Fix Number: PR4064-T
Date:
October 10, 2012

SYMPTOM

In Deduction Code Maintenance when the Deduction Type is Employer Contribution and the
Calculation Method is set to Percentage of Deduction, the deduction amount is calculated after
reaching the Standard Limit.

RESOLUTION

The following will correct the problem.

Programs
Version
TCWDTC
871
AR_CommissionEditRegister_upd.pvc 808
PRWDAB
808
PRWDAD
808
PRWDAE
808
PRWDAH
808
PRWVIP
808

These programs can be downloaded from our web site (http://na.sage.com/log-on/) after registering for
and logging into the Sage Customer or Partner Portal.

Install the self-extracting file to the MAS90 directory at the server, or copy the appropriate
programs to the …\MAS90\AR, …\MAS90\PR …\MAS90\TC folder after renaming the existing
files.

SY_Workstation.M4T Cannot Be Found – Possible Solutions For Sage 100 ERP

Sage 100 ERP users may report they sporadically receive  an error message – SY_Workstation.M4T cannot be found. In some cases the user can enter through the error and proceed normally.

Resolution:

There are several possible resolutions for this Sage 100 ERP error  - all related to the network.

Antivirus may be scanning the SY_Workstation.M4T at the same time as the user is trying to access it (Recommended: Exclude the Sage files from scanning)

Opportunistic locking may be locking files on the server and workstation (see http://support.microsoft.com/kb/296264 for information on how to turn off opportunistic locking)

In at least one instance this problem has occurred because users were not logging out/into their Windows machines each day. When they left for the night they simply powered down their monitor and did not log out and subsequently when they came into the office they were not logging back in. You are most likely to see this in conjunction with some type of server upgrade and/or workstation upgrade to Windows 7. The solution was to have the user log out from their computer at night (Important: This means the PC logout not the Sage logout). The technical reason behind this appears to be related to Kerberos and there is a lengthy discussion on the Sage Community of others who had this issue:

http://community.sagemas.com/t5/Technical-and-Installation/SY-Workstation-M4T-not-found/td-p/26166

Why Does This Happen To Sage And Not Microsoft Office (or Other Apps?)

We frequently have customers ask why this issue only occurs with Sage and not other applications such as Microsoft Office. In most cases the reason that Sage is displaying an error and not Microsoft Office is because your Sage ERP system reads and writes constantly to the network whereas other applications may only do so when they are opening a new document or saving it.

How To Remove A Sage 100 ERP Module That You No Longer Use And Stop Paying Maintenance On It

Occasionally you may find yourself with Sage 100 ERP modules installed on your system which you no longer uses. We’ve been asked in the past by our customers if there is a way to remove those modules and stop paying maintenance?

The answer is yes. First you must contact your business partner – or Sage Client Care Representative. They will send you a form (Word Document or PDF ) which you complete and send back to Sage.

Once Sage approves the downgrade they will send you new unlocking keys. You’ll need to first remove the module(s) (as well as ALL historical data). Then you use the new unlocking keys to permanently remove the module.

 

How To Remove Modules

  1. Make a full backup of Sage MAS 90 or 200.
  2. In Windows Explorer, go to ..\Mas90\ and copy the data folders of the module to be removed (optional).
  3. In Sage MAS 90 or 200, rename, move, or delete the data folder for the module from each company (for example, ..\Mas90\Mas_abc\Apabc).
  4. Open Library Master / Setup / System Configuration.
  5. Click the ‘Uninstall’ button.
  6. Select the module to be deleted and click the ‘Delete’ button.
  7. Click ‘Yes’ at the confirmation prompt.

Sage 100 ERP 2013 (fka MAS90 / MAS200 ) Beta Applications Being Accepted Now

Sage is now accepting applications for partners who wish to beta test Sage 100 ERP 2013. This is presently a partner-only beta with a customer early adopter phase to follow shortly.

Our Beta Program provides Sage Business Partners with an opportunity to be the first to learn about the new features and functionality of the new release in advance of general availability and customer shipments. Your participation in the Beta Program is vital to provide us with valuable feedback, and prepare you to support an Early Adopter customer. The Sage 100 ERP 2013 Beta is currently scheduled to run October 15th – November 26th, followed immediately with the Early Adopter Program, from November 26th through December 3, 2012.

Sage 100 ERP 2013 Beta (partners)

How To Regenerate An Sage 100 ERP ACH File With Kissinger ACH Direct

Version(s):ALL

Problem / Description:

Payroll is run but for some reason the ACH file from KISSINGER ACH DIRECT is not generated or found in the typical location. Attempting to regenerate or run the ACH report produces “no data”.

You can verify that payroll is run by spot checking some employees in employee maintenance and noticing that they all have indications that they were paid by ACH – typically a number followed by a capital D in the “check number” column.

Resolution:

Provided that you’ve ruled out all other possible causes such as: Payroll not posted, employees not flagged for ACH

Go into Direct Deposit on the Sage 100 Payroll menu

- Direct Deposit Processing
- Resubmit ACH Direct Data (this pulls up a saved copy from the \mas90\ddsave)
- Select the data file to pull back into ACH (usually the date of the payroll).
- Follow instructions on pop up menu which will tell you to run the ACH report

- You should now find your ACH file in the customary location

Kissinger Associates ACH Direct

Reminder – Sage 100 ERP v4.3 Last Tax Table Update is December 2012

Sage previously announced that as of December 31, 2012, they will no longer support updates, including the Tax Table Update (TTU), to version 4.3.

However, due to the new 2013 Medicare requirements, Sage will provide Medicare changes for 2013 in January and 941 updates in March 2013, so you can comply with the 2013-Q1 filing requirements. This will be particularly important to you, as TTUs will no longer be provided for this version.

 

 

Sage 100 ERP Payroll Tax Updates: Michigan, North Carolina, Pennsylvania – Available 9/25/12

Sage have announced that users of Sage 100 ERP payroll who are in the following states:

  • Michigan
  • North Carolina
  • Pennsylvania

Will be able to update their tax computations for new payroll law changes as noted:

  1. Michigan – withholding rates updated effective October 1, 2012
  2. North Carolina – unemployment UI wage base to $20,400
  3. Pennsylvania – increase credit weeks least amount

These updates will be available to download from the Sage site on September 25, 2012.

As previously announced the discontinuation of payroll updates for users on version 4.3 or earlier goes into effect this year though Sage have made an exception to update their program for new 2013 Medicare requirements. Sage will be providing the 2013 Medicare changes for 2013 in January 2013 and 941 updates in March 2013.

 

 

Is Pocket Soap still required to be loaded for Sage Payments integrated to Sage 100?

Versions of Sage 100 prior to 4.4 required a separate Pocket Soap program download to complete the integration with Sage 100.

Pocket SOAP is the open source Clint communication components for the windows family. It supports for SOAP 1.1 and soap 1.2. It supports attachment via Both DIME and SOAP.

As of version 4.4 this download is no longer required.

Resolution:

No separate download is required.

Versions prior to 4.4 which need Pocketsoap should reference this link

http://www.pocketsoap.com/pocketsoap/#dl

Sage 100 ERP: Unable to print this report while G/L transactions are being updated

Version(s):

3.x+

Problem / Description:

Unable to print this report while G/L transactions are being updated

 

Resolution:

 

  1. File
  2. Run
  3. GLWSJA

 

Other Information (Links/Sage KB/Additional Tips):

 

 

Another user may be printing a General Ledger report or updating to General Ledger from another module. Wait until the other user is finished before proceeding. If the error persists perform the following:
4.0 or later:
Rerun Workstation Setup. For more information, see How to install Workstation Setup for Sage MAS 90 and 200.

If the error persists, have all users exit Sage MAS 90 or 200, and reboot the workstation and server (if necessary).

 

3.71 of and before:

Have all users exit Sage MAS 90 or 200 and run the GLWSJA program to clear any flags.

Note: Do not perform this procedure if any user is printing G/L reports or updating to G/L.

 

Verify that all users have closed Sage MAS 90 or 200.
1. From the Launcher, select File / Run.
2. Enter “GLWSJA” (without quotes) in the ‘Program Name’ field, and click ‘OK’.
3. Click ‘Yes’ to purge the update from SY0CTL.
4. If the error persists, manually delete the record from the SY0CTL file using Data File Display and Maintenance.
5. Note: The actual SY0CTL record being written has the key [ABCRPTTxx,] or [ABCUPDTxx] where ABC represents the company code, RPT indicates a G/L report is being printed or UPD indicates a journal/register is being updated to General Ledger and Txx indicates the workstation/terminal ID in its compressed form.
6. Open Library Master / Repair / Data File Display and Maintenance.
7. In the ‘File Name’ field, enter “SY0CTL.SOA” (without quotes).
8. Click the ‘Key Scan’ button, and select the record.
9. Click the ‘Delete’ button.

 

 

Sage 100 ERP Webcast: SageCRM Integration to Sage 100 ERP Drives Growth

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!

With Sage CRM and Sage 100 ERP (formerly MAS 90 | 200), you can unify the sales and marketing aspects of your business. CRM supports the whole sales process — from your initial marketing campaign, lead and opportunity generation, quotes, to winning the sale, and finally, to fulfilling the order and providing outstanding customer service. Your marketing department will be able to justify the costs of their campaigns just as your salespeople will be able to track their forecasted sales. Plus, sales managers have a full view of their team’s productivity. Your staff will work more effectively because every aspect of your operations will be connected while your limited or expensive resources are optimized.

  • Sage CRM integration with Sage 100 ERP
  • Sage CRM integration with MS Outlook
  • Forecasting within Sage CRM

 

When: Wed September 12, 2012 – 1pm ET (10am PT)

Where: Online webcast – Register for How integrating Sage CRM with Sage 100 ERP (formerly MAS 90 MAS 200) drives business growth

Sage 100 ERP Webcast: Top Ten Reasons to Upgrade to Sage 100 v4.5 (MAS90 MAS200)

Sage 100 ERP (MAS 90 and 200) version 4.5 is packed with new features and benefits that are all ready for you when you upgrade. In fact, there is so much for everyone that one hour isn’t enough time to cover all of the tremendous enhancements and inclusions, so 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 100 ERP Advanced (SQL server).

 

When: Tuesday September 11, 2012 — 1pm ET (10am PT)

Where: Online webinar – register for What’s New in Sage 100 ERP v4.5 (formerly Sage ERP MAS 90 and MAS200)

How To Use Dropbox to Sync Sage 100 ERP Source Disks To Your Server

As you may know most software publishers – including Sage – have done away with providing CD media for new and upgrade releases.

Many (most) of our upgrades are done remotely without being on-site with the customer.

This creates a dilema.

How to get large sets of source files that you’ll need to start the installation onto your customer’s computer without spending hours struggling with slow connections or downloads that fail at the 98% DL mark…?

The answer typically has been that you either ship the customer a CD or take your chances and remotely connect to a site and start the download (praying that the 2 GB files all download correctly).

Here’s what I’ve found works best for me:

I use two DropBox sync accounts. One which I label as “pure” is the only one that I sync to the customer. The other labeled “normal” is the DropBox on the desktop of all my computers.

a. I have a “pure” paid DropBox used only for the purpose of syncing files to customer sites. Cost is $99/yr for 100 GB. You can probably use any number of file syncing services – DropBox is just the one that I’m most familiar with.

Upload all of your source files to a folder on “pure” DropBox.

I also like to install all the patches, FRX, Microsoft components, service updates, tax tables, what’s new guides, manuals and other third party tools I typically need during a Sage 100 ERP upgrade.

b. Share that folder to your “normal” DropBox where you can maintain (add/remove) files and documents as needed. Because these two DropBoxes are in sync you will automatically be changing your “pure” DropBox (which also syncs to any customer computers you’ve installed it to)

The reason I use a “pure” DropBox (one that only has Sage sync files) is that I believe once you install DropBox on a customer site they can activate any of the folders (including ones you may have holding personal information) and start syncing to their computer.

For $99 per DropBox account — this is definitely worth the investment.

I typically remotely install “pure” DropBox. Let it sync over a couple days. Then when I log back in every file I need is on the remote computer.

You can download individually from lots of file services – including Sugarsync or Google Drive – however I think “pure” DropBox is more of a time saver since you don’t have to babysit the downloads.

I’ve yet to have a problem synchronizing. I had lots of issues with LARGE file downloads from Sugarsync.

Yes you can sync folders this with any of the other file services like Sugarsync , Google Drive, SkyDrive, Box.Net — I just happened to use DropBox because it was inexpensive and I already was using it personally.

The bank code ‘N’ is not approved for electronic payment. You must setup this bank code for electronic payment in ACH Interface Maintenance or select another bank code

Version(s):4.4+

Problem / Description:

When going into the Check Printing and Electronic Payment screen for a bank code that does not transmit ACH (not pre-authorized) and select “BOTH” (check and electronic) and immediately receive

“The bank code ‘N’ is not approved for electronic payment. You must setup this bank code for electronic payment in ACH Interface Maintenance or select another bank code.

This situation can arise because the customer has multiple bank accounts – some of which are used for ACH and others for pure check writing (no ACH). Vendors can be setup to have ACH through one bank account and checks through another. The solution occurs during the invoice payment selection (See below).

Resolution:

During invoice payment selection you need to check off the “Pay Electronic Payment Vendors by Check”

AND

When you go intoCheck Printing and Electronic Payment to print the checks be sure to select “CHECKS” when asked how you want to pay. Don’t select “ACH” or “BOTH” or you’ll get the error message if the bank account is not approved for ACH.

 

 

Sage 100 ERP LinkedIn Discussion Group Approaches 2,000 Members

The Sage 100 ERP LinkedIn discussion group is an independent forum for the discussion of all things related to Sage 100 ERP (formerly Sage ERP MAS 90 and MAS 200).

We founded this group in January 2009 and in three years it has grown to almost 2,000 members.

The group is not sponsored by Sage though from time to time official Sage representatives participate in the discussions.

 

As of August 31, 2012 the membership is 1,999.  Will you be #2,000?

Sage 100 ERP LinkedIn Group

Sage 100 ERP (fka Sage ERP MAS 90 or 200): Slow Renumber of Accounts Receivable Customers and Data

Just a heads up on an interesting tech topic being discussed over on 90 Minds. In version 4.5 of Sage 100 ERP the time it takes to delete/renumber/merge large numbers of customers is apparently quite daunting.

One of our members is troubleshooting a way to do 20,000 of them which he computes could take 3 months of processing (I’m probably paraphrasing this but it’s a long time).

If you are in a situation where a new or existing customer asks you about renumbering AR customers – keep this speed situation in mind. It’s not something that is really easy to test short of running a trial renumber on a copy of the customer data.

 

We’ll update you if there is a workaround uncovered

 

Slow Renumber of Sage 100 ERP Accounts Receivable in V4.50

How to run or install FRX 6.7 for Sage 100 ERP (fka Sage ERP MAS90 or 200) with a 64 Bit OS (SOLVED)

As more customers have adopted 64 bit operating systems they’ve found that one of their core financial reporting tools – FRX –  has refused to install. Even though Microsoft will stop the support and upgrades for FRX on December 31, 2012 the product is for all purposes already a lame duck.

If you’ve recently updated workstations and tried to load FRX for your Sage 100 ERP (formerly Sage ERP MAS 90 or 200) you may have found that you can load the FRX just fine but when you go to print the report you receive an error “Unable to process this output request for the following reason: C:\Windows\System32\Msxml.dll could not be found…”.

If you follow the suggestion and try to register the msxml.dll in the System32 you’ll receive a failure message.

The solution for most people has been to copy the DLL into the sysWOW64 and then use RegSRV32 to register it from that folder.

Double check the msxml DLL version as the one which has reportedly been working for most people is 8.0.5226. If you check the DLL version on your computer and it’s earlier than 8.0.5226 then try downloading and installing service pack 11 for FRX for Sage 100 ERP.

Here’s my 90 Minds KB entry for getting FRX to work under a 64-bit Windows operating system

Version(s): 4.x

Problem / Description:

FRX version 6.5+ will not usually install on 64 bit Windows OS. An error message may occur when trying to register msxml.dll from the System32 (as the Sage KB directs)

 

Resolution:

NOTE: Installing the below fix (registering MSXML) appears to get the FRX system running. Makie sure you have the latest FRX SP 11.

 

A. Install and register the 64 bit (put this in syswow64) using Regsvr (see attached file) v8.0.5226

After registering (used Regsvr32) I received:

“Runtime error -2147220503( 800403E9) fatal error language database (path)/FRxXML4.dll not found” when launching FRx

Resolution:
Register the .DLL files on the workstation.

In Window’s Explorer, go to the FRx program file directory.
Double-click on FRxReg.exe.
Date Created: 8/27/12
Created By: Wayne Schulz
Source: SC
Updated:

 

Source: 90 Minds Consulting Group

Sage Summit 2012 Sunday Wrapup

This week I’m at the Sage North America annual customer and partner conference. This educational event brings together over 4,000 customer and partners for five days of technical briefings and educational settings.

Sage 100 ERP v2013

The next version of Sage 100 ERP  was previously referred to as version 5.0 and will instead be known to as version 2013.

Expect the release schedule (tentative and subject to change)  as follows:

  • Beta 10/15/12 to 11/2/12
  • Early adopter – November through December
  • New sales targeted for early November
  • Auto deliver in early December – download only

 Some key new features in Sage 100 ERP 2013:

Tasks launched from CRM don’t use a ERP license – expect there may be a “millisecond” where a license is confirmed and released. Most SageCRM  integrated to Sage 100 ERP users will no longer have to purchase additional Sage 100 ERP licenses for salespeople (Note: SageCRM licenses are still required).

Accounts Payable invoice number expanded from 10 to 20

Accounts Receivable customers and Accounts Payable vendors may now be made inactive. A new security role has been added to indicate whether a user should be able to override and use these inactive records to specific tasks such as cash receipts.

Paperless Office now allows for use of smtp email accounts such as Gmail which require SSL login.

Accounts Payable now includes a cleared date in the data file layout (Note: ONLY AP Checks) – this is viewed on multiple AP checks

Credit Card processing (integrated) will be replaced by Sage Exchange. This will require all existing credit card data to be uploaded to the Sage vault and removed from Sage Accounts Receivable. No credit card data will be stored within Sage 100 ERP.  The only credit card processor supported by Sage 100  ERP 2013 is Sage Payments.

New Sage Exchange integration supports credit card swipers (use of which may qualify you for lower processing rates)

Sage 100 ERP Premium (Formerly Sage ERP MAS 200 SQL) will use the Sage HMRS Payroll

Pricing -

 

50 employees  = 1,750

75  employees = 2,500

100 employees = 3,150

150 employees = 4.700

200 employees = 5,550

 

These are a small listing of the enhancement expected to be in Sage 100 ERP 2013. Remember that features can change prior to the official release date.

 

Google The Latest Sage Documents – Hot Tip

Here’s a quick power tip for Sage users who want a quick look at the latest documents posted on the Sage website.

If you’re looking for a faster way to uncover public documents listed in Google (this won’t work for documents hidden behind a “gated” Sage login ).

Using a special format for Google search you can view all the latest indexed pages from the North American Sage website – na.sage.com. You can quickly slice and dice this data so you only view updates from the last hour, 24 hours, past week, past month or a custom range.

This search can further be narrowed to search only for pages with PDF or other file types (helpful for finding new whitepapers).

Google Advanced Search

For even more powerful search capabilities — use Google Advanced Search (http://www.google.com/advanced_Search )

 

 

 

Shared Evernote Sage 100 Knowledgebase Available For Schulz Support Subscribers

I’m happy to make available a special connection to a Sage 100 shared knowledgebase that we are growing within Evernote.

Evernote is a multi-platform (both desktop and mobile) software solution which allows for taking notes that are synchronized and shared with other users. These notes may be text only or they can include images and PDF and other types of document files. As part of the organizing process Evernote indexes all files and allows for you to search inside of them.

Because Evernote works so well across multiple platforms we’ve decided to adopt it for keeping track of shared knowledge articles.

During the Sage 100 ERP upgrade or support process we are constantly adding knowledge articles that explain the way that a particular issue was resolved. As of now we have 90 articles and expect that we’ll triple that number by year end.

Read up on the use of Evernote – here –  take a quick peek at a sample of a few support articles here – and if you are a subscriber to our Schulz Consulting Access Agreement – simply send your email address to wayne@s-consult.com  and we’ll share a link to our full Evernote Sage 100 ERP  Knowledgebase.