Sage 100 2017 Product Update 1 (5.40.1.0)
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
- UDF with "DESCRIPTION" in name no longer causes F4 key to behave differently in ALE list lookup. DevID 105938 Knowledgebase ID 76025
Accounts Payable
-
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
-
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
-
Added new 1099-INT form changes required for tax filing year 2016: Box 12 - Bond premium on Treasury obligations. DevID 105900
-
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
-
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
-
"Errors have been encountered." no longer occurs after printing Cash Receipts Journal for multiple receipts with similar check numbers. DevID 106656 Knowledgebase ID 80145
-
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
-
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
- 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
- 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
-
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
-
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
-
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
-
CI_Item UDF is now populating the work file when Inventory Labels are printed from Receipt of Goods. DevID 106461 Knowledgebase ID 79096
-
Minimize and maximize buttons now display when increasing the height of the Customer Maintenance panel in Customizer. DevID 106454 Knowledgebase ID 79035
CRM
-
Email and phone number are no longer deleted from Customer after deleting Person in CRM. DevID 106567 Knowledgebase ID 79805
-
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
-
When creating a new Prospect Quote description now correctly reads "OTF Quote". DevID 106482 Knowledgebase ID 79180
Business Insights
-
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
-
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
- 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
-
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
-
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
-
Inventory sales history report by customer is no longer missing records in the work table for Premium version. DevID 106433 Knowledgebase ID 78933
-
Standard Cost Adjustment Register in Inventory Management now displays the correct sign for negative quantity on hand. DevID 105867 Knowledgebase ID 75284
-
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
-
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
-
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
-
Link to Sage 100c benefits are now accessible via the Information Center page. DevID 106779
-
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
-
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
-
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
-
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
-
After deleting a line from completed purchase order, the ON PO quantity calculates correctly in Item Maintenance. DevID 106463 Knowledgebase ID 78838
-
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
-
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
-
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
-
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
-
Payroll Quarterly Tax Report no longer includes employees with zero dollar in wages for current year. DevID 106631 Knowledgebase ID 80048
-
Subscription expiration checking, will now wait 5 days after subscription plan has expired before displaying expiration warning message. DevID 106792
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
Sales Order Daily Shipment Report now displays correct information when reusing deleted invoices. DevID 106446 Knowledgebase ID 78990
-
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
-
Debit memo created for invoices paid by ACH payment type now sets 'Default Payment Type' to ACH. DevID 106536
-
Credit limit checking is now performed in Shipping Data Entry. DevID 105984 Knowledgebase ID 76279
Visual Integrator
-
Physical Count Variance Register now displays the correct quantity on hand value after importing serialized items into IM_PHYSICAL. DevID 103426 Knowledgebase ID 45154
-
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
-
DED_CALC_METHOD no longer fails validation when importing into PR.EMPDED. DevID 106214 Knowledgebase ID 78021
-
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
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