Payment Journal Export

Use this guide to configure and verify bank-specific payment export from Payment Journal.

Outcome

After this guide:

1. Each bank account uses the correct export format and processing codeunit.
2. Vendor banking master data supports successful export.
3. Test exports produce the expected output format.

Supported Export Formats

Bank / Format	Codeunit	How it runs	Output
FNB	EFTExportFNB_BANK_LINC	Standard Export action	Bank-specific file or API transmission when file type is API
ABSA	EFTExportABSA_BANK_LINC	Standard Export action	Bank-specific file
Standard Bank	EFTExportSTD_BANK_LINC	Standard Export action	Bank-specific file
Nedbank	EFTExportNED_BANK_LINC	Standard Export action	Bank-specific file
Capitec	EFTExportCapitec_BANK_LINC	Standard Export action	Bank-specific file
Netcash	EFTExportNetcash_BANK_LINC	Standard Export action	Bank-specific file
Investec	EFTExportInvestec_BANK_LINC	Standard Export action	BulkPayment._Investec.csv
Moneycorp	EFTExportMoneycorp_BANK_LINC	Export to Excel action	Excel .xlsx file

Before You Start

1. Confirm app subscription is active.
2. Confirm each vendor has a Preferred Bank Account Code.
3. Confirm each preferred vendor bank account has Bank Account No., branch, and account type data.
4. Decide whether each bank uses file export or API flow.

Step 1: Configure Vendor Master Data

1. Open Vendor Bank Account Card for all vendors in payment batches.
2. Populate mandatory bank details.
3. Set any format-specific fields required by your target bank.
4. Confirm vendor Preferred Bank Account Code points to the intended bank account.

Pass criteria:

1. No export-bound vendor is missing required banking fields.

Step 2: Configure Bank Export/Import Setup

1. Open Bank Export/Import Setup.
2. For each bank format in use, set the matching processing codeunit.
3. Set file type as required for that bank process.
4. Save.

Pass criteria:

1. Active export formats have correct codeunit mapping and file type.

Step 3: Link Bank Account Card to Export Format

1. Open Bank Account Card for each payment bank account.
2. Set Payment Export Format to the correct setup record from Step 2.
3. Save.

Pass criteria:

1. Every payment bank account points to the intended export format.

Step 4: Configure Moneycorp-Specific Settings When Applicable

1. Open Bank Integration Setup and enter Moneycorp Client ID.
2. On Vendor Bank Account Card, set Moneycorp Account Type as Standard or Express.
3. Save.

Pass criteria:

1. Moneycorp settings are complete for all intended payments.

Step 5: Run Controlled Test Export

Standard bank formats:

1. Create a small Payment Journal test batch.
2. Run Export.
3. Confirm output is created in expected format.

Moneycorp:

1. Create a small Payment Journal test batch.
2. Run Export to Excel.
3. Confirm .xlsx file is generated and contains expected columns and values.

Pass criteria:

1. Export action succeeds.
2. Output matches target bank format.

Completion Checklist

The setup is complete when all checks below are true:

1. Vendor master banking data is complete.
2. Export setup codeunit and file type mappings are correct.
3. Bank accounts are linked to the right export format.
4. Test export succeeds for each format in scope.