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

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

program corrections found in prior updates.

During the Invoice Register Printing, an error 11 AP_InvoiceRegister_upd.pvc, line 1139 no

longer occurs when using 2 items with the same account # and 'Post to GL Invoice Register in

Detail' in AP Options is unchecked.

In Check Maintenance,  the discount for an invoice selected from the Invoice Selection window

using the OK button now displays the discount when the previous invoice selected was past the

discount date.

The Invoice Register update now correctly posts amounts in detail when negative and positive

amounts are entered on an invoice to the same GL account, and Post Invoice Register in Detail

in Options is selected.

In Invoice Payment Selection, using the Equal To operand in the Job Number field now correctly

selects only the job number entered.

Credit Memos/Negative Invoices created from Return Orders that were generated by RMA are

now selected in the Invoice Payment Selection.

Invoice Payment Selection by discount due date using the discount due date field now includes

the correct invoices.

Accounts Payable Repetitive Invoice Selection creates invoices that match the selection criteria

when multiple selections are processed before updating.

The correct job description now prints on the A/P Open Invoice by Job Report when an invoice is

updated with multiple jobs using the same cost codes and cost types.

During the Check Register Update, check numbers are no longer voided when another check

was added and printed after some checks were already printed.

Accounts Payable Sales Tax Report now reflects invoices that were received through Purchase

Order using different Receipt and Invoice Dates.

In Check Maintenance, invoices already selected for payment are no longer reselected on

another check entry when using the Select button.

When printing a large number of forms (A/R statements and/or S/O Invoices) to PDF through

Extended Solutions, a memory leak no longer occurs.

Running the Miscellaneous Item Listing Report no longer returns a message “Application is

attempting to open more files than allowed” when there are over 250 miscellaneous item codes.

The Invoice History Header UDF data now populates the Invoice Header UDF for an adjustment

invoice.

In Customer Maintenance/Inquiry, Invoices tab, the reference number is now displayed when the

payment type used is 'Other'.

The AR Trial Balance now correctly prints the Invoice Amount, Discount Amount, Retention

Amount, and Invoice Balance when the Prepayment date and Invoice date are the same.

The 'Payment Method is required' message no longer occurs when selecting or creating a

Payment Type in Accounts Receivable set up, Payment Type Maintenance Option.

In Cash Receipts Entry, the correct discount amount is now applied when Auto is selected to pay

a second invoice for a customer.

Finance Charge Invoices are now printed on the Aged Invoice Report when report is sorted by

salesperson.

In AR_CashReceipts, OpenItemCustomer is now a Read Only field, and no longer available for

import in Visual Integrator.

Invoices that were updated from Job Cost module are printed properly on the Accounts

Receivable Invoice History Report.

Salesperson number which is less than four characters can be selected using the lookup list in

Global Customer Change Utility. Previously, the salesperson number disappeared if it was

selected by using the lookup list.

In Finance Charge Entry, aging information is now correct when invoices are aged by invoice

date.

A Job number can now be imported into an existing record in AR_InvoiceHistoryHeader without

error.

An Invoice containing a period can be entered and updated and displayed correctly in the lines

tab in Invoice History Inquiry.

Memo auto display is now working properly. Previously, is some cases memo would not auto

display when it was supposed to.

In Import P/O Transactions and Unattended Import, serial numbers that already exist in

inventory can now be imported if they have a zero quantity on hand.

In Import Sales Order Transactions, the quantity shipped for parent item of an exploded kit is

now correct.

During Unattended Import, when printing to deferred, an error 14 BCWTEA, line 6270 and error

14 BCWTEB, line 1115 no longer occurs when importing Purchase Order Transactions and

Sales Order Transactions.

When importing Sales Order shipping invoices, the bill-to address is now correct, based on the

sales order, rather than Customer Maintenance.

During Import S/O Transactions, credit card information now comes into the shipping entry from

the order.

Purchase Order Daily Receipts Registers can now be updated while Bar Code imports are in

progress.

After importing Purchase Order Transactions, if a receipt is attempted to be entered for the

same purchase order already in data entry, the 'Purchase order is already being received.'

message now displays.

Import Purchase Order Transactions and Unattended Bar Code Import no longer allow importing

a serial number that is already in Inventory.

When importing Sales Order invoices, the bill-to address is now correct, based on the sales

order, rather than Customer Maintenance.

In Import S/O Transactions and Unattended Import, information for imported shipping entries

now comes in from the sales orders instead of the customer file.

When importing Sales Order transactions, freight is now imported from the .odb file when Use

Shipping Code to Calculate Freight is set to No.

In Unattended Import, when more than 9 .odb files are in the import folder, an error 280

BCWTFA 0215 - "Application is attempting to open more files than allowed.  Terminate it?" no

longer occurs.

On the Costed Bill of Materials Report, the cost information for items with subassemblies now

prints on the same line as the item.

When accessing Item Maintenance through the 'Item' button in Bill of Materials Maintenance, the

Extended Description does display.

Update Custom Panels to Current Level no longer changes text boxes and/or removes them

when the Inventory Quantity on Hand & Reorder screen has been modified.

Additional keys added to existing tables by developer enhancements are no longer removed

when a service update is installed.

Running the Update Customizer Panels to Current Level will no longer select the Tab Stop

check box for every Field Definition on the lib.

A comment longer than 1000 characters in either an Order or Quote no longer causes an error

88 in CU_SCRMLink_bus.

The register/journal updates now look at the source journal as well as the journal number when

updating to the Daily Transaction Register.  Therefore, "phantom" source journal postings no

longer occur when multiple source journals within a module have the same number.

In Allocation Maintenance, allocation total is incorrect when using Manual quantity based

allocations to a odd number of accounts.

The Trial Balance Report now prints current period transactions when using thirteen fiscal

periods with periods crossing over months.

An Item Extended Description is now recognized in Sales Order Entry and Invoice Data Entry

when the extended description entered in Inventory Maintenance was entered on two lines and

is less than 30 characters.

When the I/M Delete/Renumber/Merge utility is run and  there are unposted RMA entries, a

message warning the user that "RMA data entry is in process and continuing

Delete/Renumber/Merge may result in future errors." is displayed.

When making changes to Customer Maintenance, "File access mode invalid" Error 13

CI_CustomerAging.pvc 00247 for e-Business Manager .store customer no longer occurs.

An IT order automatically accepted into Sales Order Entry should no longer display in Shopping

Cart Accept/Reject Entry.

An item created using the Copy From feature in Inventory Maintenance, is now displayed on the

Products & Services page.

Temporary shopping cart records should now be removed from the eBusiness Manager

Shopping Cart data files based on the 'Hours to Retain Shopping Cart Entry' setting on the

Shopping tab in e-Business Manager Options.

e-Business Manager now functions after installing a Master Developer enhancement or

Extended Solution that modifies a base class.

"The ending date must be later than or equal to the starting date." no longer displays while using

the View Invoice Options when years '01' thru '09' are used, and the ending date is later than the

starting date.

On the Products and Services page, when there is only one item in a category, entering a

quantity and using the Enter key now correctly adds the item to the shopping cart.

When clicking on the 'Finish' button on the 'Shopping Cart Confirmation, Step 3 of 3' web page,

"The shopping cart referenced on the page submitted has already been completed. Your

Shopping Cart is empty." no longer displays when the page has not actually been completed.

"Attempting to open too many files" on the web engine no longer displays when searching by an

item description.

During conversion, numeric User ID's in User ID Maintenance are now zero-filled.

This utility will zero fill numeric User ID's, i.e. 111 to 000000000000111 to insure users can log in

to the website. To run this utility, from the File/Run menu enter *UTL and select the Pad Numeric

e-Business Manager User ID's utility.

On the Invoice Inquiry page, an invoice with a Package Tracking number correctly displays the

'tracking' link to check the status of the package.

On the Products and Services page, the Search feature no longer displays the same item

multiple times, when the item is assigned to more than one category.

After billing retention, the retention, invoice balance and aging amounts in AR Customer

Maintenance are now correct.

The Job Billing Register update now posts future sales history to the correct period in the AR

Salesperson History file.

New invoices now display correct information in history drill down from customer maintenance

and payment drill down from the Job Masterfile Billing tab when two invoices with the same

number exist and one was created in Job Billing .

When upgrading from 4.10 to 4.20 and installing 4.20 Service Update 15 without converting data

first, the process hangs while "Merging dictionary...." message is displayed.

The Resequence Views Files utility has been written in order to renumber the records in the

views file to eliminate the gaps left when views are deleted. There is a 99,999 record limit, so

this utility ensures that deleted record numbers are reused.

All BI reports previously created in 4.20 no longer receive a message that the data is in use after

installing the 4.2 service update

In the Rebuild Sort Files utility, an error 11 POWUZA, line 3330 no longer occurs after using

Visual Integrator to import a new item into PO.ORDER.

After upgrading from Version 4.10 to 4.20, records are no longer removed when rebuilding the

following files:  AR_InvoiceHistoryHeader, AR_PaymentType, SO_SalesOrderHistoryHeader,

GL_CheckMICR.

In the Custom Lookup Wizard, an error 11 SWQMAN line 1475 no longer occurs when an ALE

lookup is customized with User-Defined Table fields.

The data files are listed in the ODBC Security Tab within Role Maintenancewhen the module is

expanded.

Converting from version 4.05 to 4.20.0.6 no longer generates Error 12 AR_LevelConversion at

line 195.

In Invoice History Inquiry, an error 47 SWACCT, line 2040 no longer occurs when selecting an

invoice that has a job number, and the Job Cost module has been uninstalled.

Error 88 SY_TemplateManager, line 530 no longer occurs when the template file is use by a

second user and the first users cancels out of Office Template Manager.

MRP Generation now shows component demand for the parent item's warehouse rather than

the item's default warehouse.

MRP Generation no longer creates records in the MP_04 file with blank Warehouse Groups for

items in a phantom bill(s) that is the first component(s) on the parent bill.

MRP Report now prints the correct 'Make Qty' recommendation for Sales Order Demands when

partial quantity is available in inventory or on 'Make for' Inventory work order.

MRP Report no longer provides an ORDER Action recommendation for Projected Demands

when Quantity is available.

Partial completions of subassembly work orders using 'Make For' Work Order correctly reflects

all Demands and Issued/Supplied quantities.

An error 42 MPWRBA line 2455 no longer occurs printing the Projected Demands Report when

there are weekly projected demands.

The Quantity Sold no longer updates based on a calendar year even though Inventory Options is

set to Fiscal Periods to match GL Fiscal Year Maintenance.

During MRP Generation, records are no longer being created in MP_04 (Supplies and Demands

file) that have the warehouse in the warehouse group field.

In Purchase Order Printing, the correct purchase order(s) now print when multiple users

simultaneously attempt to print individual order selections.

Auto Generate Order Selection no longer includes sales orders on hold when the ‘Select Sales

Orders on Hold’ option is not selected.

In Receipt of Goods Entry, multiple receipts for the same serial number for an item are no longer

allowed.

During the Daily Receipt Registers Update, if the sort file is in use by another task, the program

now continues to retry until the file is available to be properly cleared.

When a receipt of invoice is processed for miscellaneous charges only, the purchase order is no

longer flagged as completed when there are inventory items still to be received.

During the Daily Receipts Register update, negative balance adjustment transactions for

average cost items are now correctly calculated.

In Check Printing, the Taxable Wages and Non-Taxable Wages fields now print the correct

amount.

Taxable Wages printed on the Quarterly 941 Report are no longer reduced by a Pension Plan

deduction that is not set up to reduce tax.

The Quarter To Date FICA tips wages are now correct on the Quarterly Pay Period Report and

on the Quarterly 941 form when converting payroll in the middle of a quarter.

The 941 Form has been updated with 2008 IRS changes to the form.  The changes are only

applicable to the Report Format ‘Entire Form’ since the changes are in the text of the 941 Form

and the year on the 941 Form.  The IRS has not made any changes to the Schedule B for 2008.

Instructions--If the 4.20 2008 941tip PR4017-T has been downloaded before installing Service

Update 14 no action will be necessary after the service update is installed for 2008 941 quarterly

reporting.

Instructions— If you have NOT downloaded 4.20 2008 941 tip PR4017-T ,before installing 4.20

Service Update 14 you will need to process as follows:

1. Using Windows Explorer, browse to the ..\MAS90\Reports directory and rename the following

report:

• PR941A.rpt  (example:  pr941a.rpt.2007 report)

2. Rename the following file in the ..\###-###\ and ..\###-xxx\ folders (xxx = company code):

• PR941A.rpt  (example:  pr941a.rpt.2007 report)

3. Install 4.20 Service Update 14.

4. Open Payroll / Period End / Quarterly 941 Printing. Click ‘OK to the message “The Crystal

RPT file for ###-xxx (xxx being company code) does not exist. The default form will be used.

Ok”.

In Payroll Data Entry, the "Wages Subject to W/H Less than zero - Delete The check?" message

no longer displays after entering a check with an earnings code not subject to taxes and a

deduction code that does not reduce taxes.

Taxes and Deductions now print on non-graphical checks when the employee has YTD earnings

for more than 13 earnings codes.

In Payroll Data Entry, the "Wages subject to W/H less than zero - Delete the check?" message

no longer appears when entering a negative cafeteria deduction.

941 Form 2007 Update:

The 941 Form has been updated with 2007 IRS changes to the form.  The changes are only

applicable to the Report Format ‘Entire Form’ since the changes are in the text of the 941 Form

and the year on the 941 Form.  The IRS has not made any changes to the Schedule B for 2007.

Instructions--If the 4.20 tip PR4013-T has been downloaded before installing Service Update1

no action will be necessary after the service update is installed for 2007 941 quarterly reporting.

Instructions—If the 4.20 tip PR4013-T has NOT been downloaded before installing Service

Update 1,

after installing in the Reports folder under your MAS 90/MAS 200 installation locate the ###-###

and ###-xxx (xxx being the company code) folders and rename the report PR941A.rpt.

(example:  pr941a.rpt.2006 report)

When you first access Quarterly 941 Printing you will receive the message “The Crystal RPT file

for ###-xxx (xxx being company code) does not exist. The default form will be used. Ok”.  Click

ok to this message.

Sage Payment Solutions for Credit Card Processing is available and the

..\MAS90\PDF\SagePaymentSolutionsSetup_v420.pdf document is copied to provide setup

assistance.

Generate Transactions now generates credit memos and sales orders at zero dollars when

options for repair and replacement are set to generate at zero dollars and 'Allow Price Override

in S/O Data Entries' in Roles is not selected.

When an 'On File' invoice is used and the default Customer Action is 'Credit', the original cost is

now used when updating the Credit Memo.

RMA entry correctly assigns the Tax Class for Inventory items when creating an RMA for

Inventory Items without Invoices or Not on File (NOF) invoices.

Generate Transactions now calculates the correct shipping charges on a credit memo, when the

Credit Freight checkbox is selected, and the shipping rate calculation type is based on Amount.

The override Unit Price no longer changes to the Standard Price from Inventory Management if

a partial receipt is entered in RMA Receipts Entry for a Not on File invoice.

Comment Options  (Alt-Q) default checkboxes for the line, now default as per Setup options,

when an invoice is selected from AR history

