Customization of Script

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

1. Click Tools | DIY | Maintain DIY
2. Go to Field and Quick Form tab
3. Right Click the User
4. Select New Field
5. Click New
6. Enter any name (eg AddField) in the Description field (Only Alphanumeric & no spacing)
7. Click +
8. 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)