Microsoft Dynamics GP (Archived)

Bank Reconcile adjustment entry

(0) Share

Report

Posted on by Community Member

Dear All ,

Kindly let me know, below mentioned Reconcile adjustment entry will hit on JV?

I couldnt see this entry when i search transactions by that purticular account number from smart list!

it is showing when i check In bank transaction entry zoom window ....!

Thanks in advance

Belraj

*This post is locked for comments

I have the same question (0)

All responses (19)

Answers (0)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (1)

Report

If there is a difference, then it depends on the posting setup (Microsoft Dynamics GP > Tools > Setup > Posting > Posting), Choose the "Financial" series, and the "Reconcile Bank Statement" origin.

If you want no journal entries to be posted to GL, turn off posting to GL by unchecking both options (Post TO and Post Through). Otherwise, the difference will be posted to GL (positive implies income, while negative implies expense)

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Mr Mohamoud M Alsaadi,

Thank you very much for your sudden response.

I need Journal entries to be posted GL..And i already turn on Post to ..Options.

But I couldnt find the GL entry for this reconsile adjustment entry ..

...How can i find/rectify it?

Was this reply helpful? Yes No
Suggested answer

babubaskaran@outloo... 12 on at

Like (1)

Report

Please check whether you have unposted financial batch gone into batch recovery.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

That entry and amount is not visible if i search in smart list by using Below mentioed [ black coloerd ] account number

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Mr BABU BASKARAN

Thanks for your response. Nothing is available in batch recovery.But I can see one batch without any transactions in GL,having same the batch name as the audit trial code name, for that reconcile adjustment entry.

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

If the journal entry has not been recorded on the GL for some reason, you may proceed with a manual journal entry for the same accounts and amounts, to keep the modules tied.

Let us know if you have any further inquiries,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you very much mr Mahmoud M. AlSaadi,

How do we Cross check and clarify, the Journal Entry is recorded or not.

Do you have any SQL query or method?

Thanks in advance

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (1)

Report
The simple way is to check the accounts as you initially did, it will clearly show whether any journal entry has been recorded or not. As for the scripts, there are a couple of scripts related to CM reconciliation on Dynamics GP essentials blog which are:

Reconcile Checkbooks to General Ledger

Pure Bank Transactions and Transfers with General Ledger Details

Although, I don't think digging in the database is a good option if you have already checked the accounts and found no entries recorded. In this essence,If you are sure that there are no entries on the GL, just record a corrective journal entry on the GL level and get this settled.

Let us know if you still need any further assistance,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you very much Mr.Mahmoud M Alsaadi,

Actually that entry was posted on 31-12-2013 .I had checked all transaction of that account through smart list with no result.

Let me go throgh your blogs..

Thanks and regards.

Was this reply helpful? Yes No
Suggested answer

babubaskaran@outloo... 12 on at

Like (1)

Report

Hi,

have you run checklink against financials

Was this reply helpful? Yes No