Inventory Database By Location


#1

Hello,

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?


#3

PM sent.

[20 char filler]