Creating an Excel form with Location, Sku and Description
J
Jennifer Schneider
started a topic
4 months ago
Hello,
I am reaching out to see if anyone knows how to create a form with:
1) Item Location Address (even if it is Out of Stock)
2) SKU
3) Description
It is proving to be very elusive. I can merge the Location and Item table but the location gets messed up when an item is out of stock. So it could be last known location or something like that. I want to go through our inventory systematically by location. Hope this makes sense.
Hi Kyle-thanks for your response. The perpetual inventory helps a little, but didn't give me exactly what I needed for generating a report. But thanks for the suggestion!
Jennifer Schneider
Hello,
I am reaching out to see if anyone knows how to create a form with:
1) Item Location Address (even if it is Out of Stock)
2) SKU
3) Description
It is proving to be very elusive. I can merge the Location and Item table but the location gets messed up when an item is out of stock. So it could be last known location or something like that. I want to go through our inventory systematically by location. Hope this makes sense.
Thanks,
Jennifer