Where is the "Paid Outs" field entered into the database?
And can I change the raw value of the field. I missed a decimal in the delivery driver drop into a drawer last night, and was off by like 6 thousand dollars on the final over/under.
Paid Outs
Re: Paid Outs
It is a special record in the orders table. You should be able to find it with that amount pretty easily.
Scott
Scott
Re: Paid Outs
You could also do another payout for negative of that value to zero it out, and then a final one of your correct value.
Re: Paid Outs
I already closed out the drawer for yesterday. So another Paid Out won't work. that's usually how I fix those mistakes.
I'll search the orders table for that "special record". Thanks!
I'll search the orders table for that "special record". Thanks!
Re: Paid Outs
Yes, the special records have a very large (1000000+) order number, so they should be easily identified. Plus you should see the very large total field on that record too.synpse wrote:I already closed out the drawer for yesterday. So another Paid Out won't work. that's usually how I fix those mistakes.
I'll search the orders table for that "special record". Thanks!
Scott
Re: Paid Outs
What is a good program for SQL database browsing? I had to write the whole SQL statement with some program I found.. and ugh, i'd rather just point n click and type.
Re: Paid Outs
SQLite Expert is a good one that works very well, and is pretty easy to use.
Scott
Scott