Solved

Customer ledger age analysis

  • 28 December 2022
  • 2 replies
  • 191 views
K
Rank
Badge
  • Kay
  • Do Gooder (Partner)
  • 0 replies

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. 

icon

Best answer by Narmada 28 December 2022, 20:42

View original

2 replies

F
Rank
Userlevel 6
Badge +19

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

https://superp.solutions/
N
Rank
Userlevel 7
Badge +13

Hi @Kay,

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

Reply


Terms & ConditionsCookie settings