Support-Blog-Sage-100 This is a blog about anything related to products and services that MBA Business Software supports.Employees on the support desk will add to this blog periodically. Check here for Tips and Tricks to help you with your daily tasks.

4 Tips for a Successful Year End

Written by Todd Martin on .

Here are just a few tips to keep in mind as you begin year end processing in Sage 100.
  1. General Ledger Closing ‐ While it’s a good idea to close modules in a timely fashion, the General Ledger can remain open for as long as you need while awaiting final processing (or audit adjustments) in other Modules. A GL that’s still open for 2017 will NOT prevent you from entering transactions for the new year.

  2. Payroll Planning ‐ Even if your company is on a fiscal year, you’ll need to close out payroll at the end of the calendar year. All W‐2’s and quarterly reports must be printed before payroll is closed in order to process the first payroll for 2018.

    NOTE: This does NOT apply to the new Payroll 2.0 which now allows two calendar years to be open so you don't have to run year‐end tax reports and W‐2's before processing payroll for 2018.

  3. Check Your Version Number ‐ Closing procedures can vary depending on which version of Sage 100 you’re currently running.  For Version 4.0 or above, do the following to identify both your version number and service pack:

    Select Help > About Sage 100

  4. Master Console ‐ Once you’re ready to close, you need to make sure all users are out of the system. That’s where the Master Console comes in handy. This utility provides a snapshot of all users currently logged into Sage 100, the workstation being used, what programs/tasks they’re using, and more. You can also broadcast a message to all users or even shut them down remotely.

    To launch the Master Console:

    Select File > Master Console

©2017 Juice Marketing, LLC. http://www.juice-marketing.com. All rights reserved. This article content may not be reproduced (in whole or in part), displayed, modified or distributed without express permission from the copyright holder.

INTRODUCING SAGE 100 2018

Written by Todd Martin on .

Sage 100 and 100c Version 2018 are now available. This newest version includes enhancements for Job Cost, warehouse management, bar coding, and a roll-out of the long-anticipated Payroll 2.0. Let’s take a closer look.

Note: Some of the features covered in this article are for Sage 100c only

Job Cost and Payroll 2.0

With Sage 100 2018, both the Job Cost and Payroll modules have been totally redesigned and modernized to improve performance and usability. In both modules, many tasks have been reorganized to provide a better workflow and more efficient data entry. In particular, the following interface enhancements have been applied:

  • Data entry grids have been implemented to improve efficiency
  • Selection grids are available on most report task windows and elsewhere
  • Calculator buttons have been added to dollar amount fields
  • Calendar buttons have been added to date fields
  • Hyperlinks to related tasks have been added where applicable

Note: As a result of the extensive improvements to Payroll, the TimeCard module is not currently compatible with Payroll 2.0. However, a compatible version of TimeCard will be released in a product update during the first half of 2018.


For full details on new features and changes in Payroll, check out the Payroll 2.0 Upgrade Guide.

Inventory Management and Bar Coding

In the Inventory Management module, new status settings are now available to help you better manage warehouses:

Continue Reading

Sage 100 2017 Product Update 3 (5.40.3.0)

Written by Todd Martin on .

The following is a list of enhancements and corrections added to Sage 100 2017.3

Product updates are cumulative; in other words, this update includes all enhancements and program corrections found in prior updates for version 2017. Smart Update will install only the programs that have been updated since your last update was installed.

Sage 100 Advanced and Premium Workstation Synchronization automatically updates the client workstations.

If you use Sage 100 Standard over a network, run WKsUpdate Standard.exe on each workstation. This program is located in the ..\mas90\wksetup folder on the server where Sage 100 2017 Standard is installed. All Sage 100 updates must be installed on the server where Sage 100 is installed.


Accounts Payable

  1. Error 26 SY_ReportUI.pvc 1453 no longer occurs when printing Accounts Payable checks and using a semicolon in the check or the stub message.
  2. A not-on-file vendor is no longer being created during Accounts Payable Invoice Data Entry when entering multiple invoices for the same vendor without existing Invoice Data Entry.
  3. Error 84, AP_DeletedChangeVendors_ui.pvc 2690 no longer appears when running the Delete and Change Vendors utility when backorder or completed purchase orders exist for the vendor.

Accounts Receivable

  1. AR_SalespersonCommissionWrk UDF is now being updated by AR_SalespersonCommission LinkUpdated field when running AR Salesperson Commission Report.
  2. Customer Listing now prints only inactive employees when Customers to Print option is set to Inactive Only.
  3. The message "Salesperson is not in division ##. The default salesperson ##- for customer ##-xxx will be used" pops up when trying to adjust Finance Charge invoices in Accounts Receivable Invoice Data Entry.
  4. Statement for customers with zero balances now only print when there is activity in current month when selecting to Include Zero Balance Customers and Zero Balance Invoices 'Current Month Only'. Previously, all customers with zero balance were printing regardless of current month activity.
  5. Customer Statement printed from Customer Maintenance now keeps the Customer Number in the selection grid when changing form code.

Bill of Materials

  1. Costed Bill of Materials Report, for Selection of Bills, is now excludes the cost of the level defined.

CRM

  1. Error 1 SO_SalesOrder_Bus.pvc 1612" no longer occurs when creating a Order or Quote in Sage CRM when integrated with Sage 100 and entering a comment over 1175 characters. CU_OrderQuoteDetail.M4T cannot contain over 1000 characters.

Customizer

  1. Default value is now being saved in User-Defined Field and Table Maintenance when Maximum Length is set to 1 and Control Type is either Drop-Box or List-Box.

e-Business Manager

  1. "An error occurred while attempting to process the page you requested." is no longer being returned when viewing a shopping cart with an Advanced Setting for IT_ShoppingCartHeader

Fixed Assets

  1. Deleted assets no longer show on the posting exception report when running period end processing in Sage 100.

Inventory Management

  1. In Sales Order Entry and Invoice Data Entry, item auto-complete no longer only lists miscellaneous items after accessing a customized Customer Maintenance from within Sales Order Entry or Invoice Data Entry.
  2. The 'On PO' quantity is now updated when a Purchase Order is created if Item Maintenance Reorder window is open.
  3. Warehouse description is no longer missing from Quantity Transaction History during drill down.
  4. The Inventory Sales History Report now prints when using selection criteria containing %Decrease Qty Sold Prior or %Increase Qty Sold Prior.

Library Master

  1. Error: "The save/update credit card information to Customer credit card is required." is no longer occurs when trying Make changes to a Repetitive Invoice that was upgraded from 4.50 and older.
  2. Error 60 SY_Gridhandler.pvc 1219 is no longer occurs when sorting more than 1 column on both Checks and Dep/Adjust in Reconcile Bank on Sage 100 Standard.
  3. Task scheduler is no longer ignoring company parameters as defined - Executes for company Key 1.
  4. Error:\"(Tax Code) is not numeric\" no longer occurs when selecting YES to “Do you want to change the existing sales tax schedule”. When changing a customer's zip code, the Tax Schedule updates based on ZIP XRef set up.

Payroll

  1. Renumbering employees mid-month and using both employee #s in tax calculation in the same month is no longer causes tier count exceeded issues.
  2. Direct Deposit Sync error no longer occurs when a random unprintable character exists in the payload - inflating (rc = -5) error in reverb.
  3. When Payroll has expired or is no longer part of the key, CI_eFilingHistory.m4p can be run from SYZCON in order to access Federal and State eFiliing forms from history.

Purchase Order

  1. "+1.42" is no longer appended to various descriptions in the Purchase Order Entry grid when scrolling from a Master or Repeating Order.

Return Materials Authorization

  1. Error 65 SY_OpenObject.pvc 95" is no longer occurs when generating documents for a RMA subsequent to partially receiving the same RMA.
  2. Deleting a batch in RMA Receipt Entry now removes the record from RA_ReceiptTierDistribution.
  3. Credit memos generated from RMA now correctly debit the Inventory G/L Account from Miscellaneous Item Maintenance. Previously, credit memos generated from RMA both debited and credited the Cost of Goods G/L Account from Miscellaneous Item Maintenance.

Sales Order

  1. In Sales Order Entry and Invoice Data Entry, auto complete now returns the same list of items when adding lines after using the Customer No. hyperlink to open Customer Maintenance, when Customer Maintenance has been customized.
  2. Pay Balance box is now available for selection in Sales Order Invoice Data Entry when a deposit is processed in Sales Order Entry.
  3. When using Sales Order Defaults the Ship date is based on options for default days until quote expires.
  4. In Shipping Data Entry, when entering a shipped quantity and clicking the Next Package No. or Item Packaging buttons, the row is now saved.
  5. In a new quote, Print Pick Sheets box is now checked when the Default setting is checked for Print Pick Sheets.

Visual Integrator

  1. When running Visual Integrator Export using AR_CashReceiptsDetail as primary table and exporting data from AR_CashReceiptsHeader as well, data is now exported from both tables. Previously, only data from AR_CashReceiptsDetail was being exported.
  2. Warehouse Type is now corrected after importing causing issues with MRP report.

Sage 100 Supported Versions - as of 2018

Written by Todd Martin on .

Sage officially supports the current plus 3 prior versions of Sage 100. With the release of Sage 100 2018, here’s the updated list of supported versions and retirement dates:

Sage 100 (Standard, Advanced, Premium) 2018 2017 2016 2015
Release Date Oct 2017  Oct 2016 Nov 2015 Apr 2015
Sage Phone Support Retirement 1 9/30/2021  9/30/2020 9/30/2019 9/30/2018
Year End IRD Updates 12/31/2020
(Use eFiling & Reporting)
12/31/2019 
(Use eFiling & Reporting) 
12/31/2018 
(Use eFiling & Reporting)
12/31/2017
(Use eFiling & Reporting)
Tax Table Updates N/A 12/31/2019 
(2019Q4)
12/31/2018 
(2019Q1)
12/31/2017 
(2018Q1)
Product Updates March 2019 March 2018  June 2017 June 2016
Hot Fixes 6/30/2020 6/30/2019  6/30/2018 6/30/2017
Online Support Knowledge Base Yes Yes Yes Yes

MBA will support customers on plan for all versions of Sage 100.

©2017 Juice Marketing, LLC. http://www.juice-marketing.com. All rights reserved. This article content may not be reproduced (in whole or in part), displayed, modified or distributed without express permission from the copyright holder.

Sage CRM

Written by Todd Martin on .

Why Mobility Matters With CRM

Perhaps more than any other department in your company, sales people spend as much time on the road as they do in the office. To stay productive, they need access to data, transactions, and customer information wherever they are. That’s why mobility matters when it comes to CRM. In this article, we’ll explain why.

It’s More Than Window Dressing


The ability to use CRM on a mobile device is about more than just keeping up with industry trends or wowing companies with gee whiz technology. There’s real business benefit in making sure that

Continue Reading

Subscribe to Newsletter
Subscribe here for MBA Business Software's newsletter and product information to stay informed about the products and services offered by MBA.

90 Minds
90 Minds Consulting Group is an 
association of proactive consulting professionals who combine technology skills while still operating their own independent companies.

MBA Business Software
1117 Perimeter Center West, 
Suite E210
Sandy Springs, Georgia 30338
(P) 678-495-5700 
(F) 770-399-5772

twitterfacebookyoutubefeedlinkedinGoogle+