**[TechCherio](/u/techcherio)** The result for my tests are attached.

**[Mian Saleem](/u/saleem)** Hello Saleem,

Attached are my results too. I don't know what I am supposed to do to fix those wrong balances

Hello,

You download file and demo are same files and should work same unless any modification.

Are you using latest version? If not, please try to update otherwise let me know the site details to have a look.

Thank you

**[Mian Saleem](/u/saleem)** Hello,

I am using v3.4.41 (guess it's the updated version). if possible, email me at [email protected] so that I can share the site details.

I never made any modifications.

Thanks

Yes, v3.4.41 is latest. You can add private reply by enabling the `PRIVATE for Staff only` at top right of the reply section. Thank you

**[TechCherio](/u/techcherio)** Hello, I feel the issue is as a result of the concatenate separator on the `getSales` function query to get balance in `POS` controller `app\controllers\admin\Pos.php` . It seems to mess up the `grand_total` and `paid` values for some reasons.


Try to replace **line 736**

->select($this->db->dbprefix('sales') . ".id as id, DATE_FORMAT(date, '%Y-%m-%d %T') as date, reference_no, biller, customer, (grand_total+COALESCE(rounding, 0)), paid, CONCAT(grand_total, '__', rounding, '__', paid) as balance, sale_status, payment_status, companies.email as cemail")


With

->select($this->db->dbprefix('sales') . ".id as id, DATE_FORMAT(date, '%Y-%m-%d %T') as date, reference_no, biller, customer, (grand_total+COALESCE(rounding, 0)), paid, (grand_total-paid) as balance, sale_status, payment_status, companies.email as cemail")


And **line 743**

->select($this->db->dbprefix('sales') . ".id as id, DATE_FORMAT(date, '%Y-%m-%d %T') as date, reference_no, biller, customer, (grand_total+COALESCE(rounding, 0)), paid, CONCAT(grand_total, '__', rounding, '__', paid) as balance, sale_status, payment_status, companies.email as cemail")


With

->select($this->db->dbprefix('sales') . ".id as id, DATE_FORMAT(date, '%Y-%m-%d %T') as date, reference_no, biller, customer, (grand_total+COALESCE(rounding, 0)), paid, (grand_total-paid) as balance, sale_status, payment_status, companies.email as cemail")

Hope that helps

Hello,

The `CONCAT` is working fine as the data generated is correct. I suspect the `balance` function is not being used from the same view file.

Please try to clear browser cache and then try again. If still same let me know the server details to check.

Thank you

**[Enyinnaya Gift](/u/giftedhands4real)** Hello,

This solved for only Full payments, but it did not solve for "due" payments. please see attached.

Due payments are showing zero balance which is wrong.

Thanks.

**[Mian Saleem](/u/saleem)** hello,

@Enyinnaya's suggestion only solved only Full payments, but it did not solve "due" payments. please see attached.

Due payments are showing zero balance which is wrong.

Thanks.

**[Mian Saleem](/u/saleem)** Yes, it has been solved. Thanks so much.

If I may ask, what was the problem?