I know this isn’t Skuid related, but I’m not really interested in using another community.
This is like “5’ nothing and like 100 pounds” Uber weird.
Before posting a substantive response, I’m just going to say that every part of your question description is hilarious. And that “5’ nothing and like 100 pounds” Uber weird" very effectively connotes to me a substantial quantity of weirdness.
I have a feeling it has to do with the Rollup field’s value , maybe how it’s rounded up or some invisible decimal
Try this formula just to be able to pinpoint the issue to a specific value (removing the checkbox logics)
Not(Total_Credit__c = Total_Debit__c)
Then try to save that problematic record
If returns validation error, try this
Not(round(Total_Credit__c,2) = round(Total_Debit__c,2))
I must not and cannot use rounding. The values need to be exactly the same. Custom Accounting app.
Additionally the values are exactly the same to begin with. The record is being flagged in error.
I only asked to do this for testing purposes and confirm where the issue lies
If by rounding (you can round to 5 decimals if u want) the validation does not trigger, you will be 1 step closer to finding the underlying issue
Now this is weird!!! I was trying a few more things and decided to delete the Journal Entry and recreate it.
I did, the records and values are exactly the same and now it works!
I’ve seen this once before where EVERYTHING looked fine but errors occurred. That time I deleted and recreated the records and the same thing happened.
Do Salesforce records ever become “corrupt”?
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.