AM
Asked
Hi,
Please kindly help me on how to make "Sales" & "Purchases" values appear are net value of the invoice means it should show the net sales after discounts value in stead of the current status it shows the total sales amount regardless of discount amounts.
Please refer to the attached screenshot.
Thanks in advance.
Regards,
Please kindly help me on how to make "Sales" & "Purchases" values appear are net value of the invoice means it should show the net sales after discounts value in stead of the current status it shows the total sales amount regardless of discount amounts.
Please refer to the attached screenshot.
Thanks in advance.
Regards,
Attachments
- EGAnsweredHello,
You can modify the `app/models/admin/Db_model.php` and change `SUM(total) Sales,` on line 50 to `SUM(grand_total) Sales,`
And `SUM(total) purchases` on line 59 to `SUM(grand_total) purchases`
Thank you - MSAnsweredHello,
You will need to modify the item code to get the desired result.
[@Gift](/u/giftedhands4real) `total` will not have order level discount/tax. The better option will be to add `total_discount` to `grand_total`
Thank you - AMAnswered**[Mian Saleem](/u/saleem)** Please let me know how could I do it?
- AMAnswered**[Mian Saleem](/u/saleem)** How to add "total_discount" to "grand_total"
- AMAnswered**[Enyinnaya Gift](/u/giftedhands4real)** Thanks for support.
- EGAnswered**[Ahmed Hamdy Montaser](/u/hamdy_85)** If I understood your question very well. You want `Sales and Purchases Values` after `discount` and `taxes` must have been `applied`.
If that is correct, then try the modifications that I suggested and see if you will get your desired result. - MSAnswered**[Ahmed Hamdy Montaser](/u/hamdy_85)** Hello,
> We don't offer support for modifications and modified versions. You are allowed to do it at your own risk as per license.
The file path is already mentioned by @Gift and if yo not sure, I suggest you hire any developer to help you. @Gift offer customisation/modification service, if you don't have any developer, you can check with him.
Thank you - Login to Reply