Sage 100 ERP 2014 Product Update 5 (5.10.5.0)

Sage has released the fifth product update for version 2014 (5.10.5.0) on 3/30/15. 

An updated "eBusiness Web Services.exe" is being installed to the Sage 100 ERP 2014 Server's..\MAS90\WS folder to correct the following issue: "UnitPrice is no longer being reset in Sales Order Detail when previewing orders with eBusiness Web Services." Existing eBusiness Web Services users should update their existing installation by uninstalling the existing eBusiness Web Services and installing the updated version .

(OPTIONAL Method, existing users can replace their existing Sage100ERP.WebServices.dll with the updated version also located in the ..\MAS90\WS folder on the Sage 100 ERP 2014 Server.)
New eBusiness Web Services users should install using the updated "eBusiness Web Services.exe"located in the Sage 100 ERP 2014 Server's ..\MAS90\WS folder.

The following is a list of enhancements and corrections that have been incorporated for Sage 100 ERP 2014 in this Product Update. Product Updates are cumulative, comprised of all program corrections found in prior updates. Smart Update will install only the programs that need to be updated since your last Product Update Installation.

If you choose to install this Product Update on a system that already has Product Update 5 installed, all programs released in Product Updates 1 through 5 will be
reinstalled. MBA Business Software customers that are on Software Support – Preferred (SSA-PF) can contact us to schedule your update to this version. As part of your support plan, minor updates and hot fixes are included. Not on a support plan but interested? Find out more about what MBA offers for support.
This Product Update also contains program corrections introduced in 5.00.5.0 through 5.00.8.0, included in this report for reference. 

Sage 100 ERP Advanced and Premium Workstation Synchronization now updates the client workstation automatically. This replaces the need to run WKsUpdate.exe after installing a product update. Users running Sage 100 ERP Standard over a network will still need to run WKsUpdate Standard.exe on each workstation. This program is located in the ..\mas90\wksetup directory on the Sage 100 ERP 2014 Standard Server.

All Sage 100 ERP 2014 Product Updates require the installation to be from the Sage 100 ERP Server.

Before installing the product update, please note the following:

• We highly recommend that you back up your system before installing any updates or version upgrades.  Otherwise, data may be lost if the update fails.
• If any customizations have been made to your Sage product, contact your Sage business partner or Master Developer before installing any update.
• Install this Product Update from the same computer that was used to install the original Sage product to the application server.
• This product Update includes fixes from all previous product updates.

Hot fix

Released	Name	Description
4/30/2015	SO5007-T	"The quantity packed does not match the quantity shipped..." warning may erroneously appear when the Item Codes are similar in Sales Order shipping entry.
4/30/2015	SO5003-T	"The quantity packed does not match the quantity shipped..." warning may erroneously appear when the Item Codes are similar, when the Quantity is negative, or when the Quantity has more than 2 decimal places in Sales Order shipping entry.
1/9/2015	SO5002-T	"The quantity packed does not match the quantity shipped..." warning may erroneously appear when the Quantity is negative, or when the Quantity has more than 2 decimal places in Sales Order shipping entry.

Accounts Payable

1. ACH: Batch Header record is no longer defaulting to the accounting date instead of the effective date. 
2. Form 1099 eFiling and Reporting has been modified for reporting Form 1099-INT Box 10 (Market Discount) and Box 11 (Bond Premium) 
3. The prompt to increment the Default 1099 Calendar Year in Accounts Payable Options now displays when exiting Form 1099 eFiling and Reporting. 
4. For 2014, Box 10 Market Discount and Box 11 Bond Premium have been added for 1099-INT. 
5. For year 2014, Box 11 Foreign tax paid and Box 12 Foreign country or U.S. possession have been removed for 1099-MISC.
6. The Last Purchase Date now updates Vendor Maintenance.

Accounts Receivable

1. AR Discount amount is no longer rounding incorrectly. 
2. Ship To Address is no longer auto populating the exemption number from a non -primary Ship To code.
3. History periods no longer duplicate rows in AR Customer Maintenance. 
4. Invoice Number is now retained in AR Invoice Data Entry when a hyphen is included in the Invoice Number. 
5. Error 33 AR_CashReceipts_Bus.pvc 816 no longer occurs in Cash Receipts Entry when deleting a Batch. 

Bill of Materials

