Send an alert when the BOM changed

[Former Member]

Hi All,

Is there any solution for send an email when the user have changed BOM in the SAP b1 ?

Thanks,

TuanAnh

[kothandaraman_nagarajan · Accepted solution]

Hi,

Do you need an email or alert within SAP B1?

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Hi Nagarajan, I need an email

[kothandaraman_nagarajan · Accepted solution]

Hi,

There is no automatic email function to send change made in BOM. You have to create query, query layout and then you have to schedule and email to user.

Use below query:

SELECT T0.[Code], T0.[TreeType], T0.[UpdateDate], T1.[U_NAME] FROM OITT T0  INNER JOIN OUSR T1 ON T0.UserSign2 = T1.USERID WHERE datediff(dd, T0.[UpdateDate],getdate()) <=0

For scheduling and emailing refer below link:

http://scn.sap.com/community/business-one/reporting-and-printing/blog/2013/06/01/how-to-schedule-rep...

Thanks & Regards,

Nagarajan

[former_member203899]

Hi,

Create Query with using Query Generator.

SELECT Code As ProductNo, Project as ProjectCode,

CASE

WHEN TreeType = 'P' THEN 'Production'

WHEN TreeType = 'S' THEN 'Sales'

WHEN TreeType = 'T' THEN 'Template'

WHEN TreeType = 'A' THEN 'Assembly'

ELSE ''

END AS 'BOMType',

CreateDate as BOMDate from OITT WHERE UpdateDate > (GETDATE()-1) AND UpdateDate< GETDATE() order by UpdateDate Desc

Just use above query and define to Alert Management.

It will satisfy your requirement.

Regards,

Nishit Makadia