on 06-11-2014 2:54 PM
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!
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$
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
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
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$
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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...
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
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.