Ideas for Acumatica

Feedback processing: We do not reply to all messages, but we do read them, analyze them, and work to improve Acumatica based on the feedback we receive. Ideas and comments may not appear immediately. Some legitimate ideas are flagged as spam and will be added when we review the spam folders.
Content: This portal is for product ideas and feedback only. If you need customer service assistance, contact your Acumatica Support Partner, submit a support case, or get assistance from community resources: LinkedIn Group or StackOverflow
No Reliance: Information is maintained on a best-efforts basis and may be changed without notice. Acumatica cannot guarantee the accuracy of the information provided or guarantee completion of features/ideas described on this portal.

Process Bank Transactions Matching: When not found, don't autocheck Create Transaction

In Process Bank transactions the system does a very good job now with automatic rules.  When selecting Auto Match, if the system does not find a match it selects Create Transaction as if the end user will be doing this.  However if the end user creates a rule and then clicks Auto Match again, it won't process the existing transactions that did not match because it has selected Create Transaction.  So you either have to go to each transaction and unselect which takes time (for the end user, plus the performance is slow), or lose all of the work you have done.

Unless their is a good reason, when a transaction fails to Auto Match, do not select Create Transaction.  It will save end users a lot of time continually building rules and then applying them against the remaining trans to do.

  • Gregg Mercede
  • Aug 29 2015
  • Attach files
  • Kathy Wassmann commented
    April 05, 2019 13:41

    Mass hiding of the unmatched transactions would be a huge improvement. Now, if the system doesn't auto-match items, we have to go the Rec Statement, click reconcile, and then hide the matched transaction on e by one.   Mass hiding would help.  What would really help is if we had a list of all open GL items we could match to manually on the Process Bank transactions scree.

  • Olga Anisimovich (Product Manager Financials Team) commented
    September 07, 2017 21:07

    Hello Kelly,

    1. if the Auto Match process cannot match an uploaded bank record to a payment or an invoice in the system, it selects the Create Payment check box on the Create Payment tab, but does not create any payment in the system. For a payment to be created, a user needs to specify customer and payment method for AR payment (or an entry type for a transaction in CA module). We will consider not selecting the Create Payment checkbox automatically (or selecting it optionally) but I cannot provide you ETA now.

    2. If you discover some error in matching, you can undo the matching by using the Unmatch button for the selected record on the Import Bank Transactions (CA306500) form.

    3. Currently, there is no way to hide multiple records at once but we will consider implementing this enhancement in future.

     

    Best regards,

    Olga

  • Kelly Bush commented
    September 07, 2017 18:39

    I have few additional questions about Acumatica.  Please see below:

    1. If a payment does not match the upload file, does Acumatica automatically create a new payment?  If so, how can you prevent the system from doing this.
    2. How would one go about unprocessing a processed bank transaction if the transaction was incorrectly processed?  As an expample, in the cash management module, the cleared box will become grayed out and checked and may not be unchecked.
    3. Is there any way to mass hide unmatched transactions?  Instead of hiding them one by one?
  • Kelly Bush commented
    September 06, 2017 19:12

    Olga,

    I have few additional questions about Acumatica. Please see below:

    1. If a payment does not match the upload file, does Acumatica automatically create a new payment? I do not want the system to do this.

    2. How would I go about unprocessing a processed bank transaction if I discover that its wrong? In the cash management module the cleared box become grayed out and checked so that you cannot uncheck it and I want to uncheck it.

    3. Is there a way to mass hide unmatched transactions? Instead of hiding theme one by one?

    Thank you,

    Kelly Bush
    Corporate Accounting, Staff Accountant
    Youngevity International. Inc.
    619-934-3980 x 5509

  • Olga Anisimovich (Product Manager Financials Team) commented
    September 04, 2017 18:27

    Kelly,

    on the Process Bank Transactions (CA306000) form, at the left pane, you can see the transactions that have been imported from multiple bank statements and are not matched yet. If there are some transactions that you cannot match to the payments or invoices in the system and you don't want to create new payments based on these transactions, you can hide them from this list. To hide the selected transaction, click the Hide button and save your changes. Use the Import Bank Transactions form if you need to unhide a transaction and use it for processing.

     

    Best regards,

    Olga

  • Kelly Bush commented
    September 02, 2017 03:32

    When a transaction fails to match in Acumatica it appears that these transactions get stuck in Process bank transactions.  These transactions appear to carry over in process bank transactions. even when a new file has been uploaded to match.  Am I correct in the assumption that these files carry over?  If the assumption is correct how do I clear these out of acumatica?  Often when items don't match I need to notify the accounts payable team.  Since there are are not many of these transactions, I'll usually just clear the them in reconcile bank statements rather than going back through "Process Transactions".  Please Advise.