on 10-22-2013 2:31 PM
Dear Experts,
My client wants to see all customer accounts which are inactive in last 6 months. There should not be any sales document created on them. He needs to block them.
I have tried to run standard report S_ALR_87012186 with (Accounts W/O sales) tick indicator, but still it showing all customers which have sales document created on them. There is no effect on the output.
I also tried SAP OSS but not able to find any related SAP note. (1178818 ,1097806 , 869192 , 1585301 ,1365420 ) None of these SAP Notes talks about correction in (Accounts W/O sales) tick.
I am not able to understand the behavior of this tick,
Can you please help me in fulfilling the requirement.
Is this report useful in my requirement or SAP has some other standard report or i need to develop some Z report which filters data using different sales tables.
Please Guide.
Thanks
Sidharth Garg
Hi Sidharth,
I have answer this question in below thread.
http://scn.sap.com/thread/3443378
Actually there is a specific way to design the layout for the report with a filter on Sales with 0.00 value.
Follow the steps given in my reply to Pradeep (with many screen shot in one reply).
You will get your desired result.
Regards,
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Try standard analysis in MCTA.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hai Mr Sidharth,
S_ALR_87012186
If you select this parameter, the system also displays the accounts in the company code without line items.
Since most of the Standard tables records the data entry.
Here we want the list of data where entries not made.
You can ask abaper to create a z report to display the list of
Customer code where in Kunnr not having entry in VBAK.
Regards,
OD
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Many options are there but, I prefer to validate in either of the following method
Option-1
You pass the customer code (KUNNR) in VBAK table by maintaining some date range. For whatever customer code, if system has not generated any data, then you can conclude, those customers are inactive
Option-2
If you execute FBL5N, there you can see one selection option "Cleared items". If you select this and execute for a given period, system will populate all customer codes who have paid during that period. Whichever is very old or whichever customer code system has not populated, you can conclude, those customers are inactive
Last but not least, the TCode what you tried would also work which is similar to Option-1 suggested above.
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
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.