On Hand Inventory

[Francis P.]

Hello everyone,

I'm pretty new with filmmaker and need some assistance getting the following done. I have two files one which contains inventory the other contains work orders. I want to create a script which I'm prompted the qty of a part# being given to a person. So let’s say I give a person 10 of part# x. I want to automatically deduct from inventory whenever that person uses one of the 10 part# x I just assigned to him. I hope my question is clear and someone is nice enough to help.

Thanks in advance.

Edited August 28, 2009 by Guest

[Francis P.]

anyone?

[bcooney]

Hello Francis,

If you has left this post with no replies, it would have been found more easily. Bumping takes it out of the No Replies list.

You've described two tables: Inventory and Work Orders. It seems to me that you need more tables. For example, in which table do you store the part assignments? If you had a parent Assignment table with a corresponding line items table, then for each Assignment you could have a list of parts (ID and Qty). This table could be related to Inventory (PartID) which could then sum the Qty Assigned.

However, it also seems that "assigned" is not the same as "used." So, you need another table that stores the parts (ID,Qty) "used." This table would also be related to Inventory (PartID), and then you can sum Qty_Used. From Qty_Received you can subtract Used to obtain Qty_OnHand. What happens to parts that are "assigned" but not "used." Are they returned to Inventory? Reassigned?

Just some ideas. You need to provide more detail of the Qty's that you need.