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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / bank transaction not s...
Finance | Project Operations, Human Resources, ...
Answered

bank transaction not showing in GL

(0) ShareShare
ReportReport
Posted on by rajivsewsarran 22

Hi all,

A transaction was made in the bank transactions window and it now appears on the bank rec. It does not appear on the GL.


I rant he find in tables script and found that in terms of th GL tables, its only on the GL10001. There isn't an entry on the GL10000

Is there a way to rebuild the header for this transaction so it can be posted? if not what would be the best way to go about this ?

 These are the tables the transaction appears on ...

GL10001
CM20100
CM20200
CM20200

Any assistance would be greatly appreciated.

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Dianahemes24 Profile Picture
    Dianahemes24 30 on at
    RE: bank transaction not showing in GL

    Bank Transactions Not Posting to General Ledger

    You can also try to run Reconcile by going to Tools >> Utilities >> Financial >> Reconcile. If still not resolved, you can just enter an adjusting Journal Entry in GL - and make a note that is your Bank Transaction entry with the reference number.

    Regards,

    Diana

  • rajivsewsarran Profile Picture
    rajivsewsarran 22 on at
    RE: bank transaction not showing in GL

    Hi All,

    thanks you for the responses.

    I ran check links and it brought the other transactions back.

    Thanks again for your time .

  • Lisa at AonC.com Profile Picture
    Lisa at AonC.com 840 Super User 2025 Season 2 on at
    RE: bank transaction not showing in GL

    Is it possible that (1) you needed to redisplay the batch list to show all the batches available int he Batches window or (2) the batch had a batch status that prevented it from showing the Batches window when using the browse buttons in the bottom left of the Batches window?

  • Jenny Shymon Profile Picture
    Jenny Shymon 5 on at
    RE: bank transaction not showing in GL

    delete spam

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: bank transaction not showing in GL

    Obviously, something went wrong during posting. The distribution lines (GL10001) get written before the header lines (GL10000). Did you receive any error messages when these bank transactions posted? If you do any inquiry on your corresponding GL account for this checkbook can you zoom back to the bank transaction?

  • rajivsewsarran Profile Picture
    rajivsewsarran 22 on at
    RE: bank transaction not showing in GL

    it was posted in the bank transactions window - ran check links - it didn't return anything

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: bank transaction not showing in GL

    Was it an online posting? I wonder if check links might have reported something? It wouldn't know the batch number but you could quickly update that.

  • rajivsewsarran Profile Picture
    rajivsewsarran 22 on at
    RE: bank transaction not showing in GL

    I also came across this with another batch - but the batch was sitting in series post ... why would it be there? and not Financial ?> Transactions > Batches?

  • rajivsewsarran Profile Picture
    rajivsewsarran 22 on at
    RE: bank transaction not showing in GL

    Hi,

    Thanks for your assistance. I've done the script to insert it into the GL10000 , i just thought maybe there was some other way of doing it , rather than writing a script.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: bank transaction not showing in GL

    Do you know how to run SQL scripts? If so,

    SELECT * FROM [dbo].GL10001 WHERE JRNENTRY NOT exists (SELECT TOP 1 * FROM [dbo].GL1000]) against your company database.

    You should see the record you need. You will need to write a SQL script to insert the missing GL10000 record. Report back what you find and I can provide the script. You know the JRNENTRY and the BACHNUMB. The rest of the values need to be determined from other bank transactions.

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,317

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 918 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 656 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans