Open main menu

Report Design: How to add sequence number in Invoice Detail Listing Report

Question : The invoice detail listing report is without sequence number, how can I add it into the report?


Answer :

1) Go to Sales > Invoice, click on Print Invoice Listing and select Print Invoice Detail Listing and click on OK

Sequence1.png


2) Go to Report > Design Detail Listing Report

Sequence2.png


3) Select report named Invoice Detail Listing, then click on Design

Sequence3.png


4) In the report design, under the DetailBand1, resize the first label to allocate a space in front for the sequence number.

Sequence4.png


5) Go to Standard Controls at the bottom left of you report design, drag and drop the Label to the allocated space

Sequence5.png


6) Click on the small arrow above the newly added label to prompt the label task box. Click on Summary

Sequence6.png


7) At Bound field, select Sequence Id to bind it to the label

Sequence7.png


8) At Summary function, select Record Number and under Summary Running, select Report. Then click on OK

Sequence8.png


9) Go to File > Save As…, key in the report name and click on Save

Sequence9.png


10) Inquiry and preview the newly saved report.

Sequence10.png


By : Michelle 180914, Lay Swan 180919, P180919



Go to menu