1. Costed/Single Level/Indented Bill of Materials report with ALL selected for Effective Change Date no longer shows the components of a bill that have been removed using Engineering Change Entry. 
2. Bill of Materials Cost Roll-up Register no longer includes components of a bill that have been removed using Engineering Change Entry when ALL is selected for Effective Change Date. 
3. Bill of Materials Option Category component items are now updated by Inventory Delete and Change Items change process.
4. "This Distribution is Out of Balance, do you want to delete this line?" is no longer received when selecting Show ALL Lots icon in Production Entry Lot Distribution.
5. "The Component Revision is required" message is no longer received when editing a component that was replaced in a Bill of Material using Replace and Delete Component Entry.
6. "The Component Revision is required' no longer displays when editing a Bill component that was replaced. 

Bank Reconciliation

1. Ending balance on Bank Rec Recap report is now correct when running for all bank codes. 

Customizer

1. Error: "[Table Name] - Cannot create the "CM/Script/CM_UDTMaint_Bus:[TableName] master script"" no longer occurs in Custom Office - User Defined Script Maintenance when selecting Compile. 
2. PO Receipt of Invoice UDF value now validates against UDT list. 
3. Error 81 SY_gridhandler.pvc 1270 no longer occurs in Sales Order Invoice Data Entry when converting an order to an invoice and shipping all lines. 
4. AR Aged Invoice Report is now pulling Transaction Payment History UDFs when printing in Detail. 

CRM

1. Error 65 no longer received for new CRM quote for Prospect company if item qty creates backorder status. 

General Ledger

1. Error 30 SY_Service.pvc 263 or 271 no longer received in data entry batch windows when the Last navigation button is clicked. 
2. Transactions are no longer missing when running the GL Detail Report by date range in Sage 100 ERP Premium. 

Inventory Management

1. History tab in Item Maintenance/Inquiry now matches the Transactions posted. 
2. Reorder Method is no longer changed when Item is sold from Warehouse with a Reorder Method of None. 
3. In Item Inquiry or Maintenance on the Cost Detail Tab, the Available column now displays the correct decimal precision.
4. Inventory Sales Analysis Report sorted by Year to Date Dollars Sold and by Warehouse now sorts correctly. 

Job Cost

1. JC - Job Estimate Maintenance - U/M code is no longer missing in line detail after making a change on the Item Pricing screen. 
2. Error: "MAS has stopped working" no longer occurs when running the Job Cost Code Detail Report. 

Library Master

1. 1 E-mail field value in RMA Entry no longer disappears after accessing System Info. 
2. 2 For Payroll eFiling and Reporting new Ohio Tax Types have been added. 
3. For eFiling and Reporting the version has been updated and new Tax Types added for Local Tax reporting. 

Paperless Office

1. "Printer Not Activated -60" no longer received when using Paperless Office and printing documents to .pdf format. 
2. Performance issue no longer occurs when printing to Paperless Office when the number of documents is greater than 150. 

Payroll

1. An ACA menu with three new tasks related to the Affordable Care Act has been added to the Payroll module. 
   • ACA Employee Maintenance for entering information that will appear on Form 1095-C. 
   • ACA Employer Maintenance for entering information that will appear on Form 1094-C.
   • ACA Applicable Large Employer Report (ALE) to generate a count of full time and full time equivalent (FTE) employees. The totals can then be updated to the ACE Employer file, and they will appear in the ALE Member Information-Monthly window accessed from ACE Employer Maintenance. 
   • For more information, refer to the help for these tasks. 
2. Other Local Tax amount will now populate Box 14 of the W2 in Federal eFiling and Reporting when a Local Tax Code is setup with both Local Withholding Tax and Other Local Tax. 

Sales Order

1. "Quantity Packed Does Not Equal Quantity Shipped" warning no longer appears when Quantity is negative or has more than 2 decimal places in S/O shipping entry.
2. SO - Sporadic mismatch between the Totals on the Order Lines tab and Totals tab has been resolved.
3. ProcessReport() no longer fails in a SO invoice printing vb script run outside of sage 100.
4. AP Invoice Data Entry Performance has been improved. 
5. Error: "One or more journals may be out of balance" no longer occurs when updating SO Daily Transaction Journal for an alpha-numeric invoice number that is less than 7 digits long with tax. 
6. Error 65 AR_CreditCard.pvc 748 no longer occurs when updating Sales Journal with credit card transactions. 
7. UnitPrice is no longer being reset in Sales Order Detail when previewing orders with eBusiness Web Services.  An updated "eBusiness Web Services.exe" is being installed to the Sage 100 ERP 2014 Server's ..\MAS90\WS folder. Existing eBusiness Web Services users should update their existing installation by uninstalling the existing eBusiness Web Services and installing the updated version . (OPTIONAL Method, existing users can replace their existing Sage100ERP.WebServices.dll with the updated version also located in the ..\MAS90\WS folder on the Sage 100 ERP 2014 Server.) New eBusiness Web Services users should install using the updated "eBusiness Web Services.exe" located in the Sage 100 ERP 2014 Server's ..\MAS90\WS folder.

