Hi there,
In the Physical Inventory Journal, we tried to add items using the "Calculate Inventory" report.
Now in one location are some items which we count for the first time. The report does not show those items, because they had no transaction on that Location.
As soon I run the report without Location Code selection, the items appear in the journal. But I can not change the Location.
Has anyone an idea, how this can be solved?
Regards
0
Comments
It seemed to work.
This should not happen again. I believe it was just a carry over from the Nav implementation process.
We have a system programmed for us that handles the building of these transmissions, and allows us to record these transactions but the mechanic doesn't always record all the parts that he removed, so at inventory they come up.
Another example of how items could turn up, which also is common, we order part PTO-100XRBGX-W3XA from a vendor. Now there are many variants to part PTO-100XRBGX-W3XA all by using a slightly different part in manufacturing gives it a different use, these are pumps that have different applications, so if you change a part it will work on a Ford and it's new number will be PTO-100XRBGX-Q3XA. Now we order the part and it comes in, but it is really the different part number, they all look very similar so the receiving guy doesn't notice. So this is a receiving error, but it doesn't show up until physical inventory when we notice that it is a different pump.
I am just pointing this out because there are a lot of reasonable ways for items to show up without having been on a purchase order or produced. And there are ways to handle it outside of a physical inventory, but if you are in the middle of inventory, with auditors monitoring it, how do you explain that you can't enter this part on the physical inventory journal because Navision thinks it is not reasonable for items to be able to show up un-expectedly.
In our 2.0 version of Navision you could simply add additional lines to the journal and record the quantity counted and it would make the positive adjustment on the physical inventory journal. Now in 4.0, we have to make a separate item journal and for add-ons, it was much easier in 2.0.
Personally I prefer a function that requests an item no, location and variant from the user, and then creates a phys journal line with a 0 on hand qty. NUt both solutions are good.