Let me start my question with this: The online help says for field 5409 “Inventory Value Zero” in table 27 “Item”: Click this field to enter a check mark if the item on inventory must be excluded from inventory valuation. This is relevant if the item is kept on inventory on someone else’s behalf. The only thing I found out is that the “Adjust Cost - Item Entries” will not attach these Items. But the “Post Inventory Cost to G/L” function will do, so this is not what I understand on an item “kept on inventory on someone else’s behalf”. For our customer I need to really exclude items from inventory valuation. In table 5802 Value Entry there is field 103 “Inventoriable”. Value entries having “FALSE” in this field, there is no “Post Inventory Cost to G/L” for those items (value entries). In the standard database there are no Value Entries where this field is set to “TRUE” and So far, I couldn’t found any function which is setting the field to “FALSE”, like I want to do. Is there something I didn’t see? Is there anybody who has experience with the field “Inventoriable”? Thanks and regards Micha
Hi Micha, If you want to know where the field is used or set just find it using Navision Developer Toolkit, in your case the field inventoriable is used by object : Table 5802,5821 form 5827 Report 798,1002,5899 Codeunit 5895,22 From my slight investigation this field will set false when value entry create by transaction that using item charge, but you should investigate further before using that field.
Aloysius, thanks for reply! Yes, you are right. I used the DevTool and found the same objects as you wrote. At the moment I found out one way to have the field been set on FALSE. It’s a positive item charge posting in Sales Order/Invoice. So this seems not to be as critical as I thought. But of course it needs carefully tests because the init value of the field is FALSE. But if it will work, it is a quite simple way to exclude items from inventory valuation and on the other hand having no reduced functionalities.