Following is the exact scenario in my Dynamics CRM instance.
I have created a custom entity (say, Order), which is having a lookup field (say, Item). The lookup field is pointing to another entity which is having a currency field (say, Amount). I have created a roll-up field (say, Total Amount) in Order entity, and set it to calculate sum of Amount for all items for the order. Once created, I have placed the control on main form of the entity.
When I try to check the value of rollup field (by clicking Refresh icon of the roll-up field), it gives me following error:
Record currency is required to calculate rollup field of type currency. Provide a currency and try again.
I tried similar for Account and Opportunities entities, and the new rollup field works perfectly there.
Any idea why it doesn't work for the custom entity? Do I need to do anything extra at entity or form level?