I am trying to set up a cycle count program for one of our warehouses (we have three active right now). Is there a way to separate the three warehouses within the ABC calculation? Right now when I run the Calculate ABC codes it assigns the codes based on value of the entire site. So the A items in this warehouse is only 6 items, when it should be about 90 based on 70% of value.
You will likely have to calculate each warehouse separately in Excel and DMT to each part…
Thanks, I will probably have to go with that.
You mean even if you choose “Warehouse stock valuation %” it assigns by site?
I always pick site, so I can’t say definitively.
Yes, we only have a single site, but multiple warehouses in the one site.
Maybe I am misunderstanding, but when I selected warehouse %, I got different ABC codes assigned to the same part in two warehouses in the same site.
These are snippets from the same report (pages 1 and 28):
Incidentally, I changed the settings from earlier - I included on-hand and skipped projected. Not that that is really relevant.