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.
Updated on : 09/12/2019

Steps - OnGridColumnValueChanged

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)