/
Correcting empty dates on Receipts
There appears to be an issue with postmarked bills showing the linux epoch when printing the receipt.
select concat("update ppt_transactions set postmark_date='", last_day(date_add(t.work_date, interval -1 month)), "'
where id = ",t.id,";") q from ppt_transactions t join receipt_payments rp ON(rp.receipt_id = t.receipt_id)
where (t.postmark_date IS NULL OR t.postmark_date ='0000-00-00') and rp.via ='POSTMARKED_MAIL';
Related articles
Filter by label (Content by label)
Related issues |
|---|
Page Properties