producing Invoices

[Rani]

hi guys I have an issue
I need to produce invoices for contracts, I have the contract date, the
amount paid per month, and the contract status (open/close) I want to create
a batch that will pass threw all the contracts and will issue invoices
registering the last date an invoice was issued.

any idea will be most welcome.

Thanks

 

[Bonnie]

I would just create a report (invoice) with a query that
filters based on which contracts you want invoiced.
Update the last invoiced field by running a Macro after
running the report (invoices) with the command SetValue
that puts the system date as the value after running the
invoices.

 

[Kelvin]

Do you mean you want to print all invoices that were not printed the last
time? If so, then add another field (Date/Time) to your table. Create a
query on your table with the criteria for this new field set to "Is Null".
That way only invoices not already printed will show. Then create an update
query that will set this blank date field to the current date. Depending on
how you call your report, add code to call this update query after it
prints.

Kelvin

 

[Rani]

is there any sample around for such a process ?

Do you mean you want to print all invoices that were not printed the last
time? If so, then add another field (Date/Time) to your table. Create a
query on your table with the criteria for this new field set to "Is Null".
That way only invoices not already printed will show. Then create an update
query that will set this blank date field to the current date. Depending on
how you call your report, add code to call this update query after it
prints.

Kelvin

 

[Kelvin]

I don't know of any, but if you'd like I can create a small sample database
and email it to you.

Kelvin

 

[Rani]

that would be highly appreciated.

I don't know of any, but if you'd like I can create a small sample database
and email it to you.

Kelvin

Create

 

[Rani]

and my mail is (e-mail address removed)

I don't know of any, but if you'd like I can create a small sample database
and email it to you.

Kelvin

Create