Error whilst evaluating field [BankCode] on transaction type [PaymentBatch]. (1 reply)
This error occurs where there is no mapping entry for the Payment Type/Currency combination.
Your specific error is due to a missing entry for APCHECK (Employee Paid) & ZAR (South African Rand) transactions.
To resolve:
- Go to the Setup tab, select Lookup Table Maint. from the left hand menu and then select the Bank Translation from the drop down list.
- Double click the empty row at the top of the grid to create a new entry.
- Enter the mapping per the attached screenshot. Leave the Bank Code empty (employee paid expenses do not have a payment element) by entering a single space; set A/P to 'True' and you can opt to enter a Default G/L Code or not.
Then try re-running the import.
Hi, we get the following error when running an import.
Error whilst evaluating field [BankCode] on transaction type [PaymentBatch]. Resolved Function - Lookup("CONCEXPBNKX3", "LKUPRESULT"= "APCHECK-CASH-ZAR", True) Error - Description: No results were returned by the lookup.