The issue of Duplication of grand total and Net total in the Report of sales invoice
if there is 2 items for a invoice the grand total and net total show twice and in the total it will add twice
If there is item wice report then double amount will come and if there is no item wice report then double amount will not come.
Please look 0n the ist invoice 191
->It has two items
->So it has two grand total and two total charges and two net total @NCP
→ At last it get added in the total
Hey you read the report carefully because you don’t know the understanding of the report. Within the report is the item, and then you go to total the column, both the invoice and the item will be totaled. So you see the total double times, and I think this query reports.
Simple solution, remove the item columns or items table-related columns then check the report.
But our manger also want the item is any alternative solution
Then not possible, that for you have to build the server script report with tough logic.
1 Like