How to generate bill?

[german]

Hi

i have a table called Smp which contains the details like fat,customer name, snf and the date .

i want to generate the bill once in 15 days for a particular customer.And it should not allow me to generate for the same vendor for the same date more than once.

how to do it?

Is there any specific method?

 

[jdraw]

Put 2 fields on the VendorBill Table

BillGeneratedDate Date/Time
HasBeenGenerated Yes/No

In the generateBill process update these fields with proper values.

Always check the HasBbeenGeneratedFlag, before printing,
Based on your 15 days condition check the BillGeneratedDate with the CurrentDate.

Just a few ideas to consider.

 

[german]

thank you so much j draw.

i have only one table.i have to create a table for bill.i have a report for bill.

in another table i have the customer name and date1 date2 and status.