Revenue lines are not removed during GI reversal

[Former Member]

Hello,

  We have a issue related to revenue lines are not deleting automatically during goods issue reversal

In our business scenario, we activate the revenue recognition at item category level and the revenue recognition category using as 'B' service base revenue recognition.  As per standard behaviour, service base revenue recognition is identified at each business transaction event, ex: goods issue, receipt etc. The detailed issue is explained below, we have a sales order contains two line items -

ITem	Condition Type	Value	Acc Key	GL Account
10	ZLPR	10000	ERL	8200000
10	ZINC	2000	ERS	8201000
10	ZINB	1000	ERS	2200300
20	ZPCM	10000	ERL	3180701
20	ZINC	2000	ERS	3180701
20	ZINB	1000	ERS	2200300

During goods issue for the two line items, the revenue lines are updating in revenue recognition table VBREVE as below -

1.  In revenue table , system adds the items with combination of line item number, condition type and GL Account

2.  If the multiple condition types in sales order line item is assigned to same GL Account then system adds a position number (counter) to the  line item in the table as below -

ITem	Condition Type	Value	Sub Item	GL Account
10	ZLPR	10000		8200000
10	ZINC	2000		8201000
10	ZINB	1000		2200300
20	ZPCM	10000		3180701
20	ZINC	2000	1	3180701
20	ZINB	1000		2200300

During reversal of goods issue, the revenue lines are not removing automatically, and certain items are still appearing as relevant for revenue realization -

ITem	Condition Type	Value	Sub Item	GL Account
20	ZPCM	10000		3180701
20	ZINB	1000		2200300

After validating the detailed issue, standard system is removing the latest line items based on sub item number or counter and keeping the remaining line items as a relevant for revenue identification.  In the above example, for item 20, at goods issue cancellation, latest row sub item '1' is removed and remaining kept as is.

When user execute goods issue for a reversed delivery, system adds a revenue lines as explained in table 2.  So instead of 6 lines, it displays 8 lines (2 rows from previous cancellation + 6 rows from latest goods issue).and it causing a issue during revenue recognition through transaction VF44.

User executes revenue realization for a sales order by selection all line items include 2 rows from previous cancellation + 6 rows from latest goods issue, and it causes inconsistancy in balances which leads to posting in unbilled receivables which is incorrect.

Here, need your help how to reverse/remove all revenue lines at goods issue cancellation, is there any standard solution or note available.

Appreciate your kind help

Best Regards,

Goutham

[Lakshmipathi]

From your explanation, it seem, from FI side, with some configuration change, you can try but not sure on the outcome.  Also not sure, whether you have discussed with your FI team before posting here.  Nevertheless, have a look at OSS note 1224871

G. Lakshmipathi