Mass inventory update

supremo

We have completed our year-end inventory count. We have 2500+ items with 6 locations, all of them with inventory discrepancies.
What is the best process to adjust or replace the inventories without hand keying them?

Thank you!

markborges

Hello Supremo,

Are you considering the Phys. Inventory Journal?

Regards,

supremo

Yes. How can we select multiple items from the calculate inventory? say we want to select items with prefix "RM"?
Is there a way to fill in the journal with a huge no. of items?

Thank you markborges :thumbsup:

markborges

Hi supremo,

You can add any filters that you want to the "Item" tab of the Calculate Inventory job.

So, for the "RM" preffix, you should filter "RM*" on the "No." field.

As for filling the journal with a huge no. of items, well, from a pretty fast calculation, you can add up to 214000 lines in a journal... If you need more, then you should split the transactions in two or more, using the fitlers on the Item tab as described before.



Kind regards,

supremo

Thank you!
Is there a way to populate the actual count for multiple items without typing per line?
We have NAV2009 SP1.

bbrown

supremo wrote:

Thank you!
Is there a way to populate the actual count for multiple items without typing per line?
We have NAV2009 SP1.

How would the system know what values to use without you (or someone) entering them somewhere? So would this really save any time over manually entering them into the journal? Unless you were to develop a process (handheld?) where they could be entered as items are counted. But you appear to be looking for a simpler solution?

markborges

supremo wrote:

Thank you!
Is there a way to populate the actual count for multiple items without typing per line?
We have NAV2009 SP1.

Still no Crystall Ball available on NAV, sorry about that :P

If you are an Excel Master, you can try to copy the Journal and Paste it on Excel, use some VLOOKUP formulas to fill the data, but still, you would need to have the typed data SOMEWHERE (Text File, Excel sheet, etc...)... After that, you would need to have a GOOD dataport available to import back the data (since you don't have NAV 2013).... But as bbrown mentioned, I think you are looking for a simple solution, so manually typing the information in is your 1st and best option again..

Kind regards,

supremo

Thank you bbrown and markborges. I was looking for a dataport to import my actual count from a spreadsheet (MS Excel). Was trying to skip the modification of actual inv. per line from the physical inv. journal.

My 1st option is still the manual encoding of actual inv., 2nd is a dataport. Will try the 2nd option into a test environment.

Thanks guys! :thumbsup: