For Create Functions

Point 1. Function name should be follow this pattern: appcode+List+Tablename

Point 2. ID’s fields should be come on top in SQL.

Point 3. All fields of parent table must be available in function.

Point 4. Description of code type fields should be lookup from codewords table.

Point 5. Check & verify all fields which are used in joins and where conditions should be applied indexes in respective tables.

Indexes

Point 6. Check & verify Function's query do not take more time in execution.

Point 7. Key field of filter must be available in function which is available in applifilter of views which are based on created function.

Point 8. Include foreign key column in query instead of PK.

Eg: AccvouchItem.GlaccountID instead of Glaccount.GlaccountID.

Point 9. Assigned Require permission to roles: Goto properties and click on Search and select roles by clicking on Browse option & assigned select permission for selected roles.