Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / eConnect - Bank Deposi...
Finance | Project Operations, Human Resources, ...
Suggested answer

eConnect - Bank Deposits - taBRPostBankDeposits

(0) ShareShare
ReportReport
Posted on by Peter Muchira 1,912

Hello,

I am trying to automate the creation of  multiple Bank Deposits from a set of Receipts on GP. The deposits need to be created and posted one after the other automatically, say by grouping the receipts by DATE. I was looking for a way of creating and subsequently "posting" the bank deposits one after the other, by creating a class library on .Net using the <taBRBankDepositsHeader> node. 

Any suggestions on how to achieve this on Dot Net, as opposed to going to SQL directly? Thanks.

Categories:
Microsoft Dynamics GP
  • Suggested answer
    Peter Muchira Profile Picture
    Peter Muchira 1,912 on at
    RE: eConnect - Bank Deposits - taBRPostBankDeposits

    Hello Richard,

    Thanks for the input. Unfortunately for the Bank Deposits, the system seems to, by default, SAVE the first transaction before creating the next one. And the posting is not automatic - as would be the case for Bank Transactions - which have no "SAVE" option, even on the face of the transaction window.

    I ended up calling the "taBRPostBankDeposits" sproc directly from my Dot Net Class Library, so as to post the deposits, one after the other (receipts for a given date would make a single deposit).

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: eConnect - Bank Deposits - taBRPostBankDeposits

    I have written a Bank Transaction integration using eConnect and I would assume doing bank deposits works the same way. Using the node for bank transactions completes the transaction and it moves on to the next one. These transactions automatically posted. No windows are opened and my code is in a self standing program not as a class library. That was caused by conflicts with printing.

  • Peter Muchira Profile Picture
    Peter Muchira 1,912 on at
    RE: eConnect - Bank Deposits - taBRPostBankDeposits

    Thanks Richard,

    My code is able to create the first deposit. But Bank Deposits Window on GP only allows you to have one deposit at a go. So the first one has to somehow get posted, to be able to create the subsequent deposit.

    Yes, grouping by date will create a single deposit per day, but am looking at a scenario where you have receipts spanning several days, and need to be posted as deposits all at one (or one after the other).

    That is why I was considering taBRPostBankDeposits, to post the deposits (and allow subsequent ones to get created).

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: eConnect - Bank Deposits - taBRPostBankDeposits

    Using the taBRBankDepositHeader and taBRankDepositLine is the way to go. Posting will automatically occur as you insert the deposits. Use your code to accomplish the grouping by date.The transactions will come from the receivables transaction table looking for payments. You will need to build code looking for payments that have not yet been put into deposits. Is that the real question here?

  • Peter Muchira Profile Picture
    Peter Muchira 1,912 on at
    RE: eConnect - Bank Deposits - taBRPostBankDeposits

    Any suggestions anyone?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans