Inventory management

[Former Member]

Hi Experts,

We are looking for a way to refine our inventory management in SAP business one.Is it possible to configure the system in such a way that when items which are being ordered more are getting depleted in warehouse.A trigger/Email to person who manages the inventory that available quantity of a particular item is less and needs to be ordered.

Any inputs are welcome.

Thanks,

Anjana Rao

[kothandaraman_nagarajan · Accepted solution]

Hi,

Have you checked standard alert from system for Minimum Stock Deviation under Alert management?

Thanks

[Former Member · Accepted solution]

I tried to set this Alert for email but i am not getting any external email,i can see alerts in SAP... what could be the reason we have outlook integration ON and we can send emails through outlook...what could be the reason the emails are not populating in my outlook mail box?

[Former Member · Accepted solution]

Hi,

You need SBO Mailer to trigger mail based on query alert.

Thanks,

Harshal

[kothandaraman_nagarajan · Accepted solution]

Have you defined email for user under user setup?

[Former Member · Accepted solution]

oh did you mean... with outlook integration Add-On i cant get the mail Alerts?Thank you for your help

[kothandaraman_nagarajan · Accepted solution]

Still you can get alert. Please try.

[Former Member · Accepted solution]

Nagarajan thanks for your response... yes i am getting an alert in SAP.. but was trying if i can get to my email.. we use outlook integration Add-on to send external emails.. thanks for your help.

[kothandaraman_nagarajan · Accepted solution]

Yes, you can receive alert to your email, provided you have added your email under your user ID.

[Former Member · Accepted solution]

Yes i have my user id and email in defaults added thank you... but still email is not getting triggered what could be the reason

[kothandaraman_nagarajan · Accepted solution]

Check under services, SAP Business One Messaging service running or not.

[frank_wang6 · Accepted solution]

If the message service is running, then u need to check windows application log and see if there is any error there to tell email failed.

Most likely, your sap message service is not configured correctly.

Frank

[Former Member · Accepted solution]

Hi,

With Outlook it will not trigger an auto mail from alert. You need SBO Mailer.

Thanks,

Harshal

[Former Member · Accepted solution]

Nagarajan.. I am using outlook integration not SBO mailer service..

If email alerts can not be sent using outlook integration then its of no use to us.. thanks for all  help

[former_member198649]

Dear Anjana,

Use MRP. It is there for exactly what you want. Else you can also Alerts Management with query.

[Former Member]

Hi Tariq,thanks for your response. but we don't use MRP as we can not predict the forecast nor can we set the minimum quantity as the top item last month might not have a single order this month...

[Former Member]

Forecast is not mandatory for MRP..

You can use inventory levels and sales orders as source.

Check out:

[Former Member]

Hi Anjana,

You can set Minimum Inventory for each Item in Item Master under Inventory Data tab.

If "Manage inventory by warehouse" is Ticked then you can set Minimum Inventory for each warehouse.

Due to this whenever the stock comes to this level (Minimum set level) then system throws an error to user.

You can also set Alert/Mail based on this also.

Let me know if you need more information.

Thanks,

Harshal

[Former Member]

Thanks both of you... give me idea as to how can i come up with a number that can be set as minimum for an item.. can i assume average sale of item in last 3 months would be a good idea?

if i am looking at average sales-Do you think its better to look at number of items that were invoiced?

Can i have a query that gives me last 3 months total of items sold and average in last 3 months..

Thanks

[Former Member]

Hi Anjana,

Try below query for Sales Quantity for each month.

Declare @fromdate as datetime

Declare @Todate as datetime

set @fromdate = /* select min(Ta.[docDate]) from inv1 ta where Ta.[docDate] >= */ [%0]

set @Todate = /* select max(Tb.[docDate]) from inv1 tb where Tb.[docDate] <= */ [%1]

SELECT [C] Customername,

       P.Itemcode,

       [6] [jun],

       [7] [jul],

       [8] [aug],

       [9] [sep],

       [10] [oct],

       [11] [nov],

       [12] [dec],

       [1] [jan],

       [2] [feb],

       [3] [mar],

       [4] [apr],

       [5] [may]

from

(SELECT T1.itemcode, t2.cardname as C, t1.quantity Volume, month(T1.[docDate]) as month

FROM INV1 T1 INNER JOIN OINV T2 ON T1.docentry = T2.docentry

WHERE T1.[docDate] between @fromdate and @todate

UNION

SELECT T1.itemcode, t2.cardname as C, -t1.quantity Volume, month(T1.[docDate]) as month

FROM RIN1 T1 INNER JOIN ORIN T2 ON T1.docentry = T2.docentry

WHERE T1.[docDate] between @fromdate and @todate

) S

Pivot

(sum([volume]) For Month IN ([1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12])) P

Thanks,

Harshal

[Former Member]

Hi,

You can also run Sales Analysis report to get last 3 months data.

Thanks,

Harshal

[Former Member]

Hi Anjana,

You can set an alert to the concerned user when the depletion of the stock in the inventory.

Hope this is the better solution, if not let me know.

Thank You