Hi
I need assistance.
I purchase 2 X Products by using Purchasing Process.
I then need to combine these two products to make a product I can sell.
I need to be able to track the "batch" purchased and will need to focus on the Ratio of the combination.
I need the quantity of the two Items to decrease in quantity and value and then the quantity of the combined (end product) to be the total quantity and value of the two Items purchased.
I.O.W
Item A - 3000 TONS at $150 per TON = $450 000
Item B - 4500 TONS at $200 per TON = $900 000
Combined
Item C - 7500 TONS at $180 per TON = $1350 000