Difference between revisions of "Customization of Script"
Jump to navigation
Jump to search
(Created page with "== Introduction == SQL are flexible to allow user insert script to customize SQL Account / Payroll. Every business do have different requirement, so below is some example case...") |
|||
| Line 4: | Line 4: | ||
== SQL Account == | == SQL Account == | ||
=== Case 1 - Prompt Override Dialog If Document Not Using Transfer From/To === | === Case 1 - Prompt Override Dialog If Document Not Using Transfer From/To === | ||
| − | Goods Received | + | Goods Received: Prompt override when system detect goods received's item is not transfer from purchase order, save abort.<br> |
| − | Purchase Invoice | + | Purchase Invoice: Prompt override when system detect purchase invoice's item is not transfer from goods received OR purchase order, save abort.<br> |
| + | Required modules: Partial Delivery, DIY Field, DIY Script<br> | ||
| + | SQL Account version: 5.2019.877.783<br> | ||
Updated on : 09/12/2019 | Updated on : 09/12/2019 | ||
| − | '''Steps - | + | '''Steps - Create User Rights Field''' |
| + | # Click '''Tools | DIY | Maintain DIY''' | ||
| + | # Go to '''Field and Quick Form''' tab | ||
| + | # Right Click the '''User''' | ||
| + | # Select '''New Field''' | ||
| + | # Click '''New''' | ||
| + | # Enter any name (eg AddField) in the '''Description''' field (Only Alphanumeric & no spacing) | ||
| + | # Click '''+''' | ||
| + | # Add field as below | ||
| + | {| class="wikitable" | ||
| + | |- | ||
| + | ! Name !! Data Type !! Size !! Sub Size !! Null !! Description !! Default !! Display Format | ||
| + | |- | ||
| + | | AllowOverride || Boolean || 0 || 0 || True || AllowOverride || 0 || | ||
| + | |- | ||
| + | | Password || String || 10 || 0 || True || Password || || | ||
| + | |} | ||
| + | |||
| + | '''Steps - OnBeforeSave''' | ||
:01. Click '''Tools | DIY | SQL Control Center...''' | :01. Click '''Tools | DIY | SQL Control Center...''' | ||
:02. At the left panel look for '''Sales Invoice''' | :02. At the left panel look for '''Sales Invoice''' | ||
Revision as of 06:00, 9 December 2019
Introduction
SQL are flexible to allow user insert script to customize SQL Account / Payroll. Every business do have different requirement, so below is some example case of customization of script.
SQL Account
Case 1 - Prompt Override Dialog If Document Not Using Transfer From/To
Goods Received: Prompt override when system detect goods received's item is not transfer from purchase order, save abort.
Purchase Invoice: Prompt override when system detect purchase invoice's item is not transfer from goods received OR purchase order, save abort.
Required modules: Partial Delivery, DIY Field, DIY Script
SQL Account version: 5.2019.877.783
Updated on : 09/12/2019
Steps - Create User Rights Field
- Click Tools | DIY | Maintain DIY
- Go to Field and Quick Form tab
- Right Click the User
- Select New Field
- Click New
- Enter any name (eg AddField) in the Description field (Only Alphanumeric & no spacing)
- Click +
- Add field as below
| Name | Data Type | Size | Sub Size | Null | Description | Default | Display Format |
|---|---|---|---|---|---|---|---|
| AllowOverride | Boolean | 0 | 0 | True | AllowOverride | 0 | |
| Password | String | 10 | 0 | True | Password |
Steps - OnBeforeSave
- 01. Click Tools | DIY | SQL Control Center...
- 02. At the left panel look for Sales Invoice
- 03. Right Click the Sales Invoice
- 04. Select New Event
- 05. Enter any name (eg Calc) in the Name field (Only Alphanumeric & no spacing)
- 06. Select OnGridColumnValueChanged for Event field
- 07. Click OK
- 08. Click the Calc (name create at Step 5 above) on the left panel
- 09. Copy below script & paste to the Right Panel (Script Section)
