Sage 100 ERP 2013 Product Update 1 (5.00.1.0)

Sage released on 12/14/2012 the first product update for version 2013 (5.00.1.0). This release was the day after the 4.5.5.0 product update and is mostly product fixes that were fixed in 4.5 and also needed to be fixed in the 2013 version. Product Updates are cumulative, comprised of all program corrections found in prior updates.

Sage 100 ERP Smart Updates now update the client workstation automatically. This replaces the need to run WKsUpdate.exe after installing a product update.

For Users who have also installed Sage 100 ERP 2013 CRM, the installation of this Product Update installs a Quick Order Entry Component Update.exe to the ..\mas90\RWC directory. Users will need to copy and execute this file on the Sage 100 ERP 2013 CRM server. 

All Sage 100 ERP 2013 Product Updates will require the installation to be from the Sage 100 ERP Server. Significant enhancements are being introduced in Sage 100 ERP 2013 and its Updates. These include: Smart Update, Workstation Synchronization and Sage Auto Update. Part of these enhancements requires the Product Update to make changes to the local registry, necessitating a server side installation. The Product Update can be installed from the Sage 100 ERP 2013 Server either physically at the console or by connecting to it through Remote Desktop.

Accounts Payable

1. "The Check Sequence number is required" no longer appears after entering the Check Number in A/P Payment History Inquiry.
2. Enhancements have been made to 1099 Reporting Calendar 2012 Changes (PU5)- 1099 INT & 1099 DIV-New Boxes-Aatrix and to the RCP Record
3. Accounts Payable Check Printing and Electronic Payment now prints the correct amount for ACH vendors with a negative amount invoice.

Accounts Receivable

1. The Aging Category option 'Days Past Due for Calculation field' is now visible when selecting Age Invoices by Invoice date in A/R Options.
2. Adjusting an invoice in AR Invoice Data Entry no longer returns the error message "Salesperson is not in the division 00. The default salesperson for customer xxx will be used."

Bill of Materials

1. Costed Bill of Materials Report now correctly calculates the Unit Cost and Cost of Bill when a sub-bill has components with a quantity per bill less than 1.
2. The Quantity Issued and Ending Qty totals are now correct on the History tab in Item Maintenance if a Disassembly Entry was updated with Disassemble Type of "Purchased Item" is used.
3. CostCalc values are no longer stranded after updating Disassembly Entry in Bill of Materials if "Purchased Item" is selected as the Disassembly Type.
4. Indented Where-Used report now matches the Indented Where-Used Inquiry,
5. Bill of Materials Production Register now prints correct serial numbers when serial numbers are reused.
6. Error 2 BM_CostedMaterialsReport_rpt.pvc 654 printing for Specific Bills with multiple bills listed, has been fixed
7. The Description for a Component Item Code is now correct on the Gross Requirements Report if a Phantom bill contains the same Component Item Code that is on the Bill.

Customizer

1. UDFs posted to G/L are no longer all for the same receipt when posting to General Ledger in Detail, when P/O Receipt & Receipt/Invoice Variance for multiple receipts is updated. Note that while posting in detail, some GL postings are still summarized by comment, so the first UDF encountered may still be the UDF used.

CRM

1. PLink_ARDivisionNo and PLink_CustomerNo are now populated when relating a customer from CRM to Sage 100.
2. Canadian zip code is no longer blank when relating a new customer from Sage CRM to Sage 100 ERP.
3. Error message "Error executing SQL for table #PhoneLinkForMAS90: Query timeout expired" no longer occurs and performance improvements have been made when creating an order with on the fly oppertunity in Customer CRM Data.
4. Relationship Management Wizard performance has been improved.
5. Users can now unrelate a Customer from CRM in customer maintenance even when the check box is avialable and Sales order invoice data entry is in progress.

Business Insights

1. Phantom bills now show in the Bill of Materials Business Insights Explorer view.

Inventory Management

1. The Inventory Sales History Report and Inventory Maintenance History Tab by Customer Sales, no longer display the Sales Amount and COGS as positive dollars for drop ship Credit Memos in 4.40 after converting from 4.20.
2. History tab Ending Balance now matches the Inventory Detail Transaction Report when Inventory is based on Calendar year and data exists for 2/29/2000
3. Issues with sales kit and drop ship sales history are now correct after conversion.
4. A File/Busy-Error 0 no longer occurs during Physical Count Worksheet when attempting to freeze inventory items when there are invoices in S/O Invoice Entry and the invoice entry session is open. Instead, a Sage 100 ERP dialog will appear with the message “The IM Item Warehouse file is in use”. This warning will appear because the I/M Item Warehouse file is in use elsewhere and the Print Worksheet and Freeze Items requires exclusive access to it . When this dialog appears, clicking OK will return the user to the Physical Count Worksheet report window so that freezing the inventory items can continue as other data entry sessions are closed.
5. The message "" is Not on File in Sales Order entry no longer occurs when Inventory Items have a Primary Vendor that is blank.
6. The Inventory Trial Balance now shows a beginning balance when run for the last day of the period.

