Small invoice handling.

[Former Member]

Hello Gurus,

We have a business scenario, where business doesn't want to bill those invoices which has amount less then 50 euro.

Current solution: Collective invoice is getting generated and then invoice below 50 Euro is getting cancelled with custom Z program.

New Requirement : Business have requirement to eliminate the need of custom z program. It wants to create functionality which runs collective invoice and left invoice below 50 Euro.

Functional Design.: We decided to copy SDBILLDL (VF04) and make Z program, where we run it first in the test mode. Then logic will filter the invoice below 50 Euro and then bill only those invoices which has amount more than 50 Euro. This design looks ok, but its very complex. First problem is that VF04 runs for collective invoices, so we have situation where one customer might have so many orders below 50 Euro, may and may not be below 50 Euro after collective invoice run. Which has forced us to run the entire program in test mode. This is second problem. It has lots of table assigned which are making FI entries. My question is how to prevent those posting in test mode and get net value per invoice before actually creating invoice?

Thanks in advance and Regards,

Mukul

[Lakshmipathi]

First you need to populate the value for those deliveries in VF04.  For that carry out the modifications as recommended in the following note:-

• Note 505386 - No display of net values and currencies in VF04

Once you are done with populating the value in VF04, add the logic in USEREXIT_FILL_VBRK_VBRP in program RV60AFZC in such a way to check the value and accordingly generate billing documents for more than 50 Euro and ignore deliveries value below this

G. Lakshmipathi

[andrea_brusarestelletti]

Hello,

  what about setting a validation during FI posting, so that you will create the SD invoice without releasing it into accounting (as a matter of fact the SD invoice as far is not released, can be considered just a draft); then all the blocked invoice can be analyzed by the user.

In case a customer has many invoices smaller than 50 Euro, what is the procedure? I guess they should be merged?

How the VF04 is run? Manually by the user or automatically?

Best regards,

Andrea

[Former Member]

Hi Andrea,

First suggestion is good and will check viability in test mode. we don't want to put validation in actual creation of the invoice. as volume is too high.

If customer has many orders less then 50 Euro due for invoice, It may or may not merge depending upon criteria. That's why we have requirement to run Collective invoice in test mode.

VF04 is run via background job. (automatically).

Warm regards,

Mukul