A5.48 : How to put Subtotal + Tax in detail for Invoice Design Report

A5.48 : How to put Subtotal + Tax in detail for Invoice Design Report

Question: 

How to add an info of Subtotal + Tax in detail for Invoice Design Report? (E.g: RM 100 + 6% SST = RM 106). Currently my report shows RM100.


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) To insert Subtotal + Tax, click on Expressions icon (symbol f)(1), click once on ‘SubTotalExTax’ field (2), then click on the ellipsis (...) at Text (3). 






3) It will prompt Expression Editor, key in [SubTotalExTax]+[Tax] at the Expression Editor, then click OK.  






4) After done, click the Menu on the top left and Save As new report.

 




When you preview the report, it should be able to show the Subtotal +Tax amount.



--Source from AutoCount Wiki --

    • Related Articles

    • A1.84 : Sales: Apply formula for Subtotal causing incorrect Unit Price

      Question : I have created UDF_CurrRate at Invoice detail and set a formula for Subtotal. Formula : Subtotal = d_Qty *d_UDF_CurrRate * d_UnitPrice But when I key in CurrRate = 2 and Unit Price = 100, the Unit Price will change to 200 and Subtotal ...

    • A1.151 : Others: Data is not loaded in Report Design

      Question : When I go to Invoice > Report > Design Document Style Report in AutoCount Accounting 2.0, there is no data loaded in Field List. Why? Possible Reason : This is a known bug and fixed in version 2.0.15.145. Solution : Update to Version ...

    • A5.98 : Tax - Functions : SST Processor

      This function allows you to process your company SST. It will process your SST transactions based on taxable period, generate a summary of your company SST so that you can submit your SST to custom. To access SST Processor, click on the Tax Menu > ...

    • A5.44 : How to insert Sales Agent in Invoice Report

      Question: How to insert Sales Agent into Invoice report design? 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) To insert SalesAgent, go to ...

    • A5.41 : How to insert Product Code in Invoice Report

      Question: How to insert Product Code in Invoice report design? 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) To insert ProductCode, go to ...