How to display my FOX formula result on the layout

[Former Member]

Hi Guru's,

I have created one Fox Formula for OTB using the given below calculation

Planned Open-To-Buy (Retail Price) = Sales / Retail Value + Last Planned Stock (Retail Value) - Open Purchase Orders (Retail Value with Tax) - GR Posting Date / Vendor RtlT + Promotion Sales / Retail .

When I am executing my Planning function (using BPS0) then it is working fine. It is showing the correct OTB value.

I have insterted this FOX function into my layout using UPSPM tcode. When I execute the OTB calc function from UPSPM then correct data gets saved into my real-time cube. However OTB data is not getting displayed on my layout.

Is there something else which I am supposed to do to display the result on the final layout ?

Thanks,

Ashu gupta.

[Former Member]

Hii Guys,

Thanks a lot for your inputs. My issue has been resolved. I was not able to get the FOX formula output on the layout as the formula was not giving unique record. I have removed version char from my level and flds for selection. Now everything is working fine.

Thanka again for your valuable time.

[Former Member]

Hi...also...you can input the below command in FOX

Message I001(UPF) with 'your result'

This will throw you the system message on your WAD.

[Former Member]

It is possible that that the key figure that gets populated wuit the FOX is not in the layout. Check this out.

Ravi Thothadri

[Former Member]

Hi,

Is the function and layout on the same planning level. Please check if there's anything different on them.

thanks

[Former Member]

Hi Ashu,

1) Check whether the planning folder layout is same is BPS0 layout.

2) Check using refersh button.

Are you able to see the data when you Exit and login again into the transaction.