Adjust Cost - Item Entries Failed, could not divide by Zero

Business Central/NAV User Forum
1

hai all…

I want to adjust cost - item entries(report 795)…

but it failed,it was said that it couldn’t divide by zero

and after I use debugger I found an error as i bold this one

codeunit 5895 - Inventory Adjustment

CalcCostPerUnit(VAR OutbndValueEntry : Record “Value Entry”;OutbndCostElementBuf : Record “Cost Element Buffer”;ItemLedgEntryQty : Deci
WITH OutbndCostElementBuf DO BEGIN
IF (OutbndValueEntry.“Cost per Unit” = 0) AND (“Remaining Quantity” <> 0) THEN
OutbndValueEntry.“Cost per Unit” := “Actual Cost” / (ItemLedgEntryQty - “Remaining Quantity”);
IF (OutbndValueEntry.“Cost per Unit (ACY)” = 0) AND (“Remaining Quantity” <> 0) THEN
OutbndValueEntry.“Cost per Unit (ACY)” := “Actual Cost (ACY)” / (ItemLedgEntryQty - “Remaining Quantity”);
END;

so, does anyone colud tell me, what should I do?

thanks

2

Pretty sure there was a hotfix for this back in early version 4, so you could look on partnersource or contact your partner.

3

hmmmm by the way, I do adjust cost every several months

but this time we had an error divided by zero…

I already convert database to Nav 4 SP 3 (local database)

it’s still error…

4

It’s an error in adjust cost object and not in client version, so you can even make a technical upgrade to 5.0 you will still get the same error. You must make a object correction.

5

is it not because because mistake from table?

i thought it was mistaken by table…

but i don’t know what table error

6

Are you saying that you only run adjust cost once every several months? Why would you not run it daily? I would think you need to run it at least at the end of each accouunting period to have accurate numbers.

7

I recommend to run that report most often you can to keep precise financial information. Customers prefer to run that report before closing fiscal month.

8

that’s it…

that’s our biggest problem… our adjusting cost, it’s not always

and now we are preparing for new database, so adjust cost and other mistakes could be solved

thanks for your advice :slight_smile: