I have a client who really wants to see Projected BOH (Beginning on Hand) to go along with Projected EOH (Ending on Hand)
Proj EOH works great - LPA does exactly what it is suppose to do when moving up from the BPL of WKPRODLOC to CalWk and to Month.
To try and provide a BOH KF - I attempted to use the period_shift. but when it hits the 2 TechWeeks into 1 CalWk - it is sideways. And it goes even worse at the month level.
EOH Config
ZPRJEOH@REQUEST = SUM("ZPRJEOH@WKPRODLOCNOPER")
ZPRJEOH@WKPRODLOCNOPER = IBP_LPA("ZPRJEOH@WKPRODLOC")
ZPRJEOH@WKPRODLOC = IBP_CAGGR("ZPRJINPUTS@WKPRODLOC", ''SUM'',''FORWARD'',''CURRENTFUTURE'')
BOH Config
ZPROJBOH@REQUEST = SUM("ZPROJBOH@WKPRODLOCNOPER")
ZPROJBOH@WKPRODLOCNOPER= IBP_LPA("ZPROJBOH"@WKPRODLOC")
ZPROJBOH@WKPRODLOC = IBP_PERIODSHIFT("ZPRJEOH@WKPRODLOC",1)
So it is making sense why it is doing it, I am just wondering if there is a way around it and how to deal with the problem.
Thoughts?

