WDF 2480004 - Support for replication of User-defined queries

The SAP Business One provides the Query Generator / Query Wizard Tools to generate adhoc reports via user queries.

This feature allows the user to replicate user-defined queries selectively across branch companies.

This feature is available only for a user having the "Can Replicated User Defined Query" 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

​

To replicate the User Defined Query, Go to Tools --> Queries --> Query Manager

Note: 

To view the query replication status, select the "Check Status" from the dropdown on Replicate button on the Query Manager window. See the screenshot above.

Solution

The enhancement described above has been incorporated in the Intercompany integration solutions version 48 and higher versions.

Product

Product or Product Version

B1 INTERCOMPANY INTEGRATION 2.0

SAP B1 10.0 FOR SAP HANA

SAP B1 9.3 FOR SAP HANA

SAP BUSINESS ONE 10.0

SAP BUSINESS ONE 9.3

This document refers to : 

WDF 2480001 - Overview Note for Intercompany integration solution 2.0 Version 48 for SAP Business One

• Related Articles

• WDF 2480003 - Support for the User Defined Tables (UDT) Structure replication

  This feature allows the user to replicate the User Defined Tables (UDT) Structure in head office, branch and template companies configured in the intercompany landscape. This will save the user time in creating the user-defined table structure in all ...

• WDF 2510013 - Supporting the SAP B1 “Support” user

  The Intercompany solution allows the login of the “Support” user without allocating the Intercompany license in the Intercompany Version 51. This user account allows partner support personnel to log on to the customer system without requiring an ...

• WDF 2480002 - Support for the User Defined Fields (UDF) Structure replication

  This feature allows the user to replicate the User Defined Fields (UDF) Structure across all participating companies. User can choose to replicate custom UDFs on item master data, business partner, and marketing documents supported by the document ...

• WDF 2470005 - Support for Users Master Replication

  This feature allows the user to replicate user master data across branch companies. Replicating user data allows the intercompany administrator to manage the user master data centrally in one company. To enable the user master data replication, the ...

• WDF 3062038 - BatchNumbers object in marketing documents supports replication of user defined fields

  Symptom BatchNumbers object in marketing documents supports replication of user defined fields. Solution You can now replicate the UDF information defined on BatchNumbers object in marketing documents. The changes described above has been ...