Options

Phys. Inventory: Items without Ledger Entries

alsolalsol Member Posts: 243
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

Comments

  • jversusjjversusj Member Posts: 489
    We had the same problem. The only thing we could think to do was to manually add the item to the journal. We then had to run a processing report to flag the manually created line as Physical Inventory = YES (since that could not be done through the item journal line table).

    It seemed to work.
    kind of fell into this...
  • Miklos_HollenderMiklos_Hollender Member Posts: 1,598
    Better rethink this requirement. Putting something on stock via positive adjustment / phys. inv. should be a rare exception, not a rule. I think it's one of the cases when Navision is completely right - if it hasn't ever been purchased/produced why would you expect it to have stock?
  • jversusjjversusj Member Posts: 489
    Better rethink this requirement. Putting something on stock via positive adjustment / phys. inv. should be a rare exception, not a rule. I think it's one of the cases when Navision is completely right - if it hasn't ever been purchased/produced why would you expect it to have stock?
    In our case, we brought a company in from using Concode C5. In C5, when they stopped selling an item, they deleted it from their database. When we created their Navision database, we didn't see the item number to bring it into the system. They then did a physical inventory, and *found* some pieces of this thing they thought was gone forever. They wanted it added to the journal, but since there were no ledger entries (we created the item after they found it), it would not populate the journal. That's why we did what we did.

    This should not happen again. I believe it was just a carry over from the Nav implementation process.
    kind of fell into this...
  • themavethemave Member Posts: 1,058
    We have it happen as a normal coarse of business, we re-manufacture transmissions, rear-end and other heavy truck parts. We also re-ratio manual transmissions, that is we change the gearing from one thing to another. To do this, we take certain parts out of a new transmission, and put a different one back in. When we take the part out, it may be a part that we have not previously stocked and thus have no inventory history on it. This is a new part that is available to re-ratio a different transmission if needed.

    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.
  • David_SingletonDavid_Singleton Member Posts: 5,479
    Cyberscout, this is a very common business requirement. Most Navision users I have seen with this need, have a modification similar to that suggested by jverusj. Or create a function that allows you to enter a Phys line directly.

    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.
    David Singleton
Sign In or Register to comment.