-16 value showing for 0 quantity in inventory valuation report

paras_mehan11
paras_mehan11 Member Posts: 14
in NAV Three Tier
Hello,
I am using nav 2016. In inventory valuation report there are some entries as: qty= -0 , value= -16.
and qty= 0, value=0.27. This issue is showing when i taking report for some location. why this happening ?
i will wait for your suggestions. Please give response as soon as possible.

Answers

  • allenyyzhou
    allenyyzhou Member Posts: 142
    Hello

    This is possible, several reason, one is because of rounding.Especially when you are using "Average Cost".
  • paras_mehan11
    paras_mehan11 Member Posts: 14
    Hi,
    Then how can i resolve it?
  • allenyyzhou
    allenyyzhou Member Posts: 142
    Hi,

    I think you do not need to resolve it, this is normal and explainable. You can pickup several Items and explain why this happens.
  • ara3n
    ara3n Member Posts: 9,258
    are you running adjust cost?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • paras_mehan11
    paras_mehan11 Member Posts: 14
    Hi ara3n,
    actually this happened because of in inventory setup i select the average cost calculation type = item & location & variant.
    it is showing when i am looking by locations but in overall it is fine .. but in location wise it is showing an error.
    now i want to know how can i resolve it .
    Thanks
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories