QNE Software Sdn. Bhd.

1. Example in Sales invoice, existing we got this format - refer to <SR>09 Invoice with Auto Numbering the field is Variable4

2. Point to it – right click – calculation – copy the content inside and exit this form

3. Open the report format that you want to modify – create a new variable – Change the data type to Integer
Remark: Note that the variable name (example here is variable 3)

4. Point to the variable – right click – Calculation – Paste the coding just now we copy
The script is like this

IF (SalesInvoice['ITEMAMOUNT'] = 0) AND
(SalesInvoice['ITEMQTY'] = 0) AND
(SalesInvoice['ITEMUNITPRICE'] = 0) AND
(SalesInvoice['ITEMSTOCKCODE'] = '')
THEN
BEGIN
VALUE := VARIABLE4.VALUE;
VARIABLE4.VISIBLE := FALSE;
 END

ELSE
BEGIN
VALUE := VARIABLE4.VALUE + 1;
VARIABLE4.VISIBLE := TRUE;
 END;

5. Change the variable4 to variable3 (since the one we create in new format is variable 3) – then set ok
6. Point to the variable3 again – right click – Timing – set Calculate on as “Travesal”; Reset on “Group End”, and Group as “Group(0)Sales Invoice”
7. Done