I have an inventory database that need some assistance with. I have an Inventory table with part number, description, part ID, UPC description, cost, number of units…
Then I have a transactions table. There are three types of transactions, RECEIVE to receive inventory into the Inventory table and a location, STAGE to delete inventory and stage to a project, and TRANSFER to transfer inventory from one location to another, which is basically a STAGE and RECEIVE in one transaction.
I’m need assistance with the transfer, and my other issue is that I need to view inventory by location.
Any developers out there I could hire to discuss and finalize the base?