Page 1 of 2 1 2 >
Topic Options
#44937 - 03/13/15 09:35 AM G/L does not balance
Inclusion Offline
New Guy

Registered: 03/13/15
Posts: 5
Loc: Kamloops Canada
I am running GL version 9.2A (150119)
I retrieved batches from the Accounts Payable and posted them. All the postings are showing but the accounts do not add up, Example If the balance was $100.00 and $200.00 was posted to the account the balance still says $!00.00 I was advised to re download the new version again but it changed nothing.

Top
#44938 - 03/13/15 09:38 AM Re: G/L does not balance [Re: Inclusion]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
How are you determining the balance in the account? Printing a Trial Balance Report? Looking at the number on a Grid? Printing a financial statement?
_________________________
Andrew Bates

Top
#44940 - 03/13/15 10:07 AM Re: G/L does not balance [Re: Retired_Guy]
Patricia B. Offline
Adagio Maestro

Registered: 06/26/08
Posts: 1160
Loc: Langley, BC
You may want to check the dates of your payables, It might have posted in the wrong fiscal year or fiscal period.
_________________________
Patricia Balbuena Cotlear
AP SMART SUPPORT
236 991 3060





Top
#44941 - 03/13/15 10:11 AM Re: G/L does not balance [Re: Retired_Guy]
Inclusion Offline
New Guy

Registered: 03/13/15
Posts: 5
Loc: Kamloops Canada
I printed a trial balance - Financial Statement and a detailed listing of the accounts
This is what shows when I print a detailed listing of the account


Pd Source Date Reference Description. Description 2 Debit Credit
1 AP 1/16/2015 T/S Jan 2015 122- 153- 13 -BC HYDRO 129.07
1 AP 1/16/2015 T/S B Jan 15 122- 153- 14 -BC HYDRO 119.78
1 AP 1/28/2015 T/S 1 2015 122- 152- 10 -FORTIS BC 120.04
1 AP 1/28/2015 T/S B 1/2015 122- 152- 13 -FORTIS BC 257.60
4 626.49 0.00


If I click on view transactions it shows there is only 119.78 posted

7950 100 Utilities Income No 0.00 0.00 0.00
7950 305 Utilities Income No 0.00 0.00 0.00
7950 320 Utilities Income No 0.00 0.00 0.00
7950 325 Utilities Income No 0.00 0.00 0.00
7950 330 Utilities Income No 0.00 0.00 0.00
7950 350 Utilities Income No 0.00 0.00 0.00
7950 360 Utilities Income No 0.00 0.00 0.00
7950 405 Utilities Income No 0.00 0.00 0.00
7950 410 Utilities Income No 0.00 0.00 0.00
7950 415 Utilities Income No 0.00 0.00 0.00
7950 420 Utilities Income No 0.00 0.00 0.00
7950 430 Utilities Income No 0.00 0.00 0.00
7950 450 Utilities Income No 0.00 0.00 0.00
7950 455 Utilities Income No 0.00 0.00 0.00
7950 460 Utilities Income No 0.00 0.00 0.00
7950 475 Utilities Income No 0.00 0.00 0.00
7950 700 Utilities Income No 119.78 0.00 0.00

Top
#44942 - 03/13/15 10:20 AM Re: G/L does not balance [Re: Patricia B.]
Inclusion Offline
New Guy

Registered: 03/13/15
Posts: 5
Loc: Kamloops Canada
They are all in the correct year here is an example
I printed a trial balance - Financial Statement and a detailed listing of the accounts
This is what shows when I print a detailed listing of the account


Pd Source Date Reference Description. Description 2 Debit Credit
1 AP 1/16/2015 T/S Jan 2015 122- 153- 13 -BC HYDRO 129.07
1 AP 1/16/2015 T/S B Jan 15 122- 153- 14 -BC HYDRO 119.78
1 AP 1/28/2015 T/S 1 2015 122- 152- 10 -FORTIS BC 120.04
1 AP 1/28/2015 T/S B 1/2015 122- 152- 13 -FORTIS BC 257.60
4 626.49 0.00


If I click on view transactions it shows there is only 119.78 posted

7950 100 Utilities Income No 0.00 0.00 0.00
7950 305 Utilities Income No 0.00 0.00 0.00
7950 320 Utilities Income No 0.00 0.00 0.00
7950 325 Utilities Income No 0.00 0.00 0.00
7950 330 Utilities Income No 0.00 0.00 0.00
7950 350 Utilities Income No 0.00 0.00 0.00
7950 360 Utilities Income No 0.00 0.00 0.00
7950 405 Utilities Income No 0.00 0.00 0.00
7950 410 Utilities Income No 0.00 0.00 0.00
7950 415 Utilities Income No 0.00 0.00 0.00
7950 420 Utilities Income No 0.00 0.00 0.00
7950 430 Utilities Income No 0.00 0.00 0.00
7950 450 Utilities Income No 0.00 0.00 0.00
7950 455 Utilities Income No 0.00 0.00 0.00
7950 460 Utilities Income No 0.00 0.00 0.00
7950 475 Utilities Income No 0.00 0.00 0.00
7950 700 Utilities Income No 119.78 0.00 0.00

Top
#44943 - 03/13/15 11:24 AM Re: G/L does not balance [Re: Inclusion]
Douglas Dickie Offline
Adagio God

Registered: 06/02/99
Posts: 4414
Loc: Vancouver, BC
For view transactions;

1. Which three numeric accounts are you displaying (the default is Balance only)?
2. until you drill down on a single account dept pair you will not see the transactions, only balances or net changes.

Also for your transactions details there is no indication of which account number you are showing the transactions for.

Just because a single account balance is not what you expected doesn't mean the Gl is out of balance.

Have you run a data integrity check (File | Data Integrity? Is it error free? Have you recently attempted a Rebuild after a data integrity error?

If I had my hands on the data I could figure out what the problem is quickly. In this forum it could take a while as we go back and forth with questions and answers. This problem would not be solved by reinstalling Ledger. Hopefully your Adagio dealer can assist you by taking a real look at the data.
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top
#44945 - 03/13/15 11:33 AM Re: G/L does not balance [Re: Inclusion]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Was an error batch created when you posted the AP batch?
_________________________
Andrew Bates

Top
#44947 - 03/13/15 12:32 PM Re: G/L does not balance [Re: Retired_Guy]
Inclusion Offline
New Guy

Registered: 03/13/15
Posts: 5
Loc: Kamloops Canada
No

Top
#44948 - 03/13/15 12:48 PM Re: G/L does not balance [Re: Douglas Dickie]
Inclusion Offline
New Guy

Registered: 03/13/15
Posts: 5
Loc: Kamloops Canada
The account is 7970 - 700 it shows a balance of $119.78 so it only picking up one amount that was posted. I did run a data integrity and it shows 64 errors I tried rebuilding and it showed detail missing on the accounts that are out on this account
it says Detail missing $506.71
I do hope that our dealer will be able to help me but he must be out of town as I have not heard from him

Top
#44959 - 03/14/15 08:44 AM Re: G/L does not balance [Re: Inclusion]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hello.

If your data was damaged before the post, then the program will have had trouble posting the figures. Do you have a backup from before the posting run? Do you have an older backup? Can you determine how long the data has been damaged?
_________________________
Andrew Bates

Top
Page 1 of 2 1 2 >


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 67 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14467 Topics
70662 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30