1 Reply Latest reply: Nov 29, 2011 10:59 AM by Sanju Sivan RSS

Customer Open item

Sanju Sivan
Currently Being Moderated

HI Experts,

I just taken the report in open customer line item through fbl5n as on today

The same day I just generate balance sheet figure (S_ALR_87012284) to know the sundry debtors total amount

My question is that Fbl5n open item total should equal to the sundry debtors total, right

If any difference what should the next step, any sap notes or some thing?




Sanju M S

  • Re: Customer Open item
    Murali Babu Nallamothu
    Currently Being Moderated



    1. Execute FBL3N for Sundry debtors account, inside of the report add customer field to your layout

        now do sub toal at customer level and export to excel

    2. Execute S_ALR_87012172 - Customer Balances in Local Currency, take the balances and export to excel

    3. Please do a VLOOKUP in excel, then you can find the differences

    Also remember the following

    1. Have you selected special GL items in FBL5N? If yes, these are posted into a separate GL account



    Murali. N