# Help customer accounts **URL:** \ **Category:** V5 Question\ **Created:** [October 26, 2015, 8:28am UTC](https://forum.sambapos.com/t/help-customer-accounts/7825 "2015-10-26T08:28:48Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![maccatwo](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/m/8dc957/32.png) [@maccatwo](https://forum.sambapos.com/u/maccatwo)\ **Post date:** [October 26, 2015, 8:28am UTC](https://forum.sambapos.com/t/help-customer-accounts/7825/1 "2015-10-26T08:28:49Z")
hi everyone, I am setting up a pos system in a small sports club , I would like to set up accounts for each of our members allowing them to buy on credit or pay in advance and use the same account as a debit account. There have been previous questions on this subject that I have tried to follow without success. Could someone please post a step by step guide to help me . thanks in advance ---
**Author:** ![pauln](https://forum.sambapos.com/user_avatar/forum.sambapos.com/pauln/32/12698_2.png) [@pauln](https://forum.sambapos.com/u/pauln)\ **Post date:** [October 26, 2015, 1:49pm UTC](https://forum.sambapos.com/t/help-customer-accounts/7825/2 "2015-10-26T13:49:52Z")
Ok so what have you managed to get working so far? I searched “Customer Account” for you and there are several links her is a good detailed one which talks about the Account Setup as well: > [@Question about customers and customer account](http://forum.sambapos.com/t/question-about-customers-and-customer-account/753): > > I am trying to set up our customer database and customer account (we do have three customers that pay at the end of the month). so, I set up a customer screen (search), I set up a customer account pay button in payment screen… but my problem is that this button appears disabled almost allways even having selected a customer (its the “Cuenta Corriente” button) heeelp, jajajajajajajajajjajajaja THANKS!!! G. Don’t forget you need to setup a New Entity - Customer and custom fields to your liking. ---
**Author:** ![maccatwo](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/m/8dc957/32.png) [@maccatwo](https://forum.sambapos.com/u/maccatwo)\ **Post date:** [October 26, 2015, 5:14pm UTC](https://forum.sambapos.com/t/help-customer-accounts/7825/3 "2015-10-26T17:14:06Z")
to be honest I have tried so many things I no longer know what the starting point is, I even tried deleting the software and starting again but it only came back with the same settings, the previous thread was going back and forward trying this and that but I may have altered something that prevents these functions. cheers ---
**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\ **Post date:** [October 26, 2015, 5:16pm UTC](https://forum.sambapos.com/t/help-customer-accounts/7825/4 "2015-10-26T17:16:14Z")
Your using a database for 90% of the settings. Deleting software and reinstalling wont clear the database. To start over from scratch you should start a new database. Did you install localdb version or SQL Express? Uninstall SambaPOS then delete the c:\programsettings\SambaPOS folder it is hidden so enable the ability to see hidden files and directories. Also delete the SambaPOS directory from your documents. * * * If your using SQL Express for your database then you can simply go to Manage \> Local Settings and Database then setup a new database name and restart. Or you can use MSSMS to delete your database and restart SambaPOS it will create a new one. * * * I hope you can understand why this would be hard for us to help you with. If you changed a bunch of stuff and dont know what you changed then we dont know either and it will be nearly impossible for us to help you unless you can show us what you have tried or changed. When you manage to get the database reset and you start fresh I recommend going through the Tutorials section of the forum and read and practice those until you get better understanding of how it works. Once you get this understanding then you should try to customize it further. Do tutorials you think you may not ever use it gives you good practice and exposes methods you can use. ---
**Author:** ![maccatwo](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/m/8dc957/32.png) [@maccatwo](https://forum.sambapos.com/u/maccatwo)\ **Post date:** [October 28, 2015, 9:32am UTC](https://forum.sambapos.com/t/help-customer-accounts/7825/5 "2015-10-28T09:32:25Z")
thankyou I will give it a go ---
**Author:** ![Mully](https://forum.sambapos.com/user_avatar/forum.sambapos.com/mully/32/26114_2.png) [@Mully](https://forum.sambapos.com/u/Mully)\ **Post date:** [November 19, 2015, 5:58am UTC](https://forum.sambapos.com/t/help-customer-accounts/7825/6 "2015-11-19T05:58:17Z")
Maybe I should be asking a new question but I can’t seem to find where to ask this. I am running V4 and I have been live with the ordering for months and I just recently went live with the money. I have Customer accounts set up, I can’t remember if I programmed them or if they were already set up with the program. They seem to be working perfectly, allowing me to charge and pay the accounts. My problem is I just noticed tonight my cash was approximately $450.00 over. Not normal of course. I searched and did some tests and have discovered that on my Daily Report, payments to accounts are not showing up on the report, therefore making my cash drawer over. The charges appear to be functioning properly. Is this acting normally? I do not have custom reports as I haven’t needed it yet and I fully intend on upgrading to V5, I just want to get the kinks out in a Version I am familiar with. Have I screwed something up or is it not possible to show payments in the daily reports so I can have a balanced cash drawer. Thanks again in advance. ---
**Author:** ![pauln](https://forum.sambapos.com/user_avatar/forum.sambapos.com/pauln/32/12698_2.png) [@pauln](https://forum.sambapos.com/u/pauln)\ **Post date:** [November 19, 2015, 6:30am UTC](https://forum.sambapos.com/t/help-customer-accounts/7825/7 "2015-11-19T06:30:13Z")
Post a copy or image of both reports here @Mully. I not an expert but if everything is working and setup fine, then its probably payments going to tickets from closed work periods or just payments on account i.e. Sale Data on the Work Period Report was already recorded and printed on a previous report. Again do not rely on my opinion but I have read it is normal for a WP Report to differ from Cash Transactions due to the above. ---
**Author:** ![Mully](https://forum.sambapos.com/user_avatar/forum.sambapos.com/mully/32/26114_2.png) [@Mully](https://forum.sambapos.com/u/Mully)\ **Post date:** [November 19, 2015, 6:47am UTC](https://forum.sambapos.com/t/help-customer-accounts/7825/8 "2015-11-19T06:47:20Z")
I will try and get the reports tomorrow. Thanks. ---
**Author:** ![JTRTech](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jtrtech/32/21270_2.png) [@JTRTech](https://forum.sambapos.com/u/JTRTech)\ **Post date:** [November 19, 2015, 12:22pm UTC](https://forum.sambapos.com/t/help-customer-accounts/7825/9 "2015-11-19T12:22:12Z")
Account payments as far as I know do not show of the standard work period report. Charges to an account show as are reported as a ticket payment method (the ticket is paid by the account). You would need to use seperate custom report in V4 or in V5 you can edit the work period report itself. ---
**Author:** ![Mully](https://forum.sambapos.com/user_avatar/forum.sambapos.com/mully/32/26114_2.png) [@Mully](https://forum.sambapos.com/u/Mully)\ **Post date:** [November 19, 2015, 10:09pm UTC](https://forum.sambapos.com/t/help-customer-accounts/7825/10 "2015-11-19T22:09:19Z")
I have read other occasions where this is the case and I suspected as much. Thanks for everyone’s help. Version 5 will be implemented soon. ---
**Author:** ![Mully](https://forum.sambapos.com/user_avatar/forum.sambapos.com/mully/32/26114_2.png) [@Mully](https://forum.sambapos.com/u/Mully)\ **Post date:** [November 29, 2015, 9:44pm UTC](https://forum.sambapos.com/t/help-customer-accounts/7825/11 "2015-11-29T21:44:28Z")
This should probably be in the Version 5 forum, but I don’t know how to move it. I have downloaded and installed and paid for Version 5. So far so good. I am now attempting to deal with the payments made to customer accounts not showing up on the Work Period Report. I have read many of the posts and am completely lost. There is too much information and I can’t make sense of it. Can someone please point me in the right direction. I would like to see the total payments made to customer accounts so when I cash out my register the cash will balance. I will be implementing a Payout and gift certificates too but I will be happy to start with the accounts. Thanks in advance. ---
**Author:** ![pauln](https://forum.sambapos.com/user_avatar/forum.sambapos.com/pauln/32/12698_2.png) [@pauln](https://forum.sambapos.com/u/pauln)\ **Post date:** [November 30, 2015, 1:03am UTC](https://forum.sambapos.com/t/help-customer-accounts/7825/12 "2015-11-30T01:03:38Z")
> [@Mully](#): > > This should probably be in the Version 5 forum, but I don’t know how to move it Hey Mully, try editing your topic and it should give you a “Drop Down” to change topic category. ![](https://forum.sambapos.com/uploads/default/original/3X/9/9/99f9ca1333adbef61edc9490ea43b69e4582e154.JPG) ---
**Author:** ![silentbob](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/s/3ab097/32.png) [@silentbob](https://forum.sambapos.com/u/silentbob)\ **Post date:** [November 30, 2015, 11:17am UTC](https://forum.sambapos.com/t/help-customer-accounts/7825/13 "2015-11-30T11:17:50Z")
Here is a start for you. This code may not be perfect but it works for me. This is for all cash payments. you can duplicate it for credit card, cheque etc whatever you need ![](https://forum.sambapos.com/uploads/default/original/3X/8/9/891798e3d0e5971ab0dca66fe070fb58d3f5f14e.PNG) ``` SELECT SUM(amount) FROM (SELECT SUM(Amount) AS amount FROM AccountTransactions INNER JOIN AccountTransactionDocuments ON AccountTransactions.AccountTransactionDocumentId = AccountTransactionDocuments.Id WHERE AccountTransactionDocuments.Date > '{Start}' AND AccountTransactionDocuments.Date < '{End}' AND AccountTransactions.Name LIKE '%Cash Payment%' AND AccountTransactions.Name NOT LIKE '%Transaction%' UNION ALL SELECT SUM(Amount) AS amount FROM Payments WHERE Payments.Date > '{Start}' AND Payments.Date < '{End}' AND Payments.Name = 'Cash') AS amounts ``` add it to report like this ![](https://forum.sambapos.com/uploads/default/original/3X/5/c/5c8fc8df3267cf8b7170b577b39e6e40913b961f.PNG) ---
**Author:** ![Mully](https://forum.sambapos.com/user_avatar/forum.sambapos.com/mully/32/26114_2.png) [@Mully](https://forum.sambapos.com/u/Mully)\ **Post date:** [December 6, 2015, 11:17pm UTC](https://forum.sambapos.com/t/help-customer-accounts/7825/14 "2015-12-06T23:17:39Z")
Once I got the typos I made corrected this seems to work great on my test system. I couldn’t use the Total Cheque and “\>Total In Drawer|@@InDrawer” but I think that is because I haven’t scripted it yet but this looks like it will do what I need. Thanks for all the help!!! ---
**Author:** ![Mully](https://forum.sambapos.com/user_avatar/forum.sambapos.com/mully/32/26114_2.png) [@Mully](https://forum.sambapos.com/u/Mully)\ **Post date:** [December 10, 2015, 1:53am UTC](https://forum.sambapos.com/t/help-customer-accounts/7825/15 "2015-12-10T01:53:08Z")
Maybe I have not done something correctly. I created a customer account called PAYOUT in order to monitor “payouts” out of the cash drawer until I can create something better. I just noticed on my test system that if I make a negative cash payment (-20.00) for example it still adds +20.00 to my cash drawer. I was hoping a negative payment would mean cash out of the drawer. It appears that all payments positive or negative are all showing as cash into the drawer. I have just verified that this affects all my customer accounts and Gift Certificate accounts. Is there a simple fix to the script that would fix this or have I made an error? ---
**Author:** ![RickH](https://forum.sambapos.com/user_avatar/forum.sambapos.com/rickh/32/51960_2.png) [@RickH](https://forum.sambapos.com/u/RickH)\ **Post date:** [December 10, 2015, 6:35am UTC](https://forum.sambapos.com/t/help-customer-accounts/7825/16 "2015-12-10T06:35:22Z")
You would be better to create a petty cash system for drawer payouts see my tutorial for petty cash > [@Rick's Tutorial 2 - Petty Cash](http://forum.sambapos.com/t/ricks-tutorial-2-petty-cash/3386): > > This tutorial is for setting up a petty cash system for personal/emergency store expenses, for example you run out of milk or an ingredient and you have to go to your local shop/supermarket to buy it as a one off or you might need to purchase stamps to post a letter etc. I have set this up using the same methods and account set up and account transaction documents in rules and actions that I used for Till Floats that you can read in my first tutorial [Rick’s Tutorial 1 - Till Float](http://forum.sambapos.com/t/ricks-tutorial-1-till-float/3364/5) so im not goi… ---
**Author:** ![Mully](https://forum.sambapos.com/user_avatar/forum.sambapos.com/mully/32/26114_2.png) [@Mully](https://forum.sambapos.com/u/Mully)\ **Post date:** [December 10, 2015, 2:05pm UTC](https://forum.sambapos.com/t/help-customer-accounts/7825/17 "2015-12-10T14:05:24Z")
I was looking at that one and a few others. I’m sure I will go that way in the near future. My main concern now is my day’s end. I am having a very hard time getting my cash drawer to balance. I thought the script above was doing the trick and I was trying to work around it to get the drawer to balance. I don’t understand the scripting at all but I am starting to grasp the automation commands and the accounts a little. Thanks for your suggestion. ---
**Author:** ![Mully](https://forum.sambapos.com/user_avatar/forum.sambapos.com/mully/32/26114_2.png) [@Mully](https://forum.sambapos.com/u/Mully)\ **Post date:** [December 12, 2015, 3:38am UTC](https://forum.sambapos.com/t/help-customer-accounts/7825/18 "2015-12-12T03:38:09Z")
I downloaded the zip files and it seemed to work fine and then I screwed up the mappings I think. I have reset and will know better next time. Thanks for all your help. I’ll get this figured out soon.