cancel
Showing results for 
Search instead for 
Did you mean: 

Target Days Suply in Planning book

Former Member
0 Kudos

Hi,

I have requirement to enter difernet TDS for different periods in planning book.

FOr this purpose i have chosen 1 in Product master for Target stock level method.

I have also deactiavted the macro for calculating the TDS from location product master.

Now it allows me to enter the TDS in planning book but when i save it it disaapears.

Can you let me know how to solve this issue.

Thanks

R

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Instead of deactivating the TDS macro, update the macro so that you can manually enter the values in the planning book.

Currently the macros for TDS has the following formula.

TARGET_DAYS( ACT_PRODUCT ; ACT_LOCATION ; ACT_VERSION ; 0 )     

You need to replace 0 with the key figure in which you want to enter the "target days of supply" value. So add a time series key figure in  your planning area and include that in the formula. Then you will see the values in the TDS Keyfigure.

So the macro for TDS should look like

TARGET_DAYS( ACT_PRODUCT ; ACT_LOCATION ; ACT_VERSION ; )

Row: ZTimeseriesKeyfigure

where Row:zTimeseriesKeyfigure is your Z key figure where you will be entering the value for TDS.

Regards,

Mitesh 


Answers (0)