cancel
Showing results for 
Search instead for 
Did you mean: 

Difference between AR Ledger Vs GL

Private_Member_10672
Active Participant
0 Kudos

Hi,

We have a difference between AR sub-ledger Vs GL account which is correctly reflected in FAGLF03. We had also run the program RGURECGLFLEX to fix the discrepancy with the return message “Doc xxxxxx previously posted in the General Ledger”.

However, the difference still exists!  Will appreciate if someone can suggest the miss, if any.

Thanks,

Nirav

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Dear Nirav,

Check if you have posted some entries in different reconciliation GL (other than which is assigned to the vendor) at the time of transaction you might have changed it. As this is possible if we tick "Recon. Account Redy for Input" FS00 under  CRETE/BANK/INTEREST tab.

In such case difference are found, please check.

Best Regards

Ruksana Khan

Private_Member_10672
Active Participant
0 Kudos

Hi Ruksana,

Thanks for your reply. I wish if this could be as simple fix. We have are allowing to post manual entry to recon.account.

I've observed one more irregularity with this particular FI doc. that Entry view and GL view are different with different amount. How's that possible? Any insight on this will be appreciated.

Thanks,

Nirav

suma_mani
Active Contributor
0 Kudos

Hi Nirav,

Can you please send screen shots for the same !!!

Rgds

Mani

suma_mani
Active Contributor
0 Kudos

Hi Nirav,

Can you please send screen shots for the same !!!

Rgds

Mani

Former Member
0 Kudos

Hi did you checked the currency of that entry view and GL view.

Secondly in FBL5N add field GL account and GL amount anc check

2. Set filter for GL account and enter you recon account in filter and check the balance.

3. If the balance is different now then may be there is table inconsistency

4. If balance is same now then either there are down payments, other speacial GL transactions, Other recon acct posted, etc.

Please try this.

Also: GL cum balance will contain balance in AR recon since it was created for all years as GL balance carryforward is normal closing activity

But AR balance will contain only current year balance as most of people do not carry out AR Balance carry forward as year end activity.

suma_mani
Active Contributor
0 Kudos

Hi Nirav

Message clearly stated Document XXXIX Previously Posted in General ledger. That means there is inconsistency FAGL* tables.  Now case is AR Sub ledger not matching with General ledger balances.First drill-down the AR Balances with reconciliation GL & Cumulative GL wise Balances in FBL5N report. Check same total is matching with FS10N GL wise. May be some of the entries passed in Down payment recd account GL instead of AR account.

Rgds

Mani

Private_Member_10672
Active Participant
0 Kudos

Hi Mani,

Thanks for your reply.  I didn't get your point of "inconsistency FAGL* tables". Could you please elaborate?

Secondly, you suggested to check the balances of Recon GL vs AR ledger (FBL5N). We already did that and different still exists!

Now, the questions is how to fix it, as we can NOT post to recon.account directly. It's a catch 22!

Thanks,

Nirav

Private_Member_10672
Active Participant
0 Kudos

Hi,

Will appreciate if anyone can shed light on this situation?

Thanks,

Nirav

nico_dewaele
Active Contributor
0 Kudos

check with your system admin for failed updates in the message log