cancel
Showing results for 
Search instead for 
Did you mean: 

Wrong billing assignment number

Former Member
0 Kudos

Hi,

We have 2 companies for which we use delivery based invoicing. Both companies use same order- delivery and billing types however for one of our company the invoice is generated with a wrong assignement number (being the shipment #). As per our configuration, in the copy control to billing the setting is E = billing doc. (no u-exit or any sort of customization).

The only difference between the companies is one is using the transportation module and the other doesn't. The issue arises with the one using the transportation module. The item sold can be the same in both company and are both ZTAN . This causes issues for our collection dept. as they use assignment number in the FI document being fed by the billing doc. to reconcile the multiple partial payments we have in our industry.

Note that this is not related to the GL account settings such as the FSG, both are using the same with same settings.

Any idea?

Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

suman_sardar2
Active Contributor
0 Kudos

Hello Genevieve,

What I understood from your post is that you want not to be printed the Billing Doc no in the assignment field for the Company which is using transportation module.If this is the requirement then are you trying to maintain any document no in the assignment field apart from the billing no. Let me know that.

If the answer is YES, then you can go for the Billing User Exit "USEREXIT_FILL_VBRK_VBRP (Module pool SAPLV60A, program RV60AFZC)" where you can put the logic based on the company code and fetch the desired document no instead of Billing doc. no.

Hope you got my point. Let me now if you face any issue on that.

Thanks,

Suman$

Former Member
0 Kudos

Hi Suman

No we want the billing document number being copied in the assignment field of that billing document.

Thanks for your help,

GV

suman_sardar2
Active Contributor
0 Kudos

Hello Genevieve,

After a prolonged discussion, it is not very clear to me what no or information you want in the Assignment field for both the Company. Can you clarify by saying that like below example;

1. For Company A = Assignment will be Billing Doc no

2. For Company B = Assignment will be Transportation doc no.

I hope I am clear to you.

Thanks,

Suman

Former Member
0 Kudos

Hi Suman

We have although we do have same config in both companies in VTFL as well as same doc types (SO, delivery, billing):

Company A : Assignment number = to billing doc

Company B: Assignment number = to transportation no

we want:

Company A&B : Assignment number = to billing doc

thanks,

GV

former_member184065
Active Contributor
0 Kudos

Hi,

Could you please share the billing document with assignment number and as well as execute that number in VT03N and share that screen shot also for understanding this issue.

BR's,

Naren

Former Member
0 Kudos

and its shipment doc:

Above is company B documents

and below invoice from company A and this is how we want B to be:

Finally VTFL:

Let me know if this suffies

BR,

GV

former_member184065
Active Contributor
0 Kudos

Hi,

This is looking strange to me.Kindly take help of ABAPer and debug the invoice which is having assignment as shipment number and see from where that is coming.

Note:I think,there would be some abap work to get that shipment number in the field assignment based on company code level.

BR's,

Naren

suman_sardar2
Active Contributor
0 Kudos

Hello Genevieve,

Thanks for the clarification, now it is very much clear what is the issue.

This is the one exactly I want to say. Please check the development what I just mentioned above.

There has to some code injected else you would not face this issue. Check the code under the "USEREXIT_FILL_VBRK_VBRP".

Thanks,

Suman$

Former Member
0 Kudos

Hi GV,

Check if any assignment value is populated in sales order for second scenario.

Thanks

Rama

Former Member
0 Kudos

Hi Suman,

Many thanks you for your help , I have sent the request to our abap support team as they had verified  EXIT_SAPLV60B_001: Change of header data in structure ACCHD which could have also affected the assignment field behavior

will keep you posted

BR,

GV

Former Member
0 Kudos

A big thank you to all for your help!!!

We finally found there was coding added for transportation (VBFA- Sub-type 8 instead of M) in UE: USEREXIT_FILL_VBRK_VBRP

GV

Answers (4)

Answers (4)

phanikumar_v3
Active Contributor
0 Kudos

Dear Genevieve,

Very long thread and you really given your best in clarifying people...

One last suggestion:

Before raising this to Abaper---Can you please assign some other assignment number(other than E) in VTFL--test it in DEV, whether this problem is only for option E...(change to B/C)

Pl update...

Phanikumar

Former Member
0 Kudos

Hi Geneve,

Please check any customized routine at item level in the copy control for this assignment number if any condition is there to pupoulate assignment number based on company code.

Sometimes, we can control assignment number through the routine at item level in copy control.

With Regards

S.Siva

Lakshmipathi
Active Contributor
0 Kudos

I am not sure, through which transaction, your finance team are updating the records.

As you would be aware, through standard transaction FBL5N, you can clear the incoming payments / partial payments line item wise and for this, it is enough the input parameter be the respective G/L Account.  Once system populate the data, you can see the Assignment Reference based on which, your finance team can reconcile the incoming payment.  Needless to mention, item category wont play in your case.

If this is not clear to you, please let me know.

G. Lakshmipathi

Former Member
0 Kudos

Hello,

It is causing the AR dept some issues due to the fact we have multiple deductions in our encashments process hence using residual payment and the assignment no to be able to renconcile them all.

Nevertheless, the issue is on the billing document where the doc number does not get copied over to the SD doc assignment number (note that the assignment from the billing doc gets copied over the FI doc. in our configuration)

BR,

GV

former_member184065
Active Contributor
0 Kudos

HI,

I didn't get your issue clearly. Once we create billing document  then it will be reflected into FBL5N. After that , FI people will be cleared that amount whenever customers paid.

Kindly let me know your issue in detail to assist you on this.

BR's,

Naren

Former Member
0 Kudos

Hi Naren,

In fact the issue is within SD billing , we want the invoice # in the invoice document number assignment as it helps AR applying payments due to the fact we have a very high volume of short payments we need to keep trace of all deductions related to an invoice therefore using the residual payments in F-28. This is why we want to have the assignment = the SD no on the SD invoice.

Thanks for your help!

GV

former_member184065
Active Contributor
0 Kudos

Hi,

Kindly see the below 3 snap shots. What you want is that in the field "Assignment",you want invoice number right.If that is the case please see the 3rd snap shot of  VTFL and make Assignment number as " E " then you will get same invoice number in the field assignment in billing document.

BR's,

Naren

Former Member
0 Kudos

Hello,

Thanks for your help ,however this is exactly the configuration we have in VTFL for both companies and they both use the same delivery type and billing type. That The issue is that even though we have E for company 2 it does not take it, the system takes the transportation no instead. I wonder what causes the system to take that transportation no...

Former Member
0 Kudos

Hello

Thanks for your reply however this is exactly what I meant when I mentioned both companies have the same copy control, I was referring to VTFL . Both companies have the same delivery and invoice type but instead of putting the actual billing doc for an obscure reason it takes the transportation no. for company 2...

Note that no user-exit or any customization code is used in this process. Would anyone know if standard SAP is overwriting the config from VTFL when transportation (incl shipment costs) are part of the delivery process?

BR,

GV

former_member184065
Active Contributor
0 Kudos

Hi,

You meant to say that transport ( shipment number ) number is coming in the field assignment ?

BR's,

Naren