Hi,
How can I find the GL accounts that are fetching to the Customer ledger age analysis report? GL Balance analysis and Customer ledger age analysis report doesn’t tally now. I want to find what are the GL accounts that will get fetched to this report. Then I can compare.
Hello,
As far as I know, the report is based on LEDGER_ITEM_TAB rather than GL accounts. GL balance can contain Q or H function vouchers that are not in ledger age analysis report.
I would recommend you to export MC Customer Ledger Detailed Age Analysis to excel and see which GL accounts are used in the report. Then search those accounts in GL voucher rows grouping function group. Anything other than B, N or F can create discrepancy
Hope this helps
Hi
You can get the report for respective GL account and identify the exact GL accounts which does match with the GL balances. Refer below screen preview.
Also, you may consider GL account connected to posting types IP2;IP19;IP21;PP8;PP28;PP32;PP36.
Best Regards
Narmada
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.