Question Status

Suggested Answer
Eric Droit asked a question on 24 Mar 2012 9:54 AM

I get a "Divide by Zero Exception" error message when trying to update my standard cost via the Standard Cost Worksheet. i also receive this error when trying to close my inventory period. In both instances, the error message prevents me from completing these tasks which means I cannot correct my standard cost on the item or close my inventory period. Why do I get this error? How do I fix this error?

Reply
Harry Ruiz responded on 26 Mar 2012 1:17 PM

You can turn on the debugger to see where it stops.  Also, It's probably some custom code or some field you are not filling out properly.

Any code dealing with division by zero should be written as

if x = 0

then y := 0 //stops the crash

else y := z/x;

taking into account the possiblity of division by zero and preventing crashes.

Reply
Suggested Answer
Tom Blaisdell responded on 2 Apr 2012 2:09 PM

Hello,

I will add some additional information to the response.  In previous reports of the Divide By Zero error, the problem was the result of some data corruption where the ILE data had been deleted but the Value Entries and Item Application Entries had not been consistently deleted..  

The Costing Error Detection Toolkit Report would be a possible starting point to determine the extent of any data issues. You would want to work with your partner to analyze the results and determine possible next steps.  The complexity of managing an issue with a "divide by zero" error go beyond what can be managed through this Forum.

Thanks

Tom

Thomas Blaisdell, MIcrosoft Dynamics NAV Support Contributor

Reply
Eric Droit responded on 3 Apr 2012 2:01 PM

Savatage99 - What debugger?

Tom - Where do I find this Costing Error Detection Toolkit Report?

Thanks for your responses!

Eric

Reply
Suggested Answer
Tom Blaisdell responded on 2 Apr 2012 2:09 PM

Hello,

I will add some additional information to the response.  In previous reports of the Divide By Zero error, the problem was the result of some data corruption where the ILE data had been deleted but the Value Entries and Item Application Entries had not been consistently deleted..  

The Costing Error Detection Toolkit Report would be a possible starting point to determine the extent of any data issues. You would want to work with your partner to analyze the results and determine possible next steps.  The complexity of managing an issue with a "divide by zero" error go beyond what can be managed through this Forum.

Thanks

Tom

Thomas Blaisdell, MIcrosoft Dynamics NAV Support Contributor

Reply