Invoice combination / Split

[Former Member]

Hi

I'd appreciate some suggestions on how I can achieve invoice split/ combination based on a customer requirement which is not known up front. eg..Customer hasn't specified that he wants his invoice combined upfront but wants us to combine certain lines from certain contracts in one invoice. Invoice list is not acceptable to them!! If I do want to approach a

customized effort, how should it be best approached?

Thanks

[Former Member · Accepted solution]

hello,

usually copy requirements can be created for such cases. But you would need the reason beforehand in order to be able to programm it.

So in standard I don't see any solutions. You will need your own report, that would select lines from the billing sue list (VF04) based on the given criteria.

Balazs

[claudia_neudeck]

the last action was before two months, so I close this thread

[Former Member]

Hi,

You can very well acheive this by using the split criteria in the billing document header.

You can use some field or data in delivery to pass into the split criteria.

Eg: You have tax indicator in material master as X - taxable & Y - non taxable.

or some field which differentiates two material from each other.

Further you need to write a routine with the help of your ABAPer.

For this goto tcode - VOFM - Data transfer - Billing Documents, here you write a routine as under:

(I am giving a code for your reference, this shows how purchasing group from material is used to split the items into different invoices )

FORM DATEN_KOPIEREN_807.

IF LIKP-VKORG = '5000'.

TABLES : MARC.

DATA: BEGIN OF ZUK,

MODUL(3) VALUE '801',

EKGRP LIKE MARC-EKGRP,

END OF ZUK.

SELECT SINGLE MATNR FROM LIPS INTO LIPS-MATNR

WHERE VBELN = LIPS-VBELN

AND POSNR = LIPS-POSNR.

SELECT SINGLE WERKS FROM LIPS INTO LIPS-WERKS

WHERE VBELN = LIPS-VBELN

AND POSNR = LIPS-POSNR.

SELECT SINGLE EKGRP FROM MARC INTO MARC-EKGRP

WHERE MATNR = LIPS-MATNR

AND WERKS = LIPS-WERKS.

IF MARC-EKGRP = 'MFG'.

*ZUK u2013 EKGRP = MARC-EKGRP.

VBRK-ZUKRI = MARC-EKGRP.

CONDENSE VBRK-ZUKRI NO-GAPS.

ENDIF.

ENDIF.

ENDFORM.

you can also pass the data in the ZUKRI field.

Finally you enter this routine number in copy control betn delivery & billing documents.

This should be entered in item details in "Data VBRK / VBRP"

Now when you create billing from delivery your invoices will be splited.

Hope this helps you.

Regards,

Dhananjay