Skip to Content
0
Former Member
Sep 18, 2007 at 09:40 AM

How to display my FOX formula result on the layout

30 Views

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.