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.

When AR Sales Tax Reporting in AR Options is set to N, AP Sales Tax Account Maintenance is

now accessible.

The release of the 2006 Year End Program Changes contains enhancements for Accounts Payable:

IMPORTANT TAX INFORMATION:  The changes required for tax year 2006 1099 reporting have

been incorporated.

1099-INT forms have been modified for the placement of boxes 1-4 and 6. These 2006 changes are

limited to the form layouts only, so no data conversion is performed.

The placement of the Company Phone Number has been corrected on both the 1099-INT and

1099-DIV forms. Note that reporting for INT boxes 5, 8, & 9 are not supported at this time.

Reset the 1099-INT and/or 1099-DIV as applicable.

Accounts Payable Invoice Register no longer prints in the footer, when Job cost is integrated with

Accounts Payable, and G/L account number is 9 characters or greater.

Accounts Payable Recap by Division now balances when multiple invoice lines are posted to the

same G/L account and the account contains a short alpha segment

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

error.

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 fields TaxableSalesAmt & NonTaxableSalesAmt in AR_RepetitiveInvoiceHeader are no longer

erroneously included in the Data tab in Visual Integrator.

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

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.

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.

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 Data Entry, the correct price now comes in when the item code is changed on an existing

line.

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.

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

on an out of balance situation.

When merging 2 .store users, the A/R Delete/Renumber/Merge utility now correctly updates the AR

Customer,  IT Customer, and the SY_EbusinessManagerUserID tables.

The due date in AR Invoice Data Entry is being calculated correctly based on the Terms Code being

used.

The Cash Receipts Report now correctly prints check details when Print Invoice Detail is set to

Summary.

The original default payment type entered in Accounts Receivable Customer Maintenance will now

be retained regardless of previous customer default information.

In AR Invoice Data Entry the Standard Unit Price displays according to what is entered in

Miscellaneous Items Maintenance.

The error "ProvideX has encountered a problem and needs to close. We are sorry for the

inconvenience," in Miscellaneous Item maintenance no longer occurs.

An error 26 in program AR_RESEQUENCEHISTORY_UTL on line number 0073 no longer occurs

when running the "Fix Sequence Numbers in Cash Receipts History" for a data set that contains

AR_CashReceiptsHistory records that have more than 9 detail lines.

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

deposit.

The Sales History tab in Miscellaneous Item Maintenance is now updated correctly after updating

from AR Invoices.

An Error 43 in AR_InvoiceHistoryInquiry_ui.pvc, no longer occurs when a line items is changed in

Invoice Data Entry but not updated.

Canceling a cash receipt entry after entering a line detail within the header will not generate an error

88.

Daily Transaction Register has been corrected for Commissioned Employees subject to state

unemployment taxes.

The Finance charge calculation is correct based on the number of days past due set in Accounts

Receivable Options.

When selecting a Repetitive Invoice with a Terms Code, the Due and Discount Date fields calculate

accordingly in Invoice Data Entry.

If an alphanumeric salesperson is shown as uppercase when entered manually in the 'Change To'

field

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

in Invoice History Inquiry.

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

after the Sales Journal is posted.

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.

Moving columns from the primary grid to the secondary grid will now correctly retain the invoice

amount.

Changing the Finance Charge Rate in the Global Customer Field Change Utility correctly adjusts the

rate.

When multiple payments are entered for an invoice with a payment date before the transaction date,

the balance and amount columns in Trial Balance are correct

A single character Earnings Code can be entered and linked to a salesperson and updated through

commission edit register without errors

The Aged Invoice Report in detail displays the reference number correctly when a cash payment is

entered and updated in Sales Order

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

when it was supposed to.

When Select Invoices button is selected and Amount Posted field is changed in Cash Receipts

Entry, no message appears and balance amount is not doubled.

The Trial Balance report now correctly prints the Retention Balance when Print Transaction Detail is

set to N.

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

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

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

deposits are entered for miscellaneous cash receipts.

The Aged Invoice Report will now print the correct invoice balance and retention balance when the

retention was billed after the 'As Of' date of the Aged Invoice Report.

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

entered manually.

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 Accounts Receivable Commission Edit Register now correctly updates Payroll so that the

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

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

Accounts Receivable Analysis Report.

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.

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

changed, recalled and changed again.

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.

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.

Choosing the Accept button on an AR Credit Memo Invoice without a value in a Required UDF on

the Header tab will no longer change the Invoice Total from a positive value to negative value.

The Aged Invoice Report now displays invoice balance to include retention when "Track JC

Retention Receivables" is OFF.

The Trial Balance Report now prints the retention invoice number on payment records created

through Job Billing Register.

An invoice with Tax Details will now print correctly when the Invoice form is customized to print Tax

amounts.

There is no payment/adjustment entry shown on the AR Aged Invoice Report for Credit Card or

Check payment entries created through AR or SO.

When a payment is posted prior to an invoice, all invoice numbers will display on AR Trial Balance

Report.

The invoice amount is correct on the AR Trial Balance when updating prepayments and invoices

with the same invoice number.

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

load time of invoices into the Invoices panel.

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

clicking on the Shipping button

Cash Receipts Entry, no longer receive message "Missing or Invalid Header" when accepting a cash

receipt

An alpha salesperson number can be selected from the Global Customer Field Change lookup in

companies that have only one division.

If Zero Balance Deposits exist then AR Period End cannot be run until the Deposits have been

cleared.

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 Import S/O Transactions and Unattended Import, FOB, Ship Via and Ship to code fields now

import into Shipping Data Entry correctly.

When importing S/O transactions, if an order has a deposit, the deposit amount is now correctly

imported to the invoice.

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.

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 Bar Code Import, lot and serial numbers are now still available after a failed import

attempt.

When importing an S/O shipping entry, the cash or check deposit reference number is now brought

in from the order.

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.

Performance in Bill of Materials Maintenance has been enhanced when selecting a  revision code,

and there is more than one user in the company.

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

Extended Description does display.

No longer receive "Out of Balance By XXX.XX" message on Daily Transaction Register when

posting Assembly or Disassembly Registers containing General Ledger accounts that have an

Accountkey$ starting with special characters.

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

an erroneous busy message is no longer displayed.

In Check, Deposit and Adjustment Entry and Reconcile Bank, if the Vendor Name and/or Vendor

Number contains a tilde (~) the field values no longer get misplaced in the grid and the dollar

amount is reflected correctly.

The BR_EmbeddedIO program was corrected so records are read correctly when accessing

BR1XXX.soa.

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

Date and Entry Number.

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

item description.

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.

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

box for every Field Definition on the lib.

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.

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.

Numeric fields added to a List Box using Customizer Selection now display with the correct numeric

format.

Numeric fields added prior this program fix will need to be removed from the List Box and re-added

to pull in the correct numeric format.

In Customizer Selection, a check box that is disabled in a data entry window that pulls the check box

setting from a maintenance window, now displays the correct setting for the check box in the data

entry window.

An Error 46 SWQUERY 19230, no longer occurs when choosing the ALE lookup for a UDF

assigned a UDT table for validation and the UDT table name has exceeded 20 characters.

Running the Customizer Update Panel to Current Level no longer remove fields on a customized

library when a field position conflicts with another field on the standard library.

In DM Group Maintenance, error #11VIWLIB Line 3030 no longer occurs during DM Group Import

processing.

When migrating from a DacEasy v13 data source, the GL summary history table now includes all

fiscal years.  Previously only the current year data was migrated.

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.

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.

An Error 47, GL_Allocation_Svc.pvc, line 291 no longer occurs when processing a Manual

Allocation Entry in General Journal Entry if the allocation entry has been created with account

masking.

The message "Authentication Failed! Retry the synchronization process or contact Sage Payroll

Services for additional assistance." will nor longer occur for a customer with 5 character Co ID

Number used in the synchronization with Payroll Services.

An Error 60, GL _BudgetHistory_ui.pvc, line 143 no longer occurs when reentering the General

Ledger Budget and History Report after selecting the Designer button from the Save As Report

Setting window for the Budget and History Report.

The General Ledger Detail Report can now be sorted by Rollup Types when Rollup Types are setup

in Options.

In legacy modules and Error 77 no longer occurs, if the Daily Transaction Register is in use during a

register or journal update. Now the "GL_DailyPosting file is in use by another task.  Update will

continue to retry until this file is available."  message will correctly display.

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.

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

alphanumeric segment.

After installing IM4006-T this utility must be run.

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

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.

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 maintenance button.

In Product Line Maintenance, changes to the 'Explode Kit' field on the 'Main' tab are now retained

when moving between the Main and Accounts panels without clicking the Accept 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.

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

the OK button in Item Text Maintenance.

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

Order module.

In Inventory Maintenance, the IT Item Attachments are now retained when renumbering or copying

the item.

When editing an item's description, the correct extended description key is now created in CI_Item

table in reference to CI_ExtendedDescription table.

Inventory Labels can now be printed when sorting by Warehouse/Bin Location and selecting a

specific Product line.

In Inventory Maintenance & Inquiry, Transactions tab, the invoice drill down now correctly displays

short alphanumeric invoice numbers.

Entering a new item in the Item Maintenance - on the fly panel with an extended description, the

UDF value entered in the CI Item UDF will now be saved.

The SVTRNA utility now populates the CI_ExtendedDescription file when the option 'Copy Extended

Description File'  is selected.

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.

On the .store Shopping Cart Confirmation page, the State X-Ref tables are now assigned correctly

and the Taxable and Sales Tax amounts are now correctly calculated and displayed.

e-Business Manager UDFs on a web page now updates the data entered to the appropriate file

table.

Multiple .store users are now able to log on to the website from the same computer when both have

previously submitted a shopping cart via a Sign On link on the Step 1 on the shopping cart page.

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.

This utility will convert the records in the SY1UID file and merge them into

SY_EbusinessManagerUserID table.

To run this utility, from the File/Run menu enter *UTL and select the Convert e-Business Manager

Users utility.

This utility will correct an Error 11 program IWWIEA line 1095 occurring on the Web Engine.  This

was caused by the A/R Delete/ Renumber/ Merge Utility incorrectly renumbering or merging

customer numbers in the SY_EbusinessManagerUserID table.  To run this utility, from the File/Run

menu enter *UTL and select the Fix e-Business Manager UserID utility.

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.

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

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

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.

On the Products and Services page, the category image no longer disappears from the page after

adding a product to the shopping cart.

On the .store Shopping Cart Confirmation page, the Zip Code X-Ref tables are now assigned

correctly and the Taxable and Sales Tax amounts are now correctly calculated and displayed.