Skip to Content
0
Former Member
Nov 07, 2016 at 04:34 PM

SAP B1 Alert Query when an international sales order is added

649 Views Last edit Nov 07, 2016 at 04:56 PM 2 rev

Our transport department has asked if it's possible to receive some form of alert when a sales order going outside of the UK is added onto SAP B1.

Looking back at the previous international sales order in B1, the only way to distinguish them is the currency is something other than GBP.

I have made a simply query which I have assigned to an alert which flags up all sales orders where the currency is NOT gbp, but this flags up every time I log into SAP showing all historical orders which are not gbp, I only really want to see new ones which have been added.

Is there a better way to do this?

SELECT T0.[DocCur], T0.[DocNum], T0.[DocType], T0.[CardCode], T0.[CardName], T0.[DocDate]

FROM ORDR T0

WHERE T0.[DocCur] NOT Like '%%gbp%%'