Solved: Inventory management batch wise choosing products

Aditya_K1999

Hi Guys,

I am trying to make an inventory management app.

I wanted to ask if a same product is entered but the batch no is different.

When I create a sales suppose, ca I get an option to choose under that product which batch I want to go for?

Domearian

Although you have a Unique ID, would they not have a Product ID? Anyway, that is besides.

You would need to have a sub table to record the batch number then. So against a product, you would have a table that lists all the batch receipts you have had. But the "Batch" information could also include date information. So when you list the "batches" for a product, that could be listed in date order rather than batch number. So always have the longest date away showing last. Does that make sense?

Or simply create a slice that filters all products but with batch numbers "grouped" in a deck view. When you select the item you want to review, it would then show all the batches associated with that product but within that deck view you could order by date.

View solution in original post

Joseph_Seddik

Please lookup "Dependent dropdown"

Aditya_K1999

I did look it up. But I am a bit confused on hos to structure it.

Domearian

Would the product number not be the same? So you could use the product number as the main but then a second slice for the batch number? It's hard understanding in what context your problem is.

Aditya_K1999

I have an inventory table which has frozen chicken which has come in 3 different stocks, where the product name & price is same but the expiry is different. The unique ID in the system for each of them is different.

But when I am about to do a sale, I want the option to choose out of these 3 available frozen chicken which one do i want to consider for sale.

Domearian

Although you have a Unique ID, would they not have a Product ID? Anyway, that is besides.

You would need to have a sub table to record the batch number then. So against a product, you would have a table that lists all the batch receipts you have had. But the "Batch" information could also include date information. So when you list the "batches" for a product, that could be listed in date order rather than batch number. So always have the longest date away showing last. Does that make sense?

Or simply create a slice that filters all products but with batch numbers "grouped" in a deck view. When you select the item you want to review, it would then show all the batches associated with that product but within that deck view you could order by date.

Aditya_K1999

Hi @Domearian

Possible to connect on a call?

Domearian

I'm not sure I can connect to anyone outside of my workplace. What is your email address?

Aditya_K1999

You can reach out to me on (PII Removed by Staff)