General Ledger Export To BPAY

System can generate BPay file based on CommBizz file specification version 6 (April 2011). The file can be downloaded here.

Warning: This function has not been used for some years and will not work with current setups. Contact your Account Manager to discuss using this function.

Records will only be selected for file creation if Reg or CTP Renewals batches:

are Posted
have BPAY checkbox ON
have not been exported previously

Create Export Files

Click on the 'New' tab
Click 'Create'
Click 'Export'
Save the csv file for import into your Banking software
Click 'Edit'
Update the status from 'pending' to 'exported ok'
Add any notes if required

The 'create' action flags the relevant transactions as exported and will not be duplicated in any subsequent 'create' actions.

Copies of exported files can be re-created anytime by using the search icon and selecting the relevant file.

Filters

Filter	Type	Description	[table]field
BPAY ID	Lookup	Lookup or enter the batch number of an existing batch.	`[gb_bpay]bpay_id`

Buttons

Button	Type	Description
Image:New.gif	Button	Click this when you want to create a new batch.
Image:Create.gif	Button	Will be active when data is available to create a batch. Click to create.
Image:Cancel.gif	Button	Click to return to the BPAY screen without creating a batch.

Field Descriptions

Field	Type	Description field	[table]field
BPAY ID	Display	Blank for new batch. Displays ID when reviewing an existing batch.	`[gb_bpay]bpay_id`
Bank Account	List Box	Auto-populates if one exists; otherwise shows selectable list.	`[gb_bpay]bank_account_id`
Control Invoices	Number	Number of invoices to be paid (payments and/or approvals).	`[gb_bpay]control_invoice_count`
Control Items	Number	Number of rows in selection for approvals and payments.	`[gb_bpay]control_item_count`
Control Total	Number	Total amount of the batch.	`[gb_bpay]control_total`
Created	Timestamp	Timestamp of when batch was created.	`[gb_bpay]created`
By	Display	User login of who created the batch.	`[gb_bpay]user_id`
Status	List Box	Displays the status of the batch.	`[gb_bpay]status_flag`
Notes	Text	Record any useful information.	`[gb_bpay]notes`

Validations and Alerts

Alert	Message	Comments
New	No payments found for Bank Account: {account_name} Company {company_id}	No records available to disburse. Check: - Payments or claims are posted - Payment Method = BPAY - Payments not already made - Contracts match selected company

BPAY File Header Record

Field #	Type	Field Name	Length	Format	Mandatory	Description
1	N	Record Type	2		Yes	"01"
2	N	File Creation Date	8	YYYYMMDD	Yes	The date the file was created
3	N	File Creation Time	6	HHMMSS	Yes	The time the file was created
4	N	File Number	3		Yes	Sequential number of file. Could commence at '001' each day
5	N	Payment Account	20		Yes	The account number of the funding account
6	N	Payment Date	8	YYYYMMDD	Yes	The date on which the payments are to be made. Can be up to 15 months into the future from the lodgement date. If left blank, will default to the date the file is submitted
7	N	Number of Payment Records	6		Yes	The number of payments in the file
8	N	Total Amount of Payments	12		Yes	The total amount of payments in the file, in cents

BPAY File Payment Details Records

Field #	Field Name	Length	Type	Mandatory	Description
1	Record Type	2	N	Yes	"50"
2	Payment Instruction Type	2	N		empty
3	BPAY Transaction Type	1	N		empty
4	Payer Institution Code	3	A		empty
5	Payment Account Detail	20	AN		empty
6	Country of Payment	3	A		empty
7	State of Payment	3	A		empty
8	Currency Code of Payment	3	A		empty
9	Biller Code	10	N	Yes	The BPay Biller Code of the beneficiary of the payment
10	Service Code	7	N		empty
11	Customer Reference Number	20	N	Yes	The account number, reference number, etc of the account that is being paid
12	Number Method	3	N		empty
13	Entry Method	3	N		empty
14	Amount	12	N	Yes	The amount of the payment, in cents (+gst_cost)
15	Transaction Reference	21	AN		empty
16	Number Reference	21	AN		empty
17	BPAY Settlement Date	8	N		empty
18	Date Payment Accepted	8	N		empty
19	Time Payment Accepted	6	N		empty
20	Payer Name	40	A		empty
21	Additional Reference	20	A		empty
22	Code Correction Reason	3	N		empty
23	Discount Method	3	A		empty
24	Discount Reference	20	A		empty
25	Discretionary Data	50	A		empty

Click here for pdf version.

Useful Queries

select c.contract_id, pm.posting_map_group, c.company_id, m.maintenance_id, m.batch_no, m.item_no, bi.bpay_flag, bi.bpay_biller_code, t.bpay_id from fm_maintenance as m inner join fm_contracts as c on c.contract_id = m.contract_id inner join gl_posting_maps as pm on pm.posting_map_id = c.posting_map_id inner join gl_batch_items as bi on bi.record_id = m.maintenance_id inner join gl_transactions as t on t.batch_no = m.batch_no and t.item_no = m.item_no group by m.maintenance_id order by maintenance_id desc limit 4;