One invoice per sales order for delivery related billing

[Former Member]

Dear all,

Here is my requirement:

One customer is requiring us to issue only one invoice per sales order.

Given that we can have multiple outbound deliveries per sales order the prerequisite is to ensure that all outbound deliveries have status goods issue posted.

Sales order 1

Outbound delivery 1

Outbound delivery 2

Outbound delivery 3

Outbound delivery 4

Invoice 1

Invoices have to be generated automatically so is it possible to implement a check to ensure all outbound deliveries linked to a sales order have status goods issue posted?

Thanks.

Anthony

[Lakshmipathi · Accepted solution]

Why don't you go for delivery related billing and generate one billilng document against multilple deliveries?  Of course, with standard cofiguration, it is not possible and you should be knowing based on what are all parameters, an invoice split can happen.  So you have to try with billing exit.

G. Lakshmipathi

[Former Member · Accepted solution]

Actually we already have delivery related billing and if we do it manually it'll work.

The tricky part is the automation. The system has to detect that the sales order is fully delivered (meaning in our business, all deliveries have goods issue posted).

Scenario:

Sales order 1

Outbound delivery 1 (GI posted)

Outbound delivery 2 (GI posted)

Outbound delivery 3 (GI posted)

Outbound delivery 4

=>At VF04 running, the invoice should not be generated because delivery 4 is not shipped.

Same behavior if we use VF01 including only first 3 deliveries, it must block invoicing.

Invoice must be generated only once all sales order related deliveries are shipped:

Sales order 1

Outbound delivery 1 (GI posted)

Outbound delivery 2 (GI posted)

Outbound delivery 3 (GI posted)

Outbound delivery 4 (GI posted)

Invoice 1

=>Invoice is generated.

I didn't find a user-exit to implement that rule. Meaning to prevent from billing deliveries linked to an uncompletely delivered sales order.

Any clue ?

[Lakshmipathi · Accepted solution]

Try with USEREXIT_FILL_VBRK_VBRP in program RV60AFZC

G. Lakshmipathi

[Shiva_Ram · Accepted solution]

Check with the OSS 63523 - User exits for billing index as of 3.1G and the user exits given in it. You may try to influence the billing index table if all the deliveries are not PGI'ed.

Regards,

[Former Member · Accepted solution]

Ok thanks. I see how to prevent my outbound deliveries from being pushed to billing index table. But how to add them back once all deliveries have been shipped?

Also it doesn't prevent from VF01 billing. Is there a way to implement the same rule at VF01 time?

Thanks.

[Shiva_Ram · Accepted solution]

For influencing VF01, you may need to check the copy control settings routines in t.code VTFL. At the header level, check the field Copying requirement field and in the existing code, you may need to add additional code to check document flow of the sales order/status of other deliveries. If condition is not met, then the routine should not allow to create the billing document.

Regards,