Skip to main content
Solved

How to create an import scenario to import bank statements in CSV

  • September 18, 2024
  • 2 replies
  • 211 views
D
Jr Varsity III
Forum|alt.badge.img

Hi,

If I use the Upload File button and choose an CSV, it gives an error saying “CA Error: This file format is not supported for the bank statement import. You must create an import scenario for this file extension prior uploading it.” since the button only allows some fixed file types but not SCV or excel.

If I use the Load from file button, it requires mapping my bank file with the system fields and upload each and every time. I rather prefer creating an import scenario and use the Upload File button as instructs by the error message. 

Will this work If I create an import scenario for the import bank transactions screen? Do you have any samples/import scenarios done for this? 

Thank you,

Dulanjana

 

 

Best answer by hkabiri

@dsenevirathne54 I think you should be able to create a simple import scenario on Import Bank Transactions Screen as you can see in my screenshot and map the values from the provider to fields on the entry form. I used existing Provider for Import CA Cash Transactions on Sales Demo data but you may need to do some tweaks to add missing fields and values to your provider like Receipt and Disbursement or right a condition if you have it with negative and positive sign.

 

View original
Anna Devyatko
meganfriesen37
smilner3
8 people like this
  • Anna Devyatko
    Anna Devyatko
  • meganfriesen37
    meganfriesen37
  • smilner3
    smilner3
  • hayleehicks
    hayleehicks
  • Chris Hackett
    Chris Hackett
  • M
    mikeho
  • J
    josyannechambers84
  • RohitRattan88
    RohitRattan88
Did this topic help you find an answer to your question?

2 replies

hkabiri
Acumatica Moderator
Forum|alt.badge.img+7
  • hkabiri
  • Acumatica Support Team
  • 226 replies
  • Answer
  • September 24, 2024

@dsenevirathne54 I think you should be able to create a simple import scenario on Import Bank Transactions Screen as you can see in my screenshot and map the values from the provider to fields on the entry form. I used existing Provider for Import CA Cash Transactions on Sales Demo data but you may need to do some tweaks to add missing fields and values to your provider like Receipt and Disbursement or right a condition if you have it with negative and positive sign.

 

SAM KABIRI | L2 Support Engineer | hkabiri@acumatica.com | www.acumatica.com
Chris Hackett
D
S
4 people like this
  • Chris Hackett
    Chris Hackett
  • D
    dsenevirathne54
  • S
    swang44
  • hdussa
    hdussa
D
Jr Varsity III
Forum|alt.badge.img
  • dsenevirathne54
  • Author
  • Jr Varsity III
  • 80 replies
  • September 24, 2024

Hi @hkabiri ,

Thank you for your feedback. With the import scenario, we have to run through import by scenario and upload the file right? And I looking for a way to upload through the upload file button available in the import bank truncation screen .But your solution will be the best option if I cannot achieve above requirement.  I noticed Import file button requires a bank statement import service which is connected to the cash account. I’m not sure a new service is a customization or not.

Thank You

Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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