Dynamics Community Forum Thread Details

Roll-up field Open Revenue error -- says i'm not putting in a numeric value.

Hello,

I'm using the managed roll-up field "Open Revenue" for Accounts and am receiving an error whenever I manually update it via the refresh icon button on the form.

When i "refresh" it on the form, I get an Alert saying "Enter a value from -922,337,203,685,477 through 922,337,203,685,477.". Thankfully, the field still actually updates to the correct $$ value of the opportunity revenue sum.

Additionally, I noticed that when the revenue under the opportunities of the account are $0, CRM then sets the Open Revenue on the account page to a date, specifically "Sat Jan 01 2000 00:00:00 GMT-0800 (Pacific Standard Time)", meaning that for some reason a date value from a currency opportunity field is being pushed over to the open revenue account field.

I checked the rollup field properties and everything looks fine. It is set to a currency type field and gets the sum of a currency type field under the opportunities.

Is this a known issue? It wasn't an issue before and i haven't changed anything.

Thanks for any help/suggestions.

Quick Links