How to find and correct items with Unit of Measure Conversion Factors of 0 in Sage Mas 90 and Mas 200
Sage Mas 90 and Mas 200 Error 40 messages can occur when attempting to update Purchase Order receipts, returns, and invoices, or Sales Order invoices and shipping entries if the Unit of Measure Conversion Factor for an item is zero. Here’s how to find and correct those items and Purchase Orders and Sales orders with those items – to prevent resulting Error 40 messages.
Follow these steps when there are NO Purchase Order receipts, invoices, returns or material requisition issue entries, and NO Sales Order invoices or shipping entries in data entry nor stuck in update because of an Error 40.
If an Error 40 is encountered during P/O Daily Receipt Registers/Update or S/O Daily Sales Reports/Updates, call Friendly Systems support to fix the particular data entry line – and possibly also the order line, and item.
To find inventory items with zero-value (0) Unit of Measure Conversion Factors:
Go to Item Maintenance. Click “Lookup” (magnifying glass icon) button to the right of the Item No. field. In the Item List window that appears, click “Custom” button. In the Lookup Customization Wizard window that appears, select “Create new view” from the View drop-down. Enter a Description, such as “U/M Conversion Factor” and press Enter. Click “Next” button, which should now be available. In the “Available Fields” box, scroll down until the “PurchaseUMFactor” and “SalesUMFactor” fields are visible. Highlight one of these two fields. Then click the “Add” (right arrow) button to move the field into the “Selected Columns” box. Add the other field as well. You may also want to highlight each of these two fields in the “Selected Columns” and click the “Move Up” button to move the field higher in the order list. Click “Finish” button to exit the Customization Wizard window.
Back on the Item List window, select the “U/M Conversion Factor” view from the View drop-down. After the view results have populated, click on the “PurchaseUMFactor” or “SalesUMFactor” column headers0 as desired to sort these factors in ascending order to find items with Unit of Measure Conversion Factors of 0. (Note: Clicking the column labels repeatedly will toggle between ascending and descending views.)
Note the items that need to be corrected. Use Item Maintenance to correct those items.
Fixing Purchase Orders for the affected items. While the Open PO By Item Report seems like the logical report to run, if a purchase order contains a line item with zero-value Unit of Measure Conversion Factor, then attempting to run the report will result in an Error 40. Instead select the Open Purchase Order Report. Check All Purchase Order Types.
Click “Preview” button to preview the report. Use the Search (binoculars icon) button to search for and Find multiple instances of the item known to have had a zero-value Unit of Measure Conversion Factor. Note the P.O. numbers with line items that need to be corrected. For purchase orders with these specific items that have not been received or invoiced, delete the line and re-enter. Then go to the Totals tab to verify amounts and Accept. Call Friendly Systems’ support if you need assistance with correcting a line on a Purchase Order that has already been partially received or invoiced.
To find and correct Sales Orders with items that need to be fixed run the Open Orders by Item Report. Check All Sales Order Types. Select the item you are correcting. Click “Preview” to preview the report. Note the sales order numbers with line items that need to be corrected. For sales orders with these specific items that have not been invoiced or shipped, delete the line and re-enter. Then go to the Totals tab to verify amounts and Accept. If a sales order has already been partially invoiced or shipped, it may be necessary to delete the sales order and create a new sales order for the remaining quantities of items to be shipped, using a new sales order number. Call Friendly Systems’ support if you need assistance with correcting a line on an order that has already been invoiced.