Specific Gravity for Lots

Hello,

We are manufacturing fluids and greases.

All items are lot controlled.

Packing UOM is KG.

Each lot can have different specific gravity - which results in different QTY to be filled in cans/barrels  for same product but different batch.

Example - If Sp. Gravity is 0.5 for Lot123 - then to fill barrel of 50 Lt - we may have to use 48 KG

But for same product if Sp.Gravity is 0.8 then to fill same barrel we may have to use 45KG.

Today users calculate it manually, is there a way in JDE which can do this calculation for lot during WO Completion, if specific gravity is entered manually.