Form Input disappeared
Hello,
I have this strange situation where information was entered with form input and for 1 of the entities the data disappeared on several accounts. This is in a scenario type1 scenario.
When ...
Forum Discussion
Hello Henning, Thanks a lot for looking into it. I don't think we have an Excel Input sheet available for this.
See below the screenshot, on Nov 5th the old amount was not visible and the the new input was done.
kin dregards
Ben
Users can be very creative sometimes 😉
But the screenshot does rule out input from Excel as this would be shown in the audit.
What is not shown in the audit is if a rule clears / overrides the data. You are saying that only some of the data is cleared in the form and not all data in the affected data unit? If so, that seems to rule out a clear data DM step as well - leaving only rules.
My strong guess is that there is a rule somewhere in the system that pushes no data on to those affected cells. Now to the fun part, to pin down when that happens exactly (every time a consolidation is run? After a custom calc? A DM step? ...?). As this seems entity specific, maybe there is a special rule run only on that entity, or only that entity enters data in the intersections which would explain why other entities do not experience the same.
Thanks Henning, that's what I was thinking. But not sure what kind of command would push No data. We used clearcalculated data in several rules, but that doesn't clear the form input, only different types of calculated data. Are there specific commands that would do this? I'll go through the rules in place and communicate if I find it.
Data buffers can do that (setting cells to zero and NoData = True), but also normal api.data.calculate functions in conjunction with a api.data.clearcalculateddata. The latter happens / is possible when existing Form Input cells are recalculated which then marks them as calculated cells, which then lets you delete those with api.data.clearcalculateddata.
One of those may have inadvertently been written in a way that your data is cleared. Not knowing your application, I would first try to pin it down to the process triggering this. I think finding the rough area first before going through each script seems like the faster approach to me.
