Direct Debit/Standing Order List

Introduction

You may want to record some details for BACS transfers, Direct Debits etc. Where to store this?

You could use the client/animal sheets but those are difficult to extract specific information from; you could use one of the telephone number fields but those are too easy to access and edit and are limited in number.

Generally you will want to record, Sort Code, Account number, monthly/weekly amount, SO or DD, start date etc.

This is confidential data and you must make sure only authorised people have access to it.

One of the best option is to use the 'Custom Screen', this allows you to add the information you want; it can be reported on easily via DataMajor and has different levels of access.

Setup

You need to work out what information you need to store, next add this to the 'Custom Screen';

Menu -> Systems Management -> Setup -> Parameters -> Fields & Defaults -> Custom Screen

This will display a text box, add in the name of the fields you want, and the '<' and '>' with spaces between them for the answer. See screen shot below and release notes.

Once you have entered the brackets, add 'T' for text, 'N' for number etc. so in the example above we have:

Field Type

Sort Code Text

Account Number Number

Amount Number

Type Text

Start Date Date

Field	Type
Sort Code	Text
Account Number	Number
Amount	Number
Type	Text
Start Date	Date

When you are happy with the fields, press <ESC>. Remember you can always add additional information later - you just can't take it away!!.

Access Permissions

Set the access permissions for the staff who should be able to look at the information, who can edit the information - use the table below to adjust the settings.

141 Does the 'Custom' 'SQL' option appear on the menu.
143 Can the user access 'Custom'
142 Does the user have permission to Edit the details

141	Does the 'Custom' 'SQL' option appear on the menu.
143	Can the user access 'Custom'
142	Does the user have permission to Edit the details

Accessing the Custom Screen

From the animal records, select the 'A'dditional screen then 'C'ustom.

DataMajor

As the custom screen is fully configurable the best way to report on the data is via DataMajor.

The system will create DataMajor columns for each field, it will add 'CS' to the name and replace the spaces with an underscore. So using our example the column names are:

Field DataMajor Column

Sort Code CS_Sort_Code

Account Number CS_Account_Number

Amount CS_Amount

Type CS_Type

Start Date CS_Start_Date

Field	DataMajor Column
Sort Code	CS_Sort_Code
Account Number	CS_Account_Number
Amount	CS_Amount
Type	CS_Type
Start Date	CS_Start_Date

These can be accessed via any ODBC link, Crystal reports, Microsoft Query, Excel etc. We have included a sample script (see below) which you can also edit via the DataMajor Utility Menu.

Sample DataMajor script

## List of Bank details. Use this as a template for your own reports.
## See: http://www.premvet.co.uk/premvet/faq/bacs.html
## If you have NOT setup the custom screen this may give errors.
## On the system as bacs.sql - run as a manual job.

SELECT 
 a.pvid as 'Ref',
 o.surname as Surname,
 a.animalname as 'Animal',
 a.animalbalance as 'Balance',
 cs_sort_code as 'Sort Code',
 cs_account_number+0 as 'Account',
 format(cs_amount,2) as 'Amount',
 cs_start_date as 'Sart Date',
 upper(cs_type) as 'Type'
FROM animal a, client o
WHERE cs_sort_code is not null
AND o.clientkey = a.clientkey ;