Sage 100 ERP Product Update 5 (4.50.5.0)

Written by Todd Martin on .

Article Index

Sage has released on 12/13/2012 product update 5 for Sage 100 Version 4.5 (4.50.5.0). This release was done around the same time that the newest version of Sage 100 was released (Sage 100 ERP Version 2013). Product update 5 is available for download from Sage's website for those customers current on their subscription. Installation of this product update is included for those sage subscription customers that are also on MBA Business Software's Support Account Preferred. Please call our office to schedule the install.

The following is a list of enhancements and corrections that have been incorporated for Sage 100 version 4.50 in this Product Update. Product Updates are cumulative, containing all program corrections found in prior updates. Product Updates through 4.50.5.0 also contains program corrections that were introduced in 4.40.0.7 - 4.40.0.10.

After installing this Product Update, WKsUpdate 90.exe or WKsUpdate 200.exe needs to be run on each MAS Workstation. This file is located in the ..\mas90\WkSetup directory on the MAS Server. (WKsUpdate should also be run anytime WkSetup.exe is run on a MAS Workstation.)

 


Accounts Payable

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

Accounts Receivable

  1. 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."
  2. The Aging Category option 'Days Past Due for Calculation field' is now visible when selecting Age Invoices by Invoice date in A/R Options.

Bill of Materials

  1. Bill of Materials Production Register now prints correct serial numbers when serial numbers are reused.
  2. Indented Where-Used report now matches the Indented Where-Used Inquiry.
  3. 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.
  4. 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.
  5. Error 2 BM_CostedMaterialsReport_rpt.pvc 654 printing for Specific Bills with multiple bills listed, has been fixed.
  6. 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.
  7. CostCalc values are no longer stranded after updating Disassembly Entry in Bill of Materials if "Purchased Item" is selected as the Disassembly Type.

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. Relationship management Wizard no longer hangs when loading the grid for customers with large amounts of data.
  2. 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.
  3. "Insufficient system memory available and then Error 33 CU_addresslink_bus.pvc 57" error no longer occurs when running Rebuild CRM in Sage 100 ERP.
  4. The following errors no longer occur when either rebuilding CRM, running the relationship wizard or Loading CRM data from the C/U Options screen:
    Error 20, CU_Address_bus.pvc, line 77
    Error 20, CU_Phone_bus.pvc, line 80
    Error 20, CU_Email_bus.pvc, line 72
    Error 20, CU_Common.pvc, line 267 or 330 or 386
  5. Canadian zip code is no longer blank when relating a new customer from Sage CRM to Sage 100 ERP.
  6. 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.
  7. Relationship Management Wizard performance has been improved. 
  8. PLink_ARDivisionNo and PLink_CustomerNo are now populated when relating a customer from CRM to Sage 100.

Business Insights

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

Inventory Management

  1. The message "" is Not on File in Sales Order entry no longer occurs when Inventory Items have a Primary Vendor that is blank.
  2. The Inventory Trial Balance now shows a beginning balance when run for the last day of the period.
  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. 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.
  6. 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.

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. For MAS200 users only, the SY_workstation.M4t is no longer populated with workstation records that contain a blank userkey when the message "Another task is attempting to start up. Wait for the task to start before invoking another task".
  2. Crystal Reports no longer Displays Duplicate Data in Sage 100 Premium.
  3. An "Unhandled Exception Error Number: 0x80010105 no longer occurs when running the scan utility on 4.50 (SQL only).
  4. An Error 43 SWQMAN 12110 no longer occurs when accessing an ALE Lookup.
  5. Additional Packing List no longer hangs when printing in Sales Order Shipping in Sage 100 Premium and Sage 100 Advanced.

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:
    1. 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. Federal and State eFiling and Reporting has been upated with format changes.
  3. 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.
  4. Total Gross wages are now correct if multiple checks are issued on the same check run on Texas Form C-3 and C-4.
  5. 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.
  6. Employer Contribution deduction are no longer zeroed out in data entry after recalculating deductions.
  7. The deduction amount is no longer calculated if the Standard Limit is reached when in Deduction Code Maintenance the Deduction Type is Employer Contribution and Calculation Method is Percentage of Deduction.

Return Materials Authorization

  1. Credit Memo created from RMA is no longer missing GL accounts when the item follows another item with zero quantity received.
  2. Replacement order now relieves inventory at the replacement item tier cost for Lot items.

Sales Order

  1. 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.
  2. 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.
  3. Lot and Serial Items can now be Distributed when Copying a Sales Order from Sales Order History.
  4. 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.
  5. “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.

Visual Integrator

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

Work Order Processing

  1. Auto Issue Material Shortage Report sorted by Work Order, no longer overlaps the Description field into the Unit of Measure Field.
  2. An Intermittent DTR Out of Balance no longer occurs after work order material issue transactions are updated.
  3. Work Order Material Issue Lot/Serial Distribution Quantity Available Unit of Measure Conversion has been corrected.
  4. Work order material costs incorrect when the cost completion method was Planned, has been corrected

 

Tags: Product Update v4.50

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