Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP forum / bank transaction not s...
Microsoft Dynamics GP forum
Answered

bank transaction not showing in GL

(0) ShareShare
ReportReport
Posted on by rajivsewsarran 87

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:
Financial Management
  • 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 87 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 2,998 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,730 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 87 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,730 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 87 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 87 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,730 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.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Community Spotlight for September 2024

Kudos to Mohana Yadav!

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,349 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,212 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans