How to: Export Electronic Payments
In Microsoft Dynamics NAV, you can export payment journal entries into a file format according to four different payment standards. You must use the following windows to export according to the different payment standards.
| Payment standard | Window to export from |
|---|---|
AEB N34 |
Payment Orders |
AEB N34.1 |
Payment Orders |
E-PAY |
Payment Journal |
SEPA |
Payment Journal or Payment Orders |
Important
Before you can export a payment, you must select a payment format in the Payment Export Format field in the Bank Account Card window.
To export electronic payments using the Payment Orders window
In the Search box, enter Payment Orders, and then choose the related link.
Select the documents that you want to pay.
On the Home tab, in the Process group, choose Export to File.
Payments of type SEPA will be exported to a file immediately.
Payments of type N34 or N34.1 will be exported when you run the Payment order - Export N34 or PO - Export N34.1 report, which automatically opens when you choose Export in step 3.
In the PO - Export N34.1 window, fill in the fields as described in the following table.
Field Description Bank Account No.
Select the bank account from which the payments will be exported.
Settle Date
Specify the date that the export will be transmitted to the bank. This date will be the posting date for the payment journal entries that are exported.
If Posting Date does not match Delivery Date:
Specify if you want to match the settle date, or if you want to skip any payment journal lines where the entered posting date does not match the settle date.
Expenses Code
Specify who is responsible for the payment expenses.
Shared (Only International Transf.)
Specify if you want to share the expenses between the payer and the payee. This is only applicable for international transfers.
Payment Order Concept
Specify the payment order concept, either Payroll, Retirement Payroll, or Others.
Relation
Specify if you want the bank to send you a detailed list of all transfer charges. If you do not select this field, the bank will send the total of all charges for all the transfers made.
Number Of Copies
Specify the number of additional copies of the remittance advice that will be printed by this process. One document is always printed so that it can be mailed to the payee.
Choose Print or Preview to see the created payment file.
The payment journal entries which have the Bank Payment Type field set to Electronic Payment will be exported. The data will be exported to a file that is formatted according the N34 or N34.1 standard format. In addition, remittance advice will be printed, which is suitable for mailing to each payee.
Note
You can only post the payment order after you have successfully exported the electronic payments.
To export electronic payments using the Payment Journal window
In the Search box, enter Payment Journals, and then choose the related link.
Select the documents that you want to pay.
On the Navigate tab, choose Electronic Payments, and then choose Export.
Payments of type SEPA will be exported to a file immediately.
Payments of type E-PAY will be exported when you run the Export Electronic Payments report, which automatically opens when you choose Export in step 3.
In the Export Electronic Payments window, fill in the fields as described in the following table.
Field Description Bank Account No.
Select the bank account from which the payments will be exported.
Settle Date
Specify the date that the export will be transmitted to the bank. This date will be the posting date for the payment journal entries that are exported.
If Posting Date does not match Delivery Date:
Specify if you want to match the settle date, or if you want to skip any payment journal lines where the entered posting date does not match the settle date.
Expenses Code
Specify who is responsible for the payment expenses.
Shared (Only International Transf.)
Specify if you want to share the expenses between the payer and the payee. This is only applicable for international transfers.
Payment Order Concept
Specify the payment order concept, either Payroll, Retirement Payroll, or Others.
Relation
Specify if you want the bank to send you a detailed list of all transfer charges. If you do not select this field, the bank will send the total of all charges for all the transfers made.
Number Of Copies
Specify the number of additional copies of the remittance advice that will be printed by this process. One document is always printed so that it can be mailed to the payee.
Choose Print or Preview to see the created payment file.
The payment journal entries which have the Bank Payment Type field set to Electronic Payment will be exported. The data will be exported to a file that is formatted according to the selected payment standard. In addition, remittance advice will be printed, which is suitable for mailing to each payee.
Note
You can only post the payment order after you have successfully exported the electronic payments.
To export electronic payments from the Cartera module
In the Search box, enter PO - Export N34.1, and then choose the related link.
Fill in the fields as described in the following table.
Field Description Delivery Date
Specify the delivery date of the electronic payment.
Expenses Code
Specify who is responsible for the payment expenses.
Payment Order Concept
Specify the payment order concept, either Payroll, Retirement Payroll, or Others.
Relation
Specify if you want the bank to send you a detailed list of all transfer charges. If you do not select this field, the bank will send the total of all charges for all the transfers made.
Number Of Copies
Specify the number of additional copies of the remittance advice that will be printed by this process. One document is always printed so that it can be mailed to the payee.
Shared (Only International Transf.)
Specify if you want to share the expenses between the payer and the payee. This is only applicable for international transfers.
Note
You can only post the payment order after you have successfully exported the electronic payments.
See Also
Tasks
How to: Set Up Bank Accounts for Electronic Payments
Reference
Payment Orders
Export Electronic Payments
Concepts
Electronic Payments – AEB N34.1