Physical inventory journal

Dave_Marwood

i would like to run a stocktake using the phy inventory journal but all my items are lot or serial tracked how do i generate the phy inventory journal to list all stock by lot or serial number or is there another way of counting lot tracked items :?

johnson_alonso

Have you specified item tracking code serial and lot no. ? I've just checked that the sourcetable of physical inventory journal is item journal line. And all my items are listed there along with their serial and lot nos. If you need to filter lot no or serial no, just make some modifications in calculate inventory windows.


Rgds,
Johnson

http://sea-navision-community.blogspot.com
sea-navision-community-subscribe@yahoogroups.com

Miklos_Hollender

Forget it by standard. If you don't want to modify the code, the best you can do is to do it without and then look up Lot/Serial Nos. manually for those which there is a difference.

ara3n

if you want to see what you have in inventory. Look at item ledger. filter on open. and look at remaining quantity. Copy it to excel and that is what you have in inventory.

Marcel

I also wanted to show a seperate line for each item-lot combination. Therefore i adjusted report 790. The lot numbers are now show in the field lotno. and for each combination a seperate line is created. On posting of the lines, the reservation entries will be created.
It works fine this way

Best regards
Marcel

Alex_Chow

Becareful of your modifications.

The one major point of a physical inventory count is to match what you have in the system against what's actually in the warehouse.

A lot of integrity of a physical count is lost is you display what should be in inventory on the counting list. The users will simple try to match what's printed.

Same goes with serial numbers, if you're keep track of inventory on both Inbound and Outbound, you have to verify the serial numbers that's sitting in your warehouse.

Navision does not fill in the serial/lot numbers on the physical inventory journal automatically by design. It's probably not the best to change this concept unless you have a very valid (and logical) business reason.

Miklos_Hollender

I agree. I think you can simply take inventory as it is and only check up the differences manually. If you use Lot and Serial No.'s I think it mostly means your warehouse is more or less in order - I mean it's not like having cheap pens 100 000 of each Item No. where nobody cares some of them is missing, right? It must be some sophisticated product. So you won't have a lot differences, I think.

Miklos_Hollender

I have another idea. It is usually a good idea to take phys. inventory with a handy bar code scanner that costs about $500 and you can load them up in a textfile. It's a lot faster. Configure it that it scans Lot and Serial Nos. Save the textfile. Copy-paste all Item Ledger Entries that have Remaining Quantity to an Excel file. Load that scanned textfile also in Excel and compare the two with a simple VLOOKUP. Then you have differences by Serial and Lot No. Write a simple dataport that imports the differences into an Item Journal and forget Phys. Inventory Journal. Phys. Inventory Journal is kind of an outdated feature now I think, left from the Stone Age where people actually ran around with printed stocktaking sheets.

Heh, I know a company who didn't want to buy a handy scanner and even not have a notebook, so they throw a PC into a shopping cart and push it around scanning barcodes with a simple peripherial-scanner

If you don't have Lot and Serial as bar code on the Items then forget stocktaking by Lot and Serial altogether as it would be a hell anyway to record all of them manually.