Sage 100 project: Company split

One of C&G's customers decided to split one of their companies into two legal entities.  C&G assisted the customer with developing a plan for the split, including the financial aspects (GL trial balances, accounts receivable customer open invoices and accounts payable open invoices) to the distribution and manufacturing aspects (work order operation codes, bills of materials, part numbers and open quantity balances on items).  The process went smoothly with the work being divided up between the customer and C&G. 

Sage 100 customer project: Simplify pricing

C&G recently assisted a customer by dramatically simplifying the pricing rules in their Sage 100 ERP system. 

Over the years, pricing records had been added at periodic intervals and had become cumbersome to maintain on a consistent basis.  Taking a different approach to their pricing model and leveraging powerful capabilities with the system, we helped our customer translate their written pricing practices into Sage 100 pricing rules, reducing the number of pricing records they needed to maintain from 7000 down to only 5.

C&G Consulting Named to Bob Scott’s VAR Stars 2012

C&G Consulting has been selected as a member of the Bob Scott’s VAR Stars for 2012, a group of 100 organizations honored for their accomplishments in the field of mid-market financial software. "This is exciting news for our firm and we are honored to be recognized for helping small and mid-size businesses with their technology needs.” said Rick Sovitzky, partner.

C&G Consulting was selected based on factors such as growth, industry leadership and recognition, and innovation. “Each year, 100 VAR Stars are picked from the best organizations that market financial software. It is always an honor to recognize those who contribute to the development of our business,”said Bob Scott, executive editor.

For close to 20 years, C&G Consulting has been helping businesses throughout southeastern Wisconsin and the nation manage their technology investments. Our team of professionals includes Microsoft Certified System Engineers, Certified Public Accountants, and Certified Forensic Analysts.

As a leading technology services firm in the Midwest, C&G Consulting actively participates in and serves on the board of many industry associations, including Alliott Group, Information Technology Alliance (ITA), and the Association of Information Technology Professionals (AITP).

Bob Scott has been informing and entertaining the mid-market financial software community via his email newsletters for 13 years. He has published this information via the “Bob Scott’s Insights” newsletter and website since 2009. He has covered this market for 21 years through print and electronic publications, first as technology editor of Accounting Today and then as the Editor of Accounting Technology from 1997 through 2009. He has covered the traditional tax and accounting profession during the same time and has continued to address that market as executive editor of the Progressive Accountant since 2009.

Updated 2013 Q1 Tax Tables for Sage 100 ERP

Sage has released a new update to the Sage 100 ERP (formerly MAS 90 / MAS 200) payroll tax tables for the first quarter of 2013.  This update contains the new Federal withholding tables released by the IRS last week as well as the federal dependent exemption increase to $3,900.  Changes were also made to various state tax tables (including Illinois).

To download these new tax tables, log into the Sage Customer Portal at https://customers.sagenorthamerica.com.  On the left side, under the Download Product Updates section, click the Tax Table Update link.  To verify that the new tax table update was installed successfully, preview the Installed Modules Listing under Library Master>Reports and verify that the 2013-Q1 Tax Tables show a release date of 1/4/2013.

The Federal tax tables for 2013 also include the following:

• an increase in the employee Social Security tax rate from 4.2% to 6.2%
• an increase in the Social Security wage base for both employees and employers to $113,700
• a calculation for an additional employee Medicare tax of .9% on wages over $200,000

For additional assistance with installing this update, give us a call at 877-526-8226 or email support@c-gconsulting.com.

Changes to Year-End Updates for Sage 100 ERP

Tax Year 2013 is the last year Sage will maintain and support tax forms within the standard Sage 100 (formerly MAS 90 / MAS 200) Accounts Payable, Payroll and Electronic Reporting modules. 

Filings for Tax Years 2014 and later will only be available with the Sage 100 ERP integration to Federal and State eFiling and Reporting, powered by Aatrix, which is available with Sage 100 ERP version 4.3 and above. The Payroll Tax Tables will continue to be maintained for the supported versions of Sage 100.

Note for Sage 100 ERP Version 4.3:   The 2013 Q1 Tax Table Update, the 2012 Interim Release Download and the 2013 Form 941 (to be released in March 2013) are the last updates that will be released for version 4.30.  You must upgrade to a more current version of software in order to receive future updates.

For assistance with upgrading your Sage 100 software or to discuss your year-end needs, contact us at 877-526-8226 or support@c-gconsulting.com. 

2012 Sage 100 Year-End Downloads Now Available

Sage has recently released year-end tax updates for customers that use Sage 100 (formerly MAS 90 / MAS 200) Payroll and Accounts Payable.

You can access these year-end updates as follows:

·        Log into the Sage Customer Portal at https://customers.sagenorthamerica.com.   

·        On the left side, under the Download Product Updates section, click either the Tax Table Update or Interim Release Download Link.

Included are changes for Payroll and Payroll Tax Tables, Federal and State eFiling and Reporting, Electronic Reporting, and Accounts Payable.  The 2012 Q4 Interim Release Download is required to be loaded in order to use eFiling and Reporting for 1099s and W-2s, the Electronic Reporting module and AP 1099 reporting.  In order for the 2013 Medicare changes to calculate correctly, you must install the 2012 Interim Release Download prior to installing the 2013 Q1 Tax Table Update and prior to running your first payroll for 2013.

Reminder:  As additional federal or state updates are received, tax table updates will be posted throughout the month of January to the Portals.

Listed below are the versions of Sage 100 that users will  need to be on in order to load the 2012 Q4 IRD and 2013 Q1 TTU.   

• 4.30.0.18:  must also have last year’s (2011) year-end IRD installed

• 4.40.0.1:  must also have last year’s (2011) year-end IRD installed or PU 8 installed

• 4.50.0

• 2013

If you have any enhancements, you must first verify that these enhancements are compatible with the 2012 Q4 IRD.  You also need to load the enhancements after loading the appropriate product update or 2012 Q4 Interim Release Download.

View the 2012 year-end frequently asked questions for more information: 
2012 Frequently Asked Questions

For additional assistance with your payroll and accounts payable year-end needs, give us a call at 877-526-8226 or support@c-gconsulting.com.

Sage 100 project - Automating picking sheet printing

One of our customers has remote salespeople that enter in orders in the evening after they've made their sales calls and onsite visits.  Shipping personnel start at 6:30 am in order to pick and ship last night's orders.  C&G assisted this customer with automating their picking sheet printing process so that all orders entered after hours print before shipping personnel arrive.  Salespeople can also place an order on "hold" so that it won't print, if they wish to come back to it later for revisions.

Sage 100 2013 - coming soon

A few technical notes about the upcoming new release of Sage 100 (formerly MAS 90 /

MAS 200 version 2013:

• Microsoft SQL Server 2012 will be supported
• Crystal Reports 2011 will be included
• A new 64-bit ODBC driver will be available

We'll be posting more informaiton about the release soon.