Forum Discussion

AnnieRyden's avatar
AnnieRyden
Qrew Member
4 years ago

Table-to-table relationships for Inventory ERP

Hello,  I'm working on creating a new ERP system for our Supply Chain Inventory/Procurement purposes. I've set up the App to have a parent table: "Projects" with a child table "Products". So, one p...
Relationships
DonLarson's avatar
DonLarson
Qrew Elite
4 years ago
Annie,

Inventory gets complicated.  Here is a model I have used


There is a fair amount going on, but not by the standards of Off the Shelf Inventory Packages.

This tracks the Manufacturer and the Vendors.

Titanium Screws are made by a handful of Manufacturers but sold by many dealers at very different price points and with different part numbers.

The Transaction Type Table is where I have Into Inventory, Out of Inventory and Inventory Adjustments which happen in the Inventory Transaction Table.

I have not explained everything, but hopefully this will help.

------------------------------
Don Larson
------------------------------
AnnieRyden's avatar
AnnieRyden
Qrew Member
4 years ago
Hi Don! 

This is immensely helpful, thank you so much! This was exactly what I needed to help get me started! 

We manufacture large industrial/electrical equipment and I'm trying to transfer the process from the person who was previously in the position. I have dozens of spreadsheets manually tracking exactly this, and these are exactly the inputs that I need to track. 

So far I've just set up a Projects Table with a child Products Table. Is there any more information I could provide for some more guidance? I really appreciate your message! This makes my project feel much less daunting already.

------------------------------
Annie Ryden
------------------------------