web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Divide by Zero Excepti...
Microsoft Dynamics NAV (Archived)

Divide by Zero Exception: How do I fix this???

(0) ShareShare
ReportReport
Posted on by Eric Droit 40

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?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    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.

  • Suggested answer
    TWBlaisdell Profile Picture
    TWBlaisdell on at

    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

  • Eric Droit Profile Picture
    Eric Droit 40 on at

    Savatage99 - What debugger?

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

    Thanks for your responses!

    Eric

  • TWBlaisdell Profile Picture
    TWBlaisdell on at

    Eric,

    The following link is to the Customer Source access:

    https://mbs.microsoft.com/customersource/documentation/whitepapers/navcostingerrordetectionwp.htm?printpage=false&sid=czungajnr2pr0skmb2hvlrjp&stext=Costing error detection

    Thanks

    Tom

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans