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.

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.

No longer receive Error 47 CI_CostCodeFormatter.pvc 0074 when printing or previewing the

invoice history report.

In Invoice Data Entry, with Job Cost integration, it is no longer possible to enter a line incorrectly

and then have the wrong grid line erased after clicking OK on the error message.

The Lines Panel displays an invoice that has retention and discount in Invoice History Inquiry

correctly.

NOF (Not on File) Vendor Payee Name is now correct in Bank Reconciliation module after

updating manual check register in Accounts Payable.

The Invoice Amount & Net Invoice Amounts that are printed on the Invoice Payment Selection

Listing are overstated by the amount of one of the invoices (it's doubled) for invoices with job

distributions

Import Job Maintenance: It is no longer necessary to import the Header InvoiceAmt field into

Invoice Data Entry (AP_InvoiceHeader-Detail table) in order for the total to balance. The total will

calculate whether the field is added or not. It will not calculate the freight nor the tax if taxes  and

freight are added.

In Check Maintenance Error 60 no longer occurs with JC integrated and Payment Amount in

Secondary Grid.

In Manual Check Entry, the Job Distribution Dialog is now enabled for roles and users that only

had remove and view and view only rights.

During the manual check and invoice register update, the credit card vendor's invoice date

should be used to record 1099 payment history for invoice transfers, but the purchase vendor's

invoice date is being used instead.

An error 43 AP_LevelConversion.pvc, line 1330 no longer occurs when trying to convert data to

4.20 when there are /m lines in the AP_13 file that have a description where the program is

erroneously trying to pull a RequiredDate from the field (requireddate field doesn't exist for /M

lines).

Error 42 no longer occurs when  the Payment History Report is printed  during Period End

Processing.

Line Comments print on the Check Register when AP Options - Printing tab, the 'Print G/L

Distribution on Check Register' is on or checked.

In Vendor Maintenance, the AverageDaysToPay, AverageDaysOverdue and BalanceDue fields

are now accessible for users assigned to Roles in which the  "Allow Editing of Statistic Data in

Vendor Maintenance" Event is selected.

When entering or changing a Zip Code the new Cross Reference file will now be used to default

the Sales Tax Schedule.  A message is displayed before changing an existing Sales Tax

Schedule allowing the user to Change or Not change the Schedule.

InvoiceSeq# is now correct in AP_CheckhistoryDetail file when updating purchase transfer and

credit card invoice and the same invoice number already exists in history.

Invoice Payment Selection is now correctly selecting by line based on the AP Job Distribution

Detail file. Previously, if an invoice had lines for more than one job, the selection was incorrectly

paying the entire invoice off when making the selection by Job Number.

Sales Tax Collected is now updated to AR_SalesTax only when a customer invoice is paid in full

through AP from AR Clearing.. Previously, sales tax collected was updated even is an invoice

was partially paid in AP from AR Clearing Entry.

Amount posted to  AR_TransactionPaymentHistory file is now correct when updating AP from

AR Clearing Register and there is a record for Balance Forward customer with discount applied.

Discount Taken GL Account is now correctly used when updating the Manual Check Register

and a new invoice with discount was created in Manual Check Entry. (AP Option  "Account for

Discounts Earned or Lost " is set to  "Lost")

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.

Future payments and credit memos are included into calculation of Amount Subject to Finance

Charge amount.

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.

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

Receivable Invoice History Report.

Invoice Number is now printed on the Deposit Transaction Report if payment to the invoice was

made by credit card. Previously, the word "payment" was printed instead of invoice number.

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

display when it was supposed to.

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

tab in Invoice History Inquiry.

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

error.

The Trial Balance columns display the correct amounts when multiple payments are posted prior

to the invoice date.

An Invoice transaction is drilled down without error when performing an inquiry in Inventory

Maintenance.

When a Cash payment is updated through Sales Order, the payment reference will appear as

CASH on the AR Aged Invoice Report.

The Commission Edit Register updates the Salesperson Commission when a single character

Earnings Code is entered in Payroll.

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.

When CRM is set up for the company, after importing SO transactions in Bar Code, when

answering Yes to run Invoice Entry, an error 13 CI_CUConvert.pvc 482 no longer occurs.

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.

Upgrading from 4.05 to 4.10 no longer returns an error 45 CI_LevelConversion 673 after loading

Service Update 2 and have Accounts Receivable Sales Codes without the Inventory or Sales

Order modules.

Data conversion without Inventory -and- Sales Order data files no longer returns an error 81

CI_LevelConversion.pvc 240.  If the error has been encountered, in Library Master-Data File

Display and Maintenace, the value for NewSystem$ in the CI_Options.M4T for the company that

failed must be edited and changed from 'N' to 'Y'. Now convert the data.

The CI_LevelConversion class now has the MDAssignments method defined and called for each

destination file write as is the case with the other module level conversion programs.

UDF's are now being populated in the grids when the Export/Import in Custom Office has been

used.

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

check box for every Field Definition on the lib.

Service Update 4.20.0.2 introduces the availability of SageCRM for MAS 90 and MAS 200

version 4.20!  For more information, visit http://www.sagesoftware.com

When printing the General Ledger Detail Report for multiple years entries are now sorted

correctly by year if the Selection Criteria is by Date.

When Bank Reconciliation is not integrated with General Ledger in Transaction Journal Entry the

message "A bank code is required" no longer displays for Check Number Transaction Type

entries.

A Synchronization Failed!! Retry the synchronization process or contact Sage Payroll Services

error message is no longer occurs when a special character is included in an Account Number

description.

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.

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.

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.

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 .

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.

Using a customer account number which is alphanumeric and running a Visual Integrator job or

program via a command line shortcut is correct in the system activity log.

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.

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

line 195.

Data conversion can now be performed without getting a "Data conversion could not be

performed for the selected company due to missing data version information in the indicated

modules: (M/R)" message when attempting to convert MAS 90 / 200 4.05 data.

Data conversion can now be performed without getting a "Data conversion could not be

performed for the selected company due to missing data version information in the indicated

modules: (M/R)" message when attempting to convert MAS 90 / 200 4.05 data.

MAS90 is no longer closing one or more clients when running on multiple machines and

attempting to change users.

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.

When rebuilding files with both Integrity Check and Optimize File selected, answering "No" to the

prompt "Do you want to rebuild the file?" no longer causes data loss.

The value entered in a Date UDF or MD created Date field will no longer become scrambled

after running a UDF update.

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.

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

there are weekly projected demands.

MRP Generation no longer overstates the Supply quantities from work orders after partial

completions have been updated.

The MRP report is no longer missing transactions for firm planned work orders that are

subassemblies of other work order parent items.

MRP Generation correctly calculates component quantity required amounts, after updating

Material Issues with Negative quantities.

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.

If receipt of invoice is performed on a PO for miscellaneous charges only, the PO correctly no

longer completes even though the inventory items have not been received.

After importing into the PO1 (po entry file), the AP Options file is inaccessible for the current

company AND several errors (object missing types of errors) occur during PO data entry.

When creating a Drop Ship Purchase Order from a sales order, the freight amount on the sales

order is correctly no longer passed to the purchase order.

Auto Generate Purchase Orders now correctly generates purchase orders from sales orders

inventory item lines that use a one-character warehouse code.

During the receipt of goods update, negative balance adjustment transactions posted to General

Ledger & inventory transaction detail for Average cost items now correctly include the allocated

freight/landed cost and allocated tax.

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.

In the Check Register update, an Error 42 PRWUBA, line 1245, no longer occurs when posting

Deductions By Department Worked.

The Employer’s FICA Tax amount is now correct on the Employer’s Expense Summary when

multiple departments or earnings codes are included in Payroll Data Entry.

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.

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.

When entering a partial receipt in RMA Receipt Entry and changing the remaining quantity to

zero, the change is now retained.

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

when an invoice is selected from AR history

In RMA Receipts Entry, if a message is displayed during line entry, the GL cost account is no

longer blank.

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.

When a sales order is generated for a return of an item with an extended description, and the

item is to be replaced by a different item, the description is now correct

In Generate Transactions, Sales Order invoice batches are now correctly created when multiple

RMA generations are performed.

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.

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

tab when the Discount checkbox is unchecked.

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.

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.

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.

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

Entry.

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 unit price in Sales Order Entry is rounding to the appropriate number of decimals selected in

the Inventory Management Options when the 'Use Last Purchase Price' button is selected in the

Lines tab.

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 Sales Order Entry, total weight is now recalculated correctly when kit component items are

deleted.

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.

Shipping Data Entry, error 65 SY_StarShipServer.pvc 210 no longer occurs when processing

large numbers of shipments

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

Ship Via code is changed.

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

items being entered on a credit memo.

The Sales Journal Update now correctly updates commission on miscellaneous charges to AR

invoice history.

In Sales Order Entry and Invoice Data Entry, lines tab, Customer/Item Last Purchase History List

window now displays the correct purchase history.

In Invoice Data Entry, an error 60 SY_Gridhandler.pvc, line 880 no longer occurs when selecting

the Show All Lots button, double-clicking in the Distribute field, and then clicking somewhere

else in the window.

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

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

on master orders.

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

Description.

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.

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

An Error 26 VIWMKA Line 2640 no longer occurs in Job Import when attempting to import the

non legacy jobs  (4.xx) after installing an upgrade of MAS90/200.

Import jobs run from a batch file or shortcut with AUTO and UION in the command line do will

now receive record locking messages.

In Import Job Maintenance, the option to select data elements for General Ledger is now

available in job definition printing.

In Import Job Maintenance, all lines are now imported when the source data contains multiple

detail lines for a single header record.

When a Sales Order 'Make' item selected has a backordered quantity, the 'Quantity Ordered'

populates correctly.

In Work Order Entry, creating a Make for Sales Order work order, the Promise Date assigned to

the item will be used for the Work Order Due Date rather than the Sales Order Ship To Date.

During the L/M Automatic Update of the W/O Transaction Journal, an Error 14 WOWJBA, line

0505 no longer occurs when the batch option has been selected.

When the Update Intermediate is not selected for a Standard Cost valued items, and the bill has

sub-bills, the Report Total no longer includes the sub-bills cost when it should only include the

parent item cost printed on the report.

420SUSRNs.htm

AP_ARClearingRegister_upd.pvc

AP_CHECK_UI.PVC

AP_CheckDetail_Bus.pvc

AP_CheckHistoryReport.rpt

AP_CheckHistoryReport_rpt.pvc

AP_CheckRegister.rpt

AP_CheckRegister_upd.pvc

AP_CheckRegisterJC.rpt

AP_Invoice_bus.PVC

AP_Invoice_ui.pvc

AP_InvoiceDetail_bus.pvc

AP_InvoiceHistory.M4L

AP_InvoiceHistory_ui.pvc

AP_InvoiceHistoryListInv_rpt.pvc

AP_InvoiceHistoryReport_rpt.pvc

AP_InvoicePaymentListing_rpt.pvc

AP_InvoicePaymentSelect_ui.pvc

AP_InvoiceRegister_upd.pvc

AP_JobDistributionDetail_bus.pvc

AP_JobDistributionDetail_Ui.pvc

AP_LevelConversion.pvc

AP_ManualCheck_ui.pvc

AP_ManualCheckRegister_upd.pvc

AP_PaymentHistoryReport.M4L

AP_PaymentHistoryReport_rpt.pvc

AP_PaymentHistoryReport_ui.pvc

AP_ProgramLibrary.m4t

AP_ProgramLibrary.m4t

AP_Vendor.M4L

AP_Vendor_bus.pvc

ar.chm

AR_AgedInvoiceReport_rpt.pvc

AR_CashReceipts_bus.PVC

AR_CashReceiptsJournal_upd.pvc

AR_CommissionEditRegister_upd.pvc

AR_CommonEntry.pvc

AR_Customer.M4L

AR_Customer_bus.pvc

AR_CustomerContact_bus.pvc

AR_DefaultPerform.M4T

AR_DeleteChangeCustomers_ui.pvc

AR_DepositTransaction.rpt

AR_DepositTransactionReport_rpt.pvc

AR_DivisionNextCustomer_ui.pvc

AR_FinanceCharge_bus.pvc

AR_GlobalCustomerFieldChnge.M4L

AR_GlobalCustomerFieldChnge_ui.pvc

AR_InvoiceHistoryInquiry_bus.pvc

AR_InvoiceHistoryInquiry_ui.pvc

AR_InvoiceHistoryReport_rpt.pvc

AR_LevelConversion.pvc

AR_Menu.M4T

AR_Message.M4T

AR_Module.M4T

AR_Options_bus.pvc

AR_ProgramLibrary.m4t

AR_ReportManagerMaster.M4T

AR_ReportManagerTemplate.M4T

AR_Salesperson.M4L

AR_Task.M4T

AR_TrialBalance_rpt.pvc

AR0CTL.SOA

AR0DCT.SOA

AR0DD2.SOA

AR0FRM.SOA

AR1Q01.SOA

AR1Q02.SOA

AR1Q03.SOA

AR1Q04.SOA

BC_ProgramLibrary.m4t

Bcwtcb

BCWTCC

BCWTCD

BCWTFA

BCWTFB

Bmwrlb

Bmwrld

CI_ActivationReq.M4T

CI_CommonEntry.M4L

CI_CommonTierDistribution.pvc

CI_CommonTierDistribution_ui.pvc

CI_CostCodeFormatter.pvc

CI_CUConvertData.pvc

CI_CULinkRecords.pvc

CI_CustomerAging.pvc

CI_CustomerUI_val.pvc

CI_EmployeeUI_val.pvc

CI_ExportLink.M4T

CI_GridDefinition.M4T

CI_LevelConversion.pvc

CI_Menu.M4T

CI_Message.M4T

CI_Module.M4T

CI_Module.M4T

CI_ProgramLibrary.m4t

CI_ReportManagerMaster.M4T

CI_ReportManagerTemplate.M4T

CI_Task.M4T

CI_UpdateCheckToAP.pvc

CI_UpdatePODetailToAP.pvc

CI0CTL.SOA

CI0FRM.SOA

CI1Q01.SOA

CI1Q02.SOA

CI1Q03.SOA

CI1Q04.SOA

CM_ExportCommon.PVC

CM_ExportWizard_UI.PVC

CM_ImportWizard_UI.PVC

CM_MaintGrid

CM_ProgramLibrary.m4t

CM_Utility_LibUpdate_UI.pvc

CU_ActivityLogReport.M4L

CU_Address_bus.pvc

CU_AddressLink_bus.pvc

CU_Common.pvc

CU_Country.M4L

CU_Country_bus.pvc

CU_Country_ui.pvc

CU_CountryListing.rpt

CU_CountryListing_rpt.M4G

CU_CountryListing_rpt.pvc

CU_FieldMapping.M4T

CU_MaintainRelationship_ui.pvc

CU_Menu.M4T

CU_Message.M4T

CU_Module.M4T

CU_Options_bus.pvc

CU_Options_ui.pvc

CU_OrderQuoteTracking_Bus.pvc

CU_Phone_bus.pvc

CU_ProgramLibrary.m4t

CU_RelationshipWizard_ui.pvc

CU_SCRMLink_bus.pvc

CU_Setup.pvc

CU_Task.M4T

CU0CTL.SOA

CU0FRM.SOA

CU1Q01.SOA

CU1Q02.SOA

CU1Q03.SOA

CU1Q04.SOA

ES_ProgramLibrary.m4t

eswuab

GL_DetailReport_rpt