Open Forum

Expand all | Collapse all

Bank Transaction

  • 1.  Bank Transaction

    Posted May 16, 2019 09:25 AM

    Has anyone successfully used SmartConnect to upload Bank Transactions and create 1 batch?  I have been able to upload but each transaction becomes a separate batch.

    Thank you!


  • 2.  RE: Bank Transaction

    Posted May 16, 2019 10:33 AM
    Hi @Lynn Pipitone

    GP is not set up to use batches at the Bank Transaction Level, so each transaction is always it's own batch even if you enter directly in the UI.

    I'm unsure why there is a batch ID field in the SmartConnect node for this, but there are no Bank Transaction batches.

    Unless someone knows something I do not, but I have never seen bank transactions come in as batches.

    Jo deRuiter, MCP, DCP
    "That GP Red Head"
    770-906-4504 (Cell)


  • 3.  RE: Bank Transaction

    Posted May 17, 2019 12:16 AM
    Hi Lynn,

    I agree with @Jo deRuiter - there isn't a batch level posting in the Bank Reconciliation module... the closest to it would be 'saving a deposit' - and this is only limited to one deposit.​
    At any rate, I would just like to mention that the "Posting Through General Ledger" option (in the Posting Setup window) applies to Bank Transaction posting despite not being in a batch.

    Ryan Galang
    BTP Technologies LLC
    Chantilly VA

  • 4.  RE: Bank Transaction

    Posted May 17, 2019 07:47 AM

    It doesn't allow batching.  But, strangely, a user can leave the window and come back to it and still see their entry.  What I did was create a 'Map Pre Task' to read the tables.  If an unposted transaction existed, I would throw an error to the user and stop the import.


    Chris Donnelly
    Sr Mgr of Info Systems and Financial Reporting
    Healthmark Industries

  • 5.  RE: Bank Transaction

    Posted May 17, 2019 04:41 PM
    Edited by Valerie Sikora May 17, 2019 04:43 PM
    I have been working with something similar recently.  The Batch is for the GL Batch, which is also created by SmartConnect when you integrate a Bank Transaction.  It's true, the Bank Transactions window does not have a batch field, and it automatically posts to the CM20200 and CM20400 tables.  However, there is also a GL Batch created, and if all of your transactions have the same GL Batch name, they will all be in the same GL Batch.

    By the way, because SmartConnect utilizes eConnect functionality, the batch posting setting you have set in GP is not applied.  From the eConnect SDK:

    The bank transaction entry is a posting window and it does not allow you to save batches. When you use eConnect to enter a bank transaction, it generates a batch in the General Ledger. eConnect does not post through the General Ledger. You must verify and post all the batches generated by eConnect to the Microsoft Dynamics GP General Ledger.

    Hint: If your Microsoft Dynamics GP setup allows posting through the General Ledger, this does not apply to eConnect.

    Hope this helps!

    Valerie Sikora
    Senior Developer
    LBMC Technology Solutions
    Brentwood TN

If you've found this thread useful, dive deeper into User Group community content by role