on 04-17-2012 2:47 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Hi,
Will appreciate if anyone can shed light on this situation?
Thanks,
Nirav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
check with your system admin for failed updates in the message log
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.