Hi all,
Yesterday I uploaded a copy of my DB that I have a question on, but haven't
gotten a reply, so thought I would try to explain things better....
I have 2 forms, one is Inventory Items, the other is Parts Inventory
On the Inventory Items form there is a subform, done with a query, that
shows my BOM, including what parts are used in a finished item and the
quantity of parts used..
On the Parts Inventory form, tab 2, I have a subform that shows how many
parts were purchased, their unit price, and a control to calculate the
number in stock.
I have tried several formulas but cannot get them to work correctly to
calculate "In Stock"
IE -
=Forms!Parts_Purchase!totalunitspurchased-Forms!Inventory_Items!Inventory_Items_BOM.Form!Quantity_Used
It will calculate 1 row from the BOM, but will not calculate each part
used. So, saying that there were 3 different parts used in an item, it is
only picking up on the first Quantity Used and then uses that number to
decrease stock for all of the parts used.
I read somewhere yesterday that Access does not have the ability to
calculate each row and assign the value to each part used, is that correct?
If so, then how would you recommend decreasing and increasing stock levels
as parts and items are purchased, used, and sold? I will also need to apply
the same theory for taking items that are finished out of stock when they
are invoiced/sold.
Any ideas would be greatly appreciated!
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar