Hi,
I'm trying to design an inventory management system, where the inventory is based on a specific product and lot number. The stock amount is in a virtual column called [Total Wt].
I'm currently categorizing the data based on "on hand", "committed", "sent". The purpose of the "committed" category is just to flag the user not to use or sent that particular inventory. Is it possible to create a formula to sum the number of "on hand" products minus the "sent". So that it would calculate the total inventory of a particular product and lot code?
Is there a better way to design the table? Should I split the table into 2 tables so it can record the on hand and sent item?
LinkedIn
Twitter
