Topic Options
#61568 - 08/09/19 04:24 PM A/R out of balance to G/L
Holiday Offline
Adagio Guru

Registered: 04/26/07
Posts: 103
Loc: Canada
Hi,

Has anyone run across an import file glitching and dropping part of the transaction? The customer A/R subledger account is the correct balance, but the transaction doesn't seem to have been recorded in the overall A/R subledger balance. There is a corresponding difference between the A/R module and the G/L module. When double clicking on the transaction in the customer's account within the A/R module, there is no G/L distribution on that transaction.

Thanks, and have a great weekend!

Top
#61569 - 08/09/19 05:12 PM Re: A/R out of balance to G/L [Re: Holiday]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10501
Loc: Canada
Are we talking about importing transactions or retrieving them from another Adagio application?

The most common cause of this is that you have coded a transaction to the AR Control account so both the debit and credit have hit the same account in Ledger. There is an option in the company profile to prevent this from happening (although it may not be checked during an import).
_________________________
Andrew Bates

Top
#61636 - 08/16/19 01:39 PM Re: A/R out of balance to G/L [Re: Retired_Guy]
Holiday Offline
Adagio Guru

Registered: 04/26/07
Posts: 103
Loc: Canada
Hi Andrew,

We have already prevented posting to the control account in the A/R module. The error occurred during importing transactions with a CSV file. I believe that there was an error on the load file into the A/R module - it gave the person an error message at the time, so she thought it didn't post to the customer's A/R subledger account and so re-posted the transaction with a corrected load file. When she then checked the customer's account, the transaction was posted twice. The original posting is the one that seems to be causing the issue though.

Top
#61637 - 08/16/19 05:02 PM Re: A/R out of balance to G/L [Re: Holiday]
Dan_Desautels Offline
Adagio Maestro

Registered: 07/21/11
Posts: 1156
Loc: Thunder Bay, ON, Canada
This is not an issue that is easily solved in the forum. You should contact your Adagio consultant for assistance so they can look directly at the data to determine the issue.
_________________________
Dan Desautels
DezTek Solutions Inc.
Thunder Bay, ON

Top
#61742 - 09/02/19 03:53 AM Re: A/R out of balance to G/L [Re: Dan_Desautels]
chinmook Offline
Edward Chris Chin-Mook

Registered: 09/29/09
Posts: 388
Loc: Jamaica
Hi Holiday,

You will have to do an AR Adjustment for the original entry or entries to the Customers accounts affected, make sure you do not have any retrievals to GL pending when you post the adjustment batch. Retrieve into GL and delete same. This will re-align your AR to the GL. ..

This is heavy lifting and as Dan mentioned you may need to get assistance from your Adagio Consultant.

Another very important question I have, If you are importing information into your AR, you must not AUTO POST, allow the responsible user to PRINT the batch and double check BEFORE POST. Never automate this process, don't care how FOOL PROOF you may think.

Your problem is a simple fix....now that you have found the exact error causing your GL Control Account to differ from the Sub Ledger.
_________________________
Edward C Chin-Mook
10 Waterloo Ave, Kingston 10, Jamaica
876-754-7444
876-754-5513

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (smhoon), 58 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1856 Members
5 Forums
14335 Topics
70141 Posts

Max Online: 359 @ 11/18/19 09:08 PM
October
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 31