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
There are no items with the selected labels at this time.
, multiple selections available,
Related content
Turn Over Bill to Clerk and Master
Turn Over Bill to Clerk and Master
More like this
BenchmarkDataDictionaryVs2.10.5.0
BenchmarkDataDictionaryVs2.10.5.0
More like this
How to Re-Open a work date Checked Out in error
How to Re-Open a work date Checked Out in error
More like this