IBP - Inventory KF as a specific UOM

[drbanning]

I have an inventory KF - lives at WK PROD LOC and has the UOM conversion factor that toggles between Case, KG (Kilo), Pallet, etc... that works just fine.

I need to have a separate KF @ WK LOC that is just a SUM of all Inventory at UOMID 'KG' for total plant value at KG UOMID * **costKF** @ wk loc

I tried doing it as a helper KF

zhstorageunits @ wkprodlocuomto = if("UOMID" = ''KG'', "totalinventoryKF@wkprodlocuomto", null)

zhstorageunits @ wk loc = sum("zhstorageunits@wkprodlocuomto")

I then need to use that output in a calculation at the Location level, so I created a standard KF

zstoragekg @ wk loc = "zhstorageunits @ wk loc"

is there an easier way to accomplish what I am trying to do?

thanks,

dan

[ankpatel · Accepted solution]

Hi Dan,

I think what you have done is more efficient way.

Regards

ankur