Release Notes
| 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
New in Service Update 4.20.0.4
Retention amount is now being set to zero for misc line in Invoice Payment Selection Listing.
1
(DE 70958, PER 99887, Resolution ID 479525)
| 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 |
2
(DE 70887, PER 99886, Resolution ID 479523)
| 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. |
3
(DE 70890)
Previously Released in 4.20.0.3
| 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. |
4
(DE 68756)
| 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. |
5
(DE 70009)
| 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). |
6
(DE 70798)
| In Check Maintenance Error 60 no longer occurs with JC integrated and Payment Amount in |
| Secondary Grid. |
7
(DE 70031, PER 99381, Resolution ID 477919)
Previously Released in 4.20.0.2
The Accounts Payable Check History Report is now sorted by Check Number.
8
(DE 70427, PER 99283, Resolution ID 477535)
| Line Comments print on the Check Register when AP Options - Printing tab, the 'Print G/L Distribution |
| on Check Register' is on or checked. |
9
(DE 69980, PER 99382, Resolution ID 477921)
| 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. |
10
(DE 70104, PER 99324, Resolution ID 477717)
If you pay an invoice that has retention only left and you pay in full, the listing is now correct.
11
(DE 70112, PER 99380, Resolution ID 477917)
Error 42 no longer occurs when the Payment History Report is printed during Period End Processing.
12
(DE 70345, PER 99586, Resolution ID 478776)
| 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. |
13
(DE 70071)
Previously Released in 4.20.0.1
| 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. |
14
(DE 70185, PER 99325, Resolution ID 477719)
| 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. |
15
(DE 70126, PER 99324, Resolution ID 477717)
| 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. |
16
(DE 70027, PER 99322, Resolution ID 477713)
| 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") |
17
(DE 62110, PER 99245, Resolution ID 477364)
| 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. |
18
(DE 70042, PER 99323, Resolution ID 477715)
Accounts Receivable
New in Service Update 4.20.0.4
| Memo auto display is now working properly. Previously, is some cases memo would not auto display |
| when it was supposed to. |
1
(DE 70937)
Drilldown to invoice history is now available when selecting an invoice that has been paid.
2
(DE 70985)
| An Invoice containing a period can be entered and updated and displayed correctly in the lines tab in |
| Invoice History Inquiry. |
3
(DE 70984)
A Job number can now be imported into an existing record in AR_InvoiceHistoryHeader without error.
4
(DE 71123)
Previously Released in 4.20.0.3
| The Trial Balance columns display the correct amounts when multiple payments are posted prior to |
| the invoice date. |
5
(DE 70301, PER 99330, Resolution ID 476969)
Previously Released in 4.20.0.2
| An Invoice transaction is drilled down without error when performing an inquiry in Inventory |
| Maintenance. |
6
(DE 69872, PER 98784, Resolution ID 474997)
| When a Cash payment is updated through Sales Order, the payment reference will appear as CASH |
| on the AR Aged Invoice Report. |
7
(DE 70291, PER 99329, Resolution ID 477723)
An Alpha Salesperson is displayed as uppercase when entered manually or selected by lookup.
8
(DE 70392, PER 99353, Resolution ID 477798)
| The Commission Edit Register updates the Salesperson Commission when a single character |
| Earnings Code is entered in Payroll. |
9
(DE 70407, PER 99378, Resolution ID 477916)
Previously Released in 4.20.0.1
Employees with alpha department numbers are able to link in Salesperson Maintenance.
10
(DE 70189, PER 99327, Resolution ID 475448)
Bar Code
Previously Released in 4.20.0.3
| When importing Sales Order transactions, freight is now imported from the .odb file when Use |
| Shipping Code to Calculate Freight is set to No. |
1
(DE 70686)
| 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. |
2
(DE 70719)
Previously Released in 4.20.0.1
| 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. |
3
(DE 70248, PER 99588, Resolution ID 478782)
Bill of Materials
New in Service Update 4.20.0.4
| When accessing Item Maintenance through the 'Item' button in Bill of Materials Maintenance, the |
| Extended Description does display. |
1
(DE 71012)
Common Item
Previously Released in 4.20.0.3
| 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. |
1
(DE 70808)
Previously Released in 4.20.0.2
| 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. |
2
(DE 70217)
| 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. |
3
(DE 70694, PER 99608, Resolution ID 478847)
Customizer
Previously Released in 4.20.0.1
| Running the Update Customizer Panels to Current Level will no longer select the Tab Stop check box |
| for every Field Definition on the lib. |
1
(DE 70246, PER 99619, Resolution ID 478883)
CRM
Previously Released in 4.20.0.2
| 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 |
1
(DE 70479)
General Ledger
New in Service Update 4.20.0.4
| 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. |
1
(DE 70954, PER 99746, Resolution ID 479194)
| When printing the General Ledger Detail Report for multiple years entries are now sorted correctly by |
| year if the Selection Criteria is by Date. |
2
(DE 70758, PER 99630, Resolution ID 478931)
Previously Released in 4.20.0.3
| 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. |
3
(DE 70154, PER 99532, Resolution ID 478294)
Inventory Management
Previously Released in 4.20.0.1
| 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. |
1
(DE 70190, PER 99590, Resolution ID 478789)
e-Business Manager
New in Service Update 4.20.0.4
| On the Invoice Inquiry page, an invoice with a Package Tracking number correctly displays the |
| 'tracking' link to check the status of the package. |
1
(DE 70924)
Previously Released in 4.20.0.1
| 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. |
2
(DE 70237)
Job Cost
New in Service Update 4.20.0.4
| 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 . |
1
(DE 70840)
Library Master
New in Service Update 4.20.0.4
Default printer is now correctly saved when multi-part printing is not enabled.
1
(DE 70977)
Previously Released in 4.20.0.3
Tax codes can now be created with names that are subsets of existing tax codes.
2
(DE 70447, PER 99320, Resolution ID 477700)
Report links in Business Insights will no longer be disabled when a new program key is installed.
3
(DE 70676)
Data Conversion for 4.20 will no longer return an error 12 AP_LevelConversion 2996.
4
(DE 70599, PER 99565, Resolution ID 478012)
Previously Released in 4.20.0.2
| The value entered in a Date UDF or MD created Date field will no longer become scrambled after |
| running a UDF update. |
5
(DE 70408, PER 99607, Resolution ID 478840)
Previously Released in 4.20.0.1
| 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. |
6
(DE 70002, PER 99606, Resolution ID 478836)
Material Requirements Planning
New in Service Update 4.20.0.4
| The MRP report is no longer missing transactions for firm planned work orders that are subassemblies |
| of other work order parent items. |
1
(DE 70853, PER 99717, Resolution ID 479343)
| The MRP by Job Report now displays all sales order requirements when multiple lines are entered for |
| the same item on the same sales order with different required dates. |
2
(DE 40002)
| MRP Generation correctly calculates component quantity required amounts, after updating Material |
| Issues with Negative quantities. |
3
(DE 28036)
| MRP Generation no longer overstates the Supply quantities from work orders after partial completions |
| have been updated. |
4
(DE 70902)
| 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. |
5
(DE 70589)
Previously Released in 4.20.0.1
| 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. |
6
(DE 70229, PER 99351, Resolution ID 476559)
Purchase Order
Previously Released in 4.20.0.3
| 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. |
1
(DE 70463)
| 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. |
2
(DE 70945)
Previously Released in 4.20.0.2
| Auto Generate Purchase Orders now correctly generates purchase orders from sales orders inventory |
| item lines that use a one-character warehouse code. |
3
(DE 70462, PER 99620, Resolution ID 474482)
| 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. |
4
(DE 66290, PER 97020, Resolution ID 467133)
Previously Released in 4.20.0.1
| 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. |
5
(DE 70249)
Payroll
Previously Released in 4.20.0.3
Employee SUI and Other Local data are now correct on nongraphical payroll checks.
1
(DE 70697, PER 99604, Resolution ID 478829)
Previously Released in 4.20.0.2
| 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. |
2
(DE 70197)
| In the Check Register update, an Error 42 PRWUBA, line 1245, no longer occurs when posting |
| Deductions By Department Worked. |
3
(DE 70528, PER 99442, Resolution ID 478038)
Previously Released in 4.20.0.1
| 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. |
4
(DE 70012, PER 99092, Resolution ID 476741)
Return Materials Authorization
New in Service Update 4.20.0.4
| In RMA Receipts Entry, if a message is displayed during line entry, the GL cost account is no longer |
| blank. |
1
(DE 70989, PER 99738, Resolution ID 479465)
| Comment Options (Alt-Q) default checkboxes for the line, now default as per Setup options, when an |
| invoice is selected from AR history |
2
(DE 71001)
Previously Released in 4.20.0.3
| 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 |
3
(DE 70596, PER 99563, Resolution ID 478567)
| Generate Transactions no longer drops lines from RMA and Credit Memo when partial receipts are |
| entered |
4
(DE 70650)
| 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. |
5
(DE 70670)
Restocking Charges are now calculated in RMA Entry for items referencing an invoice number
6
(DE 68472, PER 98028, Resolution ID 471434)
Previously Released in 4.20.0.1
| In Generate Transactions, Sales Order invoice batches are now correctly created when multiple RMA |
| generations are performed. |
7
(DE 70253, PER 99350, Resolution ID 475958)
Sales Order
New in Service Update 4.20.0.4
Fax number is now changed when Ship to field is changed.
1
(DE 66477, PER 97136, Resolution ID 467635)
| In Invoice Data Entry, the 'Item has been discontinued' message now displays for discontinued items |
| being entered on a credit memo. |
2
(DE 71061)
| The Sales Journal Update now correctly updates commission on miscellaneous charges to AR invoice |
| history. |
3
(DE 70636)
| In Sales Order Entry and Invoice Data Entry, sales tax is now correctly recalculated when the Ship Via |
| code is changed. |
4
(DE 71120)
Previously Released in 4.20.0.3
| 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). |
5
(DE 70962)
Sales Order Recap Reports now prints the Quantity Returned when the quantity is negative.
6
(DE 70792)
| 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. |
7
(DE 70346, PER 99347, Resolution ID 476320)
| In Sales Order Entry and Invoice Data Entry, lines tab, Customer/Item Last Purchase History List |
| window now displays the correct purchase history. |
8
(DE 70656, PER 99569, Resolution ID 477413)
| In Sales Order Entry, the unit price is now recalculated when the extension amount is changed on |
| master orders. |
9
(DE 70681)
| In Sales Order Entry, a check box UDF is no longer unchecked after editing the Extended Item |
| Description. |
10
(DE 70411)
| 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 |
11
(DE 70584)
Job Cost is now being updated when invoicing a kit with partially shipped components lines.
12
(DE 70577)
Previously Released in 4.20.0.2
| 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. |
13
(DE 70347)
The Back Order Report no longer includes quotes.
14
(DE 70533, PER 99622, Resolution ID 476775)
Shipping Labels now print correctly when UDF selection criteria is entered.
15
(DE 70250, PER 99348, Resolution ID 476244)
Previously Released in 4.20.0.1
The next customer number is now available in Sales Order Entry.
16
(DE 70319, PER 99377, Resolution ID 477914)
The Sales Order Auto Generate Invoice Selection Listing now correctly prints batch numbers.
17
(DE 70256, PER 99349, Resolution ID 476391)
Visual Integrator
New in Service Update 4.20.0.4
| 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. |
1
(DE 70542)
| 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. |
2
(DE 69472)
Previously Released in 4.20.0.3
| Import jobs run from a batch file or shortcut with AUTO and UION in the command line do will now |
| receive record locking messages. |
3
(DE 70332, PER 99177, Resolution ID 476710)
Previously Released in 4.20.0.2
In Import Job Maintenance, linked tables are now listed in Perform Maintenance.
4
(DE 69904, PER 98792, Resolution ID 474553)
| In Import Job Maintenance, all lines are now imported when the source data contains multiple detail |
| lines for a single header record. |
5
(DE 70336, PER 99386, Resolution ID 477934)
| In Import Job Maintenance, the option to select data elements for General Ledger is now available in |
| job definition printing. |
6
(DE 61150, PER 94957, Resolution ID 455089)
Work Order Processing
Previously Released in 4.20.0.3
| 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. |
1
(DE 70614)
Previously Released in 4.20.0.2
| 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. |
2
(DE 70286, PER 99334, Resolution ID 477493)
The Following files are contained in Service Update 4.20.0.4
| AP_ARClearingRegister_upd.pvc |
| AP_CheckHistoryReport.rpt |
| AP_CheckHistoryReport_rpt.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_ManualCheckRegister_upd.pvc |
| AP_PaymentHistoryReport.M4L |
| AP_PaymentHistoryReport_rpt.pvc |
| AP_PaymentHistoryReport_ui.pvc |
| AR_AgedInvoiceReport_rpt.pvc |
| AR_CashReceiptsJournal_upd.pvc |
| AR_CommissionEditRegister_upd.pvc |
| AR_CustomerContact_bus.pvc |
| AR_DeleteChangeCustomers_ui.pvc |
| AR_DivisionNextCustomer_ui.pvc |
| AR_GlobalCustomerFieldChnge.M4L |
| AR_GlobalCustomerFieldChnge_ui.pvc |
| AR_InvoiceHistoryInquiry_bus.pvc |
| AR_InvoiceHistoryInquiry_ui.pvc |
| AR_ReportManagerMaster.M4T |
| AR_ReportManagerTemplate.M4T |
| CI_CommonTierDistribution.pvc |
| CI_CommonTierDistribution_ui.pvc |
| CI_ReportManagerMaster.M4T |
| CI_ReportManagerTemplate.M4T |
| CI_UpdatePODetailToAP.pvc |
| CM_Utility_LibUpdate_UI.pvc |
| CU_CountryListing_rpt.M4G |
| CU_CountryListing_rpt.pvc |
| CU_MaintainRelationship_ui.pvc |
| CU_OrderQuoteTracking_Bus.pvc |
| CU_RelationshipWizard_ui.pvc |
| GL_TransactionJournal_bus.pvc |
| IN_ReportManagerMaster.M4T |
| IN_ReportManagerTemplate.M4T |
| RA_GenerateCreditMemo_upd.pvc |
| RA_GenerateSalesOrder_upd.pvc |
| RA_GenerateTransactions_UI.pvc |
| RA_ReceiptsTierDistribution_bus.pvc |
| RA_ReceiptsTierDistribution_ui.pvc |
| RA_ReturnTierDistribution_bus.pvc |
| RA_ReturnTierDistribution_UI.pvc |
| RA_ReturnTierDistribution_UI.pvc |
| SO_AutoInvoiceSelect_ui.pvc |
| SO_BackorderReport_rpt.pvc |
| SO_InvoiceTierDistribution_Bus.pvc |
| SO_InvoiceTierDistribution_UI.pvc |
| SO_PackageTrackingByItem_Bus.pvc |
| SO_ReportManagerMaster.M4T |
| SO_ReportManagerTemplate.M4T |
| SO_SalesOrderDetail_bus.pvc |
| SO_SalesRecapByProductLine_rpt.pvc |
| SO_SalesRecapByWhseProdLine_rpt.pvc |
| SO_ShippingLabels_rpt.pvc |
| SY_DictionaryConversion.pvc |
| SY_ReportManagerMaster.M4T |
| SY_ReportManagerTemplate.M4T |
| SY_TemplateManager_bus.pvc |
| SY_TemplateManager_ui.pvc |
| VI_ExportJobDefinition.rpt |
| VI_ExportJobDefinition_rpt.pvc |
| VI_ExportJobDefinition_UI.pvc |
| VI_ExportJobMaintenance.M4L |
| VI_ExportJobMaintenance_BUS.pvc |
| VI_ExportJobMaintenance_UI.PVC |
| VI_ImportJobDefinition.rpt |
| VI_ImportJobDefinition_rpt.pvc |
| VI_ImportJobDefinition_UI.pvc |