Roll up field throwing exception on refreshing


Scenario

I've Bank and Bank Fee look ups on a custom entity call Line Items. Upon change of Bank fee lookup, I am copying fee value in a currency roll up field using JavaScript. 
Now, I configured currency roll up field on Bank form to aggregate all fee that is used for a certain bank.

Problem
Upon refreshing the roll up field, it is throwing following error:

"Record currency is required to calculate rollup field of type currency. Provide a currency and try again"



Cause
Unavailability of Currency (schema name: TransactionCurrencyId) field on the form that contain the Roll up field, in my case that is custom entity Bank.

Resolution
I went down to solution, find the Currency under fields section of Bank, added that field on Bank form. 
Created a business rule to by default set its currency value and make it hidden. 

Keep learning!


Comments

Post a Comment

Popular posts from this blog

How to hide '+' on a subgrid in dynamics CRM?

I’ve to hide ‘+’ button of Order subgrid on Account form, because we are not allowing accounts to directly create Orders. Pre-requisite: Install latest version RibbonWorkBench tool from here  Create a Solutions, OrderRibbonSolution Add existing Entity, Order Publish the customization Launch RibbonWorkBench (RWB), Open the solution OrderRibbonSolution in RWB     4.    Create a new Enable rule and set following properties            a.    Default : False            b.    InvertRule : True            c.    EntityName : account            d.    Context : Form            e.    AppliesTo : PrimaryEntity     5....
Read more

Get Rid off Pending Email Warning - Microsoft Dynamics CRM

Image
Problem This is really weird when you login into MSD CRM and you came across with following screen. Reason This happen when you are sending email using workflow and the email stuck with status Pending Send Resolutions Following are three resolutions to this issue: Go to Settings > Email Configurations > Mail Boxes  and open Mail box ( that don't have approved email address and didn't test run ), then from Ribbon,   Approve Email Address and after that click on Test Run , You will see prompt coming from CRM, check the box click Ok . Create an on-demand workflow, to change the status of Pending Send email messages to some other status, say Canceled. And run this workflow from advanced find against those emails that are set to Pending Send Go to Advanced Find , Look For Email Message and Query for Status Reason  equals Pending Send, click Results and then delete all message with Pending Send Status After following any aforementioned step yo...
Read more

Remove Plugin Profiler dependency upon sitemap

I’ve to modify the sales sitemap and then move from Development to TEST and then to PROD. I added the sitemap to an unmanaged solution, change the required modifications. But when I went to import in TEST or PROD; I got following exception about the failure of the sitemap import. I went to Plugin Registration Tool; hit the Uninstall Profiler button and I were unable to uninstall with following message: Solution dependencies exist, cannot uninstall.DependencyCount : 1RequiredComponentObject details: Id : 7f7166bd-6786-44d0-bd95-3dc0f832a94b, Type : Entity, ParentId : 00000000-0000-0000-0000-000000000000, DependentComponentObject details : ObjectName : , Id : 4e467a6a-2895-e711-8101-5065f38a6bd1, Type : SiteMap, ParentComponentDisplayName I went through many CRM forums but did not found a solution to that. In the end, I opened up the sitemap in DEV environment again and hit Edit button under Client Extension of that Unmanaged Solutions. Click at Settings; find the ...
Read more