Entry not on the GL

(0) Share

Report

Posted on by Community Member

We came across another error and hope you could assist us. The transaction under the VENDOR search is historical but the entry is not posted to the GL. We are certain we have posted the JE to the GL but we cannot find the credit or debit of the entry. What would be the cause of this?

Even when we searched the entry in SmartList, we could not located the entry as well as under Summary Inquiry

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Rosemary 10 on at

Like (1)

Report

Hi,

What type of transaction is it? Is the transaction in the GL waiting to be posted?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

All the batch and entry are posted in the GL. There is nothing to post. This was a vendor entry paid with a credit card by debiting AP

Was this reply helpful? Yes No
drummerboy_10 on at

Like (0)

Report

David -

In your posting setup screen, are you configured to POST TO or POST THROUGH the GL from the payables subledger?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes, all the other entries are posted to the GL but this vendor entry. My best guess is I may have deleted the entry to post to GL. But that's not like me to do so

Was this reply helpful? Yes No
Suggested answer

Bill Campbell 12 on at

Like (0)

Report

David what reports have you printed in looking for this GL posting.

I would suggest starting with the Trial Balance - for the specific account for the specific dates - but I am sure you did this.

To figure out if you may have deleted the batch - you might use the Cross Reference and search for transactions on or near the date - look for missing JE

Go back to the Vendor and track the Audit Trial of the posting and see if you can find it in the GL anywhere - maybe ( unlikely ) that the accounts are not what you think.

Just a bunch of suggestions, no real fix, just ideas for where I would start if I were asked.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I didnt get the answer that i wanted but thanks again for your help

Was this reply helpful? Yes No
Suggested answer

drummerboy_10 on at

Like (1)

Report
David -

There's really only a couple of scenarios I can think of which would cause this issue:

Posting setup for Payables Transaction entry was inadvertently set to Post To General Ledger instead of Post Through General Ledger which would have caused the batch being posted from the sub-ledger to stop at Financial. From there the batch was accidentally deleted.

Someone with access to SQL Management Studio, knowledge of SQL querying and Dynamics GP table structure deleted the transaction from the database side (very unlikely).

Check Links could have removed the transaction if there was a problem with it, but this is unlikely as well. If anything I would expect Check Links to have recreated the transaction or batch.

It sounds like you've exhausted as much troubleshooting as possible and without some kind of auditing tool (such as FastPath's Audit Trail) it's going to be really hard to determine what caused this to happen. If you've confirmed (using the Reconcile to GL tool, or Trial Balance reports or Smartlist) the transaction is not in the GL and your GL does not tie to Payables, the only resolution is to reenter the transaction in the GL.

Just out of curiosity, have you run check links against the payables and financial transaction tables?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you Sean, we assume someone may have deleted the posting to the GL and just went ahead and re-entered to the GL. Thanks for you help

Was this reply helpful? Yes No