Stock Reached Minimum Level Want Remainder

[Former Member]

HI Experts,

     I am using sap b1 9.0 PL 0. I want to know in detail about the Inventory Module.In that i want the remainder when my stock is getting to  minimum level then i want the remainder or intimation in my system.Please help me out.

Thanking you,

Ganeshkumar.J

[Former Member · Accepted solution]

Hi

First enter minimum quantity on item master.

then Go to Administration->Alert Management->Minimum Stock Deviation

Active this alert .

and check this

Stock Deviation Minimum Alert | SCN

Thanks

Mohammad Imran

[Former Member · Accepted solution]

can u send me the query for minimum stock deviation.

[Former Member · Accepted solution]

HI,

In the Admin ->alert management  there is no minimum stock deviation for this there is an option like Query is there.

Thanks

Ganeshkumar J

[Former Member · Accepted solution]

Hi Kumar,

                     you no need to use any query. it is SAP B1 Standard Alert.

Thanks

Mohammad Imran

[Former Member · Accepted solution]

Hi Kumar,

Go to find mode and press * and enter.

Thanks

Mohammad Imran

[Former Member · Accepted solution]

hi imran,

in that standard alerts there is no option for "minimum stock deviation" in alert management

Thanks

Ganesh

[kothandaraman_nagarajan]

Hi,

Did you find option for "minimum stock deviation" in alert management?

Thanks & Regards,

Nagarajan

[Former Member]

HI,

Ya i got that one but it is not been activated.

Thanks

Gnaeshkumar J

[Former Member]

Hi,

Actually i want when the stock reached minimum level then we need to get the remainder or intimation fro the system.

I want in detail about this question. i gone through google also  but i m not getting correct solution for this.

Thanks,

Ganeshkumar J

[Former Member]

Hi

have you checked my post and links ?

Thanks

Mohammad Imran

[Former Member]

Hi Imran,

I gone through your links and all but senior consultant is asking sql query for the new alert message.

[Former Member]

Hi Kumar

Check this one

Thanks

Mohammad Imran

[kothandaraman_nagarajan]

Hi,

What is your requirement (condition) to trigger an alert?

Thanks & Regards,

Nagarajan

[Former Member]

Hi,

if the stock reaches minimum i need a reminder or alert message.this is the requirement.

Alert: minimum stock deviation

Thanks

ganesh

[Former Member]

Hi Kumar,

SELECT     OITW.ItemCode, oitm.itemname, oitw.whscode, OITW.OnHand, OITW.ONORDER as SupplierPO,

oitw.iscommited as CustomerOrder, OITW.MinStock,

((OITW.OnHand + oitw.onorder) - (oitw.iscommited + OITW.MinStock )) as CurStockStatus

FROM         OITW INNER JOIN

OITM ON OITW.ItemCode = OITM.ItemCode

WHERE     ((OITW.MinStock IS NOT NULL) AND (OITW.MinStock <> 0))

AND ((OITW.OnHand + oitw.onorder) - (oitw.iscommited + OITW.MinStock )) < OITW.MinStock

and oitm.frozenfor <> 'Y'

Thanks

Mohammad Imran

[kothandaraman_nagarajan]

Hi,

Please check threads:

Thanks & Regards,

Nagarajan

[kothandaraman_nagarajan]

Hi,

No need of query. This is predefined alert set by SAP.

Did you check above SAP help file?

Thanks & Regards,

Nagarajan

[kothandaraman_nagarajan]

Hi,

Please check SAP help file for detailed information.

http://help.sap.com/saphelp_sbo900/helpdata/en/45/06daa8d8696c30e10000000a114a6b/content.htm

Thanks & Regards,

Nagarajan