Skip to Content
0
Former Member
Feb 22, 2011 at 04:53 PM

Pricing Issue with Bill of Materials

24 Views

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