I have wriiten a few pi scripts, but I have not been able to select data from future requirements. All my scripts receive data from past records. I am trying to use forecast data and compare it to levels of inventory. I need the forecasted data to show up in the correct periods.

You can pass the period you need to the GET.PI.VALUE()
So I don't see why you can't find future data.....

Is this a macro?? Can you post an example?

just look in the help of tgeis0111m000

at the bottom you'll find the macros