JohanPersson.nu

My Digital Brain

Running FnO on a Mac
Hi…

This week I got a question from one of my oldest friends an I got curious (as one does). The question was: “What are the limitations when running Dynamics 365 for Finance and Supply Chain on a Mac?”. Since I am not a Mac user I thought; I might as well document this for the future.

I reached out to a colleague and what I got was this:

Since Finance and Supply Chain it self is a web-bases applications the core application will work without any problems in (almost) the browser of you choice (the supported browsers are Microsoft Edge, Google Chrome and Apple Safari. There are however 3 areas that does not work that requires some workarounds.
- Open in Excel – The Excel add-in is not available for the Mac version of office. You are able to export to Excel since this is just a pure download of a file that you then open, but the Open Excel requires an OData add-in for publishing the data back to FnO. The workaround is to use a virtualization. By using Parallells or another virtualization to run Windows on the Mac you are able to install the Windows version of office and run the Excel Addin.
- Management Reporter Report Designer – Management Reporter Report Designer is a is a .NET application that is launched from the FnO web application and used for editing report that are then viewed in FnO. This also requires Windows to run and the virtualization workaround above is also applicable. The tool is however not used in day-to-day work in the system which makes a bit easier to live without.
- Workflow edit – Just as the Report Designer above the Workflow editor is a tool used for building and administering the workflows in the system… not as much in the daily work. As with Report Designer it is also a .NET application and will work with the same workaround.
Depending on the technical level of your users this virtualization solution might be a working solution or you could with an old fashion terminal server/Citrix solution.

If you have any experiences around this that I have missed… please do not hesitate to reach out.

Links:
Install Windows 11 on a Mac with Apple M-series chip (parallels.com)
Options for using Windows 11 with Mac® computers with Apple® M1® and M2™ chips – Microsoft Support
System requirements for cloud deployments – Finance & Operations | Dynamics 365 | Microsoft Learn
2023-02-23
ELPOIT #402 – ELPOITs filterbubbla

Om Shownotes ser konstiga ut (exempelvis om alla länkar saknas. Det ska finnas MASSOR med länkar) så finns de på webben här också: https://www.enlitenpoddomit.se

Avsnitt 402 spelades in den 7 februari och därför så handlar dagens avsnitt om:

INTRO:
– Alla har haft en vecka… David har haft bra vecka och fått göra en del musik. har börat spela Final Fantasy XIV, läst en bok av Magnus Carling och börjat av nästa.
(Björn gör en liten ordningsfråga)
Björn har Lajvat Vuxen, (Jobb, barn, mat, hundar, tvätta, städa), Kopplat iPhone till högtalare. Johan har bokat löping, haft seminarie, stödat och låtit nån fotografera, åsså fyllt år

FEEDBACK AND BACKLOG:
– Adobe Digital Editions, e-böcker, Kobo och epub
– BONUSLÄNK: Boken som David pratar om: https://www.amazon.com/Essentialism-Disciplined-Pursuit-Greg-McKeown/dp/0804137382

ALLMÄNT NYTT
– Dashlane blir open source
https://www.bleepingcomputer.com/news/security/dashlane-password-manager-open-sourced-its-android-and-ios-apps/

MICROSOFT
– Microsoft kör AI event
https://www.thurrott.com/cloud/279091/microsoft-ai-powered-bing-edge-preview-launch
– Authenticator for Apple Watch försvinner
https://www.macrumors.com/2023/02/06/microsoft-authenticator-ends-apple-watch-app/
– MS gör sig av med Teams Free och skapar Teams (Free)
https://www.engadget.com/microsoft-teams-free-classic-retirement-no-data-180521994.html
– Microsoft Teams Premium Har nu ÄNTLIGEN gått GA
https://www.microsoft.com/en-us/microsoft-365/blog/2023/02/01/microsoft-teams-premium-cut-costs-and-add-ai-powered-productivity/
– Viva Sales får GPT stöd.
https://cloudblogs.microsoft.com/dynamics365/bdm/2023/02/02/microsoft-boosts-viva-sales-with-new-gpt-seller-experience/

APPLE
– Riktiga Browseralternativ I iOS
https://www.engadget.com/google-chrome-blink-ios-experiment-220001141.html
https://appleinsider.com/articles/23/02/07/mozilla-is-also-developing-a-non-webkit-browser-for-ios
– Jag är f*n imponerad av Apple
https://appleinsider.com/articles/23/02/03/apple-collects-nearly-all-of-the-profit-in-the-worldwide-smartphone-market

GOOGLE:
– Google lanserar ChatGPT konkurrent
https://www.androidpolice.com/google-unveils-bard-ai/
– Passkeys från Google
https://www.androidpolice.com/googles-new-credential-manager-brings-us-closer-to-a-passwordless-future/
– Google är lite pryda
https://www.androidauthority.com/google-search-blur-3280353/
– Android kanske kopierar iOS
https://swedroid.se/android-14-kan-gora-det-enklare-att-anvanda-mobiler-som-webbkameror-for-datorer/

EXTRA NYHETER:
– OnePlus Event
https://techcrunch.com/2023/02/07/the-699-oneplus-11-arrives-feb-16/
https://www.androidpolice.com/oneplus-11-review/
https://swedroid.se/oneplus-pad-ar-foretagets-forsta-surfplatta/
https://www.androidauthority.com/oneplus-buds-pro-2-2-3276786/
– Samsungs Event
https://9to5google.com/2023/02/01/samsung-galaxy-s23-price-specs-release-date/
https://www.thurrott.com/mobile/278893/samsung-galaxy-s23-galaxy-book3-series
https://9to5google.com/2023/02/06/galaxy-s23-ridley-scott/
https://www.androidpolice.com/samsung-galaxy-s23-seamless-updates/
https://9to5google.com/2023/02/03/snapdragon-8-gen-2-galaxy-s23-tsmc/
https://www.androidpolice.com/google-samsung-team-up-android-based-extended-reality-headsets/

TIPS:
– Vill du veta vilka nya funktioner som kommer i Azure. Fråga Billing APIt. 🙂

PRYLLISTA
– David: AIAIAI TMA-2 Studio Wireless+ (https://aiaiai.audio/headphones/tma-2-studio-wireless-plus)
– Men den här ville jag ha, men verkar inte gå att köpa.. 🙁 https://news.kaist.ac.kr/newsen/html/news/?mode=V&mng_no=26590
Eller https://www.etsy.com/listing/1334499723/mini-croc-shoe-charm-charms-compatible?show_sold_out_detail=1&source=aw
– Johan: Till Mario Kart https://www.webhallen.com/se/product/268720-Nintendo-Switch-Joy-Con-Handkontroll-Pair-Green-Pink

EGNA LÄNKAR
– En Liten Podd Om IT på webben,
http://enlitenpoddomit.se/
– En Liten Podd Om IT på Facebook,
https://www.facebook.com/EnLitenPoddOmIt/
– En Liten Podd Om IT på Youtube,
https://www.youtube.com/enlitenpoddomit
– Ge oss gärna en recension
– https://podcasts.apple.com/se/podcast/en-liten-podd-om-it/id946204577?mt=2#see-all/reviews
– https://www.podchaser.com/podcasts/en-liten-podd-om-it-158069

LÄNKAR TILL VART MAN HITTAR PODDEN FÖR ATT LYSSNA:
– Apple Podcaster (iTunes), https://itunes.apple.com/se/podcast/en-liten-podd-om-it/id946204577
– Overcast, https://overcast.fm/itunes946204577/en-liten-podd-om-it
– Acast, https://www.acast.com/enlitenpoddomit
– Spotify, https://open.spotify.com/show/2e8wX1O4FbD6M2ocJdXBW7?si=HFFErR8YRlKrELsUD–Ujg%20
– Stitcher, https://www.stitcher.com/podcast/the-nerd-herd/en-liten-podd-om-it
– YouTube, https://www.youtube.com/enlitenpoddomit

LÄNK TILL DISCORD DÄR MAN HITTAR LIVE STREAM + CHATT
– http://discord.enlitenpoddomit.se

(Och glöm inte att maila bjorn@enlitenpoddomit.se om du vill ha klistermärken, skicka med en postadress bara. 🙂

2023-02-09
Issues syncing Sales Order Lines with Dual Write
I am doing some experimenting with Synapse Links for Dataverse and to do that I need my FnO data in Dataverse. The way I do it, is using Dualwrite. When I try to sync Sales Order Lines V2 to salesorderdetails I get the following error:

Reason: Bad Request, Header x-ms-client-request-id f1004256-8a98-42fe-86a9-02b8e64a81a9, Produkten kan inte läggas till eftersom den inte är aktiv

(for those of you, not fluent in Swedish it says “The product cannot be added because it is not active)

This means that the product is synced but it is not active. To activate the product it needs to be published. To do this go through the following steps:
1. In Sales open products
2. Select a product and click Publish
The problem was I had a couple of thousand products. So I googled and found this forum thread helping me to write a workflow to automate it (this is way beyond my knowledge in CRM).

Links:
https://learn.microsoft.com/en-us/dynamics365/sales/publish-product-bundle-make-available-selling
Bulk publishing products – Dynamics 365 Sales Forum Community Forum
2023-01-25
Data Events issues after refresh

In a previous article I wrote a bit about Data Events in Dynamics 365 for Finance and Operations. Data Events is a really simple way to create event-based integrations based on changes in the different data entities in FnO. The Data Events functionality is based on functionality in Power Platform. The setup requires the installation of the Finance and Operations Virtual Entity solution in the Power Platform environment connected to FnO. When you create a trigger Data Event it also created a virtual entity in DataVerse. This creates a couple of challenges when it comes to refreshing databases between environments.

For FnO
The settings for the endpoints created in FnO are partially stored in FnO and partially stored in an Azure Key Vault. The settings stored in FnO are amongst others Key Vault URL, App registration ID and Secret. To make sure that these settings do not get extracted from the environment (or accidentally moved to another environment) they are encrypted using an environment specific key and are thus not readable in the destination environment for the refresh. To restore the functionality of Data Events in the destination environment the endpoints need to be removed and recreated. After that has been done, we can re-activate the triggers.

Note that broken endpoints create an issue even if they are not being used. It seems like all endpoints are being validated when you try to create a new one which results in the creation failing.

For DataVerse/CRM
Since the functionality of Data Events is based on Virtual Entities created in DataVerse these will be overwritten when a refresh is done from one DataVerse environment to another. The error message you will get when the event is triggered is this:

Response status code does not indicate success: 404 ({“error”:{“code”:”0x80048d02″,”message”:”Virtual entity ‘mserp_vendvendorbankaccountentity’ not found for external entity VendVendorBankAccountEntity”}}).

(of course, with a different entity name based on your scenario)

The solution is to go to the Active Data Events tab in the Business Events workspace and remove and recreate each Data Event Trigger.

Note. You might have to wait a moment (1 minuter or so) before you recreate the trigger in order for everything to be properly cleaned in DataVerse.

Note: I have not been able to verify what happens if the identical triggers are set up in both source and destination environments. It might be that there are no issues or we might have the same issue. If anyone knows, please let me know 🙂

Lessons Learned: There has always been a lot to think about when you do refreshes… And DataVerse integration/DualWrite adds even more. There is a great article by Faisal Fareed here that detail steps that needs to be done for DualWrite integrated environments.

Links:
Not able to activate Data Events for entities – JohanPersson.nu
Microsoft Dynamics 365 and Power Platform Library: Steps to follow when refresh dual-write integrated environments (FO and CE) (daxture.blogspot.com)

2022-12-30
Interview – Tommy Skaue

In this episode of Dynamics Update we talk to Tommy Skaue, Senior FastTrack Solution Architect at Microsoft. We discuss the impact of the community and the value of documentation.

2022-12-02
10.0.31

In this episode Johan and Gustav discusses the new in 10.0.31.

Some of the highlights

Start and Resume batches in Master Planning

Shared Tables

Create Purchase Orders from POS

Automatic Detours in the Warehouse App

Location Directives in Warehouse

Change tracking in Dataverse

Disable Database logging per tables

Disable deletion of user roles

Supply Risks dashboard

Links

https://learn.microsoft.com/en-us/dynamics365/commerce/get-started/whats-new-commerce-10-0-31

https://learn.microsoft.com/en-us/dynamics365/supply-chain/get-started/whats-new-scm-10-0-31

https://learn.microsoft.com/en-us/dynamics365/finance/get-started/whats-new-changed-10-0-31

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/get-started/whats-new-platform-updates-10-0-31

2022-11-11
ELPOIT #388 – Allt på 70-talet innehöll asbest

Om Shownotes ser konstiga ut (exempelvis om alla länkar saknas. Det ska finnas MASSOR med länkar) så finns de på webben här också: https://www.enlitenpoddomit.se

Avsnitt 388 spelades in den 25 oktober och därför så handlar dagens avsnitt om:

INTRO:
– Alla har haft en vecka… Johan tycker att det är bättre än vanligt! 2st sessioner på Dynamics 365 user group. Varav den ena tydligen var brilliant. Dessutom ska han prata med Microsoft…. om nått som Björn tyckte lät skittråkigt. Björn Har jobbat, tittat på youtube, osv. En standard vecka.

FEEDBACK AND BACKLOG:
– Även Peak Design släpper MagSafe case till Pixel 7
https://9to5google.com/2022/10/21/peak-design-pixel-7-case-review/
– BONUSLÄNK: https://www.patentlyapple.com/2020/10/apple-was-granted-two-major-patents-today-that-came-to-life-with-the-iphone-12-magsafe-charging-and-ceramic-shield.html
– Lite info om vad som händer med Stadia Spel
https://www.androidpolice.com/heres-whats-happening-to-your-stadia-games/

ALLMÄNT NYTT
– Automatic Open Sourcar Pocket Casts
https://techcrunch.com/2022/10/21/podcast-app-pocket-casts-goes-open-source/
– BONUSLÄNK: This week in google med Mat Mullenweg
https://ma.tt/2022/09/this-week-in-google/

LYSSNARFRÅGA:
”Hejsan!
Jag undrar om ni kan lösa en konstig ’feature’ som min tjej har råkat ut för.
Hon har Marshall Acton som hon strömmar musik till via BT från sin iPhone.
Men sedan ett tag så får hon en enormt svag volym. Vi har testat att para
om högtalaren och att gå igenom alla BT och ljud inställningar. Jag kan
streama från min iphone och hon kan streama från sin ipad. Hon kan också
streama till alla andra högtalare i hemmet.

Jag har googlat och dammsugit YouTube utan resultat. Det enda som vi inte
har gjort är att tömma och blåsa om hela telefonen (men det är så asjobbigt
så vill man ju inte).

Så vad sägs om en lyssnarfråga från en kille som har upptäckt en mobil som
mobbar sin matte?”

Länk:
– https://www.ifixit.com/Answers/View/624342/Volume+is+too+Low+-+Used+to+be+much+better

MICROSOFT
– Windows Subsystem for Android får Android 13
https://www.thurrott.com/windows/275017/windows-11-subsystem-for-android-roadmap-android-13-support
https://www.windowslatest.com/2022/10/20/microsoft-is-bringing-android-13-to-windows-11-via-wsa/
– Hallå alla utvecklare. Nu kan du köpa Windows Dev Kit för Windows on Arm… #SerHurAllaSpringerOchBeställer
https://www.zdnet.com/article/microsoft-starts-shipping-its-windows-on-arm-device-for-developers-windows-dev-kit-2023/
– Microsoft rensar LinkedIn
https://appleinsider.com/articles/22/10/20/linkedin-bot-battle-wipes-50-of-apple-employee-accounts
– Varför I hela helvete skall detta ens behövas och om det behövs varför är det inte inbyggt sedan stenåldern
https://www.theverge.com/2022/10/21/23416070/microsoft-pc-manager-app-performance-systems-clean-up
– Veckans korta azure-grej
https://azure.microsoft.com/en-us/updates/auto-extension-upgrade-for-arc-servers/

APPLE
– Apple lanserar nya iPads (med dålig planering)
2 nya iPads, En folio case, En Apple TV
https://www.engadget.com/engadget-podcast-apple-new-ipad-pro-123002939.html
https://www.macrumors.com/2022/10/20/ipad-accessories-compatibility-guide/
https://www.macrumors.com/2022/10/20/m2-ipad-pro-wrong-rumors/
https://www.macrumors.com/2022/10/21/apple-pencil-adapter-shipping-delay/
https://www.engadget.com/blackmagic-davinci-resolve-ipad-085121371.html
– Det var Bonos fel!!!
https://appleinsider.com/articles/22/10/22/bono-takes-the-blame-for-the-2014-itunes-u2-album-disaster
– Roligaste på länge (Lägger den här för att den är roligare här)
https://www.macrumors.com/2022/10/20/android-emoji-reactions-to-iphone-texts/
– Roligt rykte (Nästan som en Surface)
https://appleinsider.com/articles/22/10/20/apple-rumored-to-be-testing-macos-for-m2-ipad-pro
– Apple gör en google (vilket refererar till en nyhet som kommer om en stund under google-segmentet)
https://www.thurrott.com/apple/275111/apple-one-music-tv-plus-price-increases

GOOGLE:
– Google stäms av Texas
https://www.androidauthority.com/google-lawsuit-texas-3222837/
– Google höjer priset på Premium Family
https://www.thurrott.com/music-videos/275002/youtube-premium-family-plan-now-costs-22-99-per-month
– Chrome for Tablets
https://techcrunch.com/2022/10/18/google-is-finally-making-chrome-tablet-friendly/

TIPS:
– https://99percentinvisible.org/episode/the-shipping-forecast/

EVENTS:
– https://securitysummit.truesec.com/
Fortfarande den 16 november på munchenbryggeriet i stockholm

PRYLLISTA
– Björn: glasögon… alltså inte för att jag är gammal och ser dåligt utan för att jag VILL ha glasögon.
– Johan: https://www.kjell.com/se/produkter/dator/belysning-for-datorskarm-skrivbord/xiaomi-mi-computer-monitor-light-bar-p25433

EGNA LÄNKAR
– En Liten Podd Om IT på webben,
http://enlitenpoddomit.se/
– En Liten Podd Om IT på Facebook,
https://www.facebook.com/EnLitenPoddOmIt/
– En Liten Podd Om IT på Youtube,
https://www.youtube.com/enlitenpoddomit
– Ge oss gärna en recension
– https://podcasts.apple.com/se/podcast/en-liten-podd-om-it/id946204577?mt=2#see-all/reviews
– https://www.podchaser.com/podcasts/en-liten-podd-om-it-158069

LÄNKAR TILL VART MAN HITTAR PODDEN FÖR ATT LYSSNA:
– Apple Podcaster (iTunes), https://itunes.apple.com/se/podcast/en-liten-podd-om-it/id946204577
– Overcast, https://overcast.fm/itunes946204577/en-liten-podd-om-it
– Acast, https://www.acast.com/enlitenpoddomit
– Spotify, https://open.spotify.com/show/2e8wX1O4FbD6M2ocJdXBW7?si=HFFErR8YRlKrELsUD–Ujg%20
– Stitcher, https://www.stitcher.com/podcast/the-nerd-herd/en-liten-podd-om-it
– YouTube, https://www.youtube.com/enlitenpoddomit

LÄNK TILL DISCORD DÄR MAN HITTAR LIVE STREAM + CHATT
– http://discord.enlitenpoddomit.se

(Och glöm inte att maila bjorn@enlitenpoddomit.se om du vill ha klistermärken, skicka med en postadress bara. 🙂

2022-10-27
Interview – Fredrik Saetre

In this episode of Dynamics Update, Gustav and Johan Talks to Fredrik Saetre. Fredrik works as a Technology Specialist Manager at Microsoft. We discuss the architecture of Dynamics 365 for Finance and Operations and the differences between single and multi tenant hosting of ERP systems

/Gustav and Johan

2022-10-21
Finding Electronic reporting files

I really like the fact that there is an entire reporting framework built in to Dynamics 365 for Finance and Operations.

Today I got a questions from a colleague about where the files generated by Electronic Reporting. Since I had not done this before I am documenting it here.

Go to Electronic Reporting Jobs for the correct legal entity

Select the job and click Show Files

Select the file you want and click Open

Links:
Electronic reporting (ER) destinations

2022-10-04
AX 2012 Reporting Services Troubleshooting – Part 2

In the last post I was troubleshooting the SSRS connection from AX 2012. I was quite happy when the settings validated correctly but I was still not able to run the report… I got this error:

Error while setting server report parameters. Error message: The DefaultValue expression for the report parameter ‘AX_CompanyName’ contains an error: Request for the permission of type ‘System.Security.Permissions.EnvironmentPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089’ failed. (rsRuntimeErrorInExpression)

After some ~~googling~~ researching I found someone having the same issue (link below).

Apparently you need to change the PermissionSetName in the rssrvpolicy.config file on the Reporting Server. Start Notepad as administrator and open the file from the folder C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\ReportServer (you should probably back it up first).

Change this:
<CodeGroup class=”UnionCodeGroup” version=”1″ PermissionSetName=”Execution” Name=”Report_Expressions_Default_Permissions”

To this:
<CodeGroup class=”UnionCodeGroup” version=”1″ PermissionSetName=”FullTrust”
Name=”Report_Expressions_Default_Permissions”

That is all for today

Links
SSRS Report Error – AX_CompanyName – DAXNigel (wordpress.com)

2022-10-03