To Develop a Filter that is able to filter the items that are sent to the mobile clients based on the ItemGroup and on The Branch.

Suggestion: To Develop a Filter that is able to filter the items that are sent to the mobile clients based on the ItemGroup and on The Branch.

Objective: To Reduce the Amount of Data and Increase the Performance of the Mobile Client Applications.

Reason: since the introduction of SAP Business One Multi-Branch, it became simpler for the smaller economic groups to have consolidated information for sales, puchasing and accounting without the need to integrate data from different databases (which is usually a challenge to guarantee the perfect synchronization of data between these databases)

For this example, the Pommer & Barbosa Group that acts in Retail and Wholesale in two different segments, that are Jewllery and Toys. This company has 13 branches and 70.000 items in the masterdata. In the following example, such a filter would reduce the amount of data that are pushed to the mobile devices significantly (tables OITM, ITM1, OITW would have significant reductions) we estimate a reduction of 40-60% of data, depending on the branch. This would have benefits on the performance and would significantly reduce the synchronization time of the mobile client apps.

Example of how it would work: In the table OBPL (branches from SAP) a new UDF would be created (NVARCHAR(255) called U_COR_ItmsGrpCod). This field would contain the codes of the selected itemgroups that belong to that specific branch (example: 1,2,5). If the filter is active at the moment of querying the data for the synchronization, the following filter would be relevant (WHERE [OITM].[ItmsGrpCod] IN (1,2,5)), as in the following example:

DECLARE @BPLId INT = 1;
SELECT * FROM [OITM] WHERE [OITM].[ItmsGrpCod] IN (SELECT [U_COR_ItmsGrpCod] FROM [OBPL] WHERE [BPLId] = @BPLId);

In SAP Business One Multibranch, there is a tabled called USR6 that contains the branches, for which the user has access that is already being considered in the development of other filters by Coresystems.

https://helpdesk.coresystems.ch/hc/en-us/community/posts/211769545-Data-filtering-for-the-user-based-on-the-branchs-allowed-for-the-user-in-SAP-Business-One- 

 

 

1

Comments

1 comment

Please sign in to leave a comment.

Didn't find what you were looking for?

New post