Sage 100 2017 Product Update 1 (5.40.1.0)

Written by Kate Phillips on .

Article Index

The following is a list of enhancements and corrections added to Sage 100 2017 and released on February 21, 2017.

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.



Advanced Lookup Engine


  1. UDF with "DESCRIPTION" in name no longer causes F4 key to behave differently in ALE list lookup.  DevID 105938 Knowledgebase ID 76025



Accounts Payable


  1. The 1099 Electronic Consent Signed is required message no longer occurs when selecting Accept after a change to Vendor Maintenance. Issue only occurred after migrating and converting data from 4.50 or earlier.  DevID 106281 Knowledgebase ID 75590

  2. Help updates added to Vendor Delete and Change Utility describing when multiple deletes/changes are entered at one time, they are still processed one at a time, in the order they are entered. The deletes are processed first, followed by the changes.  DevID 106345 Knowledgebase ID 78522

  3. Added new 1099-INT form changes required for tax filing year 2016: Box 12 - Bond premium on Treasury obligations.  DevID 105900

  4. Accounts Payable check is no longer applied to the incorrect invoice after a paid invoice is purged and new invoice is created with same invoice number.  DevID 106186 Knowledgebase ID 8005382284


Accounts Receivable


  1. Accounts Receivable Aging on Customer Statement is not recalculated when parameters are changed and Keep Window Open After Print/Preview is selected.  DevID 106192 Knowledgebase ID 77511

  2. "Errors have been encountered." no longer occurs after printing Cash Receipts Journal for multiple receipts with similar check numbers.  DevID 106656 Knowledgebase ID 80145

  3. Now able to select a custom report setting when opening the A/R Aged Invoice Report from within Customer Maintenance > Invoices tab.  DevID 106565 Knowledgebase ID 79616

  4. No longer receive Error 43 AR_StatementPrinting_rpt.pvc 570 when printing Accounts Receivable Statements that contain over 100,000 invoices.  DevID 105115 Knowledgebase ID 69428



Bill of Materials


  1. Miscellaneous charge descriptions in Single-Level Bill of Materials Report now correspond to the Miscellaneous charge descriptions in Bill of Material Maintenance when the Miscellaneous charge description is overwritten. DevID 106239 Knowledgebase ID 77723

Common Item


  1. Miscellaneous Item History by Period report now correctly displays data for the current year and the prior year when Include Prior Year Information is selected.  DevID 105871 Knowledgebase ID 74602


Customizer


  1. Now able add additional fields from AR_OpenInvoice.M4t to Invoices by Customer List Box in AR Cash Receipts Entry.  DevID 106327 Knowledgebase ID 78537

  2. AR_InvoiceHistoryHeader UDF is now properly displayed in A/R Invoice History Inquiry if UDF with same name exists in GL_DetailPosting.  DevID 106594 Knowledgebase ID 79776

  3. Error: "Field "UDF_<field name>" has already been placed on panel "PHEADER" of this customized library. To add this UDF to this panel, you must first remove it from panel "PHEADER"." when attempting to add a UDF to PHEADERW (the wide-screen panel) no longer occurs. DevID 106263 Knowledgebase ID 78297

  4. CI_Item UDF is now populating the work file when Inventory Labels are printed from Receipt of Goods. DevID 106461 Knowledgebase ID 79096

  5. Minimize and maximize buttons now display when increasing the height of the Customer Maintenance panel in Customizer. DevID 106454 Knowledgebase ID 79035


CRM


  1. Email and phone number are no longer deleted from Customer after deleting Person in CRM.  DevID 106567 Knowledgebase ID 79805

  2. The Error message "0001*0000000000 is not on file" when saving a CRM generated Sales Order, should no longer occur.  DevID 106399 Knowledgebase ID 78830

  3. When creating a new Prospect Quote description now correctly reads "OTF Quote".  DevID 106482 Knowledgebase ID 79180


Business Insights

  1. Business Insights Reports now displays expected results when date field operand is set to Last,This, or Next for Week, Month, or Year.  DevID 106801 Knowledgebase ID 79579

  2. Error 26 no longer occurs when displaying dashboard when negative sales exist for a product line. Negative % is now treated as zero % in the pie chart. Also, product line with negative total sales is now excluded in the detail grid below the pie chart when number of detail lines is high enough to show every individual product line.  DevID 105962 Knowledgebase ID 76286


Sage Fixed Assets Link


  1. Updating the Invoice register in Accounts Payable or Receipt Register in Purchase Order now creates the asset in Sage Fixed Assets when a template is selected during data entry.  DevID 106471 Knowledgebase ID 79161

General Ledger


  1. The debit amount no longer displays under the Beginning Balance column when the General Ledger Detail Report is printed in the condensed format. The debit amount now correctly displays under the Debit column heading.  DevID 106765 Knowledgebase ID 80396

  2. No longer receive error when changing GL Account Structure that has less than 9 characters to more than 9 characters.  DevID 106251 Knowledgebase ID 53150


Inventory Management


  1. Inventory sales history report by customer is no longer missing records in the work table for Premium version.  DevID 106433 Knowledgebase ID 78933

  2. Standard Cost Adjustment Register in Inventory Management now displays the correct sign for negative quantity on hand.  DevID 105867 Knowledgebase ID 75284

  3. The Item Code is required message no longer appears when selecting 'Alternate' in Item Maintenance for a Bill that has been set to 'Inactive'.  DevID 105902 Knowledgebase ID 75482


Library Master


  1. Classic theme launcher no longer hangs when user receiving broadcast message tries to access launcher tasks prior to clicking the 'OK' button at the broadcast message. The Classic launcher is now locked until the user clicks 'OK'. DevID 106495 Knowledgebase ID 79234

  2. In Accounts Payable Repetitive Invoice Selection, error 88 no longer occurs when entering text in vendor code field in selection grid when using full text autocomplete.  DevID 106554

  3. Link to Sage 100c benefits are now accessible via the Information Center page. DevID 106779

  4. Error: "Sage 100 has stopped working" no longer occurs when remote desktop user logs into Sage 100c 2016 using “Standard” desktop view in Terminal Services.  DevID 106763 Knowledgebase ID 81240


Purchase Order


  1. Quantity on purchase order is now correct in Item Inquiry on Quantity and Orders tabs after partial receipt completes Purchase Order.  DevID 106706 Knowledgebase ID 78679

  2. Quantity on purchase order is now correct in Item Inquiry on Quantity and Orders tabs after partial receipt completes Purchase Order.  DevID 106439 Knowledgebase ID 78679

  3. Purchase History Report now prints the correct period to date and year to date data when Inventory is not used. The report options for Fiscal Year and Accounting Period now appear. DevID 106443 Knowledgebase ID 78665

  4. After deleting a line from completed purchase order, the ON PO quantity calculates correctly in Item Maintenance.  DevID 106463 Knowledgebase ID 78838

  5. Purchase Orders are generated only for those items that have a vendor specified on the sales order line, when using Auto Generate from Sales Orders.  DevID 106441 Knowledgebase ID 78719

  6. The back order quantity now shows the correct back order quantity when using Copy From Purchase Order in Purchase Order Entry.  DevID 106423 Knowledgebase ID 78071

  7. Purchase Order total is now recalculating properly in Purchase Order History Inquiry for miscellaneous items that have been edited in Purchase Order Entry. DevID 106660 Knowledgebase ID 79912

  8. Error: "The Receipt Type failed validation on R,I,G." no longer occurs when selecting a Receipt Number from lookup in Receipt History Inquiry after manually entering a not on file receipt.  DevID 106632 Knowledgebase ID 79893


Payroll


  1. Payroll Quarterly Tax Report no longer includes employees with zero dollar in wages for current year.  DevID 106631 Knowledgebase ID 80048

  2. Subscription expiration checking, will now wait 5 days after subscription plan has expired before displaying expiration warning message.  DevID 106792

  3. Users with a valid Payroll Subscription of 151 to 200 employees, no longer receive a message to enter a valid license during a Product Update installation.  DevID 106848

  4. No longer receive message "Employees' pay will not be deposited into their bank accounts by the effective date xx/xx/xxxx. Two full banking days are required to complete direct deposit transactions" in Payroll Check Printing when Direct Deposit Interface option is set to 'Manually Send ACH File' in Payroll Options.  DevID 105829 Knowledgebase ID 75045

  5. Two new Offer of Coverage Codes have been added for ACA reporting:  

1J Minimum essential coverage providing minimum value offered to you; minimum essential coverage conditionally offered to your spouse; and minimum essential coverage NOT offered to your dependent(s)

1K Minimum essential coverage providing minimum value offered to you; minimum essential coverage conditionally offered to your spouse; and minimum essential coverage offered to your dependents(s).  DevID 106113                


Sales Order


  1. Delete button is no longer defaulted when Customer Credit History window auto displays for customer on credit hold when creating sales order. OK button is now the default. DevID 105866 Knowledgebase ID 75416

  2. Sales Order Ship Date change now changes the Promise Date for Miscellaneous Charges on the Lines tab in Sales Order Entry.  DevID 105991 Knowledgebase ID 76343

  3. When entering a duplicate Sales Order or Accounts Receivable invoice at the warning prompt "Invoice was already used. Would you like to accept?" the focus is now on the 'Cancel' button, to help prevent users from not entering duplicate invoices.  DevID 105064 Knowledgebase ID 69114

  4. Credit memos now posts by division segment when selected in SO Invoice Data Entry for Miscellaneous Codes or Special Items.  DevID 106360 Knowledgebase ID 78566

  5. Sales Order Daily Shipment Report now displays correct information when reusing deleted invoices.  DevID 106446 Knowledgebase ID 78990

  6. The Daily Shipment Report no longer displays deleted invoices/shipments when the Retain Deleted Invoices checkbox in Accounts Receivable Options is unchecked.  DevID 106269 Knowledgebase ID 78230

  7. Debit memo created for invoices paid by ACH payment type now sets 'Default Payment Type' to ACH.  DevID 106536

  8. Credit limit checking is now performed in Shipping Data Entry.  DevID 105984 Knowledgebase ID 76279


Visual Integrator


  1. Physical Count Variance Register now displays the correct quantity on hand value after importing serialized items into IM_PHYSICAL. DevID 103426 Knowledgebase ID 45154

  2. The field QuantityRequiredForWO in the table IM_ItemWarehouse.M4T is now being updated when importing into WO.MASTER with Visual Integrator. DevID 106488 Knowledgebase ID 8005600616

  3. DED_CALC_METHOD no longer fails validation when importing into PR.EMPDED. DevID 106214 Knowledgebase ID 78021

  4. DEDUCT_AMT_RATE is no longer rounded to 3 digits when importing into PR.EMPDED and DEDUCT_AMT_RATE is file assigned to rate from PR.DED. Note, on existing imports field will need to be removed and re-added to import all digits. DevID 106213 Knowledgebase ID 78020



