Skip to Content
0
May 29, 2020 at 06:48 PM

Period Shift when using LPA

389 Views

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?

Attachments

example-1.jpg (40.3 kB)
example-2.jpg (47.1 kB)