Easiest way to add Location in Inventory App

[Priyanka1311]

I have a requirement of a similar Inventory app , however I need the user to be able to select the Location first and then go to Items and Inventory Log. When user opens the app, the app will ask to choose a location as different locations have different stock/target quantities for the same Item. After going through different posts, I realize I need to use USERSETTINGS to allow user to set the Location. However, I am unable to figure out how my key columns should be configured given that item ID is no more unique. In my case, a combination of Item ID and Location is unique. How do I go about setting my data structure? 

[MiguelPilo]

Hi.

I thing that you are kind of confused. USERSETTINGS do not have any relation whit yor requirement.

You just need at least 3 tables:

1. ITEMS
2. LOCATIONS 
3. INVENTORY (Use Ref Type columns for Items and Locations)

And if you want a better User Expirience, i recomend to you a 4th TABLE: "Werehouse". There you can display a Wharehouse's Lay Out to help users to find and picking or storage in the correct place easely.

[Priyanka1311]

@MiguelPilo , thanks for your response. How do I provide the user an option to select the location and then display the Items and Inventory data based on that location?

[MiguelPilo]

Considering at least the 3 tables I had mentioned, the function will be as continue:

1. ITEMS ("Info Table" Just to register info about your product {Part number, Description, Category, etc.})

2. LOCATIONS ("Info Table"  Create all requested locations with needed data {Location number, Description, Admited Categories, Capacity, etc.})

3. INVENTORY ("Action Table" Here you will log your inventory adding new rows by a Form View and needed data will be {Item_ref, Location_ref, Date, Quantity, User, Product_in/out, etc.})

And as a View page you can use a deck or table view whit INVENTORYData from grupped by location to know exactly all inventory movements.

I recomend to you combine this view in a dashboard with ITEMS list and add a virtual colum in ITEMS table [Inventory_Qty] to totalize all in and all outs for each product from INVENTORY table

[Priyanka1311]

I'm sorry but I still don't follow how to ask user for location selection if I do not use UserSettings

[Marc_Dillon]

Splitting inventory across multiple locations typically involves adding a new table to the data structure. This table references a single item, a single location, and provides a quantity of that item at that location.