We are having a critical problem at work. I hope I could get some help resolving this issue.
The problem is with 2LIS_13_VDITM datasource and is as follows:
On Dec'18, a 3.4 million dollar credit was entered and cancelled 3 times. and entered again the 4th time. The net value result in the ODS is showing correctly.
However, the result of the Credit column in the cube is showing approx. 10Million more than it should.
We have 2 key figure in the InfoCube, Billing Credit and Billing revenue. When I checked the results in the cube, I observed that c"ancellation of Creit memo" was not being posted to the Billing Credit Key figure and also the cancellation of Invoices was not being posted to the Net revenue.
When I looked for the Update rules in the Cube, there is a routine for the Billig Credit and Net Revenue. I need some help with the code. The code is as below;
For Billing Credit
result value of the routine
IF COMM_STRUCTURE-DOC_CATEG = 'O' OR
COMM_STRUCTURE-DOC_CATEG = 'P'.
RESULT = COMM_STRUCTURE-/BIC/ZZFIREV.
ELSEIF COMM_STRUCTURE-DOC_CATEG = 'M'.
RESULT = 0.
result value of the unit
UNIT = COMM_STRUCTURE-DOC_CURRCY.
if the returncode is not equal zero, the result will not be updated
RETURNCODE = 0.
if abort is not equal zero, the update process will be canceled
ABORT = 0.
Can some one tell me what is the output of this code.
"O" is for Credit memos. I am not sure what does "P" or "M" in the code do.
Could some one please help me out. We need to fix this issue to eradicate the Billing Credit Issue.
I look forward to hearing from the experts.