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
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article