Skip to main content
Answer

Error in Import Bank Transaction

  • April 16, 2025
  • 5 replies
  • 118 views
S
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. 

    harutyungevorgyan

    5 replies

    valentynbeznosiuk
    Jr Varsity I
    Forum|alt.badge.img+3

    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.

     

    Valentyn Beznosiuk || Business Analyst / Acumatica ERP Consultant at ACUPOWER LTD || www.linkedin.com/in/valentynbeznosiuk
    Chris Hackett
    harutyungevorgyan
    rimamanaseryan16
    harutyungevorgyan
    Jr Varsity I
    Forum|alt.badge.img+2

    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?

    🛠 Senior Software Engineer at AcuPower LTD | ⛓️‍💥➡️linkedin.com/in/har-gevorgyan | ⛓️‍💥➡️https://www.nuget.org/packages/AcuSharp
    Chris Hackett
    valentynbeznosiuk
    rimamanaseryan16
    S
    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,

     

    Manikanta Dhulipudi
    Captain II
    Forum|alt.badge.img+15

    ​@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. 

    Acumatica Functional Consultant & Customer Experience Supervisor
    Chris Hackett
    harutyungevorgyan
    harutyungevorgyan
    Jr Varsity I
    Forum|alt.badge.img+2

    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.

    🛠 Senior Software Engineer at AcuPower LTD | ⛓️‍💥➡️linkedin.com/in/har-gevorgyan | ⛓️‍💥➡️https://www.nuget.org/packages/AcuSharp
    Chris Hackett
    valentynbeznosiuk
    rimamanaseryan16
    Terms & ConditionsCookie settingsAccessibility 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