Same invoice linked with 2 orders belonging to diff sales org

[former_member219259]

Hi,

I have a 3rd party sceanrio where there is a third party sales order, then a Purchase order and then GR. through GR, invoice will be created.

I have a problem with a specific invoice.

where same invoice no is linked to sales orders which are not related to each other.

so VBFA is having incorrect entries.

I can correct the same by table level corrections in VBFA but trying to undestand how can this happen.

Any thoughts, pl share

Regards,

Aayush Jain

SAP SD Consultant

[former_member182378 · Accepted solution]

Aayush,

Interesting question!

Paste the screenshot of VBFA. And take each sales order, paste the document flows.

Typewriter

[former_member219259 · Accepted solution]

Hi Typewriter,

The discrepancy happened while creation of the invoice # 6175373115. This is only supposed to link with order # 133562717 in VBFA but it was wrongly linked with 3 other orders

• 134566035
• 134594986
• 134595006

Document flow for invoice 6175373115

Document flow of 1 wrong order 134566035 where you can see invoice 617573115 is also present

Now below screenshot confirming these two are having different sales areas altogether.

Order having sales org NL28

Whereas incorrect invoice linked having sales org HK29

Regards,

Aayush Jain

[Former Member · Accepted solution]

was your sales orders created with reference to your first sales order?

i also wonder, do you have problem only with what you see or your billing document is wrong too?

regards.

[former_member219259 · Accepted solution]

No George. It was not. SAP will not allow that as it has different sales area.

It was created with reference to correct order no.

Below screenshot for your reference.

[Former Member · Accepted solution]

yes you are right,

and what about your billing document and of course the fi document, are these correct?

Is your issue only VBFA relaterd or your document includes all of these sales orders?

[Former Member · Accepted solution]

also check if there are any changes to userexit

LV05CFZZ

[former_member219259 · Accepted solution]

Hi George,

there are no changes in the user exit mentioned.

Coming to next question, no accounting is correct and only problem is VBFA

reason being invoice contains correct materials only and linked to correct order as well.

but in addition to the correct order, it is linked to 3 other orders which it should be linked to.

but nothing wrong with invoice as such.

I hope it is clear

Regards,

Aayush Jain

[former_member219259 · Accepted solution]

Hi TW and George,

To let you know, i have made corrections at table level but root cause is still missing.

I found one sapnote no. 1080954 for the issue.

As per the note,

These problems occur occasionally and sporadically. In general, a cause cannot be determined.

In some cases, incorrect document flow records occur as a side effect of other database

inconsistencies between order documents and purchase order documents for third-party order

processing or individual purchase order processing.

If it is not possible to determine the cause of the problem, the only way to solve the problem is to

delete the VBFA entries that represent a reference between the order item and the purchase order

item that is incorrect or that does not exist.

So i believe there cannot be any RCA.

Still if anyone can give any random ideas, pl do.

thanks and regards,

Aayush Jain

SAP SD Consultant

[former_member182378 · Accepted solution]

Aayush,

Thanks for the update!

Editing at table level always has its risks.

I will go through the OSS note.

Typewriter

[Former Member · Accepted solution]

Hi Aayush,

thank you for the update,

i will take a look to this note.

It was a very interesting issue.

Regards,

George

[former_member338723]

Was this issue resolved. If so please let me know the solution.

[former_member182378]

Aayush,

For this unrelated order 134566035 there are several invoices, in the document flow screenshot. Can you paste the order and the "correct" invoices?

TW

[former_member219259]

Hi TW,

Sorry for my delay in reply.

Sure.

Below the updated document flow after the corrections in VBFA

Screenshot of Order:

Screenshot of 1 correct invoice:

Regards,

Aayush Jain

SAP SD Consultant

[Former Member]

Hi Jain,

it sounds very strange.

could you please give us more details?

regards