Joomla!


  • Existing customers should have an assigned ID and Password.
    If you do not remember your User name or Password use the links below to
    have them sent to you.

    If you have not been assigned a User name or Password yet,
    please call our office at 678-495-5700 and let us know you are
    in needing to be setup for our website.


  • *
    *
    *
    *
    *
    Fields marked with an asterisk (*) are required.

Blogs by MBA Business Software

Sage MAS 90 & 200 ERP Product Update 1 (4.50.2.0)

The following is a list of enhancements and corrections that have been incorporated for Sage MAS 90 and MAS 200 version 4.50 in this Product Update. Product Updates are cumulative, containing all that were included in 4.40.0.7 - 4.40.0.8. These are also listed below for reference. The numbering scheme has been changed for 4.50 Product Updates. The third segment represents the Product Update number. This change was done to accommodate future enhancements.

After installing this Product Update, WKsUpdate 90.exe or WKsUpdate 200.exe needs to be run on each MAS Workstation. This file is located in the ..\mas90\WkSetup directory on the MAS Server. (WKsUpdate should also be run anytime WkSetup.exe is run on a MAS Workstation.)

Accounts Payable

  1. Error 20 no longer occurs when you have AP Options "Sort Invoice Registers by Vendor Name" checked, and you run the AP Invoice Payment Listing.

 Bar Code

  1. Corrrected Quantity Available calculation (for Lots) in SO invoice Tier Distribution.

Bill of Materials

  1. Error 26 BM_costedmaterialsreport_rpt.pvc no longer occurs during printing of the Costed Bill of Materials Report for Specific Bills with Alpha only Option Code and option component having non-integer Unit of Measure.

Customizer 

  1. CustomizerUDF data in IM_SalesKitDetail is now copied to a new Sales Kit's when using the "Copy From" feature in Sales Kit Maintenancer

General Ledger

  1. GL Exchange Import no longer causes an error 12
  2. G/L accounts are now deleted after processing year. 

Inventory Management 

  1. Re-freezing inventory items will now retain quantities on hand manually counted and entered.
  2. Card Count Report unit cost field is no longer zero for all inventory items.
  3. Extended description entered in P/O or S/O is now correctly displayed in I/M Maint 'Orders' tab.
  4. A new utility IM Balance Inventory Quantity and Cost is now available on the *UTL menu. This utility replaces the IM_BalanceQtyOnHand_ui utility and is no longer available for use.
  5. Cost calc commits are now cleared after connections lost
  6. A new utility IM Balance Inventory Quantity and Cost has been added to the *UTL menu. This new utility replaces the IM_BalanceQtyOnHand_ui hidden utility and will no longer be available.
  7. Negative issue transactions for average cost items are now posted with the Warehouse Average Cost

 Job Cost

  1. Job Estimate Item detail now prints the descriptions for Assembly Items

Library Master

  1. MD added menus are now on the Launcher after migration
  2. On Conversion, the following error no longer occurs "Report output exceeds printer width or the record length was exceeded on a file write operation" then "Error 1 PR_LevelConversion.pvc 1731" when converting Payroll that has a cents value for Standard Amount/Rate or Standard Limit other than ".00"
  3. In Job Cost Job Maintenance, Job Number ALE lookup, 283 Job Cost Header (JCH) UDFs are now available in Custom Lookup Wizard.
  4. Error no longer occurs migrating data to MAS200 SQL 4.50
  5. SY_MultiPartForm and SY_ReportSetting Arithmetic overflow error no longer occurs
  6. Error updating SY_SagePEPTrack: PHYSICAL UPDATE ABORT: SY_SagePEPTrack, no longer occurs when running Parallel Migration.
  7. Error updating SY_SagePEPTrack: PHYSICAL UPDATE ABORT: SY_SagePEPTrack, no longer occurs when running Parallel Migration.
  8. MAS 90 Printing Performance Improvements.

Material Requirements Planning

  1. MRP is now showing component demand in the correct warehouse group.

Purchase Order

  1. A PO that has a Return of goods processed against it can now be edited.
  2. Auto Reorder Listing now includes the issued quantities with the Quantity Sold.
  3. Quantity on PO is now correct following a receipt of goods update when some of the items on
  4. the PO are received, but the item is question is not.
  5. Postings to PO Varianceadjust account now correctly post by warehouse and substitute the
  6. 'Location' segment as defined in Warehouse Maintenance.
  7. The purchase order now retains status of New if the inventory item has not been received.

Payroll

  1. For Federal eFiling and Reporting of the W-2s, the employee e-mail address will now populate the Electronic Delivery column in the W2/1099 Preparer. If you have not done so already, to set up the employee's e-mail address you will need to do the following:

Paperless Office:

From Paperless Office Setup menu select Options. Select the Forms checkbox.
From Paperless Office Setup menu select Form Maintenance. Complete the following:

  1. Company Code
  2. Module Code (P/R)
  3. Document (Direct Deposit Stub)
  4. PDF Directory
  5. Override Password/Confirm Password

Payroll:

  1. From Payroll Setup menu select Options. On the Direct Deposit tab select Require Direct Deposit checkbox.
  2. From the Payroll Main menu select Employee Maintenance. Select employee, select the Direct Deposit checkbox and then click the Direct Deposit button. On the Direct Deposits window click the Paperless button. On the Paperless Office Delivery Options window complete the following:

PDF Document Password
E-mail Address (for employee). Accept

After setting up the e-mail address for an employee, if that employee is not paid by Direct Deposit you may deselect the Direct Deposit checkbox on the Main panel in Employee Maintenance. The e-mail address entered will be retained. You will need to perform the Payroll steps 2 through 4 for each employee you want to set up with an e-mail address

Federal eFiling and Reporting has been updated with new federal tax codes for Puerto Rico and local codes for Ohio.

Sales Order

  1. Quantity in Inventory is correct when UM is changed in data entry and UM has different quantities for SO and PO
  2. Backorder quantities are no longer auto-filled in shipping data entry

 

System Setup

  1. The MAS 90/200 Help Files have been updated in this release. To update your local Help Files, run WKSUpdate located in the MAS 90/200 Server's ..\mas90\wksetup directory from each MAS 90/200 Workstation 

Visual Integrator

  1. Lines are now populated when importing into SO_SalesOrderHeader based on a Repeating Order after upgrading.
  2. The Offset Account is now imported correctly into GL_TransactionJournalheader.
  3. New inventory items are now imported into Inventory Delete and Change Utility when the new tem is the ALIAS of the original item.
  4. Error 40 WOWDBK 1560 no longer occurs when importing Work order transaction for Backflush Work Orders.
  5. Invoices are now imported into correct Batch when importing into AP Invoice Data Entry.

 

Work Order Processing

  1. Quantity is now correct after processing a Work Order completion to multiple warehouses if the second warehouse is a new warehouse.
  2. Error 13 WOWDAB 8112 no longer occurs in selecting Make For Sales Order in Work Order Entry and using keyboard shortcuts.
  3. Phantom Bills can now be reversed in work order entry
  4. The Extension in Work Order Inquiry / Transaction tab now uses the Number of Decimals in Cost Entries from Common Information

 

Sage MAS 90 & 200 ERP Product Update 8 (4.40.0.8)

The following is a list of enhancements and corrections that have been incorporated for Sage MAS 90 and MAS 200 version 4.40 in this Product Update. Product Updates are cumulative, containing all program corrections found in prior updates.

After installing this Product Update, WKsUpdate 90.exe or WKsUpdate 200.exe needs to be run on each MAS Workstation. This file is located in the ..\mas90\WkSetup directory on the MAS Server. (WKsUpdate should also be run anytime WkSetup.exe is run on a MAS Workstation.)

Accounts Payable

1. Error 20 no longer occurs when you have AP Options "Sort Invoice Registers by Vendor Name" checked, and you run the AP Invoice Payment Listing.

Customizer

1.  UDF data in IM_SalesKitDetail is now copied to a new Sales Kit's when using the "Copy From" feature in Sales Kit Maintenance

General Ledger

1. G/L accounts are now deleted after processing year end

 Inventory Management

  1. Re-freezing inventory items will now retain quantities on hand manually counted and entered.
  2. Inventory Recalculate Item History now includes and updates adjustment transactions forquantities that are generated by the IM Balance Quantity anda History utility
  3. Item Maintenance Transactions Tab quantities summed below the list box now include adjustment transactions created by the IM Balance Inventory Quantity and Cost utility.
  4. The hidden utility IM_BalanceQtyOnHand_ui has been replaced with a new utility. The new utility is named IM Balance Inventory Quantity and Cost and is located on the *UTL menu.
  5. File/Run, type in the Program field *UTL, click OK. Select the new utility on the mAS 90 Utilities menu.
  6. Two new hidden utilities have been added: IM_CommitCheckClear_utl and IM_ClearCommitDataEntry_utl. Please call Support for assistance in using these two new utilities.
  7. In Disassembly Register, Negative Tier Register, Physical Count Var Register, Material Req Issue Register, Receipt Register, Return Register, Work Order Journal update no longer orphans values in the Cost Calc Cost Committed and Cost Calc Quantity Committed fields when a connection is lost during the update.
  8. A new utility has been added: IM Balance Inventory Quantity and Cost. It is located on the *UTL menu.
  9. Negative issue transactions for average cost items are now posted with the Warehouse Average Cost.
  10. Item Maintenance Tab 6-Orders now uses correct Extended Description when it is changed on the fly in Purchase Order or Sales Order Entry.
  11. Card Count Report unit cost field is no longer zero for all inventory items.

Job Cost

  1.  Job Estimate Item detail now prints the descriptions for Assembly Items 

 Library Master

  1. During Parallel MigrationSystem files NO longer fails to convert with the following error: Error updating SY_SagePEPTrack: PHYSICAL UPDATE ABORT: SY_SagePEPTrack when running
  2. MD added menus are now added to the Launcher after migration

 Material Requirements Planning

  1. MRP is now showing component demand in the correct warehouse group

 Magnetic Media

  1. W2 Electronic Reporting has been modified according to the Social Security Administration's 2011 Specifications for Filing Forms W2 Electronically (EFW2) publication. The 2011 modifications: In W2 Electronic Reporting new field Kind of Employer has been added. "RE" Record--new required field Kind of Employer position 174."RW" Record--Cost of Employer Sponsored Health Coverage position 463-473 "RO" Record--Designated Roth Contributions Under a Governmental Section 457 position 111-121,"RT" Record--Cost of Employer Sponsored Health Coverage position 295-309 "RU" Record--Designated Roth Contributions Under a Governmental Section 457 position145-159
  2. In 1099 Electronic Reporting when a Minimum YTD Payment is entered a 1099-MISC "B" record will be created for vendors either have or do not have Misc Box 9 selected in Vendor Maintenance.

 Purchase Order

  1. G/L Account substitution is now correct for P/O Receipt of Invoice variance posting when posting by warehouse.
  2. The purchase order now retains status of New if the inventory item has not been received
  3. Completed drop ship purchase orders no longer display in I/M Item Maintenance or Item Inquiry Orders tab for PO's
  4. Item Maintenance "On PO" quantity is now correct
  5. Receipt of Goods Entry Error 45 no longer occurs.
  6. PO's that have had a return of goods processed against them can now be edited.
  7. Auto Reorder Listing now includes the issued quantities with the Quantity Sold.

Payroll

 For Federal eFiling and Reporting of the W-2s, the employee e-mail address will now populate the Electronic Delivery column in the W2/1099 Preparer. If you have not done so already, to set up the employee's e-mail address you will need to do the following:

Paperless Office:

1. From Paperless Office Setup menu select Options. Select the Forms checkbox.
2. From Paperless Office Setup menu select Form Maintenance. Complete the following:

a. Company Code
b. Module Code (P/R)
c. Document (Direct Deposit Stub)
d. PDF Directory
e. Override Password/Confirm Password

Payroll:

  1. 1. From Payroll Setup menu select Options. On the Direct Deposit tab select Require Direct Deposit checkbox.
  2. 2. From the Payroll Main menu select Employee Maintenance. Select employee, select the Direct Deposit checkbox and then click the Direct Deposit button.
  3. 3. On the Direct Deposits window click the Paperless button.
  4. 4. On the Paperless Office Delivery Options window complete the following:

a. PDF Document Password
b. E-mail Address (for employee). Accept

After setting up the e-mail address for an employee, if that employee is not paid by Direct Deposit you may deselect the Direct Deposit checkbox on the Main panel in Employee Maintenance. The e-mail address entered will be retained. You will need to perform the Payroll steps 2 through 4 for each employee you want to set up with an e-mail address.

  1. New W2 Box 12 Codes DD & EE have been added for W2 Federal eFiling and Reporting.
  2. New field Kind of Employer has been added to Federal eFiling and Reporting for W2 Reporting.
  3. In Federal eFiling and Reporting new local codes have been added for Ohio.
  4. Deduction Code Maintenance and W2 Form Printing have been modified to allow entry of new Box 12 Code DD & EE.
  5. Federal eFiling and Reporting has been updated with new federal tax codes for Puerto Rico and local codes for Ohio.

 Visual Integrator

  1. New inventory items are now imported into Inventory Delete and Change Utility when the new item is the ALIAS of the original item.
  2. The Offset Account is now imported correctly into GL_TransactionJournalheader.
  3. Lines are now populated when importing into SO_SalesOrderHeader based on a Repeating Order after upgrading

Work Order Processing

  1. The Extension in Work Order Inquiry / Transaction tab now uses the Number of Decimals inCost Entries from Common Information.
  2. Phantom Bill can now be reversed in Work Order Entry
  3. Quantity is now correct after processing a Work Order completion to multiple warehouses if the second warehouse is a new warehouse.
  4. Error 13 WOWDAB 8112 no longer occurs in selecting Make For Sales Order in Work Order Entry and using keyboard shortcuts.
 

Protect Your Business From Fraud This Time of Year

Tis’ the season of giving, but for many fraudster’s, it’s also an opportunity to take advantage of your hectic schedule! Fraud is on the rise during the holiday season. It’s even more important to keep your eyes open for the following fraud indicators. When more than one is true during a card-not-present transaction, fraud might be involved.

 

•             Larger-than-normal orders

•             Orders that include several of the same item

•             Shipping to an international address (Very High Risk)

•             Transactions with similar account numbers

•             Transactions placed on multiple cards or multiple transactions on one card over a very short period of time

•             Sales processed through the Deaf Relay System

•             Cardholder’s asking for Wires or funds through Western Union

•             Sales that seem “Too Good to be True”

 

*****Remember*****

Take every precaution at the point of sale. It’s important to take extra steps such as:

•             AVS (Address Verification) is a Match

•             Verify the CVV (3 digit security code) is a Match

•             Always ship to the AVS verified cardholder billing address

•             Look out for "red flags" for fraud signs that can be identified and stopped at the point of sale.

•             Check your batches daily! Especially if you are on automatic settlement and have an online store.
               This gives you the opportunity to identify if fraud is taking place, void the transaction, and then contact
               risk/tech support for help.

 

If you aren't comfortable with any sale or the sale seems suspicious in any way you can deny the sale or ask for the cardholder to pay using alternate form of payment (i.e. wire, money order, cash).

 

If you have any questions or concerns regarding a transaction please contact the Risk Management Department at This e-mail address is being protected from spambots. You need JavaScript enabled to view it

 

Best Regards,

Sage Payment Solutions, Inc.

 

 

Merry Christmas

MBA Business Software is celebrating Christmas. Not because it is a religious holiday but because it is an American tradition.

Our employees have diverse religious beliefs as do most business entities so individually, we will be following our own customs. Christmas at its core is a Christian celebration and because the overwhelming majority of our country’s founders and present day Americans are Christian, the day of celebration is also recognized as a legal holiday at both the state and federal level. In spite of this fact, interestingly, no government facility can display Christmas symbols.

Christmas has come to be more than just a religious holiday. It’s also Santa Claus, presents under a Christmas tree, company Christmas parties, and gatherings of friends and family. There’s a season to Christmas that runs from about Thanksgiving until New Year’s Day when homes are decorated and “Merry Christmas” is a common greeting to friends and strangers alike.

The political pressure to be more inclusive and less offensive to those not sharing in the Christian belief has unnecessarily marginalized this great American tradition. It’s in this spirit that MBA, as a company, wishes you a Merry Christmas. So join us in celebrating this special time of year.

See you in the Mall.

 

Sage MAS 90 & 200 ERP Product Update 1 (4.50.1.0)

The following is a list of enhancements and corrections that have been incorporated for Sage MAS 90 and MAS 200 version 4.50 in this Product Update. Product Updates are cumulative, containing all program corrections found in prior updates. Product Update 4.50.1.0 also contains program corrections that were included in 4.40.0.7. These are listed below for reference. The numbering scheme has been changed for 4.50 Product Updates. The third segment represents the Product Update number. This change was done to accommodate future enhancements.

After installing this Product Update, WKsUpdate 90.exe or WKsUpdate 200.exe needs to be run on each MAS Workstation. This file is located in the ..\mas90\WkSetup directory on the MAS Server. (WKsUpdate should also be run anytime WkSetup.exe is run on a MAS Workstation.)

Accounts Receivable

  1. Invoices are now imported into correct Batch when importing into AP Invoice Data Entry.
  2. Invoice History Inquiry for performance reasons, the UserKey column that was part of the default ALE lookup has been removed.
  3. The correct Customer Name now prints on the Monthly Sales Report.
  4. When running the Delete and Change Customers utility in the Accounts Receivable module, the
  5. Sales Order/Quote History records for the customer being changed are now renumbered/merged/deleted.

Bill of Materials

  1. If an Inventory Item is deleted, all Bill information is now removed that was created for the item.
  2. The unit cost on the Single-Level Bill of Materials Report now corresponds to the current unit
  3. cost entered in Miscellaneous Item Maintenance.
  4. The Costed Bill of Materials report for Option Bills is no longer printing **Invalid Bill** for valid
  5. options bills.

 Customizer

  1. In Manual Check Entry and Check and Electronic Payment Maintenance, when a UDF is named
    the same as a column in the physical table, and the UDF is mapped to flow thru to these data
    entries, the UDF value is now correctly passed when the Invoice is chosen in both data entries.
  2. In UDF and Table Maintenance, in order to map RA ReceiptHeader UDFs to the Generate
    Transactions work table, start with creating:
    1. RA ReceiptHeader udf
    2. RA GenerateTRansactions, use Business object type, datasource RA ReceiptHeader,
        column is the UDF created on step 1.
    3. RA GenerateTransactionsWork, Business Object UDF type, datasource RA
       GenerateTRansactions, column is the RA GEnerateTRansactions UDF created on step 2. 

 General Ledger

  1. Able to print recurring journal numbers in Reprint Journals.

 Inventory Management 

  1. On the Inventory Sales History Report, the Quantity Sold column for the Month the Sales Order Invoice was entered now reflects the negative Sales Order Invoice. 
  2. In Physical Count Update, Count of Zero for Standard Cost and Tiered valuation methods the TotalWarehouseValue is now cleared.
  3. Lot/Serial valuations now correctly display the actual Receipt No. and Receipt date of the cost tier transferred.
  4. Inventory item Quantity on Sales Order is no longer incremented after adding cost code information to an existing sales order without changing line quantities.
  5. The Balance Qty On Hand utility now assigns correct TierType and TierGroup when the condition requires a new IM_ItemCost OVERDIST tier to be created.
  6. Item Inquiry, Quantity Recap, the Beginning, Ending and Current Average Cost fields now appear with the Module Option selected to Allow Inventory Costing, Receipts in Item Inquiry 
  7. Quantity On Hand and Over/Short Variances no longer change when using Count Card Entry. Serial numbers are now correctly updated when receiving multiple serialized items in Receipt type Transaction Entry.

 Library Master

  1. Error “Prepare failed SY_SQLTranslateFailed:SYS” no longer occurs while running the Parallel Migration Wizard
  2. General Ledger Detail by Source for Out of Balance Journal Reports (for Level 3.x) in the Pre-migration utility no longer displays Out of Balance Journals if the same account number is used more than once in the same Journal.
  3. For MAS200 users only, the SY_workstation.M4t is no longer populated with workstation records that contain a blank userkey when the message "Another task is attempting to start up. Wait for the task to start before invoking another task".

Material Requirements Planning

  1. The Materials tab in Work Order now shows the component items from the phantom bills for Auto Generated Work Orders.

 Paperless Office

  1. The Return Order PDF is no longer removed in Vendor Viewer after updating Return of Goods register. Record is only removed if deleted in the Viewer or the Return Order is deleted.

 Purchase Order

  1. Receipt of Goods Entry Error 45 entry no longer occurs

 Payroll

  1. Deductions based on Regular Hours Worked now pull into payroll data entry after being converted.

 Sales Order

  1. The original cost for a serial item is returned on S/O credit memo update provided the cost tier still exists in IM_ItemCost
  2. Ship weight is now calculating correctly in Sales Order Entry and Sales Order Invoice Entry after conversion.
  3. Sales Journal Update, for a credit memo, or a standard invoice for a negative quantity, where a lot tier is being updated to, the cost of the existing tier is used (and retained) for the cost of the sale.
  4. Shipping Data Entry Focus now returns to Item Code Field when Kit item is not exploded. 

 Visual Integrator

  1. Invoices are now imported into correct Batch when importing into AP Invoice Data Entry.
  2. Error 40 WOWDBK 1560 no longer occurs when importing Work order transaction for Backflush Work Orders.

 Work Order Processing

  1. WO transaction entries now fill all required fields when creating new entries in IM_ItemCost.
  2. 2 WO completion transaction now prompts for Lot Number
 
  • «
  •  Start 
  •  Prev 
  •  1 
  •  2 
  •  3 
  •  4 
  •  5 
  •  6 
  •  7 
  •  Next 
  •  End 
  • »
Page 1 of 7

Need Support

Connect to supportCustomer Support Line
770-399-8021

MBA Newsletter Subscriptions

Check the box of the newsletter you
would like to subscribe to below:


Sage MAS 90 and 200 Newsletter
MBA Business Software Training Newsletter



twitterfacebookyoutubefeedlinkedin
You are here: Home Blogs