I found that there are huge balances in AR clearing account, bank clearing accounts. After I looked into every line, I found that the numbers prior to consolidation and the number after consolidation both were listed in detail listings. What causes this to happen?

Hi Jing Hui

Since clearing accounts are supposed have a zero balance once the GL is fully updated (I'm assuming you have posted all subledger batches, retrieved transactions into the GL and posted those batches), my guess is that the GL account links are not set up properly in the subledgers. Without seeing your data, it would be very difficult to tell you exactly what is wrong with the setup. You should ask your Adagio consultant for help configuring the setup properly.

As for your mention of consolidation, I have yet to find a reason why anyone, in this era of cheap memory, fast computers and ability to print large reports to file, should ever voluntarily choose to consolidate their GL detail. Among other negatives, it makes reconciling clearing and control accounts next to impossible. Please think about not consolidating in the future.

Not that it changes my reply, but what versions are using for the various modules?

Steve