on 01-06-2012 9:09 AM
Hai Gurus
I am in search of a report which gives gross profit per invoice. any standard ones. searched many but cudnt find.
regards
Sidhu
Hello,
I believe such report is not available in stadard system.
You will have to get a Z-Report Developed based on your requirement.
Hope this helps,
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.
Dear Sidhu ,
Do not think there is any standard report with 'GROSS PROFIT'.
You may create a Z report with following logic.
Selection screen:
Date : from .. to
Billing type :
Logic of report
Based on the above selectiion, fetch VBRK-VBELN & VBRK-KNUMV
Put VBRK-KNUMV to get the values of KSCHL from KOMP which is used to calculate the gross profit.
for example if your gross profit is ZXXX-ZYYY where ZXXX and ZYYY are appearing in your invoice pricing procedure as condition types, then put VBRK-KNUMV in KOMP with KSCHL = ZXXX & ZYYY.
The difference of the two condition types can be displayed as the GROSS PROFIT.
If you can provide a sample calculation of your pricing procedure,we could explain better.
Thanks & Regards,
Hegal K Charles
Edited by: Hegal . K . Charles on Jan 6, 2012 3:17 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
One of the option could be to have a provision for Gross Profit calculation in your pricing procedure for the billing.
For instance, refer Profit Margin in standard Pricing Procedure RVAA01, step no 950.
You can have similar set up in your pricing
To achieve a report on that.
You can further have Subtotal field assign for it, say, 6 - Carry over value to KOMP-KZWI6.
So, this field will take the value of KOMP-KZWI6 to VBAP-KZWI6 at sales order item level.
Thus, by using table-field combination of VBAP-KZWI6, you can take the value to report or use value of that combination.
Regards
JP
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 | |
7 | |
7 | |
4 | |
3 | |
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.