on 08-22-2013 11:25 AM
Dear sd experts
Any T.code is there if i want to know how much discount have given to customers ( only discounts) in the last month
how it is possible .. I have checked in OBXI but i am not able to find
plz forgive me if it is basic question .. thanks a lot
Hello,
It is ideal to create a Z-Report for requirements like this. Ensure that in the Z-Report the cancelled Invoice & the original Invoices (of the Cancelled Invoice are ignored).
You can also refer to below link displaying a sample ABAP code for Sales Discount Report: http://wiki.sdn.sap.com/wiki/display/Snippets/Sales+Discount+Report
Thanks,
Jignesh Mehta
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Venu
I want to know that whether you have maintained different GL for your different discount conditions? If yes then you can easily get the desired result in FBL3N. There you will find the posting date, amount and customer number or may be invoice number in reference or assignment field as per your configuration. You can extrat data on Excel file and manipulate it as per your requirement. For this you have to make sure first that you have different G/L for the discount condition which you want to check.
Another way is to create a Query report in SQVI by using Logical databaseVFV and select condition type in selection screen and amount in output. As mentioned by Jignesh pleasebe careful with reversal and return documents.
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.