How to set the "Inventory value" (posted, expected and actual) to 0,00€ when quantity is 0?

thaseman

In our stock we have quantity 0 but "Inventory value (actual)", "Inventory value (expected)" and "Inventory posted to GL" e.g. 0,02€. How can I set the value to 0,00€?

Kappa

First of all, make sure you have run Adjust Cost - Item Entries + Post Inventory Cost to G/L. If this does not resolve the issue (while all production orders are finished and invoices are posted), then the data is unfortunately incorrect. If you use lot numbers you can always make a dump of the value entries of this item to Excel and create a subtotal per lot no. Then you will find which lot number causes this issue.

Kappa

First of all, make sure you have run Adjust Cost - Item Entries + Post Inventory Cost to G/L. If this does not resolve the issue (while all production orders are finished and invoices are posted), then the data is unfortunately incorrect. If you use lot numbers you can always make a dump of the value entries of this item to Excel and create a subtotal per lot no. Then you will find which lot number causes this issue.

muca

one more possibility is to reopen all item entries for adjustment (ItemLegerEntry."Applied Entry to Adjust":=TRUE) and uncheck for this item that cost is adjusted (Item."Cost is Adjusted":=FALSE)
After that You can recalculate this cost using item ledger application ("Adjust Cost - Item Entries" and "Post Inventory cost to G/L")

P.S. Does not work in Navision Finacials versions.

thaseman

Thank you. Unfortunately we are not using lot numbers and so I guess we have to leave it as it is, correct?