Skip to main content
Solved

Import Scenario for Cleared Cash Account Details

  • September 3, 2024
  • 4 replies
  • 76 views
R
Freshman II

I am trying to make an import scenario to update posted cash transactions to show them as cleared with a cleared date from a file. I see where screen CA.30.30.00 allows me to manually do this process. However, I can’t make an import scenario to accomplish this. Has anyone had any success with this? 

Ideally we will receive a file from our bank nightly. This will run an automatic file sync and import scenario to update these records daily. So far I haven’t been able to accomplish doing any updates during an import scenario I've tested for CA.30.30.00. Any help would be greatly appreciated. I’ve attached one example of what I'm going to update for testing.

If this isn’t possible, how else are people importing the cleared data automatically?

 

 

Best answer by Laura02

Hi,

Consider importing the Cleared checkbox ON/True and the Cleared Date to the Reconciliation Statement screen.

Please review this previous post that discusses how to use @@ to locate a line to update, and update the line with Import Scenarios. (The original poster is deleting lines, but @@ can also be used to locate and update.)

The post above contains a link to an Acumatica video where Irina explains how to locate and change specific lines.

Otherwise, a developer may be able to change Cash Account Details screen behavior for you, to make the Cleared and Cleared Date fields editable.

 

Laura

View original
    Laura02
    1 person likes this
    • Laura02
      Laura02
    Did this topic help you find an answer to your question?

    4 replies

    Laura02
    Captain II
    Forum|alt.badge.img+19
    • Laura02
    • Captain II
    • 3132 replies
    • September 3, 2024

    Hello,

    One process people are using to import cleared data is Bank Feeds. Bank Feeds can be automated to  import cleared transactions regularly.   Process Bank Transactions screen is then used to match the cleared items from the bank to existing Acumatica transactions.  In Process Bank Transactions, we can also create any missing transactions in Acumatica (when an item clears the bank before it’s been entered in Acumatica).

     

    Laura

    Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
    R
    Freshman II
    • rmarschall
    • Author
    • Freshman II
    • 6 replies
    • September 3, 2024
    Laura02 wrote:

    Hello,

    One process people are using to import cleared data is Bank Feeds. Bank Feeds can be automated to  import cleared transactions regularly.   Process Bank Transactions screen is then used to match the cleared items from the bank to existing Acumatica transactions.  In Process Bank Transactions, we can also create any missing transactions in Acumatica (when an item clears the bank before it’s been entered in Acumatica).

     

    Laura

    Thanks for the reply Laura. Unfortunately the Bank Feeds didn’t work out for us as it didn’t pull the information we wanted from our bank using MX. Plaid didn’t even connect to our bank at all unfortunately.

    Laura02
    1 person likes this
    • Laura02
      Laura02
    Laura02
    Captain II
    Forum|alt.badge.img+19
    • Laura02
    • Captain II
    • 3132 replies
    • Answer
    • September 3, 2024

    Hi,

    Consider importing the Cleared checkbox ON/True and the Cleared Date to the Reconciliation Statement screen.

    Please review this previous post that discusses how to use @@ to locate a line to update, and update the line with Import Scenarios. (The original poster is deleting lines, but @@ can also be used to locate and update.)

    The post above contains a link to an Acumatica video where Irina explains how to locate and change specific lines.

    Otherwise, a developer may be able to change Cash Account Details screen behavior for you, to make the Cleared and Cleared Date fields editable.

     

    Laura

    Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett
    P
    Freshman I
    • pkrasensky
    • Freshman I
    • 1 reply
    • February 14, 2025

    Hi!

    Just wondering how you got this resolved. I am also wanting to import cleared checks and do not use the Bank Feed.

    Thanks,

    Pati

    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