Help somebody please.. getting no responce from other forums!!!

[Simon]

i have a database with the following tables below and am trying to create an
invoice table and create a relationship so that at the end of the month i
take all records that = not invoiced for a given customer and apply an
invoice number.

I have got the customer and deliveries table to work but i am now stuck on
invoice table.

i am creating this database for my fathers dleivery company, so what happens
is a customer may book 5 deliveries a day and these are then invoiced at the
end of the month ( bulk invoice ).

Any help would be appreciated as i am very new to relationship rules etc...

Here are my tables below, don't know if they are correct though..


tblCustomers
CustomerID
LName
FName
Business
Address
Town
PostCode

tblDeliveries
DeliveryID
DeliveryDate
CustomerID
FromCityID
ToCityID
OrderNumber
OrderCost

tblInvoices
InvoiceID
InvoiceDate
InvoiceNumber
CustomerID

 

[Wayne-I-M]

This is quite a complex database you are creating. You need a payments table
and some method of querying the payments against invoice numbers to client.
You need to allow for non-payments (so add this amount to this months
invoices). You need to allow for wrong payments and payments that are
applicable to customer, etc, etc, etc.

The time you spend learning to do this (create this database) would be
better spent learning something like sage accounting - or if you don't like
sage there are "many" application already available for quite a cheap cost.

If you really want to spend your time and effort learning to write a
database application it may be a good idea to start with some less complex
and move up an accounting system later. Don't forget that excel has many MS
template (free) that will do want to you already - and it's much simpler to
learn the basics

Sorry

 

[Simon]

HI Wayne,
Thanks for repsonce, but all i need is the tables mentioned as all we do is
print off the invoices and store the data of the invoice on another table.

We do not process payments etc.. using this system

I just need something like when i raise the invoice and print it the
information is then stored in a table somehow..

 

[Wayne-I-M]

Hi Simon

You some method of recording payments - thats what invoices are for. I
would add
InvoiceAmount and Paymentdate

You can use a simple is not null to the payment date in a query and issue
invoices based on that.
You report could be grouped by month - this would show not paid amounts and
current amounts oweing. Give a total owed in the report (invoice) footer