Technical and Installation Discussions

[JWJW]

We are using version 4.1 and cannot resolve this error: Error 40 in Program POWUBD at line 3030.

I tried Rebuilding the Sort Files first.  Then tried Rebuilding the Key Files, Analyze and Relink, Rebuild sort Files.

I am at a loss and would really appreciate any help.

[Natasha]

JWJW,

Error 40 is a divide by zero error.  The most common cause is the unit of measure conversion factor in a record is 0.  Contact your reseller or Sage support if you need help correcting this error.

[JWJW]

We are not currently under service contract because we are literally 5 days from switching to a new program, at which point we will only need MAS90 as a reference tool.  I am hoping to solve this issue so that we can finish MAS90 cleanly.  I am open to any suggestions.

[rmikolainis · Accepted solution]

Error 40 POWUBD 3030, when updating a Receipt Register due to the Purchase Unit of Measure Conversion Factor being 0. This is a divisor and cannot be 0.

Possible Resolution:

The Purchase Unit of Measure Conversion Factor is likely 0. Change the field in Data File Display and Maintenance.

Note: Use caution when working with this task. Always make a backup first. If necessary, seek the assistance of a qualified Sage Software business partner or Sage Software Customer Support analyst.

1. On the error window, click 'Info', and then click 'Debug' to open the debug window.
2. To obtain the receipt number, type the following at the prompt  and press ENTER:
• ? PO5$(1,7)
3. Note the receipt number that is returned. This is the receipt that received the error 40.
4. To obtain the purchase order number, type the following and press ENTER:
• ? PO5$(15,7)
5. Note the returned purchase order number.
   Note: A purchase order number is not always returned.
6. Type "bye" to exit the debug window.
7. Open Library Master / Repair / Data File Display and Maintenance (or Library Master / Utilities / Data File Display and Maintenance).
8. Select PO5xxx at the 'File Name' field (xxx = company code).
9. Click the 'Key Scan' button, and select the receipt number noted above.
10. Verify that Key=[] at top of the window is the correct receipt number. Field 02 is the starting index (first line item) in the PO6 file. Note the number at the right of Field 02.
11. Select PO6xxx at the 'File Name' field. In the 'Index' field at the bottom of the window, type the starting index number noted above and press ENTER.
12. The first line item of the receipt should display. Note whether Field 04 is a regular inventory or miscellaneous item. If it is either of the two, note the value in Field 11 (Unit of Measure Conversion Factor).
13. If Field 11 is 0, click 'Edit' and enter the following:
• Field = 11
• Change Data: Change the 0 to a 1 (or a different number, depending on the unit of measure conversion factor for purchase unit of measure compared to the standard unit of measure)
14. If the record is not a regular or miscellaneous item, or Field 11 does not equal 0, enter the value from Field 03 in the 'Index' field to go to the next line item.
15. Continue until the record is located or the last record displays (Field 03 = 0).
16. If the last record displays without locating the record, see "Notes" below.

Notes:

• The problem might also be caused by a purchase order in Purchase Order Entry. If the debug steps above (? PO5$(15,7)) returned a purchase order number, or if an item was not found in PO6, repeat the same steps above using PO1 instead of PO5 and PO2 instead of PO6.
• To avoid this issue in the future, verify that the affected item(s) have a Purchase Unit of Measure Factor greater than 0  in Inventory Maintenance. To do this:
1. Open Inventory Management / Main / Inventory Maintenance, and select the item.
2. Locate the Purchase U/M at the bottom of the window and note whether the conversion factor is 0 (The disabled field to the right of the unit of measure).
3. If it is 0, change the 'Purchase U/M' to any other value open the conversion factor field, edit the conversion factor to something other than 0, and then change the unit of measure back to the original value.

[JWJW]

THANK YOU!  THANK YOU!

FYI- The notes at the bottom were a big help.