Report Design: How to show the word ‘VOID’ on Invoice when it is cancelled

From AutoCount Resource Center

Question : How to show the word ‘VOID’ on Invoice when it is cancelled?

Version : 1.8 / 1.9 / 2.0


Answer :

Can be done by using formatting rules editor in report design.

1) Go to Sales > Invoice, click on Report > Design Document Style Report.

Void1.png


2) Select the report and click on Design.

Void2.png


3) Drag out a new label, go to Property Grid > Behavior, set the Visible to No.

Void3.png


4) Click on Formatting Rules from Appearance or you may click on the label’s small arrow > Formatting Rules.

Void4.png


5) Click on Edit Rule Sheet…

Void5.png


6) Click on (+) for Add a formatting rule.

Void6.png


7) Set Data Source as Invoice, and Data Member as 1 Data Member : Invoice Master, then click on Condition.

Void7.png


8) Click on Fields, and double click on Is Cancelled ? (True or False), then click on icon (=), and type ‘T’ after the ==, then click on OK.

Void8.png


9) Set the Visible to Yes and you may give a name for this formatting rule, then click on Close.

Void9.png


10) Click on (>) to applied this rule. Then click on OK.

Void10.png


Void11.png


11) You may double click on the label to change the wording, or click on the label’s small arrow, and change the wording for Text.

Void12.png


12) Go to File > Save As…, name a new report name and Save.

Void13.png


13) The VOID will only be shown when print/preview a cancelled Invoice.

Void14.png


By : Soh Wee 190328, Lay Swan 200224, P200225



Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations