on 04-06-2016 9:17 AM
Hi Experts,
We have a requirement where in two accounting documents need to be created for one billing document. The document type of the accounting document and G/L accounts will be different.
Please let me know if there is a way to achieve this?
Thanks in advance.
Regards,
Bhanu
It's quiet possible via exits EXIT_SAPLV60B_002 and EXIT_SAPLV60B_008, refer to the solution mentioned in OSS Note but please implement it only if business is very much blunt with the requirement and not willing to get convinced. Be careful with the business implications as suggested by other members. Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rehman,
Thanks for your response.
We are looking for something like below.
Accounting Document types needed - xx and xy. xy is configured in the billing document type config. While the accounting document is getting created, can we employ user exit EXIT_SAPLV60B_008, we want to create the additional accounting document of document type xx? No changes are made to the accounting document structures ACCCR and ACCIT for document type xy.
So, by the time the execution of the user exit is done, accounting document xx is saved and the other accounting document xy is saved once the program is out of the exit.
Please advise.
Regards,
Bhanu
Hi Bhanu,
Is it mandatory for the FI guys to see the Accounting document in the document flow of SD?
Even if you succeed to create the second accounting document, I'm actually not sure if it will appear on document flow. It might, but I repeat: Is it mandatory for the FI guys to see the Accounting document in the document flow?
Becaue if it's not, handling your requirement via output processing will be much easier and less complicated. You can trigger an action via an output type (which can be a custom program to create the additional accounting document or an IDOC). This output should be triggered only if the initial accounting document is created. Cancellations should be taken into account as well.
Hi Kivanc,
Thanks for your response.
The document flow part is something we are still debating with the customer. But, we will do away with the document flow part. They will use FBL5N to check the two accounting documents generated with a common reference number.
Also, we considered using the output type functionality earlier, but later the approach is changed to use an available user exit.
I understand this is against the best practice, but all I am looking here is to check if it is still possible to meet the requirement.
Using user exit will be messy and at this moment we are not sure if this will be the approach we will be going forward with.
Regards,
Bhanu
I can understand well that you're still in the phase of assessing the provided options but still before doing this implementation please consider all business implications. Now coming to the requirement you can achieve this using an exit SDVFX008 with the component as EXIT_SAPLV60B_008 that will be triggered when you're going to create invoice. You need to ensure favorable treatment against your requirement with the help of your abaper. Logic behind this would be first accounting document say 'AB' will be created and all relevant fields will be passed to structures ACCCR and ACCIT. Now you've to play smart with the accounting entry for the second document type say 'YZ', here you need to append the line items G/L wise in above mentioned structures where G/L will be picked from your Z* table now this would be the point where you need to influence your second accounting document by passing all the required fields. I'm assuming that abaper would be smart enough to put the logic for this and if you need help related to this you can ask w/o any hesitation.
Another thing which you need to consider here as A/R will going to stand against the same customer same as of sales order or different partner would be there? My suggestion is to go for a separate Z* ledger in order to meet user requirement and instead of creating two accounting documents for a single invoice, just create proforma invoice with the required pricing and use it in your customized ledger.
Rest choice would be totally yours, which option you would like to go for. I'm curios to know managements decision related to this and sorry for such a length reply. Thanks.
Hello
Please refer SAP Note 1670486.
Regards
Shubham
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Bhanu,
Can you explain the Business need to create two Accounting documents for One Invoice? Is this a specific requirement (say for a particular Invoice type, or particular type of Transaction) or generic requirement for all the Invoices?
Also what different GL Accounts are you expecting to be hit in two different accounting documents?
Thanks,
Jignesh Mehta
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jignesh,
Thanks for your quick revert.
Our requirement is only for one particular custom invoice type. It will be based on invoice type only.
G/L Account information is not yet known completely, but, the requirement is to have one accounting document of type AB and other of type IR to be posted for a billing type say 'ZF2'.
Let me know if there is a way to achieve this.
Thanks,
Bhanu
Hi Jyoti,
What we are looking for is something like below.
First accounting document should contain:
Acc1 - Net Value
Acc2 - Tax
Acc3 - Gross Value
Second accounting document should contain:
Acc4 - Gross Value
Acc5 - Discount
Acc6 - Net Value
This accounting documents should have a different numbers and document types (1 AB and 1 IR).
What should be our approach to achieve this?
Regards,
Bhanu
Hello Bhanu,
Is this Accounting documents requirement discussed with your (SAP) FICO colleagues and Account / Finance team from Business.
The reason for asking this is hitting different GL Accounts from same Invoice with same amount (Net Price, Tax and Gross value) seems against the basic accounting principles to me.
I mean if a particular value from Invoice say, Net Value is posted to one GL Account, what is the need to post the same value to another GL Account? Also how is the Customer account debited in this scenario? How will Invoice be cleared?
Thanks,
Jignesh Mehta
Hi Jignesh,
We have discussed the requirement with FICO as well. The scenario is as below.
We have to post the amounts to additional G/L accounts which cannot be handled in a single FI document. To be precise, we have to create two different FI documents (with 2 document types) to have the full set of postings captured.
One can be configured using the billing type configuration by assigning one of the required FI document type. The other FI additional document needs to be posted while the billing document is saved along with the one configured in the billing type config.
We are going to maintain the G/L details in a Z table from which it needs to be picked.
Can this be done using user exit EXIT_SAPLV60B_008? If yes, can someone guide me the high level logic that needs to be employed?
Many thanks in advance.
Regards,
Bhanu
Hi DJ,
We want an additional accounting document for a separate set of postings which cannot be handled in a single FI document. There is no split criteria as such.
For a few Customer Account Assignment Groups (CAAG) we want to have 2 accounting documents. The G/L account details will be maintained in a Z table.
Can you help guide me as to how to use user exit EXIT_SAPLV60B_008 to have the additional accounting document created during billing document save?
Thanks.
Regards,
Bhanu
Though you have indicated that you have discussed with your FI team, I still feel, you / FI team are not aware of this implications and neither the client. From your above example, all the debit amounts would be duplicated (Net Value, Gross Value) and does it mean, you are going to debit the customer twice for one sale?
Definitely, I would not recommend to go with exit even if the client insist on this. What the best approach can be do a proto type testing, involve your FI consultants, take the screen shots of FI postings, get concurrence from them and if they are okay, then you start in development. But again, think thousand times before you go for an enhancement as this is not at all a Best Practice. May be this can be handled from FI side in a much better way.
G. Lakshmipathi
Hi Lakshmipathi,
Thanks for the guidelines.
I am just looking for a way to use user exits and achieve this. We have considerations to use output type as well. We are weighing our options here and a final call will be taken once the pros and cons of the possible solutions are debated.
Regards,
Bhanu
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.