producing Invoices

  • Thread starter Thread starter Rani
  • Start date Start date
R

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
 
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.
 
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
 
is there any sample around for such a process ?

Kelvin said:
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
Click to expand...
 
I don't know of any, but if you'd like I can create a small sample database
and email it to you.

Kelvin
 
and my mail is (e-mail address removed)

Kelvin said:
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
Click to expand...
 
Back
Top