Accounts payable functionality

The fields as described in the following subsections are available to control the additional functionality for accounts payable.

Save Electronic reporting file to secure location

The below setup can be used for any Electronic reporting file, but the example provided is for a Vendor GER EFT payment. The feature uses the Archive functionality with the following setup steps

• Step 1: Setup Electronic reporting export connection
• Step 2: Setup Document types, using Step 1’s Connection
• Step 3: Setup Electronic reporting destination, using Step 2’s Document type
• Step 4: Setup AP Method of payment and select the Export format configuration from Step 3

Processing: When generating a payment for a method of payment with above GER, the Archive destination is defaulted, and the GER EFT payment file is saved to the assigned connection path.

Step 1 - Setup Electronic reporting export connections

Users can access the page by navigating to Organisation administration > Electronic reporting > Electronic reporting export connections

Select New to create the location where GER file is to be saved. Connection options include FTP/FTPS, SFTP or Azure blob

Field	Description	Example or Options
Name	Enter a name for your connection	ANZ_FTP
Connection type	Select the applicable connection type	• FTP • Azure blob • SFTP
Error action	The action to take when there is an error with the connection	• Error • Warning
Enable file encryption/decryption	Set to Yes if the export file should be encrypted	• No • Yes
Encryption key name	Select applicable Encryption key name. See DXC encryption parameters for additional details.
Enable business event	Option to create an event when file is saved to Azure blob. Setup required: • Set this option to Yes • Active Business event ‘Electronic reporting file exported to azure blob’ • No • Yes

Select Save and the applicable Setup will be displayed as per the Connection type selected

FTP:

Field	Description	Example or Options
Host	Specify the Host for the FTP site Note: FTP:// is not required
Path	Enter the path where the files are to be saved on the FTP site.	/GER_ANZ
Port	Specify the Port for the FTP site	22
Enable TLS	Select to enable FTPS using TLS	• Yes: FTPS • No: FTP
User	Specify the Username used for authentication to the FTP site
Credential type	Select applicable Credential type for FTP site	• Key vault • Database
Password	Enabled when Credential type is set to Database. Specify the Password used for authentication to the FTP site. Note: this is encrypted and displayed as •••••••••• within the form.
Key vault certificate	Enabled when Credential type is set to Key vault.	Select the applicable Key vault certificate.

Azure blob:

Field	Description	Example or Options
Container name	Specify the blob storage container
Credential type	Select applicable Credential type for Azure blob	• Key vault • Database
Storage account name	Enabled when Credential type is set to Database
Storage account key	Enabled when Credential type is set to Database
Connection string	Enabled when Credential type is set to Key vault

SFTP:

Field	Description	Example or Options
Host	Specify the Host for the SFTP site Note: SFTP:// is not required
Path	Enter the path where the files are to be saved on the SFTP site.	/GER_ANZ
Port	Specify the Port for the SFTP site	22
Enable TLS	Select to enable SFTP over TLS	• Yes: SFTP over TLS • No: SFTP
User	Specify the Username used for authentication to the SFTP site
Credential type	Select applicable Credential type for SFTP site	• Key vault • Database
Password	Enabled when Credential type is set to Database. Specify the Password used for authentication to the SFTP site. Note: this is encrypted and displayed as •••••••••• within the form.
Key vault certificate	Enabled when Credential type is set to Key vault.	Select applicable Key vault certificate.

Validate connection

Use button Validate connection to validate the following:

• Connection details
• Export path or container

Step 2 - Setup Document types

Users can access the page by navigating to Organisation administration > Document management > Document types.
Select New to create the Document type and assign the Electronic reporting export connection created in step 1.

Field	Description	Example or Options
Type	Enter the type	Example GER
Name	Enter a name for the document type
Class	Select Attach file	• Attach file • Attach URL • Simple note
Group	Select File	• Note • File • Image • Document • Worksheet • URL
Category	Select a Category	• None
Location	Not used, select any	• Azure storage • Database • SharePoint
SharePoint address	Not used
Remove	Document and physical file
Ask for confirmation	Should confirmation be requested priori to removing the file	• Yes • No
Electronic report export connection	Select the Electronic reporting export connection setup in step 1	Example ANZ_FTP

Step 3 - Electronic reporting destination

Users can access the page by navigating to Organisation administration > Electronic reporting > Electronic reporting destination.
Select New on the Action Pane to create an Electronic reporting destination for the selected GER and allocate Document type created in step 2.

Field	Description	Example or Options
Reference	Select the Electronic reporting Reference	Example ‘ANZ Direct Credit Service (AU)’
Select New on the File destination FastTab
Name	Enter name for the destination
File component name	Select PaymentFile	PaymentFile
Stop processing on failure	If enabled and there are errors when saving the file to location, vendor payment processing Generate payment will create a file and attach to the job. The Payment status will remain None	• Yes • No
Select the Settings button on the File destination FastTab and select the Archive tab
Enabled	Enable the Archive destination	• Yes • No
Save in job archive	Enable saving	• Yes • No
Type	Select the Document type created in step 2	Example GER

Step 4 - Method of payment

On the selected Method of payment, enable Generic electronic Export format, and in the Export format configuration field select the Reference from step 3.

Processing

Vendor payment processing using the above method of payment is discussed at Processing