Results 1 to 40 of 61

Thread: any suggestions? POS system development

Hybrid View

  1. #1
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: any suggestions? POS system development

    This is a great thread to have found...

    I'm developing a POS system for a friend right now - to run a dance studio and shop that sells dance wear.

    I'll keep this thread posted with what we discover and do as we go along...

    Here's a question - how do you open the cash drawer in the morning and close it out in the evening. How do you account for the take during the day and what's left in the drawer for making change the next day?

    I was going to ask the coffee shop below my office this question - but figured it fit here as well.

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

  2. #2
    PowerPoster
    Join Date
    Feb 2006
    Location
    East of NYC, USA
    Posts
    5,691

    Re: any suggestions? POS system development

    Quote Originally Posted by szlamany
    Here's a question - how do you open the cash drawer in the morning
    Usually any particular business operates by starting the day with the same float (cash on hand), so allow system input to set that as one of the system parameters.
    and close it out in the evening.
    A separate function (I use a separate form). The user counts cash, Amex, MC, etc., and enters each total. I reconcile the entered amounts with what should have been there, and call out any discrepancies in red.
    Code:
    		Counted		Calculated		Difference
    Cash:		$123.45		$123.55		$0.10 [in red]
    Amex:		$100.00		$100.00		$0.00
    etc.
    
    Deposit:		$173.55 (Assuming a $50 float)
    Have a textbox for them to enter the deposit amount (the cash take-out) after they reconcile any differences. Then your calculation will stay in sync.
    How do you account for the take during the day
    A separate function (passworded, maybe?), adding to a total of cash removed during the day. When you rconcile the drawer at the end of the day, you account for that total.
    and what's left in the drawer for making change the next day?
    That's your system param for the float at the start of the day.

    For taking out cash, you should also allow for taken-out cash to be put back (I took out $100 and entered it ... oops, I meant to take out $50), and for the cash take-out to be accumulated during the day, or to be deposited as taken out. (Some businesses make periodic deposits during the day - to the bank or to the safe - others make one deposit after close of business.)

    Add a function to print a deposit slip, even if it's not in a form the bank will accept. It makes it easier for the employee to take the cash, print the slip, then go to the office and write out a real slip.
    The most difficult part of developing a program is understanding the problem.
    The second most difficult part is deciding how you're going to solve the problem.
    Actually writing the program (translating your solution into some computer language) is the easiest part.

    Please indent your code and use [HIGHLIGHT="VB"] [/HIGHLIGHT] tags around it to make it easier to read.

    Please Help Us To Save Ana

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width