+12
Hi, we are using V14.5 and I have a contract that is active and invoice (4000€ only) but when I look at the Revenue recognition, I am seeing the periods duplicated. One is correct (approx. 340€ each) but the duplicate is showing about 58 MILLION € for each period.
Can anyone suggest where I need to look to see what is causing this and how to correct it please?
Thanks
Chris
Best answer by Phil Seifert
View original
+21
Hi Chris,
This is quite strange and seems to indicate that other contracts/lines are linked somehow to this contract or were at one time (perhaps a canceled contract or canceled lines?).
To correct this, I would try in a DB copy on a UAT system if possible to recalculate the revenue recognition using the contract revenue recognition module to see if this clears up the situation.
Other than that, I would suggest raising a support ticket as it seems you have a data issue which I don’t think we can fix over a Community post.
+12
Hi Phil,
Thank you for the suggestion. I tried it in one of our pilots, I just entered the contract ID and hit RUN, but it did not change anything. One thing that seemed strange was that the “Recognize Until” field shows 012021...
Anyway, I guess I need to open a support ticket.
Thanks
Chris
+21
Recognize until reflects the current fiscal period defined in the financial settings for the profile. This is not modifiable in contract revenue recognition screen as it is picked up automatically. That naming indicates it looks like the current active fiscal period is Jan 2021.
What you can do is review the contract revenue data table rows and see if there is a clue where the ccontl that is involved might be coming from with the high numbers?
select * from ccont_rec_rev with(nolock) where cconth_id = 'UJ65385_7'
+12
Hi Phil,
Thanks. The only thing I can spot is that those high value lines have the ccont_version set to -1, where it is zero for everything else. I did a search for just lines that had ccont_version set to -1 and found only 2 contracts from the last 11 years, so it certainly seems to be significant… but I have no idea why or how this might have happened. I’ll discuss it with someone here that is more familiar. Thanks again.
+12
Hi Phil,
We managed to resolve this issue, thank you
+21
Hi Chris,
May I ask how you resolve the issue and what was exactly the problem that caused this situation?
+12
Hi Phil,
After some testing in Pilots, we decided to remove the lines where ccont_version was set to -1
+12
Might be better if the code that pulls in the recognition ignored those lines perhaps?
+21
Hi Chris,
What you suggest by ignoring the rows when retrieved will not really resolve the underlying issue.
I would think it would be better to find out how this happened and prevent it in the first place. Otherwise you are only cleaning up the display by removing it from the DAL but any reporting which is looking at the rows might still pick it up, etc.
It is a very rare occurrence which suggests to me that perhaps it was something environmental while executing some process that left these rows there. I don’t know what the purpose of the ccont_version but because it was set to -1, this also suggests that this was a temporary row that should have been removed by the process and it could not for whatever reason.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.