cancel
Showing results for 
Search instead for 
Did you mean: 

How to combine invoices (split analysis, vf01)

former_member246345
Participant
0 Kudos

Hello everyone,

I have a problem with invoice splitting.

For a specific customer, i'd like the invoices stop spliting. Instead they should be combine in one invoice.

When i check split analysis in billing, i get this screen:

Could you please explain how to combine the invoices?

Thank you and best regards

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Kurba,

In order to have one invoice for one delivery u need to maintain same billing data for all line items in delivery.

Check once that u have maintained same billing date ,payment terms, payer and other relevent biling info for all line items.

If we maintain different billing data for line items in one delivery then invoice split will happen.

Check and update the results.

Thanks and regards,

Deepak

former_member246345
Participant
0 Kudos

Hi Deepak,

Thank you for your reply.

All those info you've mentioned is the same for all the items in the delivery.

Best regards

former_member246345
Participant
0 Kudos

Hello everyone,

This issue is still active.

Any help would be highly appreciated.

Thank you

Lakshmipathi
Active Contributor
0 Kudos

The split analysis shows certain data not maintained for one invoice while it is maintained for the other invoice.  Also, I believe Payer is different in this case in which case, you should be knowing that with the standard configuration, invoice split will happen for all customers.  Since your requirement is to restrict this only to one customer, you need to go for an enhancement but ensure that you tested thoroughly from financial angle also and concurrence is given by the finance team, before moving the request to PRD.

G. Lakshmipathi

former_member246345
Participant
0 Kudos

Hello Lakshmipathi,

Thank you for your response.

I've checked the invoices, Payer is the same in both invoices. The differences were the number of items each one has and their sales order numbers.

Could these differences effect the invoice split?

And in standard, is there any way to stop the invoice splitting for one particular customer?

Best regards,

former_member246345
Participant
0 Kudos

Hello,

When i check the VBAK table, i see that the credit control data for three sales orders has not been maintained. Those sales orders belong to the $000000001 invoice.

Could this effect the splitting?

Could you please explain how to stop the invoice spliting?

Thank you

jobis
Contributor
0 Kudos

Hi Kubra,

its obvious that the credit control data are different and thats causing the split.

these data are determined from the Payer. If the payer is same, then check how these data are different for both the orders..

Is any of the partners different in these orders..?

Thanks

Jobi

former_member246345
Participant
0 Kudos

Hi Jobi,

Thank you for your reply.

Payer and all the partners are the same for those orders.

Where exactly should i check to see the data difference?

Best regards

jobis
Contributor
0 Kudos

Hi Kubra,

Hope this is delivery related billing. And you are billing a delivery which was created by combining more than one sales orders.

VBAK table as u have posted, is showing the credit data.

For invoice, the data is available in VBRK table.

Jobi

former_member246345
Participant
0 Kudos

Hi Jobi,

Yes, it is delivery related billing and the delivery was created by combining more than one sales orders.

If the credit control data was maintained for those sales orders on the VBAK table i have posted, would the invoice stop splitting?

If so, could you please explain how i can maintain the data?

Thank you

jobis
Contributor
0 Kudos

If you are sure the partners of all the concerned sales orders are same, then check the sales document type.

Are these sales orders using different order types? Make sure the credit is active for the document type as well as the item categories in the order.

May be for some items the credit is not active in item category. in such case, credit data will not be created into the table.

check these, do necessary changes and test in sandbox. Split should not happen.

regards

Jobi

former_member246345
Participant
0 Kudos

Hello Jobi,

The partners and the document types of those orders are the same.

Could you please give me more detail about checking whether the credit is active for the document type or not? Where exactly should i check?

Thank you and best regards

former_member246345
Participant
0 Kudos

Hello,

When i check the sales order --> Environment --> Partners--> "Display credit account" :

When i check OVAK:

And in VOV7:

Could you please tell me, is there any other place i should check or maintain in order to stop the invoice splitting?


Thank you

jobis
Contributor
0 Kudos

Hi,

So ZTA is the document type for all these sales orders..?

And ZTAB is the item category for all the items in all these sales orders..?

I credit control is active for sales doc, and item category, and if for partners, FD32 are maintained, then I dont see any reason why, the credit control data is not created for few sales orders.

Try to debug with the help of abaper/ see if there is any user exits/ enhancements in the program being used.

Anyways you got the reason for split.

Thanks

Jobi

Former Member
0 Kudos

This message was moderated.

former_member246345
Participant
0 Kudos

Hi Nagaraj,

I've checked the sales orders. The Billing dates were different.

However, a splitted invoice has been able to include items that have different sales order references and different billing dates.

I'd like to give another example:

An another invoice which includes items from the sales orders listed below on the VBAK screenshot,  has been created. But it splitted in 2. One invoice has the items from the order 6447. And the other invoice has the orders 6441, 6460 and 6495.

By the way, both 6447 and 6460 have the same billing date. Shouldn't the items of these orders have been included in the same invoice if the billing date is the same?

As can be seen on VBAK, 6447 has credit control ares maintained whereas others do not.

I think, in this case, system splits invoices regarding to the credit control data in the sales orders.


What do you think?


I'll appreciate your suggestions.


Thank you and best regards

former_member246345
Participant
0 Kudos

Hello Jobi,

Yes, ZTA is the document type for all the orders and ZTAB is the item category for all the items.

By the way, when i try to change the sales orders which do not have credit control data maintained, i get this message:

Afterwards, i came across with SAP note 408596. It mentions a program called "RFDKLI20" aka transaction code "f.28".

It says after changing the sales orders, this program must be run to recreate SD and FI credit data.

Could running this program solve our problem?

Thank you and best regards

jobis
Contributor
0 Kudos

Hi Kubra,

That program is for recreating the credit data for FI and SD docs. You can run that, so the credit data will be recreated for those slaes orders which do not have the correct credit data.

If the credit data are same for all the sales orders, then during billing, split may not happen. thats what we analysed.

ALso you look at the configurations for invoice split (I dont have knowledge about it), if atall you can control the invoice split rules, then you will not have this issue.

Thanks

Jobi

former_member246345
Participant
0 Kudos

Hi Jobi,

I've come to realize that a customer transfer had been made. A new customer had been created. The previously used customer and its credit limit had been cancelled. The credit control data for the new customer was created İn April 2015.

When i check VBAK for that new customer, i see that all the sales orders which were created after April, have their credit control data maintained.

The sales orders with the credit control problem that i've mentioned here before were created before April.

I'm thinking the reason for that is the customer transfer and credit control data creation in April.

What do you think?

And if that is the case;

Could you please tell me what program i should run to maintain the sales orders created before April?

Thank you and best regards

jobis
Contributor
0 Kudos

Hi ,

Did you do F.28 ? if so did it help in recreating the credit data,..?

If not, then i dont think there is any possibility left.\

For the time being, for these few sales orders, you may consider filling these data directly into the table (if its allowed and only if thats permitted in your case).

then you may be able to create single invoice for these orders.

Regards

Jobi