Skip to main content
Solved

Error in Import Bank Transaction

  • Apr 16, 2025 8:29 AM UTC
  • 6 replies
  • 240 views
  • Translate All
Freshman I

Hi Team,

Issue Summary:
When attempting to save or process a bank transaction record under “Import Bank Transactions” in Acumatica, the system displays the following validation error:
"Payment Date cannot be empty."

Steps to Issue Summary:

  1. Navigate to Cash Management > Process Bank Transactions.
  2. Import a bank statement using a defined Import Scenario.
  3. Attempt to save or process a transaction line.
  4. The error appears: "Payment Date cannot be empty."

Refer to the below error message,

 

 

Thank & Regards,

Sanjana Perera

 

 

 

 

Best answer by Manikanta Dhulipudi

​@sanjanaperera94 

Could you please share the Import scenario.

 ensure the payment date is correctly entered and that the import scenario is configured to handle dates appropriately. 

View original

      6 replies

      valentynbeznosiuk
      Varsity I
      Forum|alt.badge.img+7

      Hello ​@sanjanaperera94 ,

      Could you please try one more time? After receiving the error message, open Tools (in the top right corner) → Trace and make screenshots of the Exceptions text. This may help you understand why it’s happening.

       

      Translate
      Valentyn Beznosiuk | Acumatica MVP 2026 | Acumatica Consultant & Business Analyst at Acupower ㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤ www.linkedin.com/in/valentynbeznosiuk
        harutyungevorgyan
        Jr Varsity I
        Forum|alt.badge.img+4

        Hello ​@sanjanaperera94 ,

        Are you sure you're not missing any values for the "Payment Date" (MatchingPaymentDate) or "Tran. Date" (TranDate) fields?
        Could you also share the structure of the import scenario you're using?

        Translate
        MVP 2026 🏆 | 🛠 Senior Software Engineer at AcuPower LTD | ⛓️‍💥➡️linkedin.com/in/har-gevorgyan | ⛓️‍💥➡️https://www.nuget.org/packages/AcuSharp
          Freshman I

          This incident only happened to one bank, and other banks can do bank reconciliations. Furthermore, there is no column to enter payment date data.

          See the screenshot below,

           

          Translate
          Manikanta Dhulipudi
          Captain II
          Forum|alt.badge.img+16

          ​@sanjanaperera94 

          Could you please share the Import scenario.

           ensure the payment date is correctly entered and that the import scenario is configured to handle dates appropriately. 

          Translate
          Acumatica Functional Consultant & Customer Experience Supervisor
            harutyungevorgyan
            Jr Varsity I
            Forum|alt.badge.img+4

            This incident only happened to one bank, and other banks can do bank reconciliations. Furthermore, there is no column to enter payment date data.

            See the screenshot below,

             

            ​@sanjanaperera94 ,
            Tran. Date is enough, could you show the value inside Tran. Date column?
            In addition, as I suggested earlier, and as ​@Manikanta Dhulipudi also suggested, please share the import scenario structure.

            Translate
            MVP 2026 🏆 | 🛠 Senior Software Engineer at AcuPower LTD | ⛓️‍💥➡️linkedin.com/in/har-gevorgyan | ⛓️‍💥➡️https://www.nuget.org/packages/AcuSharp
              Freshman I
              • bedrettin
              • Freshman I
              • Jul 26, 2026 1:25 AM UTC

              Hello,

               

              I receive same error message, when I try to upload the transactions. Do you have an idea?

              Error: Inserting  'Bank Transaction' record raised at least one error. Please review the errors. Error: 'Payment Date' cannot be empty

              thank you

              Translate
              Terms & ConditionsAccessibility statement
              About Acumatica ERP system
              Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
              © 2008 — 2024  Acumatica, Inc. All rights reserved