Invoice getting split based on Billing dates. Order to Billing

[Former Member]

Hi Guys,

I am having a service material. Item category TAD. (Order to Billing). Each line item has different billing date.

When I do billing VF01 or VF04 it splits the invoice based on billing date.

The client has 15 and 30th as billing cycle.

I want to combine all line items which are due for billing on 15 and 30th.

How do I prevent splitting of the invoice.

Thanks in advance.

[Former Member]

please check SAP Note 11162

[Former Member]

Samia,

The best thing I can think about is writing a routine in the copy controls that will change the billing date of all the items due on 15th and 30th to be same.

Thing about the best possible conditions and make the VBRK-FKDAT same for all the items.

Regards,

Aj

[Former Member]

Hi Samia

Combine rule is controlled through routine in copy controal. At item level for TAD item category you need to create new data copy rule.

You can create data copy rule by using T.Code VOFM.

Refer below program and points.

.g. Program FV60C900

DATA: BEGIN OF ZUK,

MODUL(3) VALUE '900',

BUPLA LIKE VBRK-BUPLA, "Business place

LIFNR LIKE LFA1-LIFNR, "Consignor (Vendor Consignment)

MWSKZ LIKE VBRP-MWSKZ, "Tax code

END OF ZUK.

ZUK-BUPLA = VBRK-BUPLA.

ZUK-LIFNR = LFA1-LIFNR.

ZUK-MWSKZ = VBRP-MWSKZ.

VTFL - Check copy control rules

Target Source

e.g. Select F2 - Invoice LF Delivery

Click Item

e.g. Double click on Tan - Standard Item

Check Data VBRK/VBRP - Copy rule number in use e.g. 900

VOFM - Creating a splitting rule

Click Data Transafer -> Billing documents

Copy the standard 1 - Inv.split (sample) to a e.g. 900 series number range

A new splitting rule 900 will be created, follows by a program FV60C900.

In program FV60C900, SAP has a standard internal table called ZUK where you can define fields that must be compared and be equal before a billing may be combined. However, total characters allowed is 40 will be store on the billing header table VBRK.

In the data copy rule routine you need to clear billing date.

Regards

Vijay