cancel
Showing results for 
Search instead for 
Did you mean: 

Report on gross profit per invoice

gino_babu2
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

jignesh_mehta3
Active Contributor
0 Kudos

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

former_member209761
Active Contributor
0 Kudos

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

jpfriends079
Active Contributor
0 Kudos

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

former_member209761
Active Contributor
0 Kudos

Dear JP ,

If we do the setting as described by you, it will only have impact on the new documents which are going to be created right?

Is there anyway we can update the same for existing documents?

Thanks & Regards,

Hegal K Charles

jpfriends079
Active Contributor
0 Kudos

Hello Charles

Rightly commented by Jignesh.

Don't have any standard report for this.

Suggestion post me is doesn't not involve any

Enhancement

or

Z Report.

With simple configuration in pricing you can get value in Table VBAP / VBRP.

Regards

JP