on 01-16-2008 1:36 AM
We have an issue: we're trying to create a link b/w the item number in the SD billing document (VBRP) table and the item number in the FI accounting document (BSEG) table. This is our problem:
invoice 9100922958 contains 3 items each with a net value of $14K
VBRP item 1 - amount 14K
VBRP item 2 - amount 14K
VBRP item 3 - amount 14K
These 3 items all have same reference (contract 41002892 - item 10) b/c they are settlement periods in a billing plan due for billing. However, they post differently due to revenue recognition.
When posting to accounting (we're using standard revenue recognition), in BSEG there are multiple entries:
BSEG item 5 - amount 14K - G/L account Unbilled
BSEG item 6 - amount 14K - G/L account Unbilled
BSEG item 7 - amount 12,393.45 - G/L account Unbilled
BSEG item 8 - amount 1,606.55 - G/L account Deferred
We want to be able to link the following:
VBRP item 1 = BSEG item 5
VBRP item 2 = BSEG item 6
VBRP item 3 = BSEG items 7 and 8 (summation of items 7 & 8 equal value of VBRP item 3)
Is there a user exit in BSEG to create this link? Is there a way to update the BSEG table with the corresponding VBRP item number?
Thanks-
MLK
Hi,
First of all. Check if you are doing the summarization in FI for invoices. Check SAP Note 545137 - FAQ Interface - summarization and note 36353 AC interface: Summarizing FI documents.
Useful userexits the in the interface FI-SD is related in Note 301077 - User exits for the interface to accounting. Perhaps you can analize what field to use to create the link if you are doing the summarization.
I hope this helps you
REgards
Eduardo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ryan,
You can get the link between VBRP and BSEG.
First take the billing document number in VBRP and VBRK -VBELN and get the header details with that take the Document Condition number (VBRK-KNUMV ) and put it in (BSEG-BELNR ) you will get the document numbers with that you can link between VBRP and BSEG with what ever you choose the GL's .
if you give me brief i can help you out more.
Thank you.
Regards
Ram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In VBRP there exist 3 line items for an invoice:
VBRP-POSNR = 000001 with NETWR = 14,000
VBRP-POSNR = 000002 with NETWR = 14,000
VBRP-POSNR = 000003 with NETWR = 14,000
In BSEG (for same invoice) there exist multiple line items:
BSEG-BUZEI = 005 with WRBTR = 14,000 and HKONT = 12104
BSEG-BUZEI = 006 with WRBTR = 14,000 and HKONT = 12104
BSEG-BUZEI = 007 with WRBTR = 12,393.45 and HKONT = 12104
BSEG-BUZEI = 008 with WRBTR = 1,606.55 and HKONT = 25500
Summation of BSEG-BUZEI 007 (12,393.45) + 008 (1,606.55) = 14,000
I want to be able to link the following:
VBRP-POSNR = 000001 to BSEG-BUZEI = 005
VBRP-POSNR = 000002 to BSEG-BUZEI = 006
VBRP-POSNR = 000003 to BSEG-BUZEI = 007
VBRP-POSNR = 000003 to BSEG-BUZEI = 008
Is there a way to update BSEG in a user exit w/in the SD-FI interface (when the SD billing document is released to accounting to create the FI accounting document) to link the VBRP-POSNR to the corresponding BSEG-BUZEI ?
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
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.