Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Tracking inventory with bin locations

Topic Labels: Base design
513 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Meatball
4 - Data Explorer
4 - Data Explorer

Hi, I’m tracking inventory coming in and out of my warehouse.   I have a shipment table where i enter a record in each time something gets received OR shipped out of the warehouse.   When the material is received i have a field to enter the bin location that the product gets put away to.   That field is a lookup to a linked table where I’ve entered all of the available bin locations that can be chosen.   In the bin location table I’m tracking the project name in a field next to the bin location.  That way i can look at all my bin locations and see which projects are in which locations.  We need to know how many bin locations a project are taking up at a given time.   My dilemma is when material is being shipped out of my warehouse I’d like to be able to re-enter the bin locations the material is leaving and then update the bin location table showing that that bin location is now empty.   Is there a way to do that?  The shipment table has a field where I select “receiving” or “shipment”.  I feel like I need something that says if record = “shipment” then whatever bin locations I enter in that line that project is cleared out of the project field in the bin location table.  

0 Replies 0