Error#40 Devide chech of numeric overload Prog:POWUBC Line:2645 1

[echo106]

It appears that we are having quite a bit of problems with posting batches either in receipt of goods or purchase order entry. For several weeks now they are in error, so far we have been able to delete and re-enter, although this still isn’t right because we are finding that the receipt is updating but the GL isn’t.
I just created a batch to post two invoices in receipt of invoice in the PO module and I got this error.

 

[BigLouie]

This is a common error message. It is a divide by zero error. Usually this is caused by a missing Unit of Measure conversion factor. Check the items in inventory maintenance and see if there is a figure there. You could extract the PO6 and see which items are causing the problem. You get this a lot on imports.

 

[echo106]

This error is caused by a miscellaneous item and cannot post batches. I have gone through all the PO6 files and found a few that did not have unit of measure however the batch still will not post and I still get the same error. Any insight would be greatly appreciated.

 

[BigLouie]

Edit the Unit of Measure Conversion Factor in the PO6 file using Data File Display and Maintenance.

Note: Extreme caution should be taken when selecting Debug. Type only the commands shown in the below instructions.

Obtain the receipt and purchase order numbers.
At the error information screen, click the 'Info' button, and then click the 'Debug' button to open the Providex window.
At the prompt, type the following and press 'Enter', and note the returned receipt number that caused the Error 40.
? PO5$(1,7)
Type the following and press 'Enter', and note the purchase order number, if one is returned.
? PO2TAG$
Obtain the line index number for PO6.
Open Library Master / Repair / Data File Display and Maintenance (DFDM), and open ..\Mas90\POxxx\PO5xxx, (xxx = company code).
In the 'Key' field, type the seven digit receipt number noted above and press ENTER'.
Verify that Key=[] at top of the screen is the same receipt number.
Note the value in field 02. This is the starting index (first line item) in PO6.
Still in DFDM, select ..\Mas90\POxxx\PO6xxx.
In the 'Index' field, type the starting index number noted above and press ENTER to display the first line item of the receipt.
Look at Field 04 and verify whether it's a regular inventory item or a miscellaneous item. If it's not, look at field 03 to get the next index number. Type that number in the index field at the bottom of the screen. You only need to look for regular inventory items or miscellaneous items. Once you have an item look at field 11.
Note: Field 11 is the Purchase Unit of Measure Factor Field which must have a value of 1 or greater. It cannot have a value of 0. A value of 0 will cause the initial error 40 during the update. If the number to the right of Field 11 is 0 then click on 'Edit' and edit Field Number type 11, press 'Enter' and in the Change Field 1. Click 'Ok'
Note: If the record you are looking at does have a correct value in field 11 then you must select the next index (line item) on that receipt. The number to the right of Field 03 is the index for the next line item. Enter that number in the Index Field and press enter which will bring up the next line item. Again, look at Field 11 to verify the value is correct and edit if need be.
Note: When the number to the right of 03 is a 0 this indicates that this is the last line item for that receipt.
Note: The below steps are to fix the purchase order record in the PO2 file only if a value was returned from step 3 above.
Library Master / Repair / Data File Display and Maintenance, File Name type PO1xxx, (xxx being the three digit company code) press 'Enter' and in the Key Field at the bottom of the screen type the seven digit purchase order number listed from step 3 and press 'Enter'.
Verify that Key=[] at top of the screen is that purchase order number. Field 02 is the starting index (first line item) in the PO2 file. Write down the number to the right of 02.
Click on File Name Field and type PO2xxx and press 'Enter'. Index Field at the bottom type the number from step 11 and press 'Enter'.
Look at Field 04 and verify whether it's a regular inventory item or a miscellaneous item. If it's not, look at field 03 to get the next index number. Type that number in the index field at the bottom of the screen. You only need to look for regular inventory items or miscellaneous items. Once you have an item look at field 11.
Note: Field 11 is the Purchase Unit of Measure Factor Field which must have a value of 1 or greater. It cannot have a value of 0. A value of 0 will cause the initial error 40 during the update. If the number to the right of Field 11 is 0 then click on 'Edit' and edit Field Number type 11, press 'Enter' and in the Change Field 1. Click 'Ok'
Note: If the record you are looking at does have a correct value in field 11 then you must select the next index (line item) on that receipt. The number to the right of Field 03 is the index for the next line item. Enter that number in the Index Field and press enter which will bring up the next line item. Again, look at Field 11 to verify the value is correct and edit if need be.
Note: When the number to the right of 03 is a 0 this indicates that this is the last line item for that receipt.

Note: Do not delete these records when the error occurs. They must be edited according to the above steps and then you will be able to finish the interrupted update without incidence.
Note: Make sure that the item(s) affected that had a purchase unit of measure factor of 0 have the correct factor value assigned in the Inventory Masterfile. If the value in the masterfile shows 0 then this error will continue to occur until fixed. Change the Purchase U/M Field to a different unit of measure, which will enable the factor field, allowing the correct value to be typed in. Once this value has changed then change the purchase unit of measure back to the correct value.

 

[echo106]

I believe I have gone through all the files and there is a quantity there. Could this error be due to missing gl accounts? The error now is error 40 POWUBC at line 2680. Big Louie you are the man, so if you have any advice I am all ears.

 

[BigLouie]

Echo did you know you could log onto the Sage web sight and go to Support and search the knowledge base for this error message and it will return the resolution.

 

[BigLouie]

Did you follow exactly what I posted? The resolution is the same for each error message. Have you called your reseller.