Sales Order Modification Alert

[Former Member]

Hi Experts,

I was wondering if there is a way in SAP to create an alert any time a sales order has been changed or updated.

Example: If someone in our sales department updates the quantity of an item in a sales order an alert will be sent out to selected individuals. Another example would be if they change the ship date of the sales order and alert would be triggered.

[Former Member]

Hi,

You may create an alert in scheduled time in B1. If you want the alert created whenever the update has be done, addon such as B1up is needed.

Thanks,

Gordon

[kothandaraman_nagarajan]

Hi,

Try:

SELECT  T0.[DocNum], T1.[Quantity] as 'Current Quantity', max(T2.[Quantity]) as 'Previous Quantity',T3.[UpdateDate] FROM ORDR T0  INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry LEFT JOIN ADO1 T2 ON T2.DOCENTRY = T1.DOCENTRY and T1.LineNum = T2.LineNum and T2.Objtype = T1.Objtype  left JOIN ADOC T3 ON T2.DocEntry = T3.DocEntry WHERE T1.[Quantity] <> T2.[Quantity] AND DATEDIFF(DD, T3.[UpdateDate], GETDATE()) = 0 and  T0.[DocStatus] = 'o'

group by T0.[DocNum], T1.[Quantity],T3.[UpdateDate]

order by T0.[DocNum]

Thanks & Regards,

Nagarajan

[Former Member]

Hi,

Try this:

Select T0.DocNum, T0.DocDate, T0.CardName From ORDR T0 Where T0.DocStatus='O' And T0.UpdateDate >= Getdate()

Thanks,

Joseph

[Former Member]

Hello Mike,

This is possible in various ways. One approach is to use the change document tables CDHDR CDPOS, another the change pointers of the business object or also to create a "simple" workflow based on change event for the business object and send a mail/sapoffice message and so on...

Each method has pros and cons that should be analysed with the business.

If you look for more details let us know, but here you have the starting point.

Alexandre

[Former Member]

Sorry, was on a mobile device and just saw it is in B1 solutions .... let me know if this does work like in ECC, at least I will learn something from my mistake !

[Former Member]

Hi Alexandre

can you provide me with some information on how I can get this setup?

[Former Member]

It wont   Cheers

[Former Member]

Hello Mike,

Just replying to say that my answer missed totally the target (mea culpa) as I mistook your Business One post with a SAP ERP SD post...Need to get better eyes

Alexandre