A5.46 : How to show Total Quantity in Invoice

A5.46 : How to show Total Quantity in Invoice

Question: 

How to show Total Quantity when I preview/ print my Invoice?


Answer:

1) To design the report, click Print and click 'Design Report' button on the right side. Click 'Design' at the report that you would like to amend.






2) Go to Field List (1) > expand objectDataSource1 (2) > Invoice (3) > InvoiceDetail (4) > click and drag out ‘Quantity’ column.







3) Then click on the Expressions icon (symbol 'f') and click on the ellipsis (...) at Text. 





4) It will prompt Expression Editor, key in Sum([Qty]) at the Expression Editor, then click OK.











5) To adjust the decimal, go to Properties > Text Format String, key in {0:n0}.

You may click on the ellipsis (...) to choose other format string too.






6) After done, move and adjust the position of the field, then click the Menu on the top left and Save As new report.



Note: May perform the same steps for show Total Discount Amount.

​


--Source from AutoCount Wiki --

    • Related Articles

    • A5.70 : Sales - Transactions : Invoice

      This function allows you to manage your Invoices. Invoice is used to bill or charge customer that purchase products or services provided by your company. *Invoice will deduct your stock quantity and amount will be posted into your accounts which will ...

    • A5.75 : Purchase - Transactions : Purchase Invoice

      This function allows you to manage your Purchase Invoices. Purchase Invoice is usually used to record your supplier’s invoices when they bill you. *Purchase Invoice will add your stock quantity and amount will be posted into your accounts which will ...

    • A2.55 : How to change quantity decimal for POS?

      Question : How to change quantity decimal for POS? Solution : User would like to set more quantity decimal point because of some items weight is lower than 1KG. (This will easier for system to calculate more accurate amount) 1. Login to POS Backend, ...

    • A1.71 : Stock: Inconsistent stock balance quantity problem keep happening

      Question: Why is my stock balance quantity always not tally with the total balance quantity at stock item maintenance and can only be solved after run fix inconsistent stock balance quantity problems? It happens very frequently. Possible Reason : ...

    • A5.49 : How to show Supplier Invoice Number instead of Purchase Invoice Number in Creditor Statement

      Question: For Creditor Statement, is there any way to change Ref (Purchase Invoice Number) to Supplier Invoice No? Answer: Yes, you can replace the Purchase Invoice No with Supplier Invoice No in Design Report. 1) After you have click on ‘Inquiry’, ...