i am looking for some advise how to create a query from Bill of material table,
bill of material table looks like below
FinishedProduct,ItemNumber
64000,7975
64000,7685
64000,7695
64000,6444
6444 is WIP
Same table has Work in process (WIP) information,
FinishedProduct, Item Number
6444, 10
6444, 20
6444, 30
in order to create product 64000 we need following item include WIP, which also have 3 different raw material.
is there any way i can create a query it show both WIP and Finish Bill of material if we select a Finished Product in criteria.
your help will be greatly appreciated.
bill of material table looks like below
FinishedProduct,ItemNumber
64000,7975
64000,7685
64000,7695
64000,6444
6444 is WIP
Same table has Work in process (WIP) information,
FinishedProduct, Item Number
6444, 10
6444, 20
6444, 30
in order to create product 64000 we need following item include WIP, which also have 3 different raw material.
is there any way i can create a query it show both WIP and Finish Bill of material if we select a Finished Product in criteria.
your help will be greatly appreciated.
Last edited: