Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Ruth Entwistle]

#NAV2017

Hi all!

I am trying to revalue our inventory but need the value to go negative. (long story) 

I get a warning message that does not let me post the transaction to make the inventory value negative.

Allowing negative inventory in inventory setup allows negative quantity of inventory but not negative inventory value.  

Anyone know a bypass for this?   

Thanks

——————————
Ruth Entwistle
Customs Broker/Vendor Relations
Heron Point Seafood
Newmarket NH
——————————

[Michael Carr]

Ruth,

We are on 2018 and use standard cost allowing for negative balances. I tested the scenario and it does value inventory at negative in the Inventory Valuation Report as well as passing the full negative entry to the GL. It could be a diffrence based on costing method.

I am not sure how you wish this to be implemented or worked around. 

——————————
Michael Carr
VP , Finance
Philadelphia Scientific LLC
Montgomeryville PA
——————————
——————————————-

[Maneesha Agrawal]

Hi Ruth,

Way to bypass this can be suggested based on the reason of doing negative inventory valuation.Also share the costing method you are using?

——————————
Maneesha Agrawal
AlleTechnologies Inc.
McLean
——————————
——————————————-

[Ruth Entwistle]

NAV 2017
Average Costing

——————————
Ruth Entwistle
Customs Broker/Vendor Relations
Heron Point Seafood
Newmarket NH
——————————
——————————————-

[Justin Falconer]

Ruth, I see you are from NH, I’m in Littleton, NH
We use NAV 2016 currently and also use average costing. 
I have never tried to do a Negative Revalue but I can try it in our test database and let you know what happens.
I find that Average Costing is not very common cost method in NAV.

EDIT – I tried to do the Revaluation and i get the error “The value mist be greater than or equal to 0”
Also with Average Cost you cannot Revalue just one entry.  Looks like Negative Revaluation does not work with Average Cost

If you can give the reason why you need this maybe someone can help figure out a way to do what you need.

——————————
Justin Falconer
IT Manager
Tender Corporation
Littleton NH
——————————
——————————————-

[Maneesha Agrawal]

Ruth,

It would be better if you can share the reason of negative inventory valuation.

——————————
Maneesha Agrawal
AlleTechnologies Inc.
McLean
——————————
——————————————-