Dear team.
I create a custom report using sales invoice line, I did not select the Vat section still its visible in the report, how to resolve it? and I wanted to generate it total of invoice value except Vat amount not the items wise i.e if the invoice having 2 items need to show the total value of its not it separately.
This is not a Custom Report but an Advanced Query. The Query will always display all the fields that you enable columns for. So if you do not want to see the VAT column then for this report disable it under enable columns.
Advanced Queries are the replacement for Custom Reports and therefore should be as capable as Custom Reports, at minimum.
@pradeepk67 has a good case, and there’s currently no column that shows pretax amounts.
Therefore, I will add this to ideas and I will change the title accordingly, however, first I need @pradeepk67 to confirm that this is the issue.
@Ealfardan, Thanks for your kind reply, yes, the issue I have the field I didn’t selected still showing in the results and this report I generated from the sales invoice - line function and it’s not possible to generate the results by invoice number rather individual items from each invoice.
@eko You can just see the selected field which I marked, I enable only issue date, reference, customer and amount column only and have no idea why the vat amount displaying above the amount column.
I can not see that, you need to show the “enable columns” info such as per screenshot below:
None of your screenshots so far show a VAT column, so show one of these as well.
Please check attached,
P.S. is it possible to generate report for total amount by using invoice number rather showing amount by items wise in an invoice. i.e an invoice having 5 items don’t need to show 5 items amount separately, instead total amount of invoice.
