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%%'