How to handle multi-user doing data entry

Hi, How do I modify/implement the piece of codes dealing with the no. series that would enable multi-user doing data entry on the Vendor card at the same time without any conflicts/errors? How does the codes look like? Has anyone done that before? Thanks in advance. Sincerely, Sylvia Tsang Management Software Solutions, Inc. stsang@mgmtsoftware.com

Sylvia, Try to apply discretionary “Series Number” access for each of users working at the same time. You can do it via “Security Filters” in a way as follows:

Object Type = Table Data
Object ID = 308 (No. Series)
Security Filter = No. Series: Code=VEND01

Regards, Yuri Pokusaev IBS, Senior Consultant NCPS, NCSD ypokusaev@yahoo.com +7(095)967-8080

Where is the Security Filters located at? Do I need to modify any code on the “OnInsert Trigger”? Sincerely, Sylvia Tsang Management Software Solutions, Inc. stsang@mgmtsoftware.com

In the OnInsert trigger code of the vendor table make sure that the code getting the vendor no. (calling the series no. code) is at the end of the process.It’s the only thing really needed for having no conflicts. Alfonso Pertierra (Spain)apertierra@teleline.es

Just from looking at the code (and never having used/needed it) the easiest should be to do one simple modification in CU396: As the first line in procedure GetNextNo you can add a “Locktable” statement. This makes it impossible that the same number will be given to two clients at the same time. With best regards from Switzerland Marcus Fabian

quote:


Where is the Security Filters located at? Do I need to modify any code on the “OnInsert Trigger”?


You will not modify C/AL code in your database. The method is in separating of users working at the same time. You will apply approved number series filter to each of them. These filters should not be cross-cut. “Security Filters” functionality is working on SQL Server option only. Follow the scenario below to apply it (Tools → Security → Roles): 1. Modify existing user roles permissions to exclude “No. Series” table from access control list. 2. Create some new “series access” roles with parameters defined as follows: Table Data,308,No. Series,Yes,Yes,Yes,Yes,Yes, No. Series: Code=VEND01 The statement ‘No. Series: Code=VEND01’ is a filter. You can create as many “series access” roles as you want. Be careful to permit all series numbers required (including other modules). 3. The last step is assigning roles to user logins. Regards, Yuri Pokusaev IBS, Senior Consultant NCPS, NCSD ypokusaev@yahoo.com +7(095)967-8080