Minimum order quantity in DP

[Former Member]

Hi Gurus,

Please help me with this issue..

We have only DP in APO and there are many SKUs with Min Order Qty(MOQ)..In DP when a planner enters the forecast in the planning book, is it possible for the system to popup a warning when the MOQ is not adhered..Example say the MOQ is 15 and if the planner enters a forecast of 8 units it should warn to add 7 more..

MOQ is a navigation attribute for the char 'Product'..may be a macro will do but how to?

[Former Member]

Hi,

You can write a default macro to get the warning to the user. Use the function MATLOC() to fetch the MOQ quantity from location-product. Write the macro in such a way that, it will throw warning when the quantity entered is less then MOQ maintained in the location product.

Thanks

Kishor

[Former Member]

Thanks  but we only use DP in APO and no loc products. The MD & TD comes to APO only via BW.

MOQ is an NAV for Product in the current setup and the problem is we are unable to fetch the value using the macro function(above said)//tried a few times but no luck..so how to get this nav value into the macro, compare and pop-up the message. and cant use KF for MOQ.

I guess your advise works if loc products are used by fetching the min lot size from loc prod by the macro fn

[Former Member]

Hi, Use the function to fetch navigation attribute value in the macro.

ACT_IOBJNM_VALUE()- ACT_IOBJNM_VALUE( 'IOBJNM'; <GRID2> ) returns the value of the InfoObject that is currently being planned. GRID2is an optional parameter. If you specify this parameter, the value of the specified InfoObject in the second grid at the time of the calculation is returned.

Functions for InfoObjects and Planning Folders - Operators and Functions in Macros - SAP Library

regards

Kishor

[Former Member]

Hi SAP APO 50,

you can use SAP MACROs to do such calcuations.

what I can suggest is to have a key figure, called MOQ, maintain the quantities in that.

ANd Forecast Key figure saperate....

design to run the Macro in background and give warnings/errors or run in foreground with a button in data view, so that user can see a pop up...

Read more about Macros in Forum, please look for solutions before posting anything.

Thanks,

Regards,

Sandeep

[Former Member]

Your KF solution does not cater for the situation and we already know a macro function act_iobjnm_value but do not know how to get the nav atr value properly..

Your comment 'Read more about Macros in Forum, please look for solutions before posting anything' <<this comment we find very immature and you better refrain writing such senseless advise>>

Friends..we are looking for an expert /specific advise for our issue through the SCN..so please no frivolous comments.