on 06-30-2013 4:08 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.