Hi,

I would like to create a invoice reminder, so if some bills are older then 30 days. I would to see it as a reminder.

So plz tel me how or if some1 knows a good tutorial sit.

Cheta

Hi cheta,


A way to do this is to create a few simple fields and calculations.
You don’t say what version of FM you are using but in FM7 or 8 do the following.

Field names I have used as examples only.

Presume you already have an invoice date formatted as a date e.g.

Invoice_date

1 Create a field called
Invoice_date_num
This is a calculation field which you set equal to the Invoice_date but return the result as a number.

2 Create a field called
Todays_date_num
This is a calculation field using the FM ‘Get’ function as follows:

Get (CurrentDate)

Return the result as a number and make sure the result is ‘Unstored’ in the Storage Options… dialogue box.

3 Create a field called
Inv_over_30

this calculates the difference in days between the invoice date and the current date as follows:

Todays_date_num - Invoice_date_num

Again this is an unstored number as a result. This will give you the ‘age’ of the invoice. This is a field you can also search on/use to work out average debtor days etc.

4 If you want you can add a message calculation or some kind of visual flag so that you can see what invoices are over 30 days and/or use in scripts etc. e.g.

Create a field called
Inv_over_30_warning

If(Inv_over_30 > "30"; "Payment overdue.";"")

The result should be set to Text and unstored.

Hope this is of help.

Or, make one calculation field:

Case ( Get (CurrentDate) - InvoiceDate > 30 ; "Overdue" )