Showing posts with the label Alert QueryShow All
User query for alert in SAP B1 SAP Business One

User query for alert in SAP B1

Er Tasneem Ahmad Karimi Saturday, January 20, 2024

Creating a right alert without duplicated lines SELECT T2.WhsCode,  T1.AcctCode,  T1.CurrTotal,  SUM(T2.OnHand) AS 'On Hand'  FROM dbo.OWHS T0 INNER JOIN dbo.OACT T1 ON T0.BalInvntAc = T1.A…

How To Get Login User Code in SAP B1 Query Manager SAP Business One

How To Get Login User Code in SAP B1 Query Manager

Er Tasneem Ahmad Karimi Wednesday, October 26, 2022

For getting a username or User code who is login into the system we can take help from the below queries Hana : SELECT T0.”USER_CODE” FROM “OUSR” T0 WHERE T0.”USERID” = $[USER] SQL : SELECT T0.USER_C…

SAP Business one Alert and Other Report Query Examples SAP Business One

SAP Business one Alert and Other Report Query Examples

Er Tasneem Ahmad Karimi Saturday, March 21, 2020

Following are the query which is use to get some standard report data from SAP Business  ------------------------------------------ ------------------------------------------ /* Sales Invoice A…