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

1. Error 20 no longer occurs when you have AP Options "Sort Invoice Registers by Vendor Name" checked, and you run the AP Invoice Payment Listing.

Customizer

1.  UDF data in IM_SalesKitDetail is now copied to a new Sales Kit's when using the "Copy From" feature in Sales Kit Maintenance

General Ledger

1. G/L accounts are now deleted after processing year end

 Inventory Management

1. Re-freezing inventory items will now retain quantities on hand manually counted and entered.
2. Inventory Recalculate Item History now includes and updates adjustment transactions forquantities that are generated by the IM Balance Quantity anda History utility
3. Item Maintenance Transactions Tab quantities summed below the list box now include adjustment transactions created by the IM Balance Inventory Quantity and Cost utility.
4. The hidden utility IM_BalanceQtyOnHand_ui has been replaced with a new utility. The new utility is named IM Balance Inventory Quantity and Cost and is located on the *UTL menu.
5. File/Run, type in the Program field *UTL, click OK. Select the new utility on the mAS 90 Utilities menu.
6. Two new hidden utilities have been added: IM_CommitCheckClear_utl and IM_ClearCommitDataEntry_utl. Please call Support for assistance in using these two new utilities.
7. In Disassembly Register, Negative Tier Register, Physical Count Var Register, Material Req Issue Register, Receipt Register, Return Register, Work Order Journal update no longer orphans values in the Cost Calc Cost Committed and Cost Calc Quantity Committed fields when a connection is lost during the update.
8. A new utility has been added: IM Balance Inventory Quantity and Cost. It is located on the *UTL menu.
9. Negative issue transactions for average cost items are now posted with the Warehouse Average Cost.
10. Item Maintenance Tab 6-Orders now uses correct Extended Description when it is changed on the fly in Purchase Order or Sales Order Entry.
11. Card Count Report unit cost field is no longer zero for all inventory items.

Job Cost

1.  Job Estimate Item detail now prints the descriptions for Assembly Items 

 Library Master

1. During Parallel MigrationSystem files NO longer fails to convert with the following error: Error updating SY_SagePEPTrack: PHYSICAL UPDATE ABORT: SY_SagePEPTrack when running
2. MD added menus are now added to the Launcher after migration

 Material Requirements Planning

1. MRP is now showing component demand in the correct warehouse group

 Magnetic Media

1. W2 Electronic Reporting has been modified according to the Social Security Administration's 2011 Specifications for Filing Forms W2 Electronically (EFW2) publication. The 2011 modifications: In W2 Electronic Reporting new field Kind of Employer has been added. "RE" Record--new required field Kind of Employer position 174."RW" Record--Cost of Employer Sponsored Health Coverage position 463-473 "RO" Record--Designated Roth Contributions Under a Governmental Section 457 position 111-121,"RT" Record--Cost of Employer Sponsored Health Coverage position 295-309 "RU" Record--Designated Roth Contributions Under a Governmental Section 457 position145-159
2. In 1099 Electronic Reporting when a Minimum YTD Payment is entered a 1099-MISC "B" record will be created for vendors either have or do not have Misc Box 9 selected in Vendor Maintenance.

 Purchase Order

1. G/L Account substitution is now correct for P/O Receipt of Invoice variance posting when posting by warehouse.
2. The purchase order now retains status of New if the inventory item has not been received
3. Completed drop ship purchase orders no longer display in I/M Item Maintenance or Item Inquiry Orders tab for PO's
4. Item Maintenance "On PO" quantity is now correct
5. Receipt of Goods Entry Error 45 no longer occurs.
6. PO's that have had a return of goods processed against them can now be edited.
7. Auto Reorder Listing now includes the issued quantities with the Quantity Sold.

Payroll

 For Federal eFiling and Reporting of the W-2s, the employee e-mail address will now populate the Electronic Delivery column in the W2/1099 Preparer. If you have not done so already, to set up the employee's e-mail address you will need to do the following:

Paperless Office:

1. From Paperless Office Setup menu select Options. Select the Forms checkbox.
2. From Paperless Office Setup menu select Form Maintenance. Complete the following:

a. Company Code
b. Module Code (P/R)
c. Document (Direct Deposit Stub)
d. PDF Directory
e. Override Password/Confirm Password

Payroll:

1. 1. From Payroll Setup menu select Options. On the Direct Deposit tab select Require Direct Deposit checkbox.
2. 2. From the Payroll Main menu select Employee Maintenance. Select employee, select the Direct Deposit checkbox and then click the Direct Deposit button.
3. 3. On the Direct Deposits window click the Paperless button.
4. 4. On the Paperless Office Delivery Options window complete the following:

a. PDF Document Password
b. E-mail Address (for employee). Accept

After setting up the e-mail address for an employee, if that employee is not paid by Direct Deposit you may deselect the Direct Deposit checkbox on the Main panel in Employee Maintenance. The e-mail address entered will be retained. You will need to perform the Payroll steps 2 through 4 for each employee you want to set up with an e-mail address.

1. New W2 Box 12 Codes DD & EE have been added for W2 Federal eFiling and Reporting.
2. New field Kind of Employer has been added to Federal eFiling and Reporting for W2 Reporting.
3. In Federal eFiling and Reporting new local codes have been added for Ohio.
4. Deduction Code Maintenance and W2 Form Printing have been modified to allow entry of new Box 12 Code DD & EE.
5. Federal eFiling and Reporting has been updated with new federal tax codes for Puerto Rico and local codes for Ohio.

 Visual Integrator

1. New inventory items are now imported into Inventory Delete and Change Utility when the new item is the ALIAS of the original item.
2. The Offset Account is now imported correctly into GL_TransactionJournalheader.
3. Lines are now populated when importing into SO_SalesOrderHeader based on a Repeating Order after upgrading

Work Order Processing

1. The Extension in Work Order Inquiry / Transaction tab now uses the Number of Decimals inCost Entries from Common Information.
2. Phantom Bill can now be reversed in Work Order Entry
3. Quantity is now correct after processing a Work Order completion to multiple warehouses if the second warehouse is a new warehouse.
4. Error 13 WOWDAB 8112 no longer occurs in selecting Make For Sales Order in Work Order Entry and using keyboard shortcuts.

Tis’ the season of giving, but for many fraudster’s, it’s also an opportunity to take advantage of your hectic schedule! Fraud is on the rise during the holiday season. It’s even more important to keep your eyes open for the following fraud indicators. When more than one is true during a card-not-present transaction, fraud might be involved.

•             Larger-than-normal orders

•             Orders that include several of the same item

•             Shipping to an international address (Very High Risk)

•             Transactions with similar account numbers

•             Transactions placed on multiple cards or multiple transactions on one card over a very short period of time

•             Sales processed through the Deaf Relay System

•             Cardholder’s asking for Wires or funds through Western Union

•             Sales that seem “Too Good to be True”

*****Remember*****

Take every precaution at the point of sale. It’s important to take extra steps such as:

•             AVS (Address Verification) is a Match

•             Verify the CVV (3 digit security code) is a Match

•             Always ship to the AVS verified cardholder billing address

•             Look out for "red flags" for fraud signs that can be identified and stopped at the point of sale.

•             Check your batches daily! Especially if you are on automatic settlement and have an online store.
               This gives you the opportunity to identify if fraud is taking place, void the transaction, and then contact
               risk/tech support for help.

If you aren't comfortable with any sale or the sale seems suspicious in any way you can deny the sale or ask for the cardholder to pay using alternate form of payment (i.e. wire, money order, cash).

If you have any questions or concerns regarding a transaction please contact the Risk Management Department at This e-mail address is being protected from spambots. You need JavaScript enabled to view it

Best Regards,

Sage Payment Solutions, Inc.

The following is a list of enhancements and corrections that have been incorporated for Sage MAS 90 and MAS 200 version 4.50 in this Product Update. Product Updates are cumulative, containing all program corrections found in prior updates. Product Update 4.50.1.0 also contains program corrections that were included in 4.40.0.7. These are listed below for reference. The numbering scheme has been changed for 4.50 Product Updates. The third segment represents the Product Update number. This change was done to accommodate future enhancements.

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 Receivable

1. Invoices are now imported into correct Batch when importing into AP Invoice Data Entry.
2. Invoice History Inquiry for performance reasons, the UserKey column that was part of the default ALE lookup has been removed.
3. The correct Customer Name now prints on the Monthly Sales Report.
4. When running the Delete and Change Customers utility in the Accounts Receivable module, the
5. Sales Order/Quote History records for the customer being changed are now renumbered/merged/deleted.

Bill of Materials

1. If an Inventory Item is deleted, all Bill information is now removed that was created for the item.
2. The unit cost on the Single-Level Bill of Materials Report now corresponds to the current unit
3. cost entered in Miscellaneous Item Maintenance.
4. The Costed Bill of Materials report for Option Bills is no longer printing **Invalid Bill** for valid
5. options bills.

 Customizer

1. In Manual Check Entry and Check and Electronic Payment Maintenance, when a UDF is named
   the same as a column in the physical table, and the UDF is mapped to flow thru to these data
   entries, the UDF value is now correctly passed when the Invoice is chosen in both data entries.
2. In UDF and Table Maintenance, in order to map RA ReceiptHeader UDFs to the Generate
   Transactions work table, start with creating:
   1. RA ReceiptHeader udf
   2. RA GenerateTRansactions, use Business object type, datasource RA ReceiptHeader,
       column is the UDF created on step 1.
   3. RA GenerateTransactionsWork, Business Object UDF type, datasource RA
      GenerateTRansactions, column is the RA GEnerateTRansactions UDF created on step 2. 

 General Ledger

1. Able to print recurring journal numbers in Reprint Journals.

 Inventory Management 

1. 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. 
2. In Physical Count Update, Count of Zero for Standard Cost and Tiered valuation methods the TotalWarehouseValue is now cleared.
3. Lot/Serial valuations now correctly display the actual Receipt No. and Receipt date of the cost tier transferred.
4. Inventory item Quantity on Sales Order is no longer incremented after adding cost code information to an existing sales order without changing line quantities.
5. 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.
6. Item Inquiry, Quantity Recap, the Beginning, Ending and Current Average Cost fields now appear with the Module Option selected to Allow Inventory Costing, Receipts in Item Inquiry 
7. 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.

 Library Master

1. Error “Prepare failed SY_SQLTranslateFailed:SYS” no longer occurs while running the Parallel Migration Wizard
2. General Ledger Detail by Source for Out of Balance Journal Reports (for Level 3.x) in the Pre-migration utility no longer displays Out of Balance Journals if the same account number is used more than once in the same Journal.
3. 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".

Material Requirements Planning

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

 Paperless Office

1. 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

1. Receipt of Goods Entry Error 45 entry no longer occurs

 Payroll

1. Deductions based on Regular Hours Worked now pull into payroll data entry after being converted.

 Sales Order

1. The original cost for a serial item is returned on S/O credit memo update provided the cost tier still exists in IM_ItemCost
2. Ship weight is now calculating correctly in Sales Order Entry and Sales Order Invoice Entry after conversion.
3. 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.
4. Shipping Data Entry Focus now returns to Item Code Field when Kit item is not exploded. 

 Visual Integrator

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

 Work Order Processing

1. WO transaction entries now fill all required fields when creating new entries in IM_ItemCost.
2. 2 WO completion transaction now prompts for Lot Number

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

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

 Accounts Receivable  

1. The correct Customer Name now prints on the Monthly Sales Report.
2. Invoice History Inquiry, for performance reasons, the UserKey column has been removed from the Invoice No. lookup.
3. 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.
4. 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.
5. The custom lookup now displays correct quantity in Customer Sales History Flashlight Lookup in Customer Maintenance.

 Bill of Materials

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

 General Ledger

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

Inventory Management

1. 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.
2. In Physical Count Update, Count of Zero for Standard Cost and Tiered valuation methods The TotalWarehouseValue is now cleared.
3. The Inventory Turnover Report’s calculation no captures all periods including the periods that don’t have any activity.
4. Sales Journal Update for for a FIFO item when the shipped qty exceeds the Tier Qty is now clearing the CostCalcCostCommitted and CostCalcQtyCommitted fields.
5. Quantity On Hand and Over/Short Variances no longer change when using Count Card Entry
6. Serial numbers are now correctly updated when receiving multiple serialized items in Receipt type Transaction Entry.
7. Lot/Serial valuations now correctly display the actual Receipt No. and Receipt date of the cost tier transferred.
8. 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.
9. Inventory item Quantity on Sales Order is no longer incremented after adding cost code information to an existing sales order without changing line quantities
10. The vendor item code is no longer removed when a different alias item code is deleted from alias item maintenance.
11. 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.

1. 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

1. 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.
2. Library Master Utility Rebuild Sorts for purchase order, now rebuilds the PO_OpenOrderDetailByItem.M4T table.

 Payroll

1. 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: 

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

 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.

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

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

Sales Order

1. Customer Last Purchase History is no longer blank in Sales Order and Sales Order Invoice Data Entry.
2. The Customer's Credit Limit Exceeded warning is now displaying in Shipping Data Entry when customer has exceeded the aging or credit limit.
3. Correct cost is returned to an existing cost tier for serial number on S/O credit memo3
4. Ship weight is now calculating correctly in Sales Order Entry and Sales Order Invoice Entry after conversion.
5. 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.
6. The Location Code List now displays all existing codes that begin with the character entered in the Ship To Addr field.
7. 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.
8. In Shipping Data Entry Focus now returns to Item Code Field when Kit item is not exploded.