concession report

[Former Member]

Hi guys,

I have been working on development of the concession report in SAP-ISU. The report lists concession name and total of that particular concession between the selected date range. All the concessions are being posted in the ECONCPOST table. The report is used for the reconciliation purpose. However, there are couple of problems in case of bill reverse.

1. Suppose the concession was posted on 5th May and entry has been created in the ECONCPOST table with document number 100. In the month of Jun the Invoice 100 needs to be return because customer was not elligible for the concession. In that case the flag document reversed for the document 100 will be ticked in ECONCPOST.

2. Suppose the concession was posted on 5th May and entry has been created in the ECONCPOST table with document number 100. In the month of Jun the Invoice 100 needs to be return because of the incorrect. billing In that case the flag document reversed for the document 100 will be ticked in ECONCPOST and the new document will be created in ECONCPOST with the concession amount.

Therefore because of these issues the report cannot be used for the reconciliation as the month of may should calculate the concession amount for document 100 where as the Jun total should substract the concession amount of document 100.

Has anyone encounter the same problem? What approach did you use to solve the problem?I hope, its clear. Any suggestion would be appreciated. Thanks

[Former Member]

Hi guys,

I have been working on development of the concession report in SAP-ISU. The report lists concession name and total of that particular concession between the selected date range. All the concessions are being posted in the ECONCPOST table. The report is used for the reconciliation purpose. However, there are couple of problems in case of bill reverse.

1. Suppose the concession was posted on 5th May and entry has been created in the ECONCPOST table with document number 100. In the month of Jun the Invoice 100 needs to be return because customer was not elligible for the concession. In that case the flag document reversed for the document 100 will be ticked in ECONCPOST.

2. Suppose the concession was posted on 5th May and entry has been created in the ECONCPOST table with document number 100. In the month of Jun the Invoice 100 needs to be return because of the incorrect. billing In that case the flag document reversed for the document 100 will be ticked in ECONCPOST and the new document will be created in ECONCPOST with the concession amount.

Therefore because of these issues the report cannot be used for the reconciliation as the month of may should calculate the concession amount for document 100 where as the Jun total should substract the concession amount of document 100.

Has anyone encounter the same problem? What approach did you use to solve the problem?I hope, its clear. Any suggestion would be appreciated. Thanks

[Former Member]

Hi,

You can put one more field on the selection screen as "Report Status as On" . This should be the date field.

The report should pick up the status as on the given date on the screen. Suppose In your case, if the "as on date" is given as 5th may and the date range for the document list is 1st april to 30th april , you should pick up the records on the given date range and check the each record status on 5th May.

there may be a case a document get reversed on 7th or 8th of May. But as on 5ht May the document is clear.

Please consult your functional consultant for more clarification and to find out the status as on date.