GP10 After recocile the Summary Trial Balance comes blank plz help

(0) Share

Report

Posted on by Community Member

Hello Everbody ,,

I'm using GP10 and after i runed the GL reconcile t

the summary trial balance report comes balnk with no data but the detailed trial balance is ok So, when i checked the GL10110 table which has the summary information for the accounts amounts is blank also .

my question is how can i rebuild this table or if there is any automated solution for this case or SQL script tor fix this issue .

your quick reply is a highly appreciated .

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Community Member on at

Like (0)

Report

Hi

Are you keeping both Account and Transaction history? (Tools > Setup >> Financial >> General Ledger).

Was the year a Historical year?

(Did you back up your data bfore you ran the reconcile?)

Best regards,

Ian

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Ian for your interest ,

With respect to answering your questions :

1- Are you keeping both Account and Transaction history? (Tools > Setup >> Financial >> General Ledger). Yes

2- Was the year a Historical year? No its Open Year.

3- (Did you back up your data bfore you ran the reconcile?) NO

For your information i tested the same case on the test copmpany by deleteing the recoreds inside the GL10110 and make reconcile the result is the reconcile update this table automatical but in the life company The opposite happened the reconcile delete the all records in the two tables GL10110 & GL10111 .

Please help

Best Regards

Mahmoud Awad

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Here's an idea. Rebuild the GL00105. Use the PSTL - it's a free tool.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi.

A couple of things to verify.

When you go to Financial Inquiry Summary and choose an account for the year that you know has activity do you see amounts - if you do the reconcile worked - if not re-execute the reconcile to see if the problem corrects itself.

In the report do you have any restrictions?

Is the posting Account check box checked?

When you select the report are you choosing opne and specifying the year or are you leaving it at current. If it is current try changing to OPEN and select the year.

Hope this helps

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi ,

Leslie Vail

what is the PSTL tool and the tGL00105 is ok and the detailed trial balance report also is ok i need to rebuild the GL10110 .

Sagi88

- the summary inquiry is blank.

- the report without any restrictions just posting account checked and an open year 2010 the current in the system 2011.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

If in Smartlist you are seeing the details for the year in Account Transactions and you are not seeing the summary records for the same year using the account summary smartlist i would recommend that you verify your Fiscal year in company setup and recalculate it.

Secondly, run a check links on the Company and Finacial series.

Thirdly rerun the reconcile for the year in question.

Hope this helps

Was this reply helpful? Yes No
Bazzer 15 on at

Like (0)

Report

Sagi88

Many thanks for your suggested fix which has just worked for me.

Was this reply helpful? Yes No
Rob Klaproth 1,730 on at

Like (0)

Report

Hello Sagi88_ - I know this an old thread, but I followed the same and for some reason GP created years 2011-2015, but this company was implemented in 2016, so there should be no data in 2011-2015.

How do I get rid of those unused years? When we go to year end close window, 2016 is closed, but now it says we need to close 2011-2015.. So that's going to be a problem in 2018 when they need to close 2017.

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (0)

Report

Rob,

If you look in the GL20000 table or the GL30000 table, do you have any records that have the value of Year1 equal to 2011-2015? Do any of the transaction dates fall within that time period?

I've never seen GP create Fiscal Years out of the blue, but it's easy enough to deal with. If you do not have anything, anywhere, that references those dates, then the only way to remove a fiscal year is to remove the applicable records from the SY40100 and SY40101 tables.

Was this reply helpful? Yes No
Rob Klaproth 1,730 on at

Like (0)

Report

Thank you Leslie, that's exactly what I did. I don't believe there were any old transactions. The issue is that they copied the company using PSTL from one of their older companies that had that year, so somewhere in one of the tables those years were lingering, even though they didn't show up in fiscal period setup. When I ran reconcile and check links those years got created. Now I have deleted iN SQL and ran check links again and they aren't getting re-created.

Was this reply helpful? Yes No