Paid Outs

Questions and Answers about the POS Pizza 6 and newer Database
Post Reply
User avatar
synpse
Veteran Member
Veteran Member
Posts: 244
Joined: Wed Oct 12, 2011 2:38 pm
Location: Pennsylvania
Contact:

Paid Outs

Post by synpse »

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.
User avatar
Scott
Site Admin
Site Admin
Posts: 2564
Joined: Wed Apr 16, 2003 5:35 pm
Location: Western PA

Re: Paid Outs

Post by Scott »

It is a special record in the orders table. You should be able to find it with that amount pretty easily.

Scott
User avatar
durbancic
Veteran Member
Veteran Member
Posts: 249
Joined: Sun Sep 30, 2007 9:13 pm
Location: Ohio
Contact:

Re: Paid Outs

Post by durbancic »

You could also do another payout for negative of that value to zero it out, and then a final one of your correct value.
User avatar
synpse
Veteran Member
Veteran Member
Posts: 244
Joined: Wed Oct 12, 2011 2:38 pm
Location: Pennsylvania
Contact:

Re: Paid Outs

Post by synpse »

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!
User avatar
Scott
Site Admin
Site Admin
Posts: 2564
Joined: Wed Apr 16, 2003 5:35 pm
Location: Western PA

Re: Paid Outs

Post by Scott »

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!
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.

Scott
User avatar
synpse
Veteran Member
Veteran Member
Posts: 244
Joined: Wed Oct 12, 2011 2:38 pm
Location: Pennsylvania
Contact:

Re: Paid Outs

Post by synpse »

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.
User avatar
Scott
Site Admin
Site Admin
Posts: 2564
Joined: Wed Apr 16, 2003 5:35 pm
Location: Western PA

Re: Paid Outs

Post by Scott »

SQLite Expert is a good one that works very well, and is pretty easy to use.

Scott
Post Reply