Work Order

1. Transaction Journal no longer stops responding and causes corrupt data when a fractional quantity is Completed for a Serialized item.

PRODUCT UPDATE FILES

Updated by this release

May require conversion

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_CheckPrinting.M4L AP AP_CheckPrinting_rpt.pvc AP AP_ExtendedStubReport.M4L AP AP_Form1099eFileandReport_ui.pvc AP AP_Vendor1099Payments_bus.pvc AP AP_Vendor1099Payments_ui.pvc AR AR_AgedInvoiceReport_rpt.pvc AR AR_CashReceiptsJournal_upd.pvc AR AR_CashReceipts_bus.PVC AR AR_CreditCard.pvc AR AR_CreditCardCommon.pvc AR AR_CreditCardSPS.pvc AR AR_CustomerShipToTaxExemptions_bus.pvc AR AR_Customer_ui.pvc AR AR_Invoice_bus.pvc AR AR_SalesJournal_upd.pvc BM BM_CostedMaterialsReport_rpt.pvc BM BM_Disassembly_bus.pvc BM BM_IndentedReport_rpt.pvc BM BM_ProductionDetail_bus.pvc BM BM_Production_bus.pvc BM BM_ReplaceDeleteCompDetail_bus.pvc BM BM_SingleLevelReport_rpt.pvc BM BM_SummarizedReport_rpt.pvc BR BR_BankRecapReport_rpt.pvc CI CI_CommonCostRollup_Upd.pvc CI CI_eFilingCommon.pvc CI CI_ItemWarehouse.pvc CI CI_TableConversion0500.pvc CI CI_UpdateCheckToAP.pvc CI CI_UpdateDetailToIM.pvc CI CI_UpdateHeaderToAR.pvc CM Cmwud2 CM CM_Script_UI.pvc CM CM_Script_UTL.pvc CM CM_UDFMaint_UI.pvc DDICTS prfile.dd DDICTS prfld.dd GL GL_DetailReport_rpt.pvc Help IM_BalanceLotSerTrans_Utl.pdf Help pr.chm Help PRReports.pdf Home lib _updater autoupdate_vbscript.txt IM IM_BalanceLotSerTrans_Utl.docx IM IM_BalanceLotSerTrans_Utl.M4L IM IM_BalanceLotSerTrans_Utl.m4p IM IM_BalanceLotSerTrans_Utl.pvc IM IM_DeleteChangeItems_ui.pvc IM IM_DetailTransactionReport_rpt.pvc IM IM_ItemValuationChangeReg_upd.pvc IM IM_Item_ui.pvc IM IM_SalesAnalysis_rpt.pvc JC JCWMEG JC Jcwrfc MAS_SYSTEM PR_ACAOfferOfCoverage.M4T MAS_SYSTEM PR_ACASafeHarbor.M4T MAS_SYSTEM PR_ACATransitionRelief.M4T MAS_SYSTEM SY_1099Setup.M4T MAS_SYSTEM SY_ConversionDriver.M4T MAS_SYSTEM SY_FormseFilingVersion.M4T MAS_SYSTEM SY_GridDefinition.M4T MAS_SYSTEM SY_Menu.M4T MAS_SYSTEM SY_Message.M4T MAS_SYSTEM SY_PayrollEFilingMapping.M4T MAS_SYSTEM SY_PopupItem.M4T MAS_SYSTEM SY_PopupMenu.m4t MAS_SYSTEM SY_PopupMenuItem.M4T MAS_SYSTEM SY_PopupXref.m4t MAS_SYSTEM SY_ReportManagerMaster.M4T MAS_SYSTEM SY_System.M4T MAS_SYSTEM SY_Task.M4T MD mdwmqz PO PO_ReceiptRegister_upd.pvc PR PayrollACAMaintenanceImports.EXP PR PRWDAA PR PRWDAC PR Prwfqc PR PRWFXB PR PRWMAA PR PRWMAA.LIB PR PRWMAB PR PRWMAG PR PRWMAH PR Prwrab PR PR_ACAALEReport.M4L PR PR_ACAALEReport_rpt.pvc PR PR_ACAALEReport_UI.pvc PR PR_ACAEmployee.M4L PR PR_ACAEmployeeCoveredInd_bus.pvc PR PR_ACAEmployeeCoveredInd_UI.pvc PR PR_ACAEmployeeMonthlyDtl_bus.pvc PR PR_ACAEmployeeMonthlyDtl_UI.pvc PR PR_ACAEmployee_bus.pvc PR PR_ACAEmployee_svc.pvc PR PR_ACAEmployee_ui.pvc PR PR_ACAEmployer.M4L PR PR_ACAEmployerMonthlyDtl_bus.pvc PR PR_ACAEmployerMonthlyDtl_UI.pvc PR PR_ACAEmployerOtherMembers_bus.pvc PR PR_ACAEmployerOtherMembers_UI.pvc PR PR_ACAEmployer_bus.pvc PR PR_ACAEmployer_svc.pvc PR PR_ACAEmployer_ui.pvc PR PR_ACAOfferOfCoverage_svc.pvc PR PR_ACASafeHarbor_svc.pvc PR PR_ACATransitionReliefIndicator_svc.pvc PR PR_eFiling.pvc PR PR_TableConversion0500.pvc Reports IM_DetailTransaction.rpt Reports IM_DetailTransactionCondensed.rpt Reports PR_ACAALEReport.rpt SO SO_CRMSalesOrder_Ui.pvc SO SO_InvoiceDetail_Bus.pvc SO SO_InvoicePrinting_rpt.pvc SO SO_PackageTrackingByItem_Svc.pvc SO SO_SalesJournal_upd.pvc SO SO_SalesOrderPrinting_rpt.pvc SO SO_SalesOrderQuickPrint_UI.pvc SO SO_SalesOrder_bus.pvc SO SO_Shipping_bus.pvc SOA swcocx SOA SWQSCR.37151050 SOA SWQSCR.40051050 SOA SWQSCR.40551050 SOA SWQSCR.41051050 SOA SWQSCR.42051050 SOA SWQSCR.43051050 SOA SWQSCR.44001051050 SOA SWQSCR.4400151050 SOA SWQSCR.4400251050 SOA SWQSCR.4400351050 SOA SWQSCR.4400451050 SOA SWQSCR.4400551050 SOA SWQSCR.4400651050 SOA SWQSCR.4400751050 SOA SWQSCR.4400851050 SOA SWQSCR.4400951050 SOA SWQSCR.44051050 SOA SWQSCR.44551050 SOA SWQSCR.4501051050 SOA SWQSCR.4502051050 SOA SWQSCR.4503051050 SOA SWQSCR.4504051050 SOA SWQSCR.4505051050 SOA SWQSCR.45051050 SOA SWQSCR.4506051050 SOA SWQSCR.4507051050 SOA SWQSCR.5001051050 SOA SWQSCR.5002051050 SOA SWQSCR.5003051050 SOA SWQSCR.5004051050 SOA SWQSCR.50051050 SOA SWQSCR.5100151050 SOA SWQSCR.5101051050 SOA SWQSCR.5102051050 SOA SWQSCR.51051050 SOA sy0dct.soa SOA SY0DD1.510 SOA sy0dd2.soa SOA sy0dd4.soa SOA sy0dd5.soa SOA sy1q01.soa SOA sy1q02.soa SOA sy1q04.soa SOA sy1qdd.soa SY SY_1099Setup_bus.pvc SY SY_BatchManagerSelect_ui.pvc SY SY_CommonHistory.pvc SY SY_CommonUI.pvc SY SY_ConversionDriver.pvc SY SY_Form.pvc SY SY_Installation.pvc SY SY_PDFConverter.pvc SY SY_Report.pvc SY SY_SalesTaxCalculation_bus.pvc SY SY_Selection.pvc VI VI_Lookup.pvc Wksetup Sage 100 Standard ERP 2014 Workstation.msi WO WOWDBJ WS eBusiness Web Services Update Readme.pdf WS eBusiness Web Services.exe WS Sage100ERP.WebServices.dll

AP_Vendor - Added FATCA yes/no feld - defaults to N PR1 - Added Added Seasonal Employee yes/no feld, PR1$(367,1) - defaults to N PR3 - Added 1095-C Electronic Consent yes/no feld for federal records, PR3$(39,1) - defaults to N PR_ACAAleWrk - new fle PR_ACAEmployee - new fle PR_ACAEmployeeCoveredInd - new fle PR_ACAEmployeeMonthlyDtl - new fle PR_ACAEmployer - new fle PR_ACAEmployerMonthlyDtl - new fle PR_ACAEmployerOtherMembers - new fle PR_ACAOferOfCoverage - new fle (in MAS_SYSTEM directory) PR_ACASafeHarbor - new fle (in MAS_SYSTEM directory) PR_ACATransitonRelief - new fle (in MAS_SYSTEM directory)