Paid Outs

Questions and Answers about the POS Pizza 6 & 7 Databases
Veteran Member
User avatar
Posts: 244
Joined: Wed Oct 12, 2011 1:38 pm
Location: Pennsylvania

Paid Outs

Postby synpse » Wed Dec 21, 2011 12:22 am

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.

Site Admin
User avatar
Posts: 2090
Joined: Wed Apr 16, 2003 4:35 pm
Location: Western PA

Re: Paid Outs

Postby Scott » Wed Dec 21, 2011 6:04 pm

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

Scott

Veteran Member
User avatar
Posts: 249
Joined: Sun Sep 30, 2007 8:13 pm
Location: Ohio

Re: Paid Outs

Postby durbancic » Wed Dec 21, 2011 6:13 pm

You could also do another payout for negative of that value to zero it out, and then a final one of your correct value.

Veteran Member
User avatar
Posts: 244
Joined: Wed Oct 12, 2011 1:38 pm
Location: Pennsylvania

Re: Paid Outs

Postby synpse » Thu Dec 22, 2011 2:22 pm

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!

Site Admin
User avatar
Posts: 2090
Joined: Wed Apr 16, 2003 4:35 pm
Location: Western PA

Re: Paid Outs

Postby Scott » Fri Dec 23, 2011 9:24 am

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

Veteran Member
User avatar
Posts: 244
Joined: Wed Oct 12, 2011 1:38 pm
Location: Pennsylvania

Re: Paid Outs

Postby synpse » Fri Jan 06, 2012 8:55 pm

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.

Site Admin
User avatar
Posts: 2090
Joined: Wed Apr 16, 2003 4:35 pm
Location: Western PA

Re: Paid Outs

Postby Scott » Sat Jan 07, 2012 1:49 am

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

Scott

Return to Database Help and Discussion

Who is online

Users browsing this forum: No registered users and 1 guest