I am trying to create an inventory system for my company (we fabricate fire sprinkler systems). We generally have 10-15 purchases a week for material. The issue is that I don’t receive all of my material on individual shipments, some times it takes 2 or 3 shipments and on rare occasions as many as 5. How can I create a base that records the items that I have received while keeping those I haven’t opened? I only get invoiced for those I receive so being able to show only that amount would be beneficial as well.
Right now I have an inventory being created in one of the tables, and then on the purchase order, I can select multiple items from the inventory table to fill out a purchase order. I need to show the items that have been received as received when they come in, while still showing the other items pending.
Eventually I want to then ship out the items we have made in partial shipments as we don’t deliver 100% of the fabricated parts to a job site all in one day.