Minimum total amount on Billing doc

[Former Member]

Hi,

Is it possible to put a check on a minimum amount for the creation of a billing document?

Ex: I have a Sales order with multiple line items: we don't have a delivery.

I expect 2 billing docs from 1 Sales order: First billing doc from SO item 1 tot amount 430

Second billing doc from SO item 2, tot amount of 90, this is less than our minimum billing amount of 100.

I want my first Billing doc to be created and the second billing doc not.

How can I do this?

Thanks!

Louis

[Former Member]

Thanks Srinath,

With the user exit USEREXIT_STATUS_VBUK_INVOICE you can indeed change the billing status. But not prevent that the posting is done in FI. It is more a user status that you can change, not a global status. Ex I put a value (A: Not yet processed) in VBUK-buchk.

In fact I want to delay this second posting. So it can be taken into account with another SO the next day when the new total exceeds the 100 amount.

Any idea?

Many thanks.

Louis

[former_member217082]

Hi Louis

You can go with the USEREXIT_FILL_VBRK_VBRP (Module pool SAPLV60A, program RV60AFZC). As this user exit is called when the billing document is created.

Regards

Srinath

[Former Member]

Hi Srinath,

I first tried this userexit to give an error message: but all the billing docs are blocked than for that SO.

Another option of the user exit USEREXIT_FILL_VBRK_VBRP is : he enters this exit at the end of each billing line or update

In the XVBRK-VBELN you have a $00000001 number: you can check the total amount is bigger than 100

so I try to remove all the lines in all corresponding tables like xvbrp, xvbrk, xvbpa, xkomv, tkomk, xthead and others with the key $00000001 but when he saves you get an update error:

Update was terminated: Inconsistency in the posting tables for XVBRK_TABIX = 0

V2: 031 in function RV_INVOICE_POST report LV60UF0V row 430.

I can not do this check earlier because I need the total of all billing items to check this minimum amount.

Kr.

Louis

[former_member217082]

Hi Louis

Welcome to SDN Forum

If you want to put a check for a minimum amount for the creation of a billing document ,then you have to go with a user exit USEREXIT_STATUS_VBUK_INVOICE where you can use this exit to influence billing status at header level.In this user exit you have to include the logic that the minimum value should be some 100 amount .

Regards

Srinath