Standard report-Non performing customers

[former_member185462]

Hi,

Is there any standard report to get the list of customer who have not done any purchase or the customer no sales is done for a certain period of time.

Thanks,

Pradeep

[amit_tunara · Accepted solution]

Hi Pradeep,

You can use report S_ALR_87012186. In the selection screen, there is an option to list Accounts (Customers) without Sales. Please see below image.

Please note that, the report will display list of customers, but by ticking this you are also enabling the customer listing where no transactions are there.

I hope this will help you.

Regards,

Amit

[venu_ch8 · Accepted solution]

Dear Amith

but in this transaction if we want to know inactive customers in perticuler time period here time option is not there ?

[amit_tunara · Accepted solution]

Dear Venu,

I think as MoazzaM has mentioned directly it is not possible to get inactive customers directly, but the SLR reports, MCTA reports will help us to get by little analysis.

It has to be done by ABAP code with a simple logic. List down customers from KNVV who does not have any entry in VBRK and you can add more requirements as per need.

Regards,

Amit

[former_member185462 · Accepted solution]

In the fiscal period wise means,from April means we can give Reporting period 01 to 06 which will cover upto September.

But against some customers sales values are there ,whereas for other customer the sales value is 0.

Why does it happens.

Thanks,

Pradeep

[amit_tunara · Accepted solution]

Hi Pradeep,

By default this report is suppose to list all Accounts. By checking the mentioned checkbox, you are just extending your list for customers where the sales is Zero. You can explore the available option to see only customers with 0.00 value.

For example, there are two buttons to define the output layout. So click on Configure button for Details List button and set the filter on Sales column to list only items where sales is Zero. Try this.

Regards,

Amit

[former_member185462 · Accepted solution]

Hi Amit,

I did as you said.Even some non zero values are coming in report.

Thanks,

Pradeep

[amit_tunara · Accepted solution]

Hi Pradeep,

I missed to mention one thing.

Click on Configure button as I mentioned above. Select the column Sales and define the filter for only Zero values. Now Save the layout with proper name. Click on Back.

Now in Default List select your layout name which you have defined and then run the report.

It should show only zero value customers.

Let me know with your findings.

Regards,

Amit

[former_member185462 · Accepted solution]

Hi Amit,

Even after doing so,as said by you .I could get zero and non zero value

Thanks,

Pradeep

[amit_tunara · Accepted solution]

Hi Pradeep,

Please follow the below step. I was able to generate the report as per need.

Click on Configure button.

Select Sales Column and click on Filter button from the toolbar.

Now instead of typing the value as 0.00, click on Multiple Select button against Sales field.

Now click on column header to get Selection option. From this select Singe value.

When you select this automatically value 0.00 will come with leading zeros. Do not change anything and click on OK.

Now save your layout with proper name. With this from report selection screen if you press F4 for number of layouts, you will see an additional tick in Filter column which is missing in your screen shot.

Now, when you run the report you will see only non-performing customers. I have done the same in my system and the output is what you are expecting.

This will solve your issue hopefully.

Regards,

Amit

[former_member185462 · Accepted solution]

Hi amit ,

I am getting report like this.what would be the mistake

[amit_tunara · Accepted solution]

Hi Pradeep,

Please make sure that the option "Display Totals Only" is not ticked. With below settings I am getting the correct result which I have pasted in my previous reply.

If your settings are same, then might be there are no records in a given period. I think you running on IDES, so try to run with some other company code.

Regards,

Amit

[Former Member · Accepted solution]

    Dear Amith .. your post is very nice but i would like to ask one thing

I am not able to find How to configure lay out plz plz explain me

[amit_tunara · Accepted solution]

Dear Geetha,

In the selection screen of the above report, scroll down at the bottom. You will see two Configure button. Click on Configure button of Detail List field. Here you can set the layout. If you read the entire thread, I think al screen shots are given.

Let me know if you still face issue.

Regards,

Amit

[Former Member · Accepted solution]

Dear Amit .. i found it Thanks

May i know what is the purpose of Layout ?

[amit_tunara · Accepted solution]

Dear Geetha,

The purpose of Layout is to set the default settings for Report output. The default preference of Sorting, totaling and filter can be set using Layouts.

Regards,

Amit

[former_member216765]

Hi

Try standard analysis from MCTA.

[venu_ch8]

Dear AMITH SAXENA

MCTA ALSO wont work bz in mcta we can find how much stock we have sent to perticuer customer

as MOAZZAM Said directly not possible

[moazzam_ali]

Hi

No there is no such report. You have to extract data in Excel from VBRK table or BKPF or from FBL5N, VF05N. Then extract data from VCUST or KNA1 fr customers. Put VLookup formula in excel and find out the customers who have never done any business with you.

Thank$

[venu_ch8]

Dear MOAZZAM

May i know

 vlook farmula 

I think FD11 ,, FDK43 ALSO POSSIBLE

PLZ comment on this i am right ?

Thanks a lot

[moazzam_ali]

Hi Venu

Please create a new customer and dont maintain any credit limit and dont create any sale order, delivery or billing. Just create customer and check in FD11 or FDK43. Will you be able to see that customer in these two reports or not?

Thank$