Skip to main content

Steps to Resolve the Bank Transactions Import Error

Jun Wang Profile Picture Jun Wang 3,827 Super User

 The issue involves an error encountered while importing bank transactions into Microsoft Dynamics 365 Business Central Cloud. The error message indicates that the "Journal Batch Name" specified in the import file, "xyz," does not match any existing General Journal Batch names in the system. The solution requires either adjusting the batch name in the import file to match an existing one in Business Central or creating a new General Journal Batch with the name "xyz" in the system.

Steps to Resolve the Bank Transactions Import Error

  1. Verify the Batch Name in Your Import File:

    • Open the CSV or import file you are using.
    • Check the column that specifies the "Journal Batch Name" and confirm if the name “xyz” is listed.
    • Ensure there are no typos or extra spaces in the batch name.
  2. Check for Existing Batch Names in Business Central:

    • Go to Finance Management > General Journals.
    • Select or open any existing journal, and look for the batch name selector to view available batches.
    • Verify if “xyz” exists in the list.
  3. Create or Modify a General Journal Batch:

    • If “xyz” does not exist, you can create a new General Journal Batch with this name:
      • Navigate to General Journals, and open the batch list.
      • Choose New to create a new batch.
      • Enter “xyz” as the batch name and fill out the necessary details.
    • Alternatively, if adjusting the import file is easier:
      • Modify the import file to match the name of an existing batch in your Business Central setup.
  4. Re-import the Bank Transactions:

    • After ensuring the batch name is correct in either Business Central or your import file, attempt to re-import the bank transactions.
    • Monitor for any errors during the import process.
  5. Troubleshoot Further if Necessary:

    • If the issue persists, check the error log for more details.
    • Consider reaching out for support through the Business Central help system or consult a BC expert if the problem is complex.

Additional Tips

  • Validation: Always validate data in your import files before attempting to import, to avoid similar issues.
  • Documentation: Maintain a log of batch names and other setups in Business Central for easy reference.

Following these steps should help you resolve the issue with importing bank transactions by ensuring the journal batch names in your import file and Business Central align correctly.

Comments

*This post is locked for comments