Copy Controls for Deliveries to Billing doc's

[Former Member]

Hi

I hope someone can shed some light on this issue i have.

I have six deliveries, that i need billing, same plant, same sold to, diff mats, diff del dates.

My current routines plit these into 6 invoices, but we want one invoice for he lot, i have taken out all the copy routines in a hope this would solve my problem but what ever combination i do i either get 6 invoices or 3, the 3 i do get are split by date. I take a the routines out at header and item and i am unable still to get 1 invoice i still get three, where else if anywhere can this be changed??

Hope you can help me????

Regards

Steve

[Lakshmipathi · Accepted solution]

Dear Steve

As you would be aware, if the following header datas in sale order differs, then you will get invoice split.

1) Payer

2) Inco Terms

3) Payment Terms

4) Exchange Rate

5) Shipping Conditions

6) Actual GI Date in delivery

If all the above datas are same but still you are getting split invoice, then you need to check your copy control in VTFL which should be as follows:-

At Header Level

Copying requirements::::::003

At Item Level

Copying requirements:::::004

Data VBRK/VBRP::::::::::001

thanks

G. Lakshmipathi

[Former Member · Accepted solution]

The delivery days and GI dates are all diffrent, but we want to consolidate all these deliveries onto one invoice regardless of delivery date, plant materials.

SAP does nothing with these invoices, these are sent via an interface to another system elsewahere for re processing and a new invoice is generated on another system and payment dates are sorted out there, is ther any way i can just get one invoice out of the sytsem for what ever i bill, by sold to / papyer??

Regards

[Former Member · Accepted solution]

then presume that the billing dates are different.

in this case, please use the default data tab in the VF01 screen and enter today's date and the deliveries to be billed. this should allow to create a single invoice

[Former Member · Accepted solution]

but i will be automating this process i will not be using VF01 to do this i will use the program SDBILLDL, so i guess i could use the default data section? as in VF04?

Regards

[Former Member · Accepted solution]

Hi Steve,

If your requirement is collective invoice for multiple deliveries, then in VTFL, go to the data transfer routine at line item level. hopefully, you will be having the routine 001 here.

You have to make changes to the routine 001 to make collective invoices happening. Whatever fields that are coming under the split analysis, you will find them in the coding of the routine 001. You have to just remove it.

Hope this solves your problem mate.

Cheers,

Bala

[Former Member · Accepted solution]

Ok guys some good news, i can now create one invoice, but i have to remove my routine at the Data VBRK/VBRP level, we have aspecial one in there, this is doing the splitting, any one see where it is doing it???

FORM DATEN_KOPIEREN_900.

*{ INSERT DF2K900431 1

********Basic documentation of ABAP***********************************

• Date : 30-Apr-03 *

• Programmer : Stuart Coombs *

• Program Specification : Copy Routine, billing document pricing *

• Unit Test Cases : Not Applicable *

• *

• Transport No. : DF2K900431 *

• *

• ABAP's functionality : This routine is a copy of Data Transports *

• for Billing documents (3, Single Invoice). An*

• addition has been made as per OSS note 24832 *

• (solution example 2). The change stops SAP *

• from altering the price per multiple *

• quantities (£132.10 per 100 litres) to price *

• per single quantity (£1.3210 per litre), *

• which causes rounding errors when creating *

• billing documents. *

• *

• Attributes *

• Logical Database : Not Applicable *

• ABAP type : Copy Routine *

• Status : Copy Routine *

• Authorisation group : Not Applicable *

• *

• Inputs *

• Tables : Not applicable *

• External files : Not Applicable *

• Other object : Not Applicable *

• *

• Outputs *

• Reports : Not Applicable *

• Tables : Not Applicable *

• Databases : Not Applicable *

• Screens : Not Applicable *

• External files : Not Applicable *

• Other objects : Not Applicable *

• *

• Return codes by ABAP : Not Applicable *

************************************************************************

• Modification documentation ****************************

• Modification ID: Not Applicable *

• Date of modification: 01-Jul-03 *

• Transport No.: CTS No. DF2K900548 *

• *

• Programmer: Stuart Coombs *

• *

• Description of modification: *

• 1) For delivery type ZOIL copy the order reason code to *

• LIKP-LIFEX *

• Additional logic reported in DFG-INT-004c ZZ0020 - GFMS-BFIS *

• Sales Interface ABAP V01 *

*****************************************************************

DATA: BEGIN OF ZUK,

MODUL(3) VALUE '003',

VTWEG LIKE VBAK-VTWEG,

SPART LIKE VBAK-SPART,

VGBEL LIKE VBRP-VGBEL,

END OF ZUK.

ZUK-VTWEG = VBAK-VTWEG.

ZUK-SPART = VBAK-SPART.

IF KURGV-PERFK = SPACE.

ZUK-VGBEL = VBRP-VGBEL.

ENDIF.

VBRK-ZUKRI = ZUK.

• Inserted clear command as per OSS note

CLEAR VBRP-WAVWR.

• SCOOMBS...DF2K900548...BEGIN

IF LIKP-LFART EQ 'ZOIL'.

MOVE LIKP-LIFEX TO VBRP-AUGRU_AUFT.

ENDIF.

• SCOOMBS...DF2K900548...END

*} INSERT

ENDFORM.

[Former Member · Accepted solution]

This part

IF KURGV-PERFK = SPACE.

ZUK-VGBEL = VBRP-VGBEL.

[Former Member · Accepted solution]

It's the data going into the ZUKRI field. This is used for invoice splitting and the routine you posted is inserting VGBEL (i.e. reference document) which will be different for each delivery and thus cause a split.

Brian

[Former Member]

All resolved now

[Former Member]

more questions to ask regarding this issue

[Former Member]

Thanks again everyone

[Former Member]

Hi i have some more questions if you guys dont mind taking a look and giving me some advice.

I am using the following copy controls as suggested earlier.

At Header Level

Copying requirements::::::003

At Item Level

Copying requirements:::::004

Data VBRK/VBRP::::::::::001

This is all good for GB invoices but when i process a NON GB delivery lets say IT, i get single invoice, i think the reason for this is that in the foreign trade data in the organisation tab there is a "number of foreign trade data" (EIKP-EXNUM) this is what seems to be splitting the invoices (this is based on if i select two deliveries from VF04 and to collective invoice then split analysis). Other than this area all header data is the same.

My question is how can i make these invoices be combined??

Regards

Steve

[Former Member]

In the copy control at header level, try setting the "Detrmin export data" field to 'B'.

Brian

[Former Member]

Hi Brian, thanks for that but that made no difference.

I take it this should be the copy from Delivery to Billing Doc

[Former Member]

If i do the collective online processing i get this info : -

Split analy.

Split due to different header data

Fld Name $000000001 $000000002

Number of foreign trade data i 0000011665 0000011666

Customer purchase order number 000022621 000022690

Reference Document Number 000022621 000022690

[Lakshmipathi]

Dear Steve

From the split analysis given by you, what I can suggest is that go to VTFL, select your billing type and delivery document type and click on magnifying lens. Now maintain a blank field against "Determ.export data". Now retry.

thanks

G. Lakshmipathi

[Former Member]

I get the same result if it is blank or has a B in it......

[Former Member]

Your split analysis shows different sales orders and PO numbers so even if the FT data is fixed you will still get a split. What are your settings against Allocation number and Reference number?

Brian

[Former Member]

Hi Brian, but this is also the case for GB diff orders and they work fine....

Settings are : -

Copying requirements 003 Header/dlv.-related

Determ.export data

Assignment Number E

Reference number A

[Lakshmipathi]

Dear Steve

Instead of "A" in Reference Number, please try with option of maintaining "E". Moreover, I dont think based on PO references, invoice will split bcoz, I have generated lot of invoices clubbing multiple sale orders and each sale order will have different PO reference obviously.

thanks

G. Lakshmipathi

[Former Member]

Steve,

Are GB orders using the same delivery and billing types?? If so, then I struggle to see how they can be behaving differently.

On the subject of customer PO numbers, the system will ignore the differences unless you enter 'A' in either the Allocation or Reference fields.

Brian

[Former Member]

with the following combination i am able to get one billing doc out now.......

Copying requirements 003 Header/dlv.-related

Determ.export data B

Assignment Number E

Reference number E

[Former Member]

Thanks for all your help yesterdays guys but i have some more question, i have issues where i have eg, 3 diff sold to's but the same payer, i still get 3 invoices i would like invoices based on the payers if this is possible, is there a standard setting in config to allow this to happen?

Regards

Steve

[Former Member]

since the header partners are different, system will always split. this is already specified by SAP in their Note 11162

[Former Member]

absolutely right

[Former Member]

hi,

if u want to do collective invoice

then the payer, terms of payment and billing date three should be same. Check whether these three r same.

regards,

ram

[Former Member]

please check the split analysis to find out why the split invoice created. You can find more information in SAP Note 11162

[Former Member]

Hi there thanks for the quick response, there is no splitto look at all i get is the following : -

1000000324 SCANE 23.04.2008 3 1

[Former Member]

In VF03 -> Enter the billing document number

Then in the Menu -> Environment -> Split Analysis

System will ask to enter the other billing document. After this you can check why the documents split