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.

Bank Payment to multiple Suppliesr should show as only 1 line in the Bank Rec

ISSUE
(CA
  1. Bank Reconciliation problem for multiple vendors from a batch payment STESPS TO

 

STEPS TO REPRODUCE
Checked Sev/Pri Replicated in Rapidbyte, AB v
  1. 3.3108
  2. Log into AB, go to > Finance > Accounts Payable > Processes > Payment Processing > Prepare Payments, select a payment method to process payment
  3. Select 2 or more bills, click Process to process payment
  4. At Process Payment / Print Cheques screen, click Process
  5. After printing of cheques, at Release Payments screen, click Process to release payments
  6. Go to > Finance > Cash Management > Work Area > Import Bank Transactions, select Cash Account used for payment made earlier 102000, enter a bank transaction as per bank statement or upload transaction from bank file
  7. Go to > Finance > Cash Management > Work Area > Process Bank Transactions, select Cash Account 102000, click Auto Match, system not able to match it against payment made through Prepare Payment process (AP

 

IMPACT
Slow down Reconciliation Statements process

 

WORKAROUND
Reconcile bank statement manually

 

EXPECTED RESULTS
Able to auto match multiple vendors invoices in Process Bank Transaction

 

SUPPORT NOTES
Sev/Pri as per SLA description Snapshot and bank file provided Tested in Chrome
  1. 2357.132 m (64-bit)
  • Ada Jin
  • Sep 3 2015
  • Already exists
  • Attach files
  • Olga Anisimovich (Product Manager Financials Team) commented
    May 02, 2018 17:01

    Hello Joel,

    the requested functionality is available starting from 5.2 Update 10. 

    If in your bank statement a batch payment is reported as a single transaction, you should select the Match Bank Transactions to Batch Payments check box on the Cash Accounts (CA.20.20.00) form for the cash account that represents your bank account. 

    For more information, please refer to https://help.acumatica.com/Main?ScreenId=ShowWiki&pageid=8252de4e-6f9a-46f9-ab1d-c6cf127f9dbe

    Best regards,

    Olga

  • Joel McDonell commented
    April 23, 2018 18:40

    This appears to have not been implemented (per Acu Case 073862).  How are others addressing the bank reconciliation steps for batch/ACH payments?

  • Gabriel Michaud commented
    September 04, 2015 21:10

    That is planned to be included in Acumatica 5.3.

  • Gabriel Michaud commented
    September 04, 2015 15:00

    Ada, you should see it in the Aha! portal if you login at http://acumatica.aha.io. You have an access. Full URL is https://acumatica.aha.io/features/ACU-761

  • Ada Jin commented
    September 03, 2015 23:26

    BTW, I cannot search the ACU-761, could you please give me a link?

     

    Thanks,

  • Ada Jin commented
    September 03, 2015 23:25

    Hi Gabriel

     

    Glad to know ACU-761 is doing the same feature, could you please tell me when the feature will be available for testing?

     

    Thanks,

    Ada

  • Gabriel Michaud commented
    September 03, 2015 11:37

    HI Ada. We have feature ACU-761 under development right now which will make system show a single line in bank reconciliation when you use the batch payments feature, typically required to do ACH/EFT payments with Acumatica. In your steps to reproduce you don't mention using it, however that will be a requirement - this is how you will group together multiple payments.

  • Ada Jin commented
    September 03, 2015 02:23

    MYOB Archie: SR121177692196

    MYOB Rally: US10231