The following is a list of enhancements and corrections that have been incorporated for Sage MAS 90

and MAS 200 version 4.10 in this Service Update.   Service Updates are cumulative, containing all

program corrections found in prior updates.

Records are now being created in AR Cash Receipts History after clearing a large number of

invoices through AP from AR Clearing in Accounts Payable.

An error 26 in program APWUGA on line number 3550 no longer occurs after clearing a large

number of invoices through AP from AR Clearing.

The Trial Balance Report now prints the invoice number and invoice balance when an invoice is

created  in a future period and a credit memo, debit memo, or adjustment is applied to the invoice in

the current period.

An Invoice Header UDF mapped to Invoice History Header UDF is correctly passing the UDF value

during the Sales Journal Update.

The job number is now correctly defaulted from the original invoice when an adjustment is entered

Track Job Cost Retention Receivables in AR Options is No.

Bank Reconciliation is being updated when no deposit amount is entered when accept is selected

on an out of balance situation.

Accounts Receivable Invoice History Inquiry and RMA Inquiry in Customer Maintenance now

correctly display information when there are new customers starting with the same letters as an

existing customer.

The Cash Receipts Recap Report now prints cash account postings on the same line when multiple

deposits are entered for miscellaneous cash receipts.

The fields TaxableSalesAmt & NonTaxableSalesAmt in AR_RepetitiveInvoiceHeader are no longer

erroneously included in the Data tab in Visual Integrator.

AR Cash Receipts Update now correctly updates the retention amount when paying retention for

Job's that have less than seven character Job Numbers.

In Customer Maintenance, the message "Record XXXXXXXXX has been changed by another user

and the changes will not be saved," no longer erroneously displays when saving a new customer

with credit card information, if the Automatically Recalculate Aging Option is selected in Accounts

Receivable Options.

In AR Invoice Data Entry, the retention amount no longer incorrectly rounds when the amount is

entered manually.

In Invoice Data Entry, for Terms Codes set up to use day of Month, if the Invoice Date is between

the Discount Day of Month and Due Date Day of Month, the discount date now correctly increments

the Due Date and Discount Date by one month.

When rebuilding sort files for Accounts Receivable, and selecting the Recalculate Open Order

Amount check box, the credit card number is no longer cleared from the customer file.

The Accounts Receivable Commission Edit Register now correctly updates Payroll so that the

Federal, State, and FICA withholding tax are generated for commission wages.

A Recalc Avg Days to Pay utility is now available to correct the calculation of the average days to

pay on the Statistics tab in Accounts Receivable Customer Maintenance.

Note: To run this utility, from the File/Run menu enter *UTL and select the Recalc Avg Days to Pay

option.

The Accounts Receivable Commission Edit Register now correctly updates to Payroll Data Entry

only for the linked employees who have commissions to be paid.

When the Accounts Receivable Cash Expectation Report is printed with the Use Average Days to

Pay check box selected, it now displays the projected cash receipts in the correct Payment Due

Through field.

The Accounts Receivable and Sales Order Update programs now correctly update the data for the

Accounts Receivable Analysis Report.

In Accounts Receivable Customer Maintenance the performance has been enhanced to improve the

load time of invoices into the Invoices panel.

In the Aging and Finance Charge Section of the Accounts Receivable Options, If the Aging "Age

Invoices By" is set to Due Date and then the Aging Category for Calculation is entered, and then

subsequently the Aging Category By is changed to Invoice Date, the finance charges will now

correctly be calculated.

The Credit Card Settlement Report now correctly lists post-authorizations under the company code

after the Sales Journal is posted.

In Cash Receipts Entry, the Invoice Amount now displays correctly when a Cash Receipt is entered,

changed, recalled and changed again.

Running Period End caused Similar named Customers information to be removed i.e. Customer

01-ROCK and 01-ROCKWELL.

If 01-ROCK was a temporary customer then running period end caused Invoices of both 01-ROCK

and 01-ROCKWELL to be removed.

In Invoice History Inquiry, the tracking number will now display in the Summary Package tracking

Inquiry window.

In UDF and Table Maintenance, creating a UDF for AR Cash Receipts detail and choosing the Data