Job Cost

1. TakeOff U/M now lists newly added Unit of Measures
2. J/C Estimating - Unit of Measure Conversion now correctly contains the Operation (multiply or divide) column and the JC estimating UM's perform correctly.

Library Master

1. An Error 88 SY_UI.PVC 256 no longer occurs when accessing Rebuild Key Files after cancelling the Pre Scan utility.
2. Filtered ALE lookups have been corrected and no longer return an Error 13 SWQUERY 2047.
3. Sage 100 ERP Smart Updates now update the client workstation automatically. This replaces the need to run WKsUpdate.exe after installing a product update.
4. Crystal Reports no longer Displays Duplicate Data in Sage 100 Premium.
5. An "Unhandled Exception Error Number: 0x80010105 no longer occurs when running the scan utility on 4.50 (SQL only).
6. An Error 43 SWQMAN 12110 no longer occurs when accessing an ALE Lookup.

Magnetic Media

1. W2 Electronic Reporting has been modified according to the SSA 2012 Specifications for Filing Form W-2 Electronically. The following changes have been made:
   1. In W2 Electronic Reporting on the Additional Information tab the field Problem Notification has been removed—it is no longer required
   2. “RA” record position 499 is now blank
   3. “RA” record position 446-485 Contact E-Mail/Internet field is now required:
   4. “RW” record position 342-352 is now blank
   5. “RT” record position 220-234 is now blank
2. 1099 Electronic Reporting has been modified according to the Internal Revenue Service's 2012 Publication 1220. The following changes have been made:
   
   The “A”, “B”, “C” and “K” records for 1099 DIV have been changed for reporting the following 2 new amount codes:
   
   F—Exempt Interest Dividends
   G—Specified Private Activity Bond Interest Dividends

Purchase Order

1. A Backordered Purchase Order now Completes after Receipt of Invoice if the referenced Work Order has been purged.
2. Auto Generate from Sales Order now allows generating one Purchase Order per Sales Order for range of sales orders

Payroll

1. Payroll has been modified to calculate the 2013 Additional Medicare Tax. In order for the Additional Medicare Tax to calculate, prior to your first Payroll in Janaury 2013 you will need to install the 2013-Q1 Tax Table Update.
2. Employer Contribution deduction are no longer zeroed out in data entry after recalculating deductions
3. Duplicate deduction code records are no longer created in the Payroll Data Entry file when the Method to Recalc Deductions is set to Only Automatic in Payroll Options.
4. Payroll has been modified to calculate the 2013 Additional Medicare Tax. In order for the Additional Medicare Tax to calculate, prior to your first Payroll in Janaury 2013 you will need to install the 2013-Q1 Tax Table Update.
5. Federal and State eFiling and Reporting has been upated with format changes.
6. Local codes for OH and PA have been update for State eFiling and Reporting. The eFiling and Reporting version has been update to 2.26.
7. Total Gross wages are now correct if multiple checks are issued on the same check run on Texas Form C-3 and C-4

Return Materials Authorization

1. Replacement order now relieves inventory at the replacement item tier cost for Lot items

Sales Order

1. Picking Sheets no longer print for Sales Order Quotes when "Picking Sheet After Quick Printing Sales Order" is selected on Quick Print tab in Sales Order Options.
2. Changes to the Ordered Qty for Kit Components in Sales Order Entry no longer revert back to the original Kit Component quantity in Sales Kit Maintenance when using Shipping Data Entry.
3. Miscellaneous Charge Revenue for a 2-Step invoice no longer posts to the Sales Account Defined in Job Type Maintenance when S/O Options/Job Cost Tab "Use Sales Orders Accounts for Sales Revenue" is selected.
4. “The distribution quantity exceeds the available quantity” message no longer appears when distributing lot quantities greater than half of the lot quantity on hand in Shipping Data Entry.
5. Lot and Serial Items can now be Distributed when Copying a Sales Order from Sales Order History

Visual Integrator

1. VI Perform Type is now working when set to Before Assign or After Assign.
2. Users are now able to import Null or blank for reorder method when importing to IM_itemwarehouse.
3. Importing into JC.POSTCST now imports fields from JC.TYPE when using File Assign operation.
4. Next Batch Number now writes to Header record when using Replace pointed to an empty column
5. Performance improvements have been made when importing to CI_Item.

Work Order Processing

1. WOUxxx W/O Transaction Entry Lot/Serial Tier Distribution File is now cleared when a single batch is updated for Lot and Serial items.
2. Work order material costs incorrect when the cost completion method was Planned, has been corrected
3. Auto Issue Material Shortage Report sorted by Work Order, no longer overlaps the Description field into the Unit of Measure Field.
4. Work Order Material Issue Lot/Serial Distribution Quantity Available Unit of Measure Conversion has been corrected.
5. An Intermittent DTR Out of Balance no longer occurs after work order material issue transactions are updated.