Final Filer Software

The complety free database management system for cemeteries & crematoria

Reports- pre-defined variables and constants

There are a number of pre-defined variables that can be used in report designs to enhance  and track reports as they are generated.

The current list is

Variable Name

Type

Description

EmployeeName

Report or Script

If the employees table is active this variable contains the current logged on employee's name

EmpoyeeTitle

Report or Script

If the employees table is active this variable contains the current logged on employee's title (Manager etc)

StatusLogMessage

Report

If declared, this variable's assigned data is recorded in the respective register record's Status Message Log.

For example, if you assign  “First follow up letter printed” to the Status L

Category

Report

If declared, this variable's assigned data is used as the CATEGORY under which the Status Log Message is recorded in the respective register record's Status Message Log

RegisterDataID

Script

Assign the current register data record's ID to this variable. You should do this in the report's MASTDATABAND On Print event.

The Final Filer needs this value to record status log messages

Sqlstr

Script

The Final Filer Pro uses this variable to pass the SQL WHERE

OrderID

Script

When creating purchase order reports, this variable contains the current purchase order's ID

OrderItemID

Script

When creating purchase order reports, this variable contains the current purchase order transaction's ID

InvoiceID

Script

 

TransactionID

Script

 

confirmservicebbooking

Script

If set to TRUE this variable will force the Final Filer to set the Register Record's “Acknowledgment” check box to on. A status log message is also written under the category “Service Confirmation”

acknowledgeservicebbooking

 

Same as “confirmservicebbooking”, but infers a lower priority

savepdfcopy

 

Saves a PDF copy of the report to the current register record

Certificate

 

Sets a “Certificate Printed” flag

Contribute!