Sage MAS 90 and 200 Product Update 7 (4.40.0.7)

Written by Chris Bishop on 15 November 2011.

Article Index

The following is a list of enhancements and corrections that have been incorporated for Sage MAS 90 and MAS 200 version 4.40 in this Product Update. Product Updates are cumulative, containing all program corrections found in prior updates.

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

Invoice Payment Selection Listing Report Vendor Total and Vedor CheckTotal are now correct when printing the directly to the printer.

Accounts Receivable

The correct Customer Name now prints on the Monthly Sales Report.
Invoice History Inquiry, for performance reasons, the UserKey column has been removed from the Invoice No. lookup.
When running the Delete and Change Customers utility in the Accounts Receivable module, the Sales Order/Quote History records for the customer being changed are now renumbered/merged/deleted.
Error 13 IT Customer_bus.pvc 557 no longer occurs when renumbering an IT enabled customer and Webengine is running in Delete and Change Customers utility.
The custom lookup now displays correct quantity in Customer Sales History Flashlight Lookup in Customer Maintenance.

Bill of Materials

If an Inventory Item is deleted, all Bill information is now removed that was created for the item.
In Disassembly Entry and Production Entry the Unit of Measure is displayed properly now when moved to primary grid from secondary grid.
The unit cost on the Single-Level Bill of Materials Report now corresponds to the current unit cost entered in Miscellaneous Item Maintenance.
The Costed Bill of Materials report for Option Bills is no longer printing **Invalid Bill** for valid options bills.

General Ledger

Now able to print specific recurring journals numbers in Reprint Journals.

Inventory Management

On the Inventory Sales History Report, the Quantity Sold column for the Month the Sales Order Invoice was entered now reflects the negative Sales Order Invoice.
In Physical Count Update, Count of Zero for Standard Cost and Tiered valuation methods The TotalWarehouseValue is now cleared.
The Inventory Turnover Report’s calculation no captures all periods including the periods that don’t have any activity.
Sales Journal Update for for a FIFO item when the shipped qty exceeds the Tier Qty is now clearing the CostCalcCostCommitted and CostCalcQtyCommitted fields.
Quantity On Hand and Over/Short Variances no longer change when using Count Card Entry
Serial numbers are now correctly updated when receiving multiple serialized items in Receipt type Transaction Entry.
Lot/Serial valuations now correctly display the actual Receipt No. and Receipt date of the cost tier transferred.
The Balance Qty on Hand utility now assigns correct TierType and TierGroup when the condition requires a new IM_ItemCost OVERDIST tier to be created.
Inventory item Quantity on Sales Order is no longer incremented after adding cost code information to an existing sales order without changing line quantities
The vendor item code is no longer removed when a different alias item code is deleted from alias item maintenance.
A new utility is available to check your ItemWarehouse and ItemCost tables for orphaned CostCalcCostCommitted and CostCalcQtyCommitted fields. A comma separated value file is updated with a list of the items found and the values.
To verify if orphaned values, this utility should be run after all registers and updates have been completed. If run during a register print and update the values found may be valid.

To run the utility:

Select File/Run
Type syzcon
Click Accept
at the > prompt type run "IM_CommitCheck_utl
press Enter key

A message with an OK button will appear with the location of the report when utility has completed. The default location of the report is found in ../home/textout/IM_CommitCheck001.csv. Every time the utility is run, the sequence number will increment by one, i.e. CommitCheck002.csv. If the report has entries listed for items please contact Customer Support.

The Inventory Detail Transaction Report Beginning Balance is now correct when a transaction has been posted to the future period/year while im options Base Inventory Periods On is set to Calendar.

Library Master

Contact Code list is no longer blank in Paperless Office Delivery Options.
Error "Unable to spawn a new session. The command line required for the server process is too long" no longer occurs when trying to run a Custom Crystal Report from the Custom Reports menu.
Participate in the Product Enhancement Program:
- You can now participate in the Product Enhancement Program (PEP). Through PEP, Sage collects information that will help Sage identify trends and usage patterns to improve the quality of the products and services we offer. Sage will not collect sensitive information such as financial information or information on individual transactions.
- When installing or upgrading to a new version of Sage ERP MAS, you will be automatically enrolled in PEP. You can opt out at any time using the Product Enhancement Program window accessed through the Administrative Tools window if security is enabled, or the Manage Your System window on start-up if security is not enabled.
Re-Display the Manage Your System Window:
- To display the Manage Your System window on start-up, select the new Display the Manage Your System Window on Start-Up check box in System Configuration. This check box is available only if security is not enabled
Custom reports created for work order files WOO and WO9, crystal conversion will remove from the custom report the following fields as there aren't available mappings: itemnumber1 and completeditemnumber1.

Material Requirements Planning

The Materials tab in Work Order now shows the component items from the phantom bills for Auto Generated Work Orders.

Paperless Office

The Return Order PDF is no longer removed in Vendor Viewer after updating Return of Goods register. Record is only removed if deleted in the Viewer or the Return Order is deleted.

Purchase Order

Auto Generated Purchase Order quantity is now correct when Summarize Multiple Items by Line is selected for purchase orders created from multiple Master Order type sales orders.
Library Master Utility Rebuild Sorts for purchase order, now rebuilds the PO_OpenOrderDetailByItem.M4T table.

