Routing Operation - Formula

SOLVED

Hello All,

We are trying to get away from a predefined STK-OPE conversion within our Routings. I would instead like to use a formula that pulls the needed number from ITMMASTER automatically. I know I need to bring in something like [F:ITM] and grab the field I need, however I'm unsure how to set what the item number is given that this formula will take place within a Routing under the "STK-OPE coeff form.". I'm not familiar enough with formulas to understand where I would do something like (Select [F:ITM]PCU(0) where [F:ITM]ITMREF = X?)

This may be a bit edge case but any help would be amazing.

  • +1
    verified answer

    I believe base on the way formula works, it should already know what ITMREF is, and you should not need to specify it. So I would simply try this formula..

    1/[F:ITM]PCUSTUCOE(0)

    Noted that on the routing, the coefficient it's looking for is STK-OPE conversion(How many OPE in 1 STK), while on the PCUSTUCOE represents a PCU - STK conversion (How many STK in 1 PCU). Therefore, instead of simply using [F:ITM]PCUSTUCOE(0), you will need to change it to 1/[F:ITM]PCUSTUCOE(0)

    I hope this helps.