Creating an invoice (beginner question)

[Guest]

I am using a modified northwind databse.
I just have one problem, i want to modify it that i can set it up that i can
choose it to be either a "proforma" invoice or a final invoice. (i want to
be able
to have multiple proforma invoices). And then i want to be able to lets say
ask for the copmuter to show me all the final invoices from past, or just all
the diffrent proformas this particular order went thru. what would be the
best way to go about this.
And they will all share the same order number so i can track the diffrent
steps the invoice went in. so i can tell the computer to print up all
diffrent versions of the invoice.

thankx

 

[Guest]

This question answered on 12/31. See:

http://groups-beta.google.com/group..._frm/thread/c043086453b89c2a/c4060c3db9a884f9

Please maintain a single thread.

Tom
________________________________

 

[Mike Painter]

I am using a modified northwind databse.
I just have one problem, i want to modify it that i can set it up
that i can choose it to be either a "proforma" invoice or a final
invoice. (i want to be able
to have multiple proforma invoices). And then i want to be able to
lets say ask for the copmuter to show me all the final invoices from
past, or just all the diffrent proformas this particular order went
thru. what would be the best way to go about this.
And they will all share the same order number so i can track the
diffrent steps the invoice went in. so i can tell the computer to
print up all diffrent versions of the invoice.

Ouch.
Invoices are just reports, so the first question is what differentiates the
underlying data to make it proforma or final?
Will a proforma invoice look a lot different or will it just have some text
that tells what it is?

I suspect the order number table will end up with a two part key.
OrderNumber*InvoiceNumber and the invoice header will have a Boolean field
for proforma or final.
Each "Invoice " would have to be separate for what you want.

It should be interesting.