SQL BANK RECONCILIATION

(0) Share

Report

Posted on by Community Member

I would like to practice the SQL in MS Great Plains, How can I get into the SQL DB, I know how to look the tables but where I can write the instructions

*This post is locked for comments

I have the same question (0)

All responses (15)

Answers (1)

Heather Roggeveen 9,146 on at

Like (0)

Report

Hi Pat

Not sure what you are asking for here - you will need to be a bit more specific on what you are trying to do to get adequate support from the forum. Maybe if you could describe the task you are trying to achieve - are you doing development or looking for some database queries?

Cheers

Heather

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Heather

I wan to practice development, any help will be really appreciated. Maybe I'm in the wrong Forum

Thanks

Was this reply helpful? Yes No
Suggested answer

sueconrod 337 on at

Like (0)

Report

I am assuming that you are going into Sql Server Management Studio (SSMS) and creating a connection. Then you need to go to "New Query".

I also am assuming that this is a test db that you are going after to practice SQL, such as the TWO db and if you are looking at the bank reconciliation you would be looking at the CM tables.

And there are a whole lot of people who have blogs that are devoted to developing for GP that you might want to go look at:

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

Like (0)

Report

Well, this is absolutely a broad question. But the essence is clear,

In case you have the development basics, you may get encountered to real case studies. You may be interested in reviewing the famous blog Developing for Dynamics GP

Please never hesitate to share any further inquiries on the community

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

Like (0)

Report

Just a bit curious, why did you pick a title like SQL Bank Reconciliation .. Have you got any special case that you are working on at the mean time which is related to Bank Reconciliation ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes I want to undo the Bank Rec, but I am working in test company, here is where I am practicing all the new stuff, since I am leaning GP by myself.

Thank you!

Was this reply helpful? Yes No
Suggested answer

sueconrod 337 on at

Like (0)

Report

Hope you saw the article by Doug:

(thanks to Mark Polino for the link)

gp.rosebizincblogs.com/.../undoing-a-bank-reconciliation-after-its-already-been-posted-for-dynamics-gp.html

I've used this in the past. It works.

Sue

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

I am also tried the query from above link for undoing a Bank Reconciliation and it was worked for me. Before starting the undo process, make sure you have latest backup for company database.

Note: Before running the every update query mentioned from the blog, run the select query to verify the records.

For Example:

SELECT Recond,* CM20200 where RECONUM = ‘##.#####’

update CM20200 set Recond = 0 where RECONUM = ‘##.#####’

SELECT ClrdAmt,* CM20200 where RECONUM = ‘##.#####’

update CM20200 set ClrdAmt = 0 where RECONUM = ‘##.#####’

SELECT clearedate,* CM20200 where RECONUM = ‘##.#####’

update CM20200 set clearedate = 0000-00-00 where RECONUM = ‘##.#####’

SELECT RECONUM,* CM20200 where RECONUM = ‘##.#####’

update CM20200 set RECONUM = 0 where RECONUM = ‘##.#####’

Hope this helps!!!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

It is great but my problem is how to get where to write this code.... :(

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

If you familiar with SQL server, follow below steps to update the GP tables to undo Bank Reconciliation.

1. Open SQL Server Management Studio(SSMS).

2. Connect to your GP instance and click new query window.

3. Then choose your company database or type " use [companydatabasename]" and press F5.

4. Now follow the queries derived from the link.

Note: Better try this on test company database and then go to live.

Before executing the queries in live database, make sure you have latest backup for company database.

Hope this helps!!!

Was this reply helpful? Yes No