on 10-24-2013 8:02 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
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
Hi
Try standard analysis from MCTA.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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$
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.