Source InvoiceNo will now correctly pull in the column assigned.

For Repetitive Invoices that have a short customer number (for example; 01-AA, 01-AA1, 01-AA2)

and have the same reference number the sales tax detail records will no longer be removed when

the repetitive invoice for customer 01-AA is deleted.

In Invoice History Inquiry, "The shipping invoice failed validation on Y,N" no longer occurs when

clicking on the Shipping button

In Invoice Data Entry, the correct price now comes in when the item code is changed on an existing

line.

In Cash Receipt Entry, previously entered receipts now correctly remain after canceling a new

deposit.

In Import S/O Transactions and Unattended Import, FOB, Ship Via and Ship to code fields now

import into Shipping Data Entry correctly.

During Import S/O Transactions and Unattended Import, if an item code contains a space (i.e.,

TEST ITEM), the ship quantity is now correctly imported into the invoice.

In Unattended Bar Code Import, lot and serial numbers are now still available after a failed import

attempt.

The Daily Transaction Register for a Bill of Materials production now correctly posts the

manufacturing variance if the parent item is Lot-valued and components have Unit Costs to 4

decimal places.

The Bank Reconciliation Register now prints sorted by Bank Code, Document Type, Check No.,

Date and Entry Number.

In the Bank Code Maintenance, Cash Deposits and Adjustment Entry, and Reconcile Bank tasks,

an erroneous busy message is no longer displayed.

Sales Order Inquiry from Inventory Inquiry no longer hangs when the item contains an extended

item description.

A blank form code is no longer created when adding a Custom Tab to the Sales Order Printing or

Picking Sheet Printing lib.

The validation list assigned to a drop box UDF is missing when there is another UDF that is mapped

from the drop box UDF and has the same field name.

Error 46 no longer occurs during data conversion of Sales Order or Accounts Receivable UDFs from

4.05 to 4.10 that have previously been migrated from 3.71 where edits to these UDFs were made

prior to upgrading to 4.10.

Text Objects added using Customizer Selection now correctly anchor to their original position when

a window is resized.

The Sales Order Printing and Sales Order Picking Sheet Printing print screens are now available in

Customizer Selection for editing.

In Business Insights Reporter, you can now generate a report when a user-defined field exists with

same name as a field in the file.

Account memos now correctly display for General Ledger account numbers that contain a short

alphanumeric segment.

When attempting to update from a subsidiary module to the Daily Transaction Register, and the

General Ledger Daily Transaction Journal is being previewed or printed, the user in the subsidiary

module will now receive the message, "A file is in use by another task." and Retry will continue until

the General Ledger Daily Transaction Register is exited or updated or the user can choose End to

exit out of the update. The subsidiary module postings will no longer be erroneously removed.

When setting a default printer which is different from workstation default printer is selected for a

Financial Report Group, the financial reports will now correctly print to the default printer saved in

Financial Report Group Maint.

After reinitializing the Inventory Item Masterfile, new items added can now be selected in the Sales

Order module.

In Inventory Maintenance,  an Error 26, IMWMAA, line 1310 no longer occurs when accessing an

item that has had a long description deleted.

In Inventory Maintenance, the 'Quantity in Shipping field now correctly displays quantities being

invoiced/shipped for warehouse codes less than three characters.

In Inventory Maintenance, the Item Description will no longer incorrectly be cleared when clicking

the item text text maintenance button.

In Inventory Item Maintenance for items with an extended description, data entered into a UDF is

now correctly saved.

Inventory Utilities Item Merge will now correctly merge if the new item number is lower than the old

item number; for example, trying to Renumber/Merge item 3000 to item 1000.

After installing IM4006-T this utility must be run.

This utility has been enhanced to include the IM2 QUANTITY Issued  PTD/YTD data.

In Sales Kit Maintenance, an Error 26 program IMWMBB Line 20210 no longer occurs when clicking

the OK button in Item Text Maintenance.

The fields TaxableSubjectToDiscount,  NonTaxableSubjectToDiscount,

TaxSubjToDiscPrcntOfTotSubjTo, TaxableAmt, and NonTaxableAmt in IT_ShoppingCartHeader are

