EPE - Banking and Electronic Payment
Set up bank accounts
The first setting when creating a bank account is the number series. Entering the search bar No. Series.
After that enter in the search Electronic Payment menu. Action New will open a new bank card.
How to set up bank accounts
It is necessary to set up bank accounts – posting groups, currency, account number, no. series, source codes. For each bank you can set up General journal template , defining type – Electronic payment, Bal. Account type – Bank account, No. series, and Source code.
You can set up General journal batches for each bank:
- Copy VAT setup to journal lines (whether the program calculates VAT for accounts and balancing accounts on the journal lines of the selected journal batch)
- Insert XML data ports requires to complete setup, depending on bank client, both for file imports and exports
No series and XMPL port need to be entered on General Journal Batch.
Payment suggestions
How to create vendors payment suggestion
Go to Electronic payment menu . Select bank you want to work with. Next step is to choose Preparation - El. payment journal will open. Choose option Prepare/Suggest vendor payments . In new window, define important filters:
- Last payment date : Last invoice date that will be included in payment suggestions; all entries before that date and on the date will be included
- Use vendor priority : if there are limited payment funds, type in Available amount LCY and along with this filed the system will suggest lines by priority until this limit is entirely used
- Posting date
- Summarize per vendor : activate this option if all vendor entries need to show as summarized in one line
- New doc. no. per line - type manually if no. series are not set up If there are already suggested lines in other journal batch, the system will show warning, escaping the possibility to have duplicated payments:
Vendor payments confirmation
Next step is to select and confirm lines for payment. If all the lines need to be selected, choose Related/Payments/Confirmation :
Payment lines will be found in Confirmation at the Electronic payment menu:
How to create employee payment suggestion
Similar to Vendor payment suggestion, go to Electronic payment menu, choose Preparation :
- Suggest Vendor Payments.
- Suggest Employee Payments.
Next thing to fill in is the request page
Payment import and export files
How to export payment journal lines file
After the payment lines for vendors and/or employees are confirmed, these can be exported as txt. file, ready for import within the electronic payment app.
To export this file, go to Confirmation/Related/Payments/E-Payment export :
How to import bank statement
From Electronic payment menu select Statement :
Next, go to Related/Payments/E-payment import
New window will appear, choose file for import (previously exported from el. payment app). During importing process, the system searches for customers/vendors by bank account. If there is no bank account on customer/vendor card, there will be a notification warning.
Even though some customer/vendors have not been found, all the transaction will be imported. Depending on side (Debit/Credit), the system will choose Account type (Vendor or Customer) leaving account no. empty if those lines have not been found.
If payment needs to post as prepayment, there is a filed Prepayment that has to be checked.
Vendor and customer ledger entries that are found by credit reference no. will be selected for application in "Applies to doc. no". If desired, further entries application can be completed through this journal.
After regular control of the statement, it can be posted through "Post" action on header.
Sales & Receivables Setup
On the Sales & Receivables Setup page there is a field Def. Credit Ref. Formula Code. The field is adjusted and the formula is defined for further recognition. The field will be filled in on sales invoices and on posted sales invoices.
To create a code, choose select from full list.
- Code name is entered
- Enter the description for the code
- Model - it can be filled in, it is not a mandatory field
- Formula - gives us a list where we can choose parameters
- The maximum number of parameters allowed to be selected
Sales invoices - Invoice Detailes 
Posted sales invoice - Invoice Detailes 
The Credit Reference No field will also be filled in on the statement. When importing txt format.