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
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.
Hello Henning, I have found the root cause of the issue.
It's below member formula where I want to have a translation to USD done in the account formula, here the entity has functional currency USD. When this runs the first time the value becomes a calculated value, second time it is set to zero. I will make the exclusion on entity, not on consolidation currency.
Dim Targetcur As String = api.Entity.GetLocalCurrency(api.Pov.Entity.MemberId).Id
Dim SourceEntcur As String = "176"
Dim AvgRate As String = api.FxRates.GetCalculatedFxRate(api.FxRates.GetFxRateTypeForRevenueExp().Name.ToString, api.Pov.Time.MemberId,SourceEntcur, Targetcur).XFToStringForFormula
If (Not api.Entity.HasChildren()) And api.Pov.Cons.Name.Equals("USD") And (Not api.Entity.GetLocalCurrencyId.Equals ("USD"))
If Not AvgRate = 0 Then
api.Data.Calculate("C#USD = C#Local /" & AvgRate, accountFilter:="A#BalRecurAccs_PRICE.base")
End If
End IfHi Ben, thank you for sharing the issue for the wider community!
Glad I was able to help 🙂