Generate Transactions no longer drops lines from RMA and Credit Memo when partial receipts

are entered

In RMA Receipts Entry, the 'Show All Lots' button in the Lot/Serial Distribution window now

displays the quantity invoiced from Invoice History when an historical invoice is entered as the

return invoice number.

The Sales Journal update now posts costs correctly to Job Cost when a kit is exploded and one

or more components are backordered.

In Invoice Data Entry, freight that was entered manually on a sales order is now retained when

invoicing the order when Use Shipping Code to Calculate Freight in Options is Yes or Actual, if

either the Ship Via field (header tab) or Ship Zone field (totals tab) is blank.

In Shipping Data Entry, a credit is no longer issued to the customer's credit card when canceling

an invoice for a sales order with an authorized deposit.

In Shipping Data Entry, when using the Auto Increment feature, if an item is scanned more times

than the quantity ordered, the "The quantity shipped exceeds the quantity ordered." message

now correctly displays.

Credit memos generated from RMA now update the payment type information from history when

adding an Apply to invoice after generation.

In Sales Order Entry, when selecting to convert a quote to an order, credit limit checking is now

correctly done before converting the order.

In Sales Order Entry, if a customer's division was changed on an existing order via AR Delete

and Change Customer, the salesperson number can now be successfully changed on the order.

In Sales Order Entry, bill option interactions defined with a single alpha character are now

recognized.

In Customer Last Purchase Maintenance, the rebuild now correctly displays the last purchase

transaction information when there are several invoices for a customer.

In Sales Order Entry and Invoice Data Entry, the FOB entered in the Defaults window no longer

clears from the order or invoice when a customer is selected.

In Sales Order Entry, if a kit item was changed on a master or repeating order, changing the

quantity ordered now correctly changes the quantity ordered for the component items.

In Invoice Data Entry, performance has been improved for Quick Printing invoices when there is

a large number of batches and/or records in the file.

In Auto Generate Invoice Selection,  orders can now be selected by ship date when Salesperson

Commission Reporting is turned off.

In Sales Order Entry & Invoice Entry, the Ship To information is now correct if the Customer

number is changed to a customer who has the same primary ship-to location code.

In Invoice Data Entry, freight is now calculated correctly for a shipping code defined with a

Calculation Type of Product Line.

In Sales Order Entry and Invoice Data Entry, the extended item description window no longer

automatically displays if the Description field is in the primary grid, and the item extended

description was changed in Inventory Maintenance to be less than 30 characters.

A "not on file" warehouse no longer prints on the Sales Recap by Warehouse by Product Line

when a comment has been entered in the previously updated Sales Order Invoice batch.

A Sales Order Invoice that inlcudes Job Number, Customer Discount and/or Freight when

Miscellaneous Item Codes are used and Job Type Revenue with a blank g/l account updates to

Daily Transaction Register in balance.

In Invoice Data Entry, when invoicing a sales order that has a deposit, the deposit amount no

longer exceeds the invoice amount  when the quantity shipped for all items is 0.

Picking Sheets no longer print for sales orders with an expired pre-authorization unless the

'Include Unauthorized/Expired Credit Card Orders" checkbox is selected.

The Sales Order discount amount is recalculated based on 'subject to discount' field in the Lines

tab when the Discount checkbox is unchecked.

The Open Orders by Item Report now prints the first item in a range when the range selected

starts with an item code containing a quote (").

In Sales Order Entry, the promise date is now correct when converting an order from a quote

and the expiration date for the quote is other than the default of 12/31/5999.

In Sales Order Entry and Invoice Data Entry, the Ship-to and Bill-to addresses are now changed

correctly if the customer number is changed and the Ship-to code is the same for both

customers.

When Using the Copy Charges feature within Shipping Rate Maintenance, the correct Shipping

Zone charges are now being copied.

When the Gross Profit Report is printed for the first time, the Cost of Goods Sold is correct for

invoices with exploded kits and zero quantity shipped.

The Customer Memo information in the auto display window can be copied during Sales Order

Entry.

Auto Generate Invoice Selection is no longer creating a blank batch when 'Batch Entry' is

enabled in Sales Order Invoice Data Entry.

The Print Pick Sheets and Print Order checkboxes in Sales Order Entry remain checked if the

Entry has not been selected to print the Sales Order or Picking Sheet.

In Shipping Data Entry, an error 26 SO_InvoiceDetail_bus 2562 no longer occurs when selecting

Ship Remaining after backordering a lot item.

In Shipping Data Entry, when Order to Display Lines in Shipping Setup Options is set to Bin

Location or Item Code,  items can now be selected from the Item Code lookup.

In Sales Order Entry, total weight is now recalculated correctly when kit component items are

deleted.

In Invoice Data Entry, the 'Item has been discontinued' message now displays for discontinued

items being entered on a credit memo.

In Sales Order Entry and Invoice Data Entry, sales tax is now correctly recalculated when the

Ship Via code is changed.

In Sales Order Entry, a check box UDF is no longer unchecked after editing the Extended Item

Description.

In Sales Order Entry, the unit price is now recalculated when the extension amount is changed

on master orders.

In Invoice Data Entry and Shipping Data Entry, in the lot distribution window, after selecting

Show All Lots, quantities can now be distributed by clicking on the Distribute button (or using the

Alt-D hotkey).

Shipping Data Entry, hanging issues and/or error 65 SY_StarShipServer.pvc 210 no longer

occurs when processing large numbers of packages between MAS and StarShip

In Invoice Data Entry, if the quantity shipped is changed to 0 for a previously distributed serial or

lot item, the previously entered lot or serial distributions are now removed from the

SO_InvoiceTierDistribution.M4T table.

'H.VendorNo' fields pass validation when importing into AP_ManualCheckHeader if the vendor

number is numeric and all 7 numbers are not part of source file.

For existing jobs, the default perform needs to be set up as follows:

Perform Type: Before Assign

File Type: Header

Table Name: AP_ManualCheckHeader

Column Name: VendorNo

Command: ..\AP\AP_VIPerform.M4P;AP_MANUAL_CHECKS_VENDORNO_FB

The default perform will automatically be included in new jobs.

In Export Job Maintenance, the "Wrap String Fields in Quotes" option now works correctly, which

is to create the export file with quotes around the columns where there are string values.

When using Visual Integrator to import into PR.DATAENT, auto deductions are no longer

duplicated on records already entered into Payroll Data Entry.

"The Shipping Code is Required" no longer occurs when importing Ship Rates into the

SO_ShippingRateDetail file using Visual Integrator.

In a VI Export that has a date field, using the "tools" button in Export Field Properties no longer

causes an error 65 VI_ExportElements_UI, line 422.

When importing into AR_InvoiceHeader, the "IN  You cannot change invoice type" message no

longer displays when using a "Selection" criteria, and deleted invoices (type XD) exist in the file.

Qty on PO is now correctly updated into IM2 when importing into PO.ORDER when the Unit of

Measure conversion factor is any value other than 1.

“The Invoice xxxxxxxxxx is already being paid” no longer prints on the import log when importing

into AP_CheckHeader if the import job is tested before it is actually run.

Records import properly when there are multiple "D" records in the source file or multiple

distributions of lot/serial numbers to a single line item.

The General Ledger Journal displays all entries and shows all records and balances correctly for

the period selected.

In VI Export, the "After Write" perform now executes even if previous records were "Not

Selected".

If several VI "export" jobs are exported to a .EXP file, then imported via Job Import, the jobs are

now assigned unique compiled names.

Error "Record Failed. The Tax Schedule is required. The Terms Code must be numeric. The

Warehouse Code is required." no longer displays on import log when importing into

SO_InvoiceHeader if a Test import is run prior to the actual import.