Bill amount shows zero
Jump to navigation
Jump to search
The issue occurs while editing the bill, hence the hand receipt shows cheque amount as zero.
Find the bills and corresponding offices with bill amount as zero using the following query. Also we can specify the date. <source lang="sql"> SELECT kwahr_core_offices.*,kwahr_bill.* FROM kwahr_bill LEFT JOIN kwahr_core_offices ON kwahr_bill.bill_office_id=kwahr_core_offices.office_id WHERE bill_total_amount='0.00' AND kwahr_bill.deleted=0 AND bill_deletion_status=0 AND kwahr_bill.t_created>='2018-07-01' </source> Solution: To prevent the issue give validation for the bill amount field and restore the missing amount from the db backup.