PRODUCT UPDATE FILES
Updated by this release May require conversion
The following are updated by Sage 100 2017.1
providex.auc
providex.dcl
providex.dde
providex.ddf
providex.kdf
providex.prm
pvxview.gpd
pvxview.grp
pvxview.itm
pvxview.lnk
pvxview.src
pvxview.vue
AP AP_InvoiceHistory_ui.pvc
AR AR_CashReceipts.M4L
AR AR_CashReceiptsJournal_upd.pvc
AR AR_CashReceipts_bus.PVC
AR AR_CashReceipts_ui.pvc
AR AR_CreditCardCommonEntry.pvc
AR AR_CreditLimit_ui.pvc
AR AR_Customer_Svc.pvc
AR AR_Customer_ui.pvc
AR AR_InvoiceHistoryInquiry_ui.pvc
AR AR_Invoice_bus.pvc
AR AR_Invoice_ui.pvc
AR AR_StatementPrinting_rpt.pvc
BM BM_IndentedReport_rpt.pvc
BM BM_SingleLevelReport_rpt.pvc
CI CI_ItemCode_val.pvc
CI CI_MiscItemHistoryByPeriod_rpt.pvc
CM cm1ofc.soa
CM Cmwud3
CM CM_MaintHdr
CU CU_Common.pvc
CU CU_EmailLink_bus.pvc
CU CU_Opportunity_Svc.PVC
CU CU_PhoneLink_bus.pvc
CU CU_SCRMLink_bus.pvc
ES ES_Generate.pvc
ES ES_GenerateData.pvc
FL FL_FALink.pvc
FL FL_Options_bus.pvc
FL FL_Options_ui.pvc
GL GL_AccountStructure_ui.pvc
Help AP.chm
Help FAQs.chm
Help GL.chm
Help IM.chm
Help PO.chm
Home lib
Home pvxwin32.exe
Home lib _obj
Home lib _obj gridac.pvc
Home lib _obj mlac.pvc
IM IM_AliasItem_bus.pvc
IM IM_AlternateItem_bus.pvc
IM IM_ItemVendor_bus.pvc
IM IM_Physical_bus.pvc
IM IM_ReceiptLabelPrinting_rpt.pvc
IM IM_SalesHistoryReport_rpt.pvc
IM IM_StandardCostAdjustReg_upd.pvc
Launcher html
Launcher launcher.2016.exe
Launcher Launcher.old.exe
Launcher Sage.Erp100.Native.dll
Launcher html benefits.html
Launcher html images
Launcher html sage100c
Launcher html stylesheet.css
Launcher html welcome.html
Launcher html What.htm
Launcher html images 100cMFG.png
Launcher html images APAuto.png
Launcher html images AutoBank.png
Launcher html images Budgeting.png
Launcher html images eComm.png
Launcher html images eInvAdv.png
Launcher html images MBbasics.png
Launcher html images SIAB.png
Launcher html sage100c welcome.html
MASHome Lib
MASHome masrkc.dll
MASHome Microsoft.NET
MASHome Sage.PaymentCenter.Merchant.dll
MASHome Sage.PaymentCenter.OAuth.dll
MASHome Sage.PaymentCenter.Sage100.dll
MASHome START_UP
MASHome UpdateManifest.xml
MASHome Lib _repository
MASHome Lib _Updater
MASHome Lib _repository mas5.40
MASHome Lib _repository WorkstationFiles.txt
MASHome Lib _repository mas5.40 app
MASHome Lib _repository mas5.40 env
MASHome Lib _repository mas5.40 app any
MASHome Lib _repository mas5.40 app any Home
MASHome Lib _repository mas5.40 app any Launcher
MASHome Lib _repository mas5.40 app any manifest.conf
MASHome Lib _repository mas5.40 app any Home autoupdater.ini
MASHome Lib _repository mas5.40 app any Home Microsoft.NET
MASHome Lib _repository mas5.40 app any Home Newtonsoft.Json.dll
MASHome Lib _repository mas5.40 app any Home Newtonsoft.Json.xml
MASHome Lib _repository mas5.40 app any Home pvxwin32.exe
MASHome Lib _repository mas5.40 app any Home Sage.PaymentCenter.Merchant.dll
MASHome Lib _repository mas5.40 app any Home Sage.PaymentCenter.OAuth.dll
MASHome Lib _repository mas5.40 app any Home Sage.PaymentCenter.Sage100.dll
MASHome Lib _repository mas5.40 app any Home START_UP
MASHome Lib _repository mas5.40 app any Home Microsoft.NET Sage100.SLS.Client
MASHome Lib _repository mas5.40 app any Home Microsoft.NET Sage100.SLS.Client BouncyCastle.Crypto.dll
MASHome Lib _repository mas5.40 app any Home Microsoft.NET Sage100.SLS.Client
Microsoft.Practices.TransientFaultHandling.Core.dll
MASHome Lib _repository mas5.40 app any Home Microsoft.NET Sage100.SLS.Client Sage100.SLS.Client.dll
MASHome Lib _repository mas5.40 app any Home Microsoft.NET Sage100.SLS.Client SageNA.CE.SLS.Client.dll
MASHome Lib _repository mas5.40 app any Launcher html
MASHome Lib _repository mas5.40 app any Launcher launcher.2016.exe
MASHome Lib _repository mas5.40 app any Launcher Launcher.old.exe
MASHome Lib _repository mas5.40 app any Launcher Sage.Erp100.Native.dll
MASHome Lib _repository mas5.40 app any Launcher html benefits.html
MASHome Lib _repository mas5.40 app any Launcher html images
MASHome Lib _repository mas5.40 app any Launcher html stylesheet.css
MASHome Lib _repository mas5.40 app any Launcher html welcome.html
MASHome Lib _repository mas5.40 app any Launcher html What.htm
MASHome Lib _repository mas5.40 app any Launcher html images 100cMFG.png
MASHome Lib _repository mas5.40 app any Launcher html images APAuto.png
MASHome Lib _repository mas5.40 app any Launcher html images AutoBank.png
MASHome Lib _repository mas5.40 app any Launcher html images Budgeting.png
MASHome Lib _repository mas5.40 app any Launcher html images eComm.png
MASHome Lib _repository mas5.40 app any Launcher html images eInvAdv.png
MASHome Lib _repository mas5.40 app any Launcher html images MBbasics.png
MASHome Lib _repository mas5.40 app any Launcher html images SIAB.png
MASHome Lib _repository mas5.40 env any
MASHome Lib _repository mas5.40 env any CommonProgramFiles
MASHome Lib _repository mas5.40 env any manifest.conf
MASHome Lib _repository mas5.40 env any CommonProgramFiles Sage
MASHome Lib _repository mas5.40 env any CommonProgramFiles Sage Common Components
MASHome Lib _repository mas5.40 env any CommonProgramFiles Sage Common Components Help
MASHome Lib _repository mas5.40 env any CommonProgramFiles Sage Common Components Help 5.4
MASHome Lib _repository mas5.40 env any CommonProgramFiles Sage Common Components Help 5.4
AP.chm
MASHome Lib _repository mas5.40 env any CommonProgramFiles Sage Common Components Help 5.4
FAQs.chm
MASHome Lib _repository mas5.40 env any CommonProgramFiles Sage Common Components Help 5.4
GL.chm
MASHome Lib _repository mas5.40 env any CommonProgramFiles Sage Common Components Help 5.4
IM.chm
MASHome Lib _repository mas5.40 env any CommonProgramFiles Sage Common Components Help 5.4
PO.chm
MASHome Lib _Updater autoupdatecustom.conf
MASHome Lib _Updater cinfocustom
MASHome Microsoft.NET Sage.Data.Search
MASHome Microsoft.NET Sage100.SLS.Client
MASHome Microsoft.NET Sage.Data.Search Sage.Data.Search.dll
MASHome Microsoft.NET Sage100.SLS.Client Sage100.SLS.Client.dll
MAS_SYSTEM SY_ConversionDriver.M4T
MAS_SYSTEM SY_Message.M4T
MAS_SYSTEM SY_Module.M4T
MAS_SYSTEM SY_PopupXref.M4T
MAS_SYSTEM SY_System.M4T
MD mdwmqz
PO POZUZA
PO PO_GeneratePurchaseOrders.pvc
PO PO_PurchaseOrderDetail_bus.pvc
PO PO_PurchaseOrderHistory.pvc
PO PO_ReceiptHistory_ui.pvc
PO PO_ReceiptRegister_upd.pvc
PO PO_ReportUI.pvc
PR Prwrcb
PR PRWSDA
PR PR_ACAEmployer_ui.pvc
Reports GL_DetailReportCondensed.rpt
SO SO_CommonEntryDetail.pvc
SO SO_CRMSalesOrderRWC_Ui.pvc
SO SO_CRMSalesOrder_Ui.pvc
SO SO_DailyShipment_bus.pvc
SO SO_InvoicePayment_bus.pvc
SO SO_Invoice_Bus.pvc
SO SO_Invoice_Ui.Pvc
SO SO_SalesOrder_bus.pvc
SO SO_SalesOrder_ui.pvc
SOA startup.m4p
SOA SWQSCR.37154010
SOA SWQSCR.40054010
SOA SWQSCR.40554010
SOA SWQSCR.41054010
SOA SWQSCR.42054010
SOA SWQSCR.43054010
SOA SWQSCR.44001054010
SOA SWQSCR.4400154010
SOA SWQSCR.4400254010
SOA SWQSCR.4400354010
SOA SWQSCR.4400454010
SOA SWQSCR.4400554010
SOA SWQSCR.4400654010
SOA SWQSCR.4400754010
SOA SWQSCR.4400854010
SOA SWQSCR.4400954010
SOA SWQSCR.44054010
SOA SWQSCR.44554010
SOA SWQSCR.4501054010
SOA SWQSCR.4502054010
SOA SWQSCR.4503054010
SOA SWQSCR.4504054010
SOA SWQSCR.4505054010
SOA SWQSCR.45054010
SOA SWQSCR.4506054010
SOA SWQSCR.4507054010
SOA SWQSCR.4508054010
SOA SWQSCR.5000954010
SOA SWQSCR.5001054010
SOA SWQSCR.5002054010
SOA SWQSCR.5003054010
SOA SWQSCR.5004054010
SOA SWQSCR.5005054010
SOA SWQSCR.50054010
SOA SWQSCR.5006054010
SOA SWQSCR.5007054010
SOA SWQSCR.5008054010
SOA SWQSCR.5009054010
SOA SWQSCR.5100154010
SOA SWQSCR.5101054010
SOA SWQSCR.5102054010
SOA SWQSCR.5103054010
SOA SWQSCR.5104054010
SOA SWQSCR.5105054010
SOA SWQSCR.51054010
SOA SWQSCR.5106054010
SOA SWQSCR.5107054010
SOA SWQSCR.5201054010
SOA SWQSCR.5202054010
SOA SWQSCR.5203054010
SOA SWQSCR.5204054010
SOA SWQSCR.5205054010
SOA SWQSCR.52054010
SOA SWQSCR.5301054010
SOA SWQSCR.5302054010
SOA SWQSCR.5303054010
SOA SWQSCR.5304054010
SOA SWQSCR.53054010
SOA swquery
SOA sy0ctl.soa
SOA sy0dct.soa
SOA sy0dd2.soa
SOA sy0eop.soa
SOA sy0frm.soa
SOA sy1q01.soa
SOA sy1q02.soa
SOA sy1q03.soa
SOA sy1q04.soa
SY SY_Activation_ui.pvc
SY SY_DirectDepositApply.pvc
SY SY_Installation.pvc
SY SY_Launcher.M4L
SY SY_Launcher.PVC
SY SY_Metering.pvc
SY SY_Options_ui.pvc
SY SY_Registration.pvc
SY SY_ReportRuntime_Rpt.PVC
SY SY_ReportRuntime_UI.PVC
SY SY_SagePEP.pvc
SY SY_TableConversion0500.pvc
System_files MISC
System_files MISC EULA.txt
System_files MISC MASInstall.dll
WO wowvip
The following files or tables may undergo conversion in Sage 100 2017.1
None

Tags: Sage 100 ERP Product Updates Sage 100 Version 2017 Product Update v2017

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
6100 Lake Forrest Drive, 
Suite 520
Sandy Springs, Georgia 30328
(P) 678-495-5700 
(F) 770-399-5772

Remote Office
Chicago, Illinois

twitterfacebookyoutubefeedlinkedin