related to report

[Former Member]

Hi All

I have an issue ,please help me out. The issue is like this we

have lot of customers and these customers are extended in many sales

area.. Now we want to create a report in which we want to find out

customers in those sales area in which

no sales document of that particular customer is generated.

For ex- suppose one customer is extended in 5 sales area ,

than i want to find that sales area in which no sales document has been generated

means the customer is only extended but nothing at all happened. I

want report for this.

Thanks and Regards

Abhilash Nayak

[Jelena]

There is no standard report for the sales documents.

There is one FI report (use Search if you're interested) that has an option to list 'Customers with no sales'. However, the description is misledaing since it's actually looking for the customers that do not have any FI postings. They could have open sales documents that haven't been billed yet.

[Former Member]

Please check if these transactions get you the required info

MC+E or

MCSI or

MC+2

Regards

Sai

[Jelena]

>

> Please check if these transactions get you the required info
> 

No, these transactions will not get the "required info". The OP wants to know the customers, for which the documents do not exist. The transaction that you mention are using SIS - there won't be any records for a customer if there are no sales documents.

There are many reports that show the sales data per customer, but no reports that show the customers with no sales data. It doesn't seem that OP would be interested to run a report for each customer # to see if anything comes up.

This question has already been asked at least several times on SDN.

[former_member1091983]

Hi,

Why don't you try in t-cod VA05N? Enter sold to party and see the orders for which sales area the same have been created.

If u want to see the sales area of a custoemr then use t-code VCUST...

If this is not suffce..then develop a Z-report with ABAP help by combining these two reports..

Reg,

JJ