Invoice split issue with foreign trade data, pls help

[former_member186887]

Hi All,

Regarding this issue, i have found quite a few links in SCN but I am unable to understand

I had created a sales order with two line items and completed delivery and PGI. Now, when I am trying to create invoice in VF01, the invoice split is happening. Then I checked with split analysis; the split analysis shows the two different values. One is material group and second one is number of foreign trade data (please find the screenshot).

I had understood that material group is coming from material master; so I tried creating order to invoice with materials having different material groups and could able to generate single invoice (so material group is not splitting invoice)

Now, coming to number of foreign trade data. I do not understand where this data is coming from (material master or where the source is). System is showing two different foreign trade data values for two invoices in split analysis (which are having one material in each invoice). Business needs one invoice per one delivery. I am trying understand the issue to explain the user. How these two materials are different in terms of foreign trade data and where we can see the differences.

Request you all to help me in understanding the foreign trade data source. If possible, help me a bit clear steps.

Thank you in advance.

split-analysis.png

[former_member183501 · Accepted solution]

What is "HNO" & "HMI" this is causing Invoice split because of this only, system is giving two foreign trade data numbers.

I believe in copy control(VTFL) you might have maintained (Determ.export data:B) or is it copying from delivery document number if Determ.export data is blank? For that you can check Foreign trade data number both the items in Delivery item level.

Check if any custom routine assigned in copy control specific to your business need in which additional fields might have been considered for Invoice splitting.

If nothing helps then finally you can also get the same debugged.

[former_member186887]

I took help of ABAP team to debug the custom routine in VTFL and found the cause for this issue. It was due to an enhancement for a sales org specific invoice split.

Thank you all for your inputs, it's a good experience to understand about this topic.

[bell_yang]

The foreign trade data are determined during the Intrastat selection run directly from the master data or from customizing. Please check note 2267310 and 2411124.

[Lakshmipathi]

Have a look at OSS notes 36864 and 1781888

[former_member186887]

Thank you Lakshmipati sir.

[former_member186887]

Hi Kivanc Bilgin,

Thank you.

Please help me with where this number of foreign trade data coming from? Where is this data maintained? On what basis system determines this foreign trade data in split analysis?

Please explain the source for this info in split analysis. Thank you in advance.

[sez41]

Hi Maddy,

You are looking at the wrong picture. The reason for the invoice split is not Foreign Trade data, it is "Combination criteria in the billing document". Fix it and the other will also be fixed, as I had already said in my first post.

[sez41]

Another foreign trade document is probably getting created because of the other criteria in the invoice split. I can't tell what it is, the one starting with Combination..... ->>>> What is it exactly? I have a feeling that had these criterion of the items not been different, that invoice split would not have occured.