Payroll

Payroll Tax Calculation and the tax tables have been modified based on the Connecticut Withholding and Calculation.

Rules Effective August 1, 2011. The Tax Calculation program has been modified for versions 4.20 and higher.

Note: Following the last payroll processed in July and prior to the first payroll processed in August, in order the Connecticut taxes to calculate correctly for the remainder of the Tax Year 2011, you must:

1. Install the Payroll Tax Table Update
2. Assign the appropriate new employee filing status for each employee that earned Connecticut income in 2011 prior to August 1.

The following new filing statuses have been added to the CT tax tables based on the Withholding and Calculation
Rules: Filing Status Description
A1 A-PHASEOUT WGS TO 62,750
A2 A-PHASEOUT WGS > 62,750
A3 A-PHASEOUT/RECAP WGS > 200K
B1 B-PHASEOUT WGS TO 98,500
B2 B-PHASEOUT WGS > 98,500
B3 B-PHASEOUT/RECAP WGS > 320K
C1 C-PHASEOUT WGS TO 125,500
C2 C-PHASEOUT WGS > 125,500
C3 C-PHASEOUT/RECAP WGS > 400K
D1 D-PHASEOUT WGS TO 62,750
D2 D-PHASEOUT WGS > 62,750
D3 D-PHASEOUT/RECAP WGS > 200K
F1 F-PHASEOUT WGS TO 81,500
F2 F-PHASEOUT WGS > 81,500
F3 F-PHASEOUT/RECAP WGS > 200K

The pre-existing Filing Statues A, B, C, D & F have been updated with the new rates for Table C-Withholding Tax and should be used for employees hired after August 1, 2011.

Additional Information Regarding Calculating Connecticut Taxes Due to the significant changes in the Connecticut tax law you must pay special attention to employees’ wages throughout the balance of this tax year. The following are some special circumstances where the Sage ERP MAS 90 and 200 Payroll program calculations cannot fully accommodate these tax law changes and manual calculations may be required.

For example:

If you have recently hired employees, prior to August 1, 2011, you will have to determine whether to continue to use their existing filing status or change to the new filing status. Either way, for this small group of employees, they will be under or over withheld. You may want to calculate their taxes manually to determine which filing status will calculate the most accurate withholding amount for the rest of the year.

For employees with varying paid hours (20 hrs week 1, 30 hrs week 2, etc) you would need to manually calculate their taxes using the wage bracket tables and enter as manual taxes in Payroll Data Entry for each check.

In order for employees who have elected to have an additional state tax amount withheld from their check, manual tax calculation will be required because the new recapture tax calculations for Connecticut will keep adjusting the YTD state tax based on the new tables.

For employees with standard paid hours (40 hours weekly) who have elected to have anadditional state tax amount withheld from their check, you would manually calculate their taxesand add the additional amount, then store the amount as an override Amount in EmployeeMaintenance. Or, you may elect to no longer make the additional calculation available to youremployees.

For employees with varying paid hours (20 hrs week 1, 30 hrs week 2, etc) who have elected to have an additional state tax amount withheld, you would need to manually calculate their taxesusing the wage bracket tables, add the additional amount and enter the sum as manual taxes inPayroll Data Entry for each check. Or, you may elect to no longer make the additional calculationavailable to your employees.

For employees who receive a raise in pay after August 1, 2011, it may be necessary to re-assign their Filing Status when processing their change if the salary adjustment moves them into another bracket.

Daily Transaction Register is no longer out of balance when accruing payroll. In State eFiling and Reporting gross wages now populate Line 13 on Texas Form C- 3.3

Return Materials Authorization

Selections made using the Show All button in RMA entry Lot distribution now retains the selections.

Sales Order

Customer Last Purchase History is no longer blank in Sales Order and Sales Order Invoice Data Entry.
The Customer's Credit Limit Exceeded warning is now displaying in Shipping Data Entry when customer has exceeded the aging or credit limit.
Correct cost is returned to an existing cost tier for serial number on S/O credit memo3
Ship weight is now calculating correctly in Sales Order Entry and Sales Order Invoice Entry after conversion.
In Shipping Data Entry, following specific steps lines disappear when the Shipping Setup Options Return Focus to Item Code after Entering Quantity is selected and a handheld scanner is used.
The Location Code List now displays all existing codes that begin with the character entered in the Ship To Addr field.
Sales Journal Update, for a credit memo, or a standard invoice for a negative quantity, where a lot tier is being updated to, the cost of the existing tier is used (and retained) for the cost of the sale.
In Shipping Data Entry Focus now returns to Item Code Field when Kit item is not exploded.

Visual Integrator

Invoices are now imported into correct Batch when importing into AP Invoice Data Entry.
Error 40 WOWDBK 1560 no longer occurs when importing Work order transaction for Backflush Work Orders.

Work Order Processing

Invoices are now imported into correct Batch when importing into AP Invoice Data Entry.
Error 40 WOWDBK 1560 no longer occurs when importing Work order transaction for Backflush Work Orders.

Tags: Product Update v4.40