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.

2018 - The Road Ahead for Sage 100

Written by Todd Martin on .

Sage recently provided us with a glimpse of the future for both Sage 100 and 100cloud including development goals, new features planned in upcoming releases, and continued expansion of the ecosystem of connected apps. Let’s take a closer look at the road ahead for your ERP software.
 

Product Vision and Strategy

One word that describes all current and future product development goals is modernization. That applies to modernizing not only the underlying technology, but to the user experience when it comes to things like ease of use, screen navigation, and the installation process. It also means that if you need to migrate from Sage 100 or 100cloud to another Sage product, it will be as easy as updating.

Continue Reading

Sage 100 2017 Product Update 4 (5.40.4.0)

Written by Todd Martin on .

The following is a list of corrections and selected enhancements added to Sage 100 2017.4
For a full list of Enhancements, refer to the What's New page inside the Product.

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. Accounts Payable Adjusted Invoice no longer paid twice.

Accounts Receivable

  1. Error 20 AR_AgedInvoiceReport_rpt.pvc 386 is no longer occurred when previewing/printing the Accounts Receivable Aged Invoice Report.
  2. Correct amount for discounts allowed and A/R GL accounts posted to GL shown on Sales Journal Recap by Division when printing/updating.
  3. Fix Error: "<Customer Number> is in use by another user and can only be viewed" in Price Level by Customer Maintenance.
  4. Error 47 CI_CustomerFormatter.pvc 100 is no longer occurred when entering cash receipts for Cash customer.
  5. Schedule text is not displayed over Exemption No text on Sales Order Invoice Data Entry Header panel when Sales Tax Reporting is disabled.


Bar Code

  1. Invoices getting imported into Sage 100 through Bar Code were getting the correct Ship Date set from the Ship/Expire Date entered on the sales order.

Bill of Materials

  1. Costed Bill of Materials Report with Report Type Selection of Bills now ignores Integer Unit of Measure for Miscellaneous Charges.
  2. The Component Extended Description will now print on first and any additional Bill of Materials Picking Sheets.

CRM

  1. Sage 100 Rebuild CRM no longer cuts off CRM Company Names more that 30 characters long.
  2. Added information to the "Cannot Synchronize Data with Sage CRM" message to help resolve the issue when no company records exist in Sage CRM.
  3. Quick Order Entry Component.exe is now being installed to the servers ..\mas90\CRM directory.
  4. Memo button visible when accessing Customer Maintenance via Sage CRM.
  5. Launching Customer Maintenance and editing the customer immediately after linking a company to a customer no longer returns the message "Record has been changed by another user andthe changes will not be saved upon accept".
  6. Import into AR_Customer does create new CRM companies automatically.

Customizer

  1. Drop-Box UDF no longer loses Drop-Box Functionality when Panel is Modified.
  2. Required UDF is being enforced.

Fixed Assets

  1. Error: "Report output exceeds printer width or record length exceeded on file write operation" is now fixed.

Inventory Management

  1. There are no Unit Cost discrepancies for FIFO component item in BOM Production Entry and Disassembly.
  2. The Retail Price is not disabled anymore, if user moves to different tab and check or uncheck the Allow Returns check box.

Job Cost

  1. Last invoice from previous job are appearing on the Job Masterfile Maintenance on Billing History tab for new Job if same customer.

Library Master

  1. No "Restrict Accounting Date to Current and One Future Period" allows users to change posting date to more than one future period.
  2. The following message is showing when user ran the rebuild key files for the AP_Audit.M4T with the Integrity check option. No problems have been found during the Integrity test.
  3. Dates from secondary tables are now sorted correctly in Custom Lookups.
  4. Fixed the Error: "Unable to view" [name of report, register etc] Database Connector Error:[Database Vendor Code:9]".

Paperless Office

  1. On the fly "From" e-mail address is now used when Electronically Delivering Accounts Payable Check Remittance Advice. Note that the Electronic Delivery button has been moved from the check printing and stub printing screens. The Electronic Delivery for Forms screens now appears after the user says Yes to update the check register.
  2. Paperless Office output "Print/PDF for Print Delivery Option" is now available in Direct Deposit Stub Printing when "Deliver During Check Register Update" is not selected in Paperless Office Form Maintenance.
  3. Error message "The column is not part of the key" no longer occurs after installing 2017 TTU and selecting existing Journal and Register Maintenance for P/O Daily Transaction Register in Paperless Office for Sage 100.

Purchase Order

  1. The PO numbers are showing with the Alpha numeric after PO # 9 - Example - starts from 0000###, 9000### then A000### and no special characters are showing for PO Number after PO#9.
  2. Purchase Order Variance Register no longer only shows the First Invoice number.

Return Materials Authorization

  1. Option category now prints actual option description in RMA printing.

Sales Order

  1. Sales Order Entry and SO Invoice Data Entry Component items showed the correct qty ordered when "Kit" Bill is exploded due to masking.
  2. The 'Generate PO' button is hidden when 'Enable Purchase Order Generation During Sales Order Entry' is N.
  3. The Deposit Amt is showing as $0:00 for credit card and check, if user changed from Standard to Repeating order.
  4. AR Customer/Invoice Tab now shows a balance due for the invoice instead of 0.
  5. Quote Expire Date using Default Days Until Quote Expires from SO Options when Standard is selected as the default Sales Order Type in Default Values for Sales Order Entry .

System Setup

  1. Sage 100 Premium install no longer allows non-premium modules and demo data companies to be installed.

Visual Integrator

  1. Visual Integrator module, no longer allows importing records into Payroll Data Entry for Inactive or Terminated employees.

Sage 100 2018 Product Update 2 (6.00.2.0)

Written by Todd Martin on .

The following is a list of corrections and selected enhancements added to Sage 100 2018.2
For a full list of Enhancements, refer to the What's New page inside the Product.

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

Workstation Synchronization has been enhanced to update Sage 100 Standard Workstations along with Sage 100 Advanced and Premium Workstations. Sage 100 Standard Users are no longer required to run WksUpdate Standard.exe on each Sage 100 Standard Workstation. 

All Sage 100 updates must be installed on the server where Sage 100 is installed.


Accounts Payable

  1. Help for A/P Invoice History Inquiry has been enhanced.
  2. Unable to enter Amount on Credit Memo in Job Cost Distribution Detail when reversing an electronic payment is now fixed.

Accounts Receivable

  1. Error 20 AR_AgedInvoiceReport_rpt.pvc 386 is no longer occurred when previewing/printing the Accounts Receivable Aged Invoice Report.
  2. Correct amount for discounts allowed and A/R GL accounts posted to GL shown on Sales Journal Recap by Division when printing/updating.
  3. "Customer On Credit Hold" text font color is now red in Customer Maintenance version 2018.
  4. Fix Error: "<Customer Number> is in use by another user and can only be viewed" in Price Level by Customer Maintenance.
  5. Error 47 CI_CustomerFormatter.pvc 100 is no longer occurred when entering cash receipts for Cash customer.
  6. Schedule text is not displayed over Exemption No text on Sales Order Invoice Data Entry Header panel when Sales Tax Reporting is disabled.
  7. Fixed Error: "Payroll is not installed on this system" in AR Salesperson Maintenance when clicking Link button if Payroll is not installed.
  8. The Error: "65 CI_AuditTracking.pvc 355" is not occurred when saving new credit card in customer maintenance with AR Audit tracking enabled
  9. The Cash Receipts records are updating to AR or Job Cost correctly.


Bar Code

  1. Invoices getting imported into Sage 100 through Bar Code were getting the correct Ship Date set from the Ship/Expire Date entered on the sales order.

Bill of Materials

  1. The Component Extended Description will now print on first and any additional Bill of Materials Picking Sheets.

CRM

  1. Sage 100 Rebuild CRM no longer cuts off CRM Company Names more than 30 characters long.
  2. Added information to the "Cannot Synchronize Data with Sage CRM" message to help resolve the issue when no company records exist in Sage CRM.
  3. Quick Order Entry Component.exe is now being installed to the servers ..\mas90\CRM directory.
  4. Import into AR_Customer does create new CRM companies automatically.

Customizer

  1. Drop-Box UDF no longer loses Drop-Box Functionality when Panel is Modified.
  2. Required UDF is being enforced.

Fixed Assets

  1. Error: "Report output exceeds printer width or record length exceeded on file write operation" is now fixed.

General Ledger

  1. General Ledger Financial Reports displayed data on Sage 100 2018.1 Premium.

Job Cost

  1. Last invoice from previous job are appearing on the Job Masterfile Maintenance on Billing History tab for new Job if same customer.
  2. AP Check Register no longer hangs during update when integrated with Job Cost.
  3. An Error 65 CI_JobNo_VAL.pvc 69 no longer occurs in Job Billing Selection or Job Billing Data Entry.
  4. The Cost Code Format is no longer invalid when attempting to enter different segmented CostCode in Cost Code Maintenance in Sage 100 2018.
  5. The message changed as below on the prompt message box.Purge Closed Jobs Dated on or Before.
  6. Users are now able to enter an Actual Percent Complete greater than 9% in Job Billing Data Entry.
  7. User can able to proceed the Sales Tax Calculation with J/C Job Billing selected. There is no Error 88 AR_Salestaxcalculation_bus.pvc 119 displayed.
  8. Fix Error: "A missing GL account was found in Job Type: xxx" in Job Billing after converting to version 2018 and "Post to G/L for Work in Process" is unchecked in Job Cost Options.
  9. A/R Invoice with a job referenced is no longer adding $1 Sales Tax Billed to the invoice in Job Billing History - Version 2018.
  10. Calculated Overhead Allocation amounts from Job Posting Entry transactions are correct.
  11. Error 26 is not occurring for the Job Transaction Detail History Report & Job Transaction Detail Report when selecting Save As for the reports.
  12. Job Billing Data Entry Fixed Bill Totals tab is now displays the Job-To-Date Cost instead of the Year-To-Date Cost.
  13. Transaction Date is retained in Primary Grid when exiting Job Posting Entry.
  14. Trans Date in Job Posting Entry is now defaults to Module Date not System Date.
  15. Cost Code Detail Unit Price and Unit Cost amount can be entered after the decimal.
  16. Job Billing Data Entry line Bill Amount is recalculate correctly when Bill Rate is changed for a Time & Material job in version 2018.
  17. Fix Job Billing Register update to G/L does not relieve WIP when Post to G/L for WIP is selected in Job Cost Options.

Library Master

  1. The following message is showing when user ran the rebuild key files for the AP_Audit.M4T with the Integrity check option. No problems have been found during the Integrity test.
  2. New logic added to strip leading spaces and spaces in the middle of a date field which creates invalid date and produces Error: "Unable to view" [name of report, register etc] Database Connector Error: [Database Vendor Code:9]".
  3. Dates from secondary tables are now sorted correctly in Custom Lookups.
  4. Error 13 no longer occurs after installing 2018.1 on a 2018 installation without PR installed.
  5. Fixed the Error: "Unable to view" [name of report, register etc] Database Connector Error:[Database Vendor Code:9]".
  6. Auto-Complete is not slow when running with a large data set on SQL.

Paperless Office

  1. On the fly "From" e-mail address is now used when Electronically Delivering Accounts Payable Check Remittance Advice. Note that the Electronic Delivery button has been moved from the check printing and stub printing screens. The Electronic Delivery for Forms screens now appears after the user says Yes to update the check register.
  2. Error message "The column is not part of the key" no longer occurs after installing 2017 TTU and selecting existing Journal and Register Maintenance for P/O Daily Transaction Register in Paperless Office for Sage 100.
  3. An Error 46 PL_CommonUtility.pvc 2912 no longer occurs when printing the Labor Distribution Report and using Job Number as report format.

Purchase Order

  1. The PO numbers are showing with the Alpha numeric after PO # 9 - Example - starts from 0000###, 9000### then A000### and no special characters are showing for PO Number afterPO#9.
  2. Receipt of Goods Posting Comment to Job Cost is no longer missing the Vendor Number and Receipt number in version 2018.1.
  3. PO Material Requisition Register update no longer hangs when there are multiple lines with Job Cost detail in Sage 100 2018.

Sales Order

  1. The 'Generate PO' button is hidden when 'Enable Purchase Order Generation During Sales Order Entry' is N.
  2. The Deposit Amt is showing as $0:00 for credit card and check, if user changed from Standard to Repeating order.
  3. AR Customer/Invoice Tab now shows a balance due for the invoice instead of 0.
  4. Help for S/O Printing from history.
  5. Quote Expire Date using Default Days Until Quote Expires from SO Options when Standard is selected as the default Sales Order Type in Default Values for Sales Order Entry.

System Setup

  1. Sage 100 Premium install no longer allows non-premium modules and demo data companies tobe installed.

Visual Integrator

  1. Visual Integrator module, no longer allows importing records into Payroll Data Entry for Inactive or Terminated employees.

Work Order Processing

  1. Error message is not appearing as follow The Warehouse Code is required" and we added the logic for inactive warehouse code - User will not be added the Inactive Warehouse.

Perpetual License Pricing Change Coming in March 2018

Written by Todd Martin on .

While many software providers have moved solely to subscription-based licensing, Sage continues to offer both subscription and perpetual license options to customers. In order to accommodate the added cost of maintaining both options, Sage announced that they’ll be adjusting the price of Sage Business Care prices for Sage 100 perpetual licenses.

Beginning in March, Perpetual customers will see an annual increase of 20% on their renewal notification for any Sage Business Care plan renewing on or after March 1, 2018.

Sage states that pricing adjustments are determined based on an annual review across their entire solution portfolio which considers market conditions, the cost of doing business, added value delivered through major product releases, and various other factors. The price increase reflects the added personnel and resources required to support both subscription and perpetual license models.

Note: the increase does not affect Sage 100cloud subscription licenses which remain the same.

©2018 Juice Marketing, LLC. https://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 - 2018

Written by Todd Martin on .

Introducing Sage CRM 2018

Sage CRM 2018 is now available. Enhancements in this newest version focus on continued calendar improvements, ease of use, and simplified navigation across the product. Let’s take a closer look.

Sage CRM 2018 Calendar

You may have noticed that enhancing Calendar functions has been a focus over the last couple of new releases and version 2018 continues that trend. Because the Calendar is at the heart of so many activities in Sage CRM, the following improvements are now available:

Task Quick Complete - Allows you to complete a task with a single click. Completed tasks are automatically removed from the screen when filtering by ‘Pending’.

Drag and Drop Calendar Appointments - Appointments can be moved by dragging and dropping it to a new time in the Day, Week, Work Week and Month views.

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
Headquarters
1117 Perimeter Center West, 
Suite E210
Sandy Springs, Georgia 30338
(P) 678-495-5700 
(F) 770-399-5772

Remote Office
Chicago, Illinois

twitterfacebookyoutubefeedlinkedinGoogle+