Quote from Administrator on May 29, 2020, 9:28 am

Here is a query that might help you if you ever need to pull data from one SAP Business One database or more into a single report. Keep in mind, the database names are hard coded in this report. Therefore, you will need to change my database names to your exact database names. I am also limiting each database to include only 20 items. The possibilities are endless, combined with the Fiori Cockpit and Pervasive Analytics, being able to easily pull data from multiple SAP Business One databases into a single query, then turn that query into a dashboard is really really cool!

Extra Pizzazz - To further enhance this report, I also created a Boyum Universal Function "SQL Report" with a clasping first column.

SELECT TOP 20 'SBODEMOUS_SW' "Database", T0."ItemCode", T0."ItemName", T0."OnHand", T0."IsCommited", T0."OnOrder" FROM "SBODEMOUS_SW"."OITM"  T0 WHERE T0."OnHand" +  T0."IsCommited"  +  T0."OnOrder" > 0
UNION
SELECT TOP 20 'SBODEMOUS_SE' "Database", T0."ItemCode", T0."ItemName", T0."OnHand", T0."IsCommited", T0."OnOrder" FROM "SBODEMOUS_SE"."OITM"  T0 WHERE T0."OnHand" +  T0."IsCommited"  +  T0."OnOrder" > 0
UNION
SELECT TOP 20 'SBODEMOFR' "Database", T0."ItemCode", T0."ItemName", T0."OnHand", T0."IsCommited", T0."OnOrder" FROM "SBODEMOFR"."OITM"  T0 WHERE T0."OnHand" +  T0."IsCommited"  +  T0."OnOrder" > 0
UNION
SELECT TOP 20 'SBODEMOUS_NW' "Database", T0."ItemCode", T0."ItemName", T0."OnHand", T0."IsCommited", T0."OnOrder" FROM "SBODEMOUS_NW"."OITM"  T0 WHERE T0."OnHand" +  T0."IsCommited"  +  T0."OnOrder" > 0
UNION
SELECT TOP 20 'SBODEMOUS_MW' "Database", T0."ItemCode", T0."ItemName", T0."OnHand", T0."IsCommited", T0."OnOrder" FROM "SBODEMOUS_MW"."OITM"  T0 WHERE T0."OnHand" +  T0."IsCommited"  +  T0."OnOrder" > 0
UNION
SELECT TOP 20 'SBODEMOCA_CAN1' "Database", T0."ItemCode", T0."ItemName", T0."OnHand", T0."IsCommited", T0."OnOrder" FROM "SBODEMOCA_CAN1"."OITM"  T0 WHERE T0."OnHand" +  T0."IsCommited"  +  T0."OnOrder" > 0
UNION
SELECT TOP 20 'SBODEMOCA_2' "Database", T0."ItemCode", T0."ItemName", T0."OnHand", T0."IsCommited", T0."OnOrder" FROM "SBODEMOCA_2"."OITM"  T0 WHERE T0."OnHand" +  T0."IsCommited"  +  T0."OnOrder" > 0
UNION
SELECT TOP 20 'SBODEMOBEAS' "Database", T0."ItemCode", T0."ItemName", T0."OnHand", T0."IsCommited", T0."OnOrder" FROM "SBODEMOBEAS"."OITM"  T0 WHERE T0."OnHand" +  T0."IsCommited"  +  T0."OnOrder" > 0
UNION
SELECT TOP 20 'SBODEMOUSAPS' "Database", T0."ItemCode", T0."ItemName", T0."OnHand", T0."IsCommited", T0."OnOrder" FROM "SBODEMOUSAPS"."OITM"  T0 WHERE T0."OnHand" +  T0."IsCommited"  +  T0."OnOrder" > 0