web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Bank Account No. &...
Microsoft Dynamics GP (Archived)

Bank Account No. & Sort Code Transactions

(0) ShareShare
ReportReport
Posted on by Ben Huggins 145

Hi there,

I am having trouble using the report/smart lists on Dynamics. I am in desperate need of being able to search all transactions by bank account number/sort-code (i.e I need to see all payments to made to account number xxxxxxx and sort code xx-xx-xx). I am sure this will be in one of the smart lists, but cannot find it in any of the 'columns' list. If this isn't the case, could you advise of a way to do this search?

Your help in this matter is massively appreciated!

Many Thanks!

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi Ben,

    What version of GP are you on?

    Do you want to be able to see all payments made from a particular Chequebook in GP...or all transactions paid into a specific bank account? If the latter are you using EFT?

    Best regards,

    Ian Stewart

     

  • Ben Huggins Profile Picture
    Ben Huggins 145 on at
    Hi Ian, thanks for the reply. I am currently using GP 9.0 and I wish to see all payments made to a specific UK bank account. Unfortunately, due to my lack of knowledge of the Dynamics program, I couldn't say if we are using EFT (Nor do I have a clue what that means!) Sorry to be vague..!! Thanks!
  • Community Member Profile Picture
    Community Member on at

    Hi Ben, no problem. If you can find one of the payments in GP, perhaps you could email me a screen shot? This will tell me all I need to know.

    EFT stands for Electronic Funds Transfer. This application allows you to prepare a file of payments you want to make, that you send to your bank and they effect the payments for you. In this application, you have to record the bank account number and sort code for anyone you might want to pay. This really is the only 'official' place you can record an account number and sort code in GP.

    Perhaps you are storing this data in some other fields, perhaps on the Creditor Card? (Cards >> Purchasing >> Creditor).

    How were the payments into the UK bank recorded in GP?

     - as a Manual Creditor Payment? (Transactions >> Purchasing >>Manual Payment)

     - as an automatic Creditor Cheque ?

     - as a sundy bank payment? (Transactions > Financial > Bank Transaction....)

    Can you confirm that you are definately not looking for transfers between your own bank accounts?..ie...these are payments into a third party bank account.

  • Ben Huggins Profile Picture
    Ben Huggins 145 on at
    Ah yes, when we make BACS payments, GP generates a text file that the payments are then made from. All the creditor bank details are stored in Cards > Purchasing > Creditor, then once seclected creditor, its 'Address > Bank, then it will display that creditors Bank acc No and Sort code. We never use the idea of trans > Financial > bank transactions. And the payments I am trying to identify are definitely made to 3rd party bank account. Thanks again!
  • Community Member Profile Picture
    Community Member on at

    Hi Ben, understood.

    What you need so is a smartlist or report that lists all BACS payments, filtered by a specific account number and sort code.

    Is there a BACS report that suits, that you could edit in Report Writer and place a restriction for the account code and sort code, on it?

    Do you have Smartlist Builder?

    Is the BACS functionality you are using a customised development for GP?

     

    Ian.

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans