Summary
How to solve the error “Validation failed: bank_accounts|BA_XXXXXXXX:nominal_code: XXXX - related ledger account with type BANK does not exist.”
Cause
The bank_account_type_id doesn't match with the associated ledger_account_type_id.
Resolution
- Open Sage 50.
- Find the affected ledger accounts.
- Update their Account Class and settings to match the correct type.
Set the ledger account type as follows:
- Bank – Use for checking, savings, cash in hand, or similar accounts
- Line of Credit – Use for credit cards or loan accounts
After updating the ledger account types in Sage 50, rerun the migration tool.