no longer erroneously included in the Data tab in Visual Integrator.

An Error 0, IT_ShoppingCart_Upd.pvc 0000, in the e-Business Manager Web Error Log will no

longer occur when the Sales Tax Reporting check box is cleared in Accounts Receivable Options.

The Freight amount on the e-Business Manager shopping cart confirmation page is now calculated

correctly.

When viewing the RMA detail on the web, the page now correctly displays a listing of each lot and

serial distribution record along with the quantity distributed.

When updating a Cash Receipt posted using Job Posting Entry, the update will now correctly reduce

the retention amount.

The 'Fix Job Cost Data Files' utility is now available to correct the following Job Cost 4.10 data

issues :

- Corrects payment records in the Billing History (JC3) and retention amounts in the retention record

(JC_03) created for job numbers that are fewer than 7 characters, for example; job numbers APT1,

HOUSE2, BLAKE, etc.

- Corrects records in the Job Masterfile (JC1) for jobs created using Estimate Update to Jobs.

- Corrects Deferred Revenue and Unbilled Cost records in the Job Masterfile (JC1) and Cost Detail

file (JC2) for Completed     Contract jobs where Works in Process is selected in Job Cost Options.

Note: Remember to back up your data prior to using the utility. To run this utility, from the File/Run

menu enter *UTL and select the Fix Job Cost Data Files option. After the utility is completed, verify

the job information, review the log that will be stored in the company JC folder (named JC1Utility,

User Code, Month, Day, and Session ID.txt) and make any adjustments to the retention rates if

need be. This utility will be processed for the Job Masterfile (JC1) records regardless of any

developer modifications. Please contact your MD prior to using this utility.

This change corrects a random hanging, an Error 14 message, or an Error 27 entry in the Activity

Log issue that may occur when using the Broadcast function in Master Console.

Error 65 SWMZI, Line  0031 will no longer occur when creating new ZIP code on the fly in legacy

modules.

MAS Office button is no longer missing the second time it is selected on the same lib in the same

session.

The File Layouts and Program Information link on the "Resources" page, and result links from a

query on the "How Do I?" page will now work correctly with IE7.

For MAS 200 installations you also need to perform the following steps on each workstation:

1. Copy the ..\MAS90\Help\awSearch.js file from the MAS 200 server to the local ..\MAS90\Help

folder

2. Copy the ..\MAS90\Launcher\Html\Home.htm file from the MAS 200 server to the local

..\MAS90\Launcher\Html folder.

The Lookup Customization Wizard Available fields list for Inventory Maintenance now contains the

CI_Item user-defined fields. (DE 65072, PER 96788)

An Error, CI_NOTCREATED:SY_SESSION, no longer occurs during the installation of a Service

Pack or Service Update. If the PvxDax.DLL is not registered, the correct error message will be

displayed.

The error, “This view cannot be used. One or more tables are missing.” no longer will display when

creating Business Insights Report and selecting various AP Vendor views. (DE 66394, PER 97061)

When new memo default settings are added they are now copied over to existing company memo

setting tables.

MRP Inquiry and MRP Report  no longer show Quantity on Hand as twice the actual amount

showing in inventory after running MRP Generation and clicking the Print button.

In MRP Generation, the component demand is now correctly calculated if the Item's default

warehouse is different than the parent item's warehouse.

Return of Goods batch records are no longer deleted from the PO Batch Masterfile (POV) after

accessing Receipt of Goods Entry.

In RMA Entry, an error 65 SY_MemoHandler_ui.pvc 529 will no longer occur when Accepting the

entry while focus is on the Custom Tab.

When the Accept button is selected when focus is on a Custom Tab added through Customizer

Selection for RMA Entry an Error 65 SY_MemoHandler_UI.pvc 529 Class SY_MemoHandler_UI

Method GetMemo CtlInfo no longer occurs.

Unselecting All or Credit Memos in Comment Options dialog no longer invokes message 'The

column is not in the IOList.'

In RMA Data Entry and Receipts Entry, the Item Action field is now correctly disabled for drop ship

items when Auto Display Item Selection Screen in RMA Options is selected.

A utility has been created to correct Sales Kit Lines that have been converted from versions prior to

4.10.  After running this utility, RMA lines for RMA’s that were created prior to converting to Version

4.10 can now be accessed.

To run this utility, from the File/Run menu enter *UTL and select the Fix RMA Return Detail option.

In Generate Transactions, the Qty on SO and Qty Committed in Inventory are now correctly updated

when an item is returned for repair, and Track Repair Items Through Inventory in RMA Options is

selected.

Generate Transactions now correctly generates credit memos in Sales Order for invoices paid with a

credit card.

In Shipping Data Entry, tracking number are retained after answering No to the credit limit exceeded

warning

In Sales Order Printing, tax amounts now print correctly when Tax Code Detail fields are added to

the form.

In Shipping Data Entry when a date field has been moved to the primary grid, the entry will now

properly be saved, if the Quick Print button is clicked prior to accepting the entry.

The Daily Transaction Register is no longer out of balance when components of an exploded kit are

drop shipped.

Running the Sales Tax Calculation Utility to correct tax detail records now correctly recalculates and

creates tax detail records as needed in Accounts Receivable and Sales Order.

Packing List Printing, performance has been tuned to better handle large records counts within the

Invoice Header File

An existing SO Ship To Address UDF on the Address tab in Sales Order Entry will now have to be

mapped to a Sales Order Header UDF.

Follow the steps below AFTER loading the new .M4L:

1.  Install program fix

2.  Customizer Selection

3.  Expand Sales Order

4.  Expand Sales Order Entry

5.  Edit the Paddress panel that was customized (and PaddressW if Ship To Address UDF was

added)

6.  Delete the Ship To Address UDF from the Paddress/PaddressW panels.

7.  UDF and Table Maintenance

8.  Expand Sales Order

9.  Edit fields SO Sales Order header

Note:  you will be mapping your SO Ship To Address UDF to the SO Sales Order Header table.

10.  Click Add

11.  Enter Field Name and Description

12.  Choose Business Object radio button

13.  Choose ShipToCode Data Source

14.  Choose your Ship To Address UDF from the Column drop box

15.  Save UDF and Update

16.  Customizer Selection

17.  Expand Sales Order

18.  Expand Sales Order Entry

19.  Edit the Paddress/PaddressW panel(s) and add the SO Sales Order header UDF to the panel.

Values entered in the SO Ship To Address UDF will now pass to the mapped SO Sales Order

header UDF.

Daily Sales Recap Report by Customer, Period to Date and Year to Date Sales and Profit % are

now correct when multiple invoice batches are posted at the same time

The Sales Order and Quote History Report now prints the correct extended amount when Extension

calculated by Revised Quantity is selected.

In sales order and invoice printing, component detail no longer prints when kits defined with the Print

Detail checkbox cleared are inserted between other line items.

In Order and Invoice Data Entry, when the Job Cost Option to "Post to GL for Work in Process" is

selected, the GL Cost Account is now updated when the defaulted cost code is changed.

In Shipping History Inquiry selecting a shipment from the lookup no longer displays "The header

sequence number is required".

Picking Sheet Printing, Sales Order Option to print Picking Sheets by Line Number now functions

correctly when sales order lines are shipping from multiple warehouses

In Sales Order Entry, when a price quote is converted to a standard order, the Qty on SO for the

items on that order is now correct when the last item uses a unit of measure conversion factor

greater than 1.

Sales Order Entry and Invoice Data Entry partial item lookups now display correctly after using the

Ship To lookup.

In Invoice Data Entry and Shipping Data Entry, the "Sales Order header in use by another task"

message now displays correctly.

In Shipping Data Entry, "Not On File Customer Number" and "Not On File Division Number" no

longer display on the Error Log after clicking No at the "Customer credit limit has been exceeded"

message in Shipping Data Entry.

During Invoice Data Entry, the Deposit Amount field is now enabled when the current Payment Type

has Other selected at the Payment Method field in Payment Type Maintenance.

In Sales Order Entry and Invoice Data Entry for orders or invoice numbers that begin with the same

alphanumeric numbering scheme (for example, A111345, A111346, etc.), if the common order or

invoice number is cancelled or deleted (such as, A111), the detail and summary tax records for the

similar numbered orders/invoices are no longer removed.

In SO_SalesOrderHeader and SO_InvoiceHeader the fields TaxableSubjectToDiscount,

NonTaxableSubjectToDiscount, TaxSubjToDiscPrcntOfTotSubjTo, TaxableAmt, NonTaxableAmt

are no longer erroneously included in the Data tab in Visual Integrator.

In Shipping Data Entry, the number of packages is now correctly updated when packages are added

and deleted through Summary Package Tracking.

In Invoice Data Entry, miscellaneous items now correctly display when doing a partial lookup after

changing a ship-to address.

Picking Sheet Printing no longer prints line items twice on picking sheets when similar alpha order

numbers exist (for example, A, AA, AAA), and the picking sheets are sorted by line number.

In Invoice Data Entry, the payment type can now be changed when invoicing an order, and on a

one-step invoice; at the time of entering the invoice, and after accepting and recalling.

In Sales Order/Quote History, the Totals tab now correctly displays the order totals for partially

shipped orders.

When using the SO_Shipping_bus object to import shipping data entry with batches enabled, the

batch sub type is now being correctly set to "S" for shipping.

In Shipping Data Entry, in Item Packaging Maintenance, when clicking the Next Package button to

distribute a single line item into multiple packages, the quantities now distribute correctly.

In Invoice Data Entry, for invoices that have a short alpha number, the sales tax is no longer

removed when the invoice is accepted.

In Customer Last Purchase Maintenance, the Last Purchase Date no longer incorrectly changes

when the Rebuild button is clicked.

In Invoice Data Entry, the message "This order is currently being invoiced" no longer incorrectly

displays after cancelling or deleting a prior invoice for the same order and then selecting an

alphanumeric sales order number with less than seven digits, .

In Shipping Data Entry the message "This order is currently being shipped" will no longer

erroneously be displayed when recalling a shipment.

In Shipping Data Entry, the error message "SO_SalesOrderHeader.m4t is in use by another task"

will no longer erroneously be displayed when recalling and deleting a shipment.

In Sales Order Entry the freight amount will now be correctly reset to zero after a Backorder (when

you partially invoice an existing order) if the 'Use Shipping Code to Calculate Freight field in the

Sales Order Options window is set to No.

When the Sales Order module is integrated with Job Cost, and a job number is not entered on a

one-step invoice, the Qty on SO and Qty Committed in Inventory are now correctly updated.

When batch processing is enabled, the lookup for the shipping number in additional packing list

printing is no longer blank.

In Sales Order entry, the correct cost now displays for alias items in the Sales Order Entry Lines tab

when typing an item alias number following a line for a regular inventory item number.

The Sales Journal update now correctly updates the retention amount in the Job Cost files for jobs

with a job number fewer than 7 characters, when making a deposit that includes retention.

Note: If you have been using version 4.10 prior to installing this service update, run the Fix Job Cost

Data Files utility to correct your retention amounts after installing this service update but before

performing any new Sales Journal updates. To run this utility, from the File/Run menu enter *UTL

and select the Fix Job Cost Data Files option.

The Sales Order Sales Journal update now correctly posts to the general ledger and to the Job Cost

Code Detail file (JC2) for non drop-shipped items that have a Cost Code and Cost Type.

In the Sales Order Sales Journal update, drop-shipped lines now are correctly posted to the job

even if a cost code/type is entered.

When updating a sales order invoice that contains a job that is using the Completed Contract

accounting method, the postings to the Job masterfile (JC1) and the Job Cost Detail file (JC2) for

Deferred Revenue and Unbilled Cost are now correctly included in the update.

Note: If you have been using version 4.10 before this service update, run the Fix Job Cost Data

Files Utility. To run this utility, from the File/Run menu enter *UTL and select the Fix Job Cost Data

Files option.

When a sales quote is turned into an order, drop-ship lines are now correctly writing the vendor

division to the SO_SalesOrderDropShip table.

In Sales Order Invoice Data Entry, the payment type is no longer disabled when a customer number

is entered that begins with CASH, for example; 01-CASH123.