Remote Query Execution in Intercompany Solution
SAP Business One provides the Query Generator / Query Wizard Tools to generate adhoc reports via user queries. The Remote Query Execution feature extends these adhoc reports by providing the ability to execute them remotely on one or multiple branch companies.
To run the Remote Query Execution process:
- Create a query using the Query Generator or Query Wizard (refer to the SAP Business One Online Help) and save it.
- Open the Query Manager from Tools ->Queries ->Query Manager.
- Select the query created in step 1, or a standard SAP Business One query from the System category.
Note
To use the Remote Query Execution feature, you must save the system queries with a new name. Ensure that the field alias does not contain spaces or any special characters.
- In Query Manager window following options are provided:
- Local: runs the query on the local company as per standard SAP Business One functionality.
- All: runs the query on all branch companies
- Selection: Selecting this will open a new window that contains the list of branch companies. You can select the branch codes in which the query needs to be run.
Note
The preceding options are only available for a user if the Can Use Remote Query Execution checkbox is selected in the Users – setup window.
To open the Users – setup window, in the SAP Business One Main Menu, choose Administration->Setup ->General ->Users
Select one of the options and choose Ok. If Local mode was selected, the standard SAP Business One results window is displayed. Otherwise, the Remote Query Execution window is displayed.
- To display the data, choose Refresh.
Note
- The user can export the report data to CSV using the Export to CSV button in all the intercompany reports. When Intercompany reports are exported in CSV format, the data is typically structured in a plain text file with values separated by commas.