I am trying to create a list of resources (Small Carton, Large Carton etc) with purchase price and purchase date against each product.
I use this data to then allocate resources against each order.
Eg : Order No. 1
Order Date: 1 Jan 2022
I am trying to create an airtable with resources, rate, jobs no. quantity, amount and total.
To do this I have created a master of inventory type with rate against each item.
Eg: Small Carton $ 5, Large Carton $10 etc.
Now I want to use that data ...