Material based invoice split

[Former Member]

Hi

I have a requirement to split invoice based on a particular material.

In a sales order there are 3 materials say X, Y and Z. When i create a invoice followed by a delivery the invoice should be splitted into 2. 1 for materials X and Z and another 1 for material Y always that is always material Y should have seperate invoice with seperate invoice numbers.

Kindly help me to map this.

Regards

Rajkumar K

[Former Member · Accepted solution]

Hi ,

Maintain one set of payment terms for "X" and "Z".

Maintain another different payment terms for "Y".

Goto VTFL screen.

Select your valid combination of billing type and delivery type.

Click on item.Select your item category.

Details.

Maintain "Data VBRK/VBRP" as "001".

Save.

If you try then definitely splitting will happen.

Next goto VF01 T.Code.

Enter your delivery number.Donot press Enter.

Click on Selection list.

Select your items.

Save.

Regards,

Krishna.

Note:Pls search the forum.

[Former Member · Accepted solution]

Hi Krishna

Thanks for your suggestion but in my case the payment terms remain same for all materials.

Regards

Rajkumar K

[ivano_raimondi]

Hi Rajkumar,

in transaction VTFL, at item level, there is the routine 'Data VBRK/VBRP'. In this routine the field VBRK-ZUKRI is filled.

This field is designed to set custom splitting criteria.

So you should create your own routine setting VBRK-ZUKRI so that split occurs whenever you need.

Best regards,

Ivano.

[Lakshmipathi]

In the material master, maintain the Division as 01 for Material X and Z and 02 for Material Y.

Next go to VTFL, select your item category for the combination of your delivery type and billing type where you can see a field "Data: VBRK/VBRP". Assign routine 351 here and save.

Now create sale order, delivery and billing. See how it works.

thanks

G. Lakshmipathi

[Former Member]

Hi Lakshmipathi

Thanks for your valuable inputs. Let me try this and come back to the forum.

Regards

Rajkumar K

[Former Member]

Hi

One more suggestion.

You can define different "Material group" assign them to the material master in Sales org 2 for the respective material.

You ask your Technical Consultant to develop a new routine where he must specify the "Material group" as one of the split critria.

He can copy the standard one "001" and add "Material Group" as an additional criteria for splitting, save it.

Assign the new routine in VBRK/VBRP field at Item level in Copy control table (Delivery doc to Billing doc).