Combining Deliveries in Invoice

[Former Member]

Hi, How do we combine 3 delivery in 1invoice? Plz give me step by step config.? Thanks

[Former Member]

You can check SAP Notes 11162, 36832, 308733 for more insight into the Invoice consolidation & Split issues.

At the time of Invoice creation (VF01- SAPMV60A), a Function Module : RV_INVOICE_CREATE is called and an internal table containing the source documents is passed to this function.

System compares various values from the source documents (for header and item level) to enable it to understand as to what all source documents can be clubbed into a single invoice, and for the others it generates different invoices. (A Combination Criteria is set up, and the system behaves accordingly)

System has several fields hardcoded in the invoice creation program which should NOT cause a split to occur.

for this you can check the include MV60ATOP in SE38, the fields mentioned here, if found differnt in the source document DO NOT cause Invoice split to happen. By adding a field here would be a Global change, so its only recommended after consulting with the business.

DATA: BEGIN OF AUSNAHME_TAB,

FELD1(5) VALUE 'VBELN',

FELD2(5) VALUE 'NETWR',

FELD3(5) VALUE 'KNUMV',

FELD4(5) VALUE 'VBELN',

FELD5(5) VALUE 'ERNAM',

FELD6(5) VALUE 'ERDAT',

FELD7(5) VALUE 'ERZET',

FELD8(5) VALUE 'AEDAT',

FELD9(5) VALUE 'BELNR',

FELD10(5) VALUE 'RFBSK',

• FELD11(5) VALUE 'MRNKZ',

FELD12(5) VALUE 'SFAKN',

FELD13(5) VALUE 'MWSBK',

FELD14(5) VALUE 'FKTYP',

END OF AUSNAHME_TAB.

besides this there are Data Transfer Routines in the system which support the business cause. (VBRK/VBRP field in the item level copy control between delivery-billing, order-billing)

New Routines can be created supporting the business process, just in case if the business doesn't want a particular field to cause a split to happen.

Hope this helps.

Regards,

Vivek

[Former Member]

Hi Gaurav

In standard settings, system tries to combine the deliveries into one Billing document if they have the certain same data in common.

Those data are,

1. Payer

2. Payment Term

3. Billing Date

4. Destination Country

5. Incoterm

Standard settings means,in copy control (VTFL) at Item level, ensure that in the VBRK/VBRP field value is "001".

So if the above data are same for the deliveries, then system will combine them into one Billing document.

Go to collective processing (VF04), give your required criteria like Sales organisation , Sold-to-party, date. etc and execute.

In the next screen select the deliveries you want to process from the list and click "SAVE" button.

System will create the billing document collectively to as few billing document as possible under a group number.

Those deliveries which do not satisfy the above criterias are splitted as different billing document and those satisfy will be combined into one billing document.

If you want to see the billing document numbers then select the group number and click on the "Document" Button.

[Former Member]

Hi Vishal,

Goto T.code VTFL and select the billing type & delivery doc. type then click on item there is a field Data VBRK/VBRP here give 003.And wen ur doing a billing give delivery doc .nos. one for each

line item.

ex.9000000

9000001

9000002

i hope it wil help u

thanks

sreenivas

[Former Member]

Hi,

Go to T.Code: VF01 (Create Invoice).

Select your Billing Type & Billing Date*.

*Billing must be the same as in the latest delivery document, among all the deliveries.

Example: You have 3-Deliveries:

Del. 1: Dated - 01.09.2008

Del. 2: Dated - 03.09.2008

Del. 3: Dated - 05.09.2008

So Billing Date must be either 05.09.2008 or a later date.

Now, key-in your Delivery Doc. Nos. in Column: Document; one after another and Press F8.

Now, System will take you to another page. Check all the Details as Material, Net Value etc... and Save.

This will Generate the Invoice. Also, the system will post an Accounting Doc. for the same for Financial-purposes.

Best Regards,

Amit

[Former Member]

Go to transaction VF04 and enter the three delivery document numbers and execute. Select the three documents and click on Individual or Collective. This will create the invoice provided there are no invoice splits i.e. all the criterion for split are ok.

Regards,

GSL.

[former_member204513]

Dear Vishal,

There is some of the data should be identical in all the three deliveries then only you can able to bill in the single document.

Like

Payer

Payment terms

Bill to party etec.

Go to VF04 transaction enter the proper selection data then execute now system will give the deliveries list which are not at billed in this screen you select your three delivery number then click on Collective billing document./online now system will take you to the billing creation screen finally save the billing document system will generate the nuber for that billing document.

I hope it will help you,

Regards,

Murali.