Splitting Invoices according to VAT conditions

[Former Member]

HI All,

We have a requirement that if a sales order has 2 materials and if one of the material is relevent for tax and the other is not then when the invoice is being created there should be seperate invoices created, any ideas?

[Former Member · Accepted solution]

Hi Paul

Please go thru this link which would give you clue to set split criteria

http://help.sap.com/saphelp_470/helpdata/en/dd/560f63545a11d1a7020000e829fd11/frameset.htm

Kalpesh

[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 order to pass into the split criteria.

Suppose, you have tax indicator in material master as X - taxable & Y - non taxable.

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:

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 condition type 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

[Former Member]

Hi Paul,

You can use copy control for the same.

Create routine with help of Technical consultant and assigne at Data VBRK/VBRP .

In routine you can check tax classification at line item level that is for material if it is diffrent then invoice split will happen.

0 is Tax classification for nontaxable material.

1 is Tax classification for Taxable material.

Rajesh