http://kb.owrench.com/index.php?action=history&feed=atom&title=Bill_amount_shows_zeroBill amount shows zero - Revision history2026-05-04T04:26:57ZRevision history for this page on the wikiMediaWiki 1.34.2http://kb.owrench.com/index.php?title=Bill_amount_shows_zero&diff=138&oldid=previmported>Midhungirish at 10:32, 11 September 20182018-09-11T10:32:28Z<p></p>
<p><b>New page</b></p><div>The issue occurs while editing the bill, hence the hand receipt shows cheque amount as zero.<br />
<br />
Find the bills and corresponding offices with bill amount as zero using the following query. Also we can specify the date.<br />
<source lang="sql"><br />
SELECT kwahr_core_offices.*,kwahr_bill.* FROM kwahr_bill <br />
LEFT JOIN kwahr_core_offices ON kwahr_bill.bill_office_id=kwahr_core_offices.office_id<br />
WHERE bill_total_amount='0.00' AND kwahr_bill.deleted=0 AND bill_deletion_status=0 AND kwahr_bill.t_created>='2018-07-01'<br />
</source><br />
Solution:<br />
To prevent the issue give validation for the bill amount field and restore the missing amount from the db backup.<br />
<br />
[[Category:march]]</div>imported>Midhungirish