Difference between revisions of "SQL View"
From eStream Software
|Line 38:||Line 38:|
:8. Key-in the '''branch code''' (
:8. Key-in the '''branch code''' (from Maintain Branch), eg. KL-BRANCH.
Revision as of 07:40, 24 September 2019
- SQL View is one of the powerful advance security module to SQL Payroll to limit your employees access and process payroll by designated grouping.
- For example, KL HR manager can view and handle the KL branch employees only. However, the Penang HR staff will allow to view and handle Penang branch employees only.
1. All branches
2. Branch KL (KL HR Manager View)
3. Branch Penang (Penang HR Staff View)
Menu: Tools | DIY | Maintain DIY...
- 4. At View Template form, key-in description (eg. KL).
- 5. At Filter tab, add the condition by press the button to add a new condition.