How to show item auto number in another report format?

Created by QNE Software Sdn bhd, Modified on Mon, 21 Dec, 2020 at 12:45 PM by 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

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article