Aloha Deposit (Over/Short) Issue

[gadang]

I have a site where the Sales/summary report shows that the Cash is always short. After doing the math it seems that the Credit Cards or Non Cash is what the difference is. I have checked all tenders and the Cash tenders are showing that they affect deposit and all non-cash tenders do not affect deposit. I am running TableService and have gone from versions 5.3.22 to 5.3.25 back to 5.3.19 and am still having the same issue. I have another site that is running 5.3.19 and am not having any problems with that location.

Can anyone help me figure out why my Credit Card sales are showing up as cash! I have tried many things as you can see so I am willing to try anything to get this straight!

Thanks in advance for any help!

Brian

 

[DTSMAN]

Check under maintenance, tenders, and see what the credit card tenders say in the report as box. Make sure it doesn't say cash in there.

Bo

Kentucky phone support-
"Mash the Kentrol key and hit scape."

 

[AkamaiAloha]

I agree with Bo on this one. I've seen some pretty flakely problems with Aloha reporting, so it may not be quite that easy--but it's a good place to start.

 

[gadang]

Hey guys I appreciate any help you can give.

I looked at the "Report as" area as I have done a few times before and all Tenders are reporting what they should be, Visa reports as Visa, MC reports as MC and so on.

Let me know what you think I should look at next.

Once again thanks for your help

Brian

 

[DTSMAN]

Try this to start. In the sales summary report, go to settings and highlight the deposit option on the included side. There will be be some coices to the right to break it down and help you troubleshoot, select them all. Do that and see if it returns an info that may be helpful.

Bo

Kentucky phone support-
"Mash the Kentrol key and hit scape."

 

[AdamDR]

I've ran into this before, and the solution is editing the deposit. Go into Function, Edit Deposit. For the problem I had, there was an entry for a preset deposit. Delete anything in there and you should be good to go.

Adam

 

[Aloha1]

Do they do any tip refunds? Credit card tenders have this option, and sometimes those numbers can get lost on a summary report. Just a thought.

 

[gadang]

Hey all,
I have looked into each of your ideas and I still have not found anything that is not configured properly. I looked at the report per Bo and could not see anything out of the ordinary. Maybe you can give me specifics to look for in that report.

AdamDR, I did not see a place to set a "preset" deposit amount. All they can do is add the daily amount and a description ie; am deposit or pm deposit.

Aloha1, The site does not do tip refunds so all of the checks marks are clear.

I even cleared all reports and let Aloha rebuild the default and reconfigured it and it still shows Credit Cards as cash.

I have scratched a hole in my head on this one. Like I said before I have another site running this version and it is GTG.

More ideas?

Thanks alot guys for your help and any more that you can give.

 

[DTSMAN]

Go into your tender setup and check the type tab and make sure it is not checked as cash there.
Are they authorizing through edc?

Bo

Kentucky phone support-
"Mash the Kentrol key and hit scape."

 

[gadang]

Bo,
I checked all of the type tabs and they are reporting as non-cash ie; visa reports as visa, amex as amex and so on. I am authorizing thru edc for credit card sales.

Thanks Bo

 

[Aloha1]

I have a balncing utility for aloha, its basically an XLS and report settings file that you plug in and put the numbers on the XLS off the report. It gives you the breakdown of the way aloha calculates the deposit. You can prob see where your shortage is with it. Do you have like an FTP or somewhere i can post it to? Since this forum bans email addy postings?

 

[posrescue]

If you are stiil scratching a hole in your head...
Is this a new database built from a template?
Try deleting all of the .cdx and .tdx files from data and new data,(you may want to keep the adjtime files in data if live). Run DBconfig to recreate the dbf indexers. This will not change past reports of previous days reports without wuite a bit of work but may fix you for the future. If the problem is corruption in the dbf files you can always clean wthem up with RDB and then recreate the dbf files.

 

[gadang]

Hey,
Thanks for all of the help that you have come up with. We finally got this fixed and you won't believe what it was....or maybe you will. It was the Bank in Petty cash! When our reseller setup the database they demonstrated how you can have petty cash amounts in the system. We did not put that into play but they never removed it. So after hunting and pecking I found the solution.

Thanks again for all who helped. I am sure we will talk again!