Skip to Content
author's profile photo Former Member
Former Member

Customer ageing report

Dear All,

I checked in SCN and did not find answer for my query so posting here.

This is with reference to customer ageing report,

we are developing z report for customer ageing since we could not get customer specific report either through standard transaction or FDI4/FDI0 level.

So, we are developing Z report for customer ageing.

My doubt is, case where Customer is also a vendor

in BSID table we can get customer open item balances. which means due and not due balances. This is clear.

but how to bring Net off balances (customer open items - vendor open items) into ageing report like (0-30, 31-60, 61-90, 91-120 & >120).

Kindly share the ideas to get net off balances into ageing.

also let me know how would I confirm that my zreport showing the correct values.

Thanks in advance.

Regards,

Ganesh

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 06, 2015 at 10:04 AM

    I have a doubt on customer ageing standard report balances Vs BSID table balances.

    Details:

    I am running this report for only one company code

    customer ageing report - S_ALR_87012168 showing balances as below.

    Due - 8,179,683.54

    Not due - 763,705.90

    Total balance - 8,943,389.44

    when I go to BSID table: i have given same company code which i have given for standard report above also.

    but total local currency value is showing value 130,093,609

    Now which one is correct since both are SAP standard.


    How can I cross check with report S_ALR_87012168 values and with BSID table values.



    Please share your ideas on this query.



    Regards,

    Ganesh

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 05, 2015 at 01:39 PM

    Already couple of following standard tcodes are there

    • S_ALR_87012168 Due date analysis for open items
    • S_ALR_87012178 Customer open items analysis by balance of overdue items
    • S_ALR_87012174 List of customer open items

    and I am not sure, whether you have come across with these tcodes. Go with standard as much as possible instead of reinventing the wheel.

    G. Lakshmipathi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 06, 2015 at 09:50 AM

    Hi All,

    I tested one scenario like where customer is also a vendor and posted invoices through F-22 & F-43.

    When I check the BSID - table only customer open items alone are there and same way when I check BSIK table only vendor open items alone are there.

    I understand that, net off balances can't be bring into customer ageing report whether it is standard report or z report.

    we can only see the balances either in FBL5N or FBL1N by selecting vendor/customer to see open item net off balances.

    Please correct me if I am wrong.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.