Remote Query Execution in Intercompany Solution

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:

  1. Create a query using the Query Generator or Query Wizard (refer to the SAP Business One Online Help) and save it.
  2. Open the Query Manager from Tools ->Queries ->Query Manager. 
  3. 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.

  1. In Query Manager window following options are provided:
    1. Local: runs the query on the local company as per standard SAP Business One functionality.
    2. All: runs the query on all branch companies
    3. 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.

  1. To display the data, choose Refresh.

 Note

  1. 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.

This format is easy to read and process, making it suitable for sharing data between different systems or for further analysis.

  1. The user can use the Copy to Clipboard button to paste the report data into different applications.

    • Related Articles

    • Intercompany Integration Solution for SAP Business One

      Growing organizations that control more than one legal business entity are sometimes faced with the challenge of how to share data between partner companies.  The Intercompany Integration Solution for SAP Business One enables businesses running SAP ...

    • User Defined Query Replication in Intercompany Solution

      The SAP Business One provides the Query Generator / Query Wizard Tools to generate adhoc reports via user queries. The User Defined Query Replication feature replicates the user defined queries to one or multiple branch companies based on the ...

    • Copy Intercompany Setups

      The Copy Intercompany Setups feature allows user to copy a branch company’s setup data from one branch company to one or multiple branch companies.  This saves the user from login in each branch database and perform the setup steps individually, ...

    • Prerequisites for Intercompany Integration Solution

      Before you can perform, interbranch transactions, all required installations and setups must be completed in all branch companies.  All master data records (except item master data, business partner master data, and bill of materials) replicated by ...

    • Consolidation-Automation Setup of Intercompany Solution

      Note This setup is only available in the consolidation company. This window enables you to automate the consolidation process. After automatic setup, the system automatically exports the financial data from the branch companies and imports the same ...