Start a new topic

Creating an Excel form with Location, Sku and Description


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 Jennifer,

Would the perpetual inventory log work for this?

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!

I believe you want the inventory snapshot table.


Login or Signup to post a comment