Spring Cleaning – Purging old Purchase Orders, Recaps and Receipts records

May 1st, 2012 by Lee Graham

In Sage Mas 90 and Mas 200 (now re-branded Sage 100), when you look up Purchase Orders do you get a long list of ancient Purchase Orders no longer in effect?  Would you like to get rid of those?  If your P.O.  System History options are set to retain history, there are six options on the Purchase Order Utilities menu to help you purge old Purchase Orders, recap info and Purchase Order Receipts History.    Purge Completed Purchase Orders allows you to enter a date, and the system will remove Purchase Orders completed on or before 60 days prior that date.    Purge Expired Master/Repeating Orders allows you to automatically purge Master or Repeating (or both) Purchase Orders that have passed their expiration dates.  Purge Completed/Cancelled PO Recap option will purge the recap data as of the date you enter.  Note the Purchase Order Recap report on the reports menu for the information being purged.  Purge Obsolete Purchase Orders will remove all obsolete purchase orders whose purchase order date, last receipt date, last issue date, and last invoice date are on or prior to the date you enter.  This option is useful for Purchase Orders that were never officially completed, and don’t have a completion date that would be used by the Purge Completed P.O. option.  Purge Purchase Order Receipt History will remove receipt history for nonexistent (completed and purged) purchase orders to provide additional space in the Receipt History file.  Using these Purge utilities will shorten your lookups and various Purchase Order reports that may be cluttered with outdated or obsolete information.

 

Online Map With Sales Tax Rates

April 11th, 2012 by Phil McIntosh

If you’ve ever had to spend time on any of the following:

  • Guessing at a customer’s sales tax rate based on zip code
  • Having a customer reject an invoice because you guessed wrong
  • Had a tax audit find you charged the wrong tax (even if you based it on what jurisdiction the customer said they were in).

there is a website that can save you time and grief.

http://www.avataxrates.com by Avalara provides a searchable overlay to Google maps that tells you the tax rate and jurisdiction for the specific address, not just the zip code.

Why is the zip code not good enough? Especially here in Georgia, with its multiple small counties, zip code borders and county lines rarely match up exactly. 30052, where I live, has pieces of four counties, and I can always tell when I order something from a company that uses a zip based tax map (yes, Office Depot and MicroCenter, I am talking about you), because I get charged 7% instead of the 6% Gwinnett County rate).

Avalara offers the online map for free, and if you’d like to completely automate the sales tax process and even have returns filed for you, they offer a paid service which integrates with Sage 100 ERP (MAS 90/200) and Sage 300 ERP (Accpac).

Another (Deliberate) Hole in the Facebook Privacy Bucket

April 9th, 2012 by Phil McIntosh

Facebook has made a fortune out of a seriously warped version of the word “free”. You give them all your thoughts, feelings and behaviors for free, and they’ll happily sell that info to advertisers. “Sharing” as in “what’s yours is mine and what’s mine is mine”.

The latest revelation is that, by default, anything you share with your friends is also shared with any Facebook app that any of your friends install, even if you have never authorized that app.

For instructions on how to fix this, see When you share personal data with Facebook friends, you’re sharing your personal data with every app your friends use.

If any of you still think Facebook is “free”, please post all of your bank and credit card login/password info as a comment here.

Suffering from Computer Vision Syndrome?

March 5th, 2012 by Lee Graham
Are you one of the many who suffer from Computer Vision Syndrome (CVS)?  Don’t let eye fatigue slow you down- try to incorporate the 20-20-20 rule in your daily work routine.
Step I:  After every 20 minutes of looking into the computer screen, turn your head and try to look at any object placed at least 20 feet away. This changes the focal length of your eyes, a must-do for the tired eyes.
Step II:  Try and blink your eyes for 20 times in succession, to moisten them.
Step III:  Time permitting of course, one should walk 20 paces after every 20 minutes of sitting in one particular position. This helps blood circulation for the entire body.
Computer Vision Syndrome is a group of symptoms associated with prolonged computer use.  The most common symptoms associated with CVS are eyestrain, headaches, blurred vision, dry eyes, and neck and shoulder pain. These symptoms may be caused by poor lighting, glare, improper viewing distances, poor seating posture, uncorrected vision problems, or a combination of these factors.
Check the location of your computer screen. Ideally, you should have your monitor a few inches below eye level. Next check the lighting in the room. You can use blinds or drapes to decrease the amount of light reflected from the computer monitor. Switching to lower wattage light bulbs in overhead and desk lamps may also help. Glare comes from reflections, so choose matte finish walls in a darker paint color in lieu of bright white walls in your office. If you can’t get away from windows and light, you can use an anti-glare filter on your computer screen. It is essential to have anti-reflective coatings on the lenses in your glasses. AR coatings reduce reflections off the front and back surfaces of your lenses, reducing glare and improving comfort.  – from my Eye doctor – Lee

Sage Software will be re-branding many of their products, including MAS 90, MAS 200 and Accpac

February 6th, 2012 by Lee Graham

Sage Software will be re-branding many of their products in the future, especially as new releases are rolled out.  You may begin to see some of these name changes in the coming year, but despite the branding changes, the products are the same software packages many people are running today.  Here is a list of Sage’s proposed changes:

  • Sage 50 – the “install yourself” products such as Sage Peachtree and Simply Accounting
  • Sage 100 will be MAS 90, MAS 200, Timberline, Fund Accounting
  • Sage 100 Contractor – formerly Timberline
  • Sage 100 Standard ERP – formerly MAS 90
  • Sage 100 Advanced ERP – formerly MAS 200
  • Sage 100 Premium ERP – formerly MAS 200 SQL
  • Sage 100 Fund Accounting  – formerly Sage Fund Accounting
  • Sage 300 will be the current Accpac software series
  • Sage 300 Standard – formerly Accpac 100
  • Sage 300 Advanced – formerly Accpac 200
  • Sage 300 Premium – formerly Accpac 500
  • Sage 300 Construction – formerly Sage Timberline Office
  • Sage 300 Trade/Specialty – formerly Sage Timberline Enterprise
  • Sage 500 will be MAS 500 and Multi-user Fund Accounting
  • Act!, Saleslogix, Sage TimeSheet and Sage TimeSlips will keep their current names

For a complete list from Sage’s website, see:

http://www.sagenorthamerica.com/Company/Brand/New-Sage-Product-Family-Descriptions

Pricing on Purpose vs Hourly Billing: What’s Been Left Out

December 20th, 2011 by Phil McIntosh

There has been much discussion recently among business software VARs about how to price our services. The traditional method has been hourly billing. How long does it take the consultant to do the work? Others are now saying we should scrap time tracking and should use “pricing on purpose” or value billing. What is the solution worth to the customer?

Those who want to get rid of the timesheets say it creates the wrong incentive, and could tempt some people (always not you, but others) to pad their hours. Opponents of value pricing say it creates an incentive for customers to minimize the value.

Both of these arguments point to the same thing, but never seem to discuss it: TRUST. We received a letter a few years ago from one of our allies (isn’t that a better word than customer?) which included the following:
“You have served us so well that we are convinced you are indeed a partner, an ally. I don’t think you could have taken our interests more to heart if you were the sole owner of the company; that is how confortable I feel in not only your technical support but also the recommendations you make on purchase of new/additional software.”

With this ally we do much of our work on an hourly basis. Sometimes on a project they will ask for a quote up front so they can figure out if the ROI is there to do it. Either way, they trust us to do quality work for a reasonable price, and we trust them to provide us honest answers to our questions so that we can make the system work for them efficiently and effectively.

They trust us, we trust them. The unit of measure on the invoice doesn’t matter.

New Physical Count Features can speed up your counting for Sage Mas 90 and Mas 200

November 17th, 2011 by Lee Graham

Sage Mas 90 and Mas 200 version 4.4 added some features to the Inventory Physical Count functions that you may find useful during Quarter-End or Year-End Inventory Counting. You may want to review these new options before your next Physical Count to see which options are best for your situation.

For those using MAS 90 or MAS 200 version 4.40:

Option to print the system’s on-hand count on the Count Sheets for reference.  This can quickly alert people to review discrepancies while they are counting.

Option to set the system’s on-hand quantity as the default-count value so you only have to enter the exceptions, not every single count.

Inventory quantities can be stored with up to 4 decimal places if you need that.

Count Card Entry Introduced in version 4.40.05 in summer, 2011:  To assist with doing a physical count of diverse inventory in a large warehouse, you can now enter counts for the same item in different locations on individual count cards. This new option will help prevent you from counting the same inventory twice, and is useful when you have the same items located in multiple locations across your warehouse. When you enter your individually numbered count card information, it can be more accurately tracked, and missing cards can be easily spotted. To speed data entry, multiple users can enter information on cards. Once you’ve entered all your count card information, your quantities can be totaled by item for each warehouse, and you can make any necessary adjustments before posting thel Count Card Variance Register.  Use Count Card Entry, Count Card Report, Missing Card Listing and Count Card Variance instead of Physical Count Entry and Physical Count Variance Register.

Let us know if you have questions about these features.

Sage Mas 90 and Mas 200 version 4.50 is now available

November 11th, 2011 by Lee Graham

Sage Mas 90 and Mas 200 version 4.50.01 is now available, and with product update 01, existing users can upgrade to use the new 4.50 features. For Mas 200 only, version 4.50 can now run on a Microsoft SQL database platform.  For both Mas 90 and Mas 200,  application enhancements include:

Accounts Receivable has added the ability to bill National Accounts while keeping statistics on branches and subsidiaries.

Payroll has added 5 new deduction calculation methods, including calculation of deductions based on changes in the earnings line made during data entry.  New features for importing payroll entries from popular time-tracking packages have also been added.  New Benefit Accrual figures allow you to set minimum hours for accruing types of benefits.

Automatically Create Purchase Orders from Sales Orders.  New features allow Purchase Orders to be created for not just drop-ship Sales Orders, but all Sales Orders based on specifications that you set.  This is really helpful for companies that don’t purchase products until their customers order them.

Additional Pricing methods have been added to Sales Order system, including pricing by customer for each product line that will allow a company to set default price levels for each of their customers by product line.  Discounts can now be offered by Total order quantity, quantity by Item Category, and for quantity by Product Line.

Assign lot and serial numbers during Sales Order entry. In addition to using lot and serial numbers to be tracked for potential recall of their products, this will also allow companies to reserve limited-quantity lots or serial numbers for their best customers or to match the product-lot previously shipped to a customer.

A new feature for default Split Commissions allows you to establish and maintain default Split Commissions between multiple salespeople for a customer that are invoked each time the customer is billed.

Version 4.5 includes a FREE user and server license of SageCRM 7.1 which allows you track communications with customers and prospects.  The new eMarketing module for SageCRM will deliver all the power of e-marketing software directly through SageCRM for end-to-end e-marketing campaign management. It will enable users to execute high-quality, targeted email marketing and create drip marketing campaigns quickly and easily.

Let us know if you would like to schedule an upgrade to your Mas 90 or Mas 200 system to take advantage of these new features.

Atlanta Rod Converts to xTuple PostBooks from Thoroughbred

October 24th, 2011 by Phil McIntosh

Atlanta Rod and Manufacturing Co, Inc. in Lavonia, Georgia manufactures anchor bolts, embeds, headed bolts and construction fasteners to customer specifications. They had become frustrated with their old Thoroughbred software, and chose Friendly Systems to implement PostBooks by xTuple as their new business software. PostBooks characteristics easily handled recording the specs needed for each custom order for both sales and the shop, giving them a software package that works for them, rather than manual processes to work around deficiencies in their previous software.
Friendly Systems installed PostBooks on their new Linux server, worked with Atlanta Rod to set up the software, and did a “train the trainer” approach to get them up and running quickly and efficiently. We also imported customers, vendors, items and GL data from the old system.
According to Madeline Spratt of Atlanta Rod, “The new xTuple software is easy to use” and “Any glitches we discovered were very quickly resolved.”

Sage Investment Protection Plan for Platinum, SagePro, SBT, Visionpoint Migration

October 5th, 2011 by Lee Graham

Companies using Sage Platinum for Windows and Sage Pro ERP can receive significant discounts by migrating to one of Sage’s flagship products, including Sage MAS 90 and MAS 200, and Sage Accpac under the Sage Investment Protection plan until Dec 31st 2011.  This is an important deal, and it should be reviewed as part of those companies’ strategic planning.  This also includes customers using SBT, BatchMaster and VisionPoint software.  Friendly Systems, Inc. is a reseller of Sage MAS 90 & MAS 200, and also Sage Accpac, and we are available to help you in evaluating these products for your needs.  Friendly Systems is also an authorized Silver Developer Partner for Sage MAS 90 & MAS 200 and can modify the software to suit specific needs.  Do you have customized software?  In addition to Sage Mas90/200 and Accpac modifications, we are dealers for one of the top open-source manufacturing software packages, xTuple.  See the home page of our website for more info.