Tip #1396: Multi-currency aggregates in Dataverse

tl;dr When using aggregates with multiple currencies make sure the business understands how the totals are calculated, how exchange rate is used, and why it’s a good idea to roll out your own calculations. Bring it on Multi-currency support has always been one of the staple features of …. eerrr … Dataverse since version … […]

Tip #1321: Formatting currency values in Power Apps portals

Dollars are dollars are dollars. Until they’re not. I’ve been working on the portal implementation where pricing can look like this: Forms seem to be fine but any custom layout, uhm, is suddenly very challenging. I can get values without any issues but can’t format them for display. Before long, an SOS is sent: Folks, […]

Tip #1063: Do not touch currency system views

Protected area

This tip comes from Guillaume Domont. (And you can get your names into the Dynamics 365 History Book™ too by sending your tip to jar@crmtipoftheday.com. Guest Microphone I found a quite interesting bug in my last project. As the CRM/Dynamics 365 is used worldwide, we had to handle the currency changes. The standard currency lookup […]

Tip #486: Don’t hard code currency in workflows

Bad currency workflow

If you have a workflow dealing with the entities that include money fields, avoid setting explicit currency. Instead, try to infer the currency from the related records. For mere mortals, it’s just a bad practice, for ISVs, it’s definitely a case of spießrutenlaufen. Why? Because if you activate your workflow and add it to a […]

Tip #407: Some things are irreversible

Truck goes wherever it pleased. For example, US Patent Office. Andrhe “I’ve got 88 in my handle” Margono could not make up his mind, kept adding then deleting attributes and got himself into a pickle: Recently I was migrating some data from my Dev environment to Test environment and I noticed that there are 2 […]