Receipt/invoice database

[eyalco]

Hi guys.
I'm building a receipt/invoice database - I've started with the invoice first, then the receipt.
I have invoice = parents and sons + receipt = parents and sons tables + a customer table.
I want to issue 1 receipts with 12 checks (for each month of the year) and then, everytime a check comes to delivery, the invoice gets hout with the receipts number.

What would be the relation between the receipt/invoice tables and how do I make the relevanr receipt number for each invoice please?

Thanks.

 

[David Eagar]

I think the common link in all this is the Customer table. The receipts & invoices should be one to many fom this table

 

[eyalco]

Thanks.
Will that address the fact that I need the invoice and receipt to be linked together?
How will I create the receipt number in the invoice ?
Thanks.

 

[David Eagar]

I'm pretty flakey in how finance actually works - my simplistic view is map out the interactions with the Customer, this should give you a flow of what generates what
Also, do some searches of the forum, there are some real experts lurking here

 

[ajetrumpet]

I have invoice = parents and sons + receipt = parents and sons tables + a customer table.
I want to issue 1 receipts with 12 checks (for each month of the year) and then, everytime a check comes to delivery, the invoice gets hout with the receipts number.

I'm not sure I understand what you're really doing here, but from what I've gathered, you're paying on one invoice 12 times in one year? One payment every month?

Regardless though, I can give you a few thoughts on what I have done for invoicing and payments:

1) linked the invoice table with the vendor's table (invoices on the many side)
2) linked the payments table with the invoice table (payments on the many side)
3) after payments come in, and are entered into a form, use an UPDATE statement upon confirmation of the receipt to update the vendor's balance in the vendors table.

What would be the relation between the receipt/invoice tables and how do I make the relevanr receipt number for each invoice please?

Maybe you're talking about invoicing someone else, and receiving payments from them. And if you are, the process would be the same, just different table names.

 

[uhaditcomin]

Receipt Database

I am fairly new to access but I am faced with having to make a database which shells out a receipt (on one of those rolling paper printers like a cash register)

The idea is for selling top-up codes for recharging voice calling accounts
So basically what I want to do is load the codes into the database
There are 1000 of $10 value, 1000 of $20 value, $1000 of $50 value and 500 of $100 value

When a client comes in to buy a top up, the database is used, the type of top up is chosen (ie $10, $20, $50, $100), the quantity is also chosen (so a client can ask for 1, or more of a particular code, or could ask for 1 x $10 and 2 x $20 for example)

Client details are not required to print on the receipt or coupon but could be taken just as a record tracker- Their name, account number and or phone number)
Once all detail is entered a receipt is printed (I call it a receipt but its more like a coupon really). It should print on the rolling paper printer (like the cash register type) and display simple details for example

**************************
COMPANY NAME GOES HERE
**************************
Date: --|--|----
Time: -- -- am or pm
Top Up Value: $--.--
Receipt #: --------

Top Up Code: xxxxxxxxxxxxxxxx


Instructions for use:
---------------------------------
To add top up value dial *07 &
follow voice prompts or what-
ever other text needs to be put
here.

**************************
THANK YOU FOR YOUR PURCHASE
**************************


ANY IDEAS HOW TO GET THIS STARTED/?

 

[ajetrumpet]

I have several reports that were manually designed by me, so what you have posted here would be no different, as far as I'm concerned. Do you want to make a report, and have that report page printed on the paper? Is that what you're doing here?

If so, I would manually design a report to reflect what you have posted. It wouldn't be too difficult either, because from what I see of your design, all you would need from the program are some basic functions (string extraction, date/time, calculation) to supplement the variable values. Other than that, you can manually place the instructions (and other fixed values / strings) where you want and fix them to the location, since they don't change very often.