Error in populating COPA report.

[Former Member]

First these were the changes to the system,the COPA report in KE30 was modified to show an added field which was the customer billing date, so we made the changes to accommodate the field and ensured that the historical profitability segments too showed the changes. Next the customer also had a discrepancy in the quantity interfaces ie: they wanted a discrepancy between the billed quantity and the SKU sorted, after these two were solved, we face this issue:-

In the COPA data for the last month, only the customer rebate tab doesn't net to zero (the entries are all the values for the reversals), when I saw these, customer rebate COPA and see that they were reversed by the reposting program but were never reposted again.I am not sure what caused this but when tested in QAS before reposting the COPA documents in PRD, it did not reverse the cust rebate COPA documents but it in PRD. So I am looking in to this issue to find out the root cause of this error.

Any inputs on this???

[former_member217324 · Accepted solution]

Hi there,

Are there any chances you can get the line items from the KE30 report? The only solution is probably to anaylsis the line items and see if anything wrong there.

br

Ronny

[Former Member · Accepted solution]

Hi Ronny,

In the report, the only error we are seeing is that during the repostings, the errors are for the rebate postings only. The values in the entries correspond to the value of the rebate entries.

Thanks

[Former Member · Accepted solution]

Have you done Rebate documents reversal and postings .. or done COPA documents reposting using KE4S . If you have used KE4S .. have you selected the update control ( reversal of line items).

[Former Member · Accepted solution]

Hi Sarada,

When we ran the reposting program, we found that the entries were reversed by the reposting program, but never reposted, the error is only for the last months report, but I suspect that the error might go all the way to all the posted entries to date.

Thanks

[Former Member · Accepted solution]

Hi ,

1. Have you done reposting using KE4S.

2. have you selected the update control ( reversal of line items) while reversing or used any other control.

[Former Member · Accepted solution]

Hi,

Yes the reposting was done through KE4S and I am not sure if any other control was used though.

Thanks

[Former Member · Accepted solution]

Hi ,

I strongly believe that KE4S updated control selection was not done correctly.

Please rectify it using KEFC upload . You may have a KEFC upload settings in your system , please upload the same in excel and correct the same .

Regarding root cause , next time you use KE4S , please make sure that in update control ( reversal of line item tab) is selected . If even after selecting it , line items are only reversed and not reposted.. please raise an OSS.