Dear Experts,
I have a scenario which I am looking for a solution. An example is in the below table
Gas component Volume i(%) Price ($/MT) Value ($/MT)
A 50 100 50
B 30 200 60
C 20 300 60
Total Unit Price 170
Total Quantity of all components: 10,000 MT
Total Value of vessel = 10,000 * 170
My current solution is set up a BOM for these components and price each of the gas components at the item level. I also used the quantity field in the sales order for the volume in percentage composition of each item. But this solution only gave the total unit price (170 USD/MT).
My challenge is to be able to capture the total quantity of the gas in the system, as we have to print the delivery document with this quantity, and also be able to multiply by the total unit price so I can arrive at the total value of the vessel.
Thanks for helping towards a solution that will solve this issue.
Luqman