Perform End of Day Procedure
Trying to finish up my Simple Invoice system, but need a little help with end of day proc.
i would like to do the following:
- find *ALL invoices that occured on today's date or any other date
- sort those records by customer name
- create a report that lists job totals, payment type(cash,charge,credit,check) *deposits,etc
- then prints a summary of total sales for day, total deposits, total refunds
- and at bottom we would have total amount available for deposit.
i am sure somewhere my logic is flawed,but again i know someone knows how to go about this.