Topic Options
#63129 - 02/25/20 02:42 PM GL not agree to receivables (Multi currency)
Braedon Offline
Adagio Graduate

Registered: 09/16/16
Posts: 42
Loc: BC
Our AR listings do not agree to the GL for AR by about $21.26
When I look at the GL the balance is made up of

$783,684.32 Canadian
-$40,149.12 USD / $52,626.70 CAD
For a total of $731,057.62

The AR listings show that it should be
$766,454.58 Canadian
$27,516.89 USD / 35,418.22 CAD
For a total of $731,036.36

Is there a way to adjust the GL split to match the AR listings split?
I have no idea how they got out of sync I just want to fix it.

Top
#63146 - 02/25/20 06:25 PM Re: GL not agree to receivables (Multi currency) [Re: Braedon]
Douglas Dickie Offline
Adagio God

Registered: 06/02/99
Posts: 4414
Loc: Vancouver, BC
Yes this adjustment can be done.
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top
#63952 - 05/20/20 02:42 PM Re: GL not agree to receivables (Multi currency) [Re: Braedon]
PEMB Offline
Stranger

Registered: 06/14/19
Posts: 3
Loc: Ottawa, Canada
I am having the same problem. The difference is more significant in my case. How could this happen?

Top
#63954 - 05/20/20 03:43 PM Re: GL not agree to receivables (Multi currency) [Re: PEMB]
Douglas Dickie Offline
Adagio God

Registered: 06/02/99
Posts: 4414
Loc: Vancouver, BC
There are too many possibilities to cover in a forum. the most common issue is posting an adjustment in Ledger to the Control Account. The sub-ledger doesn't know anything about this transaction.

In ledger look for transactions with a Transaction type that starts with GL.
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 183 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14467 Topics
70661 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