Framework Enhancement_5.4.0.0

1. Record Limit

In Vienna Advantage, we have an option to set the Limit on the Records to be added in Tab. By using this option System Admin can limit the no. of records for a window/tab.  

For example: If admin set the limit to 3 for order line window than user cannot add more than three order line record/item. After 3^rd item "Add New record" Button  will be disabled, if order line item has 3 or more item existing already, in this case as well "New Record" will be disabled. Below is the more detail on this. 

Steps 1 

How  to configure the functionality: 

• Login with System Administrator role. Open the screen configuration window.  

• Select the window from header tab in which user want to set the limit then Move to the "Tab"  and select target tab. 

• New field "Record Limit" is introduced as can see in the below pic  

Open

• Enter the limit "for example. 3" and save the record. 

Open

Step 2  

How we can use on window: 

• Login with your User/Role. 

• Open the target screen and select the tab (In our case we set this on Window : Sales Order / Tab: Order Line. 

• Add the 3 new record. 

 If the record limit is match with the mention limit than the "New Record"  Button will be Disabled/Read only. 

Note: The applied limit will be working from Add New Icon on Tab toolbar and system will not check any applied record limit in case record is inserted from "Form" or "Processes" Or any fixed pop up screen like copy Line Record button. 

2. Auto New Record 

Provided a new checkbox Field named as "Auto New Record" on Tab Level.  

This feature enable to open the Tab in "Add New Mode" if there is no record exist in the Tab. 

It will works with combination of "Auto New Record" Checkbox in Preference Window, It means the target tab will open in Auto new mode either of the checkbox is true. 

Step 1 

How to configure the functionality: 

• Login with System Administrator role.  

• Open the screen configuration window.  

• Select the target window from header tab and then select the target Tab 

• Set "Auto New Record" checkbox to "True" 

• Save it. 

Step 2  

How we can use on window: 

(Here we assume the Auto New Record set to True on "Order Line" child Tab on Sales Order Window) 

• Login with your User/Role. 

• Open the target screen and add the new record on parent tab. 

• Move to Order Line child tab  

• Automatically new record Should be Appear while click on tab as show in below pic. 

3. Tab Switch 

In the release bring new option of move from current tab to any others Nth tab. To achieve this functionality in the system provide  

• New checkbox field "Action" on Column Tab (Window: Database Schema) and  

• New field "Tab Index" on Field Tab (Window: Screen Configuration) for define the tab index where to move 

Above added two new fields will work for Button Reference column. 

After define all the configuration user can use the button control as Tab Switch and user can directly move on Nth tab of the window from current tab.  

Step 1 

How to configure the functionality: 

• Login with System Administrator role.  

• Open the Data schema window.  

• Select the target "Table" from header tab and move to column tab. 

• Add a New column with the Reference "Button" and Action checkbox set to "True" for example in our case column name 'TabSwitch'. 

• Save it and click on the Synchronize button. 

Step 2 

• Login with System Administrator role.  

• Open the screen configuration window.  

• Select the window linked with table (used in step 1) from header tab and Move to the target "Tab". 

• After select the tab, click on the "Field" tab. 

• Add a new field with the created column (in our case it is 'TabSwitch' it may be different in your case) and enter the value in the "Tab Index" field. On which tab you want to move by press this button field.  

Note : Index number is always starts from zero.  

So,  

     For first tab we will use tab index 0 

     For second tab we will use tab index 1... 

     -------and so on-------------- 

     For Nth Tab we will use tab index as N-1. 

As in example below, we defined the tab index = 4, so on press this button field system will move to 5^th tab of the current window. 

Step 3 

How we can use on window: 

(Here for example purpose we define the setting on Product Window) 

• Login with your User/Role. 

• Open the target screen (in our case Product ) and select any record. 

In our example we defined Tab Switch button on Header tab and on click on this Tab Switch System will move directly to 5^th tab (BOM Component) of the current window. 

4. Introduced new Tabs (Table Index & Index Column) 

In Vienna Advantage we have introduce new Tabs by the name called Table Index and Index Column on Database Schema window.  By using this tab user can create and modify the Indexes on Tables.  

 How to create Indexes 

• Login with System Administrator role. Open the Database Schema window.  

• Select a table then Move to the Table Index Tab. 

Step 1.  Create Table Index 

• Name: This filed is use for define table index name. (should be start with table name as prefix followed by _)   

.e.g    c_bpartner_name  

• Description: Here user can add description for table index. 

• Comment: Here user can add comment for table index. 

• Unique: With this checkbox user can make the unique index. 

• Process Now: By clicking on this button table index will get created in DB (Firstly user need to add column in index column tab then). 

• Record Type: Here user can select the record type from dropdown. 

Case 1: If Unique checkbox is False 

It will only create non-unique index 

 Case 2: If Unique checkbox is True 

It will only create unique index 

Step 2.  Create Index Colum 

• Column: select a column for add in indexing. On adding multiple columns, Index will create with and condition on multiple columns. 

• Column SQL: This field is use to create function based index.  

  • For example if user want to create index with lower value then in column sql user can define LOWER('ColumnName'). In our case this is LOWER('NAME'). 

  • If user want to create index to store data in descending or ascending order, then user can use  ColumnName DESC  or ColumnName ASC. 

• Sequence: Here user can add sequence. Column used in Index as per defined sequence. 

After user added column into Index Column tab then user need to move Table Index tab and click on Process Now button and after clicking on this button index will be created in DB. 

Limitation: Only supported Add and Update Index, Drop Index is not supported. For drop any index, do directly from database. 

Note: Define Index in database only after consult with you DBA. 

5. Added New Product Pop-Up 

In this Release we have introduce new pop-up to add Product, with this user can add the product directly from pop-up. 

Steps 1 

Firstly user need to click on Add Product button from product field by click on three ellipses. 

Steps 2 

After clicking on Add product button new pop-up will display from where user can add product by clicking on OK button. 

6. Right Configurator

In this enhancement we have added a new feature on adding a new window in Right Group, its related processes and workflow & Forms will auto add in group processes, workflow & Form tab. For more details, click on Rights Configurator (Web View)

1. Creating a Group(Right Group Window): In system there is already a functionality to create a Group by adding multiple windows, processes , workflow etc. Now we enhanced here as you add a new window in the group system will add new its related process and workflow in group window under respective tab.  

2. After saving the Group, when we assign the Group to a Role, Role will have access to all component which were defined in the respective Group.  

Step 1

How it Works: 

1. Open "Right configurator" Form . 

2. Add the New User or choose any existing user. 

3. Add the New Role or choose the existing one. Assign the role to the selected user and click on save Button. 

Step 2  

4. Open "Right Group" window and add the new Group.

5. Click on  "Group window" tab and add the new Record 

• Select "Sales order" from the screen column and  

• Click on save. 

6. After adding  the  Record in Group window tab (Sales order), System will Add Sales order related Process, Workflow, Form in respective tabs. 

         Forms will be added on the respective tab. 

          Processes will be added on the respective tab. 

         Work Flow  will be added on the respective tab. 

Step 3

7. Open Right configurator Form  from the Menu and assign the same Group to the created Role and click on save. 

 Step 4 

8. After assigning  the Group to the Role, by default  system will set window Access, Process Access, Form Access and Work Flow Access  of that Group  on Role window. 

          Forms will be added on the respective tab. 

         Workflow will be added on the respective tab. 

         Processes will be added on the respective tab.