APO Demand Planning

[Former Member]

Hi all,

Iam creating Macros in Demand Planning.

I need to create a macro on Final Demand Forecast.

Logic: If value is > 0, convert to pack quantity

Default macro, not directly executable.

Example

P 10/2007

Final Demand Forecast before conversion = 300

Pack Quantity = 1500

Final Demand Forecast after conversion = 1500

Final Demand Forecast before conversion = 1501

Pack Quantity = 1500

Final Demand Forecast after conversion = 3000

The converted Pack Quantity will be called as Final demand forecast after conversion.

pl give me the steps to create this macro in screen.

thanks

Phani

[Former Member]

Hi Phani,

I quite did not understand the logic that you want to implement in the Macro. Can you give some more clarity on the logic that you are looking for.

Best Regards

Raghu.

[srinivas_krishnamoorthy]

You can use the TRUNC() function for this.

Packed Quantity = 1500 x ( TRUNC(Final Dem before conversion/1500)+1 )

This should work.

[Former Member]

Srinivas,

Thanks for your early reply.

But i have given example to you.If for a particular period if the pack quantity changes to 2000 it should take that value and calculate automatically.

Please give me the elaborate answer related to macro screen.

[srinivas_krishnamoorthy]

Actually I meant

Final Demand after conversion = Packed Quantity Lot Size x ( TRUNC(Final Dem before conversion/Packed Quantity Lot Size)+1 )

TRUNC basically takes the integer part of the calulation. So TRUNC(1501/1500) = 1 and similarly TRUNC(900/1500) = 0. That is the reason 1 is added in the end and the sum is multiplied back with the Lot Size

[Former Member]

Srinivas Krishna Moorthy,

sorry for the late reply.

yours suggestions helped me a lot.

thanks for your help.

Edited by: phani kumar gudipati on Jan 3, 2008 9:11 AM