Bill amount shows zero

From Origami_Wiki
Revision as of 16:02, 11 September 2018 by imported>Midhungirish
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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.