Skip to Content

Customized Sales Employee Report

I have a Business Requirement in which I need to create a Report showing

1)Ordered Quantity

2)Delivered Quantity

3)Billed Quantity

4)Outstanding Customer Balance

The Input Parameter is Sales Employee

We enter the Sales Employee and the Report should display the customers with the Sales Employee and the Ordered Quantity, Delivered Quantity, Billed Quantity and Outstanding Customer Balance.

The Transaction FD10N shows the Outstanding Balance by Customer.

But we need to display the Outstanding Customer Balance by Customers associated with the Sales Employee.

Please Advise.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Aug 29, 2017 at 07:28 AM

    Hi

    We had a similar requirement in one of our project. We used the t code S_ALR_87012172. Now make use of a field which is available in customer master and also in dynamic selection of this report. Than you can input this field with a code for Sales Employee and execute the report based on that. You do not need to develop a custom report in that case.

    If that does not work for you, another way is to use COPA report. Here you can create a characteristic which will flow into COPA and than run KE24 as well.

    So check what works best for you

    Regards

    Sanil Bhandari

    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.