VF01 net value of invoice in custom report.

[former_member761924]

Hi Experts,

There is a requirement to get Net value of invoice in a Custom report. Basically the invoice wouldn't be created yet, but delivery would be completed. In such scenario, I need to get the estimated net price as it would display while creating the invoice in VF01 transaction.

I needed help with calculating this net price in the custom report, is there any function module that I can use for the calculation or can I call any standard program related to VF01 in this net value calculation?

Any help is appreciated.

[sanilbhandari]

Hi

Just another perspective on the requirement purely from a process perspective, you could probably create a performa invoice. This would have two effects:

a) The business would have an idea on the invoice value and they can share the same with their customers as an output since that is the functionality of performa invoice

b) You can also pull the info from VBRK

Please question your business if they have a requirement to know the invoice value even before the tax or commercial invoice is created, why not add an additional step to create a performa invoice. Even without a custom report, you can get a list through VF05 based on billing type F5, so a custom report is not even required ( I do not know what fields you need, so you need to check out in the system the display of VF05 supports your requirement). Why do a custom development when this can probably be solved using a standard SAP functionality !

Thanks & Regards

Sanil Bhandari

[former_member761924]

Hi Sahil, there is an existing custom report to which net value field needs to be added, so we need to code in oreder to get this net value. Since the requirement is to know the net value before invoice is created, we can't fetch from VBRK. Could you explain more about usage of performa invoice for this requirement.

[sanilbhandari]

Hi liki999

A performa invoice is also an SD Invoice, but is not released to accounting. The information is also updated in VBRK, so you can directly fetch the values. It is not a commercial or tax invoice, but more of a what an actual commercial or tax invoice would look like with values, but without updating the GL in the system or posting of taxes. I infer from your question is that this is what your user is looking for. If that is the case, they must adapt a change of process, where they create performa invoice before the actual invoice. You can identify a performa invoice from VBRK as shown below:

A performa invoice would have billing category as U. If you are someone with a technical background, please work with an SD Colleague to talk to your business and use a standard process already available.

Thanks & Regards

Sanil Bhandari

[former_member761924]

Thanks Sanil, much appreciated. Will check with business on this.

[Lakshmipathi]

In vf04, you have net value. If the value column is blank in vf04, and you desperately needed, have a look at OSS note 505386

[former_member761924]

Thanks for taking time out to look into the query. I found a FM RV_INVOICE_CREATE to get the net value by just passing the delivery doc number and running in analyze mode (Import parameter - I_ANALYZE_MODE). Your thoughts on this?