Accounts, invoices and statements

[oliverdempsey]

Hi there,
I am developing an accounts package based on the Northwind template and I want to add a facility for printing statements at the end of each month.

I am wondering what is the conventional approach to this type of project.
Receipts,
create a new table for receipts?
Credit notes,
Create a table for credit notes or put them in as negative entries in the order details table?
Statements,
How would I create a query to list all transactions for each customer from two or three tables ('order details', 'credit notes' and 'receipts') or is this possible?

Regards
Oliver Dempsey

 

[DougAtAvalon]

If the tables's relationships are set just use the deesign mode for a queary, add the three tables, choose fields, and put in your criteria use the fllowing for prompting:

Earliest Date: [Type in earliest Date ] etc . . .

 

[Guest_imported]

Hi Doug,
I had already tried that and had no success. Have a look at

http://www.barrowvale.com/accounts

to see screenshots of what I have done so far. You will notice at No. 5 where I tried to create a query with the orders and receipts tables, but with no success.

Have a look and see if you can solve my problem

Regards
Oliver Dempsey