You’re offline. This is a read only version of the page.
97
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.
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
Hi All,
thanks you for the responses.
I ran check links and it brought the other transactions back.
Thanks again for your time .
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?
delete spam
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?
it was posted in the bank transactions window - ran check links - it didn't return anything
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.
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?
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (