JohanPersson.nu

Warning:[DWCE0001] Export was skipped. Max lookup count supported in Initial Sync stage is 10. Current lookup count 11

Today I was setting up the Dual-Write sync for one of my customers and I bumped into this error message:

Warning:[DWCE0001] Export was skipped. Max lookup count supported in Initial Sync stage is 10. Current lookup count 11

The issue here is that there is a limit in DataVerse that (I would guess) for performance issues there is a hard limit on a maximum of lookup fields.

In our case we had these fields in the default mapping for Customer V3 -> Account using lookup:

transactioncurrencyid.isocurrencycode
msdyn_customergroupid.msdyn_groupid
msdyn_billingaccount.accountnumber
msdyn_paymentday.msdyn_name
msdyn_customerpaymentmethod.msdyn_name
msdyn_paymentschedule.msdyn_name
msdyn_paymentterm.msdyn_name
msdyn_vendor.msdyn_vendoraccountnumber
primarycontactid.msdyn_contactpersonid
msdyn_salestaxgroup.msdyn_name
msdyn_company.cdm_companycode

The workaround is to remove one of the problematic mappings, do the initial sync and add it back. Remember to take a screenshot of the mapping that you are removing so you can put it back exactly the same.

Missing Warehouse app step instructions in D365FO

This week we have been having an issue with the warehouse at a customer. We are in the process of rolling out a new Legal entity and when moving the Legal entity to a new environment using DMF we noticed that the Warehouse app step instructions stopped working and was replaces with very cryptic labels

This issue was not present in the environment we used to set up the legal entity, but rather it occurred when we moved it.

Turns your enabling the feature (Warehouse app step instructions) sets the default steps in all existing Legal Entities but if we create a new one they are not.

To create these in a new legal entity we need to click “Create Default Steps” in the Mobile Device Steps module.

There is also no data entity for moving mobile device steps from one environment to another which might be a good idea for future improvement.

That is all for today

ELPOIT #345 – Vad har du på din björnlista, Prylen?

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 345 spelades in den 1 december och eftersom att en människa normalt har 52 ben i sina fötter av totalt 206 i kroppen ( https://www.ontariochiropodist.com/Public/foot-facts.html ) så handlar dagens avsnitt om:

INTRO:
– Alla har haft en vecka…

FEEDBACK AND BACKLOG:
– Johan har kommit på att det var “Differential Privacy” som han tänkte på förra veckan
https://en.wikipedia.org/wiki/Differential_privacy

ALLMÄNT NYTT
– Winamp kommer tillbaka, men…
https://musictech.com/news/industry/winamp-is-coming-back-as-a-unique-space-for-creators-and-possibly-a-music-making-platform/
– Nya IoT regler I UK (tips från DanielGR)
https://www.bbc.com/news/technology-59400762
– Varför inte en Cyberwhistle
https://appleinsider.com/articles/21/12/01/tesla-selling-50-cyberwhistle-musk-mocks-19-apple-polishing-cloth
– Vi har pratat om Logistikpodden förut:
https://logistikpodden.se/podcast/niklas-modig-fran-japan-till-varlden-med-flodeseffektivitet/
– Twitter får ny VD
https://www.thurrott.com/cloud/social/259733/twitter-ceo-steps-down
– Amazon låter oss bygga tvillingar
https://aws.amazon.com/about-aws/whats-new/2021/11/aws-iot-twinmaker-build-digital-twins/
– Kryptovalutan JRR Token stoppas
https://computersweden.idg.se/2.2683/1.759298/upphovsratten-satter-stopp-for-kryptovalutan-jrr-token

LYSSNARFRÅGA:
– Världens bästa Carin har hört av sig om klistermärken

MICROSOFT
– Men vafan… igen:
https://www.thurrott.com/cloud/web-browsers/microsoft-edge/259781/users-pushback-against-bloatware-in-microsoft-edge
– En bra sak har man också gjort
https://www.bleepingcomputer.com/news/microsoft/microsoft-edge-adds-super-duper-secure-mode-to-stable-channel/
– Ny superdator:
https://www-zdnet-com.cdn.ampproject.org/c/s/www.zdnet.com/google-amp/article/microsoft-now-has-one-of-the-worlds-fastest-supercomputers-and-no-it-doesnt-run-on-windows/
– Flytta Office 365 till Sverige. Fast man ska kanske inte ha bråttom.
https://docs.microsoft.com/en-us/microsoft-365/enterprise/request-your-data-move?view=o365-worldwide
– BONUSLÄNK: 99% invisible
https://99percentinvisible.org/episode/alphabetical-order/
– Dags att köra windows 11 överallt?
https://www.thurrott.com/windows/windows-11/259730/windows-11-is-now-on-almost-9-percent-of-pcs

APPLE
– Apple stämmer NSO Group
https://www.apple.com/newsroom/2021/11/apple-sues-nso-group-to-curb-the-abuse-of-state-sponsored-spyware/
– BONUSLÄNK: https://darknetdiaries.com/episode/100/

GOOGLE:
– Nya funktioner I Android
https://www.thurrott.com/mobile/android/259810/google-announces-new-android-features-2
– Google betalar skatt
https://computersweden.idg.se/2.2683/1.759460/google-betalar-miljardbelopp-i-restskatt-till-irland
– Och håller på med teckenspråk
https://blog.google/outreach-initiatives/accessibility/ml-making-sign-language-more-accessible/
– Inte bara döva som ska få hjälp, utan även synskadade
https://blog.google/outreach-initiatives/accessibility/more-accessible-web-images-arrive-10-new-languages/

PRYLLISTA
– Björn: Blackweek: Pluralsight
pryllista: Kartonger: https://www.etsy.com/listing/893963572/mini-amazon-box-16-envelope-template
– David: Blackweek: Musikprogramvara
pryllista: Dekorationsslinga: https://www.kjell.com/se/produkter/hem-fritid/belysning-lampor/stamningsbelysning/dekorationsslinga-3000-led-med-ljuseffekter-p64646
– Johan: Blackweek: Hörlurar, löparskor, Pannkakajärn, Oura ring
Pryllista: https://www.xxl.se/gore-wear-m-windstopper-facewarmer-ansiktsvarmare-svart/p/1150300_1_style

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. 🙂

Interview – Joris De Gruyter

Hi All

This time we have the honor of interviewing none other than Joris De Gruyter – Senior Program Manager for Dynamics 365 Dev Tools at Microsoft. Wi talk a bit about the evolution of D365FO since it was initially released and then we have a discussion about the convergence between D365FO, D365CE and PowerPlatform. The discussion is based on this talk by Sunil Garg.

https://youtu.be/9wWGCTHxRq0

ELPOIT #344 – Don‘t be a rövhatt

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 344 spelades in den 23 november och eftersom att en människa normalt har 52 ben i sina fötter av totalt 206 i kroppen ( https://www.ontariochiropodist.com/Public/foot-facts.html ) så handlar dagens avsnitt om:

INTRO:
– Alla har haft en vecka… Ord som ingår i beskrivningarna är: David har fått nya glasögon. har umgåtts med barn och familj. Johan har INTE gått, så mycket som han vill…

FEEDBACK AND BACKLOG:
– WOWOWWOWW – Magnum Double Gold Caramel Billionare på burk!!!
– Angående Kindle i Sverige
– Notis om WearOS marknadsandel
https://swedroid.se/wear-os-har-vuxit-markant-tack-vare-samsung/
– Denna nämnde Johan I förra avsnittet (Xbox video på Youtube)
https://www.thurrott.com/games/xbox/259517/xbox-is-celebrating-its-history-with-an-alumni-roundtable

ALLMÄNT NYTT
– Sony och MS sätter press på Blizzard
https://www.engadget.com/xbox-phil-spencer-activision-blizzard-203557204.html
– BONUSLÄNK: https://howmuch.net/articles/putting-companies-power-into-perspective
– Johan är ledsen
https://www.engadget.com/star-trek-discovery-leaves-netflix-080929478.html
– Adele har lite att säga till om
https://www.engadget.com/adele-spotify-removes-shuffle-button-173856590.html

DISKUSSION:
– Hur lyssnar vi på poddar.
– BONUSLÄNK: https://poddtoppen.se/podcast/1507649534/stulet-gods

MICROSOFT
– Xbox Cloud Gaming på konsol
https://www.thurrott.com/games/xbox/259355/xbox-cloud-gaming-comes-to-xbox-series-xs-and-xbox-one
– Azure AD är redundant
https://azure.microsoft.com/en-us/blog/advancing-service-resilience-in-azure-active-directory-with-its-backup-authentication-service/

APPLE
– Hur f_n skall detta gå till (veckans förmodligen viktigaste nyhet)
https://www.thurrott.com/apple/259359/apple-to-open-iphone-to-self-repair-in-2022
https://appleinsider.com/articles/21/11/17/apples-self-service-repair-answers-critics-doesnt-help-users
https://appleinsider.com/articles/21/11/17/ifixit-calls-apple-self-service-repair-program-a-total-shift-in-perspective
– Fast den här BORDE varit det viktigaste nånsin!!
https://appleinsider.com/articles/21/11/21/woman-swallows-airpod-instead-of-painkiller-records-audio-from-stomach
– Apple ber sina användare ge betyg till Podcast appen… inte podcasten de lyssnar till
https://www.engadget.com/apple-podcasts-app-review-score-prompts-215857401.html
– Varför finns inte Windows för M1 macar?
https://appleinsider.com/articles/21/11/22/qualcomm-microsoft-deal-could-explain-lack-of-windows-on-apple-silicon
– Apple Car kommer att förändra ALLT!!
https://appleinsider.com/articles/21/11/19/apple-car-will-disrupt-auto-industry-says-morgan-stanley

GOOGLE:
– Google fixat pixel 6 och 6 Pro?
https://www.theverge.com/2021/11/17/22787537/google-pixel-6-pro-update-fingerprint-scanner-slow
– Google reparerar iMessage (det hade varit såååå kul med tillbakakaka)
https://www.thurrott.com/mobile/android/259504/google-is-going-to-solve-the-imessage-problem
(samma nyhet fast från Appleinsiders: https://appleinsider.com/articles/21/11/22/imessage-reaction-support-rolling-out-in-google-messages )
– Detta är ju grymt coolt
https://blog.google/outreach-initiatives/accessibility/project-relate/

PRYLLISTA
– David: Minifrys: https://www.elgiganten.se/product/vitvaror/kyl-och-frys/frysskap/MTF34W18E/matsui-frys-mtf34w18e
– Björn: https://www.logitech.com/en-hk/products/keyboards/pop-keys-wireless-mechanical.920-010577.html
Fast jag gillar ju popcorn, och min fru (och jag) gillar att ha ljus tända: https://varuhus1.se/doftljus-popcorn
Men jag är JÄTTESUGEN på en sån här: https://burgerstore.se/product/smashburger-kit-38-38/
– Johan: Jabra Elite Active 75t Wireless (Jag kan använda min fatboy kudde igen)
https://www.hifiklubben.se/jabra-elite-active-75t-wireless-charging-traadlosa-in-ear-horlurar/jabelite75tactwdgrey/

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. 🙂

ELPOIT #343 – Jag har varit tyst jättelänge

Om Show notes 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 343 spelades in den 16 november och eftersom att det japanska whiskeyinstresset startade 1854 när Matthew Perry gav 110 gallon whiskey till kejsaren ( https://www.huffpost.com/entry/japan-whiskey_n_7117650 ) så handlar dagens avsnitt om:

INTRO:
– Alla har haft en vecka… Ord som ingår i beskrivningarna är: massa jobb, massa kul, shuffleboard, kycklingar, hostningar, förkylningar, kul
– BONUSLÄNK: Läs på om xlookup: https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929

FEEDBACK AND BACKLOG:
– Iphonen med USB-C var lite dyrare än vanligt
https://appleinsider.com/articles/21/11/11/user-modified-iphone-x-with-usb-c-port-sells-for-86k

ALLMÄNT NYTT
– Zuckerberg personligt ansvarig för Cambridge Analytica:
https://www.cnbc.com/2021/10/20/facebook-ceo-mark-zuckerberg-added-to-dc-privacy-lawsuit.html
– Spotify “börjar” med ljudböcker
https://appleinsider.com/articles/21/11/11/spotify-pushes-into-audiobook-business-with-findaway-purchase
– Är inte detta en ganska stor förändring i hur filmbolag ser på sitt IP?
https://techcrunch.com/2021/11/11/amazon-prime-video-app-introduces-a-new-clip-sharing-feature/
– Patreon bygger lösning för att hosta video
https://www.theverge.com/2021/11/11/22774301/patreon-jack-conte-video-player-podcast-youtube-launch
– Vissa har med bandbredd än jag har på ComHem
https://techcrunch.com/2021/11/15/cloudflare-terabits-ddos-attack/
https://therecord.media/microsoft-said-it-mitigated-a-2-4-tbps-ddos-attack-the-largest-ever/
– Vita huset tycker INTE att intel ska bygga fabriker i china
https://appleinsider.com/articles/21/11/13/white-house-shot-down-intel-plans-to-increase-chip-production-in-china

LYSSNARFRÅGA:
– Anders har skickat in en fråga om “Routrar, routerOS och Brandväggar” som vi diskuterar

MICROSOFT
– Idag öppnar Microsofts svenska datacenter
https://news.microsoft.com/sv-se/2021/11/16/idag-oppnar-microsofts-hallbara-datacenter-i-sverige-skapar-nya-mojligheter-for-sverige-genom-hallbar-digitalisering/
https://docs.microsoft.com/en-us/microsoft-365/enterprise/moving-data-to-new-datacenter-geos?view=o365-worldwide
– BONUSLÄNK: Och vilka tjänster finns det då?
https://azure.microsoft.com/en-us/global-infrastructure/services/?products=all&regions=europe-north,europe-west,norway-east,non-regional,us-central
– The Verge: Windows 11 is making it easier to share your screen in Microsoft Teams and other video calls.
https://www.theverge.com/2021/11/10/22774730/microsoft-windows-11-teams-integration-sharing-features
– Windows 10 21H2 är släppt
https://www.thurrott.com/windows/windows-10/259315/microsoft-releases-windows-10-version-21h2
– Och nu kommer uppdateringarna att komma en gång per år istället
https://www.zdnet.com/article/with-rollout-of-21h2-microsoft-moves-windows-10-to-annual-updates/
– Xbox firar 20 med bakåtkompatibla spel
https://news.xbox.com/en-us/2021/11/15/70-new-backward-compatible-games/
– BONUSLÄNK: Darknet Diaries om Xbox:
https://darknetdiaries.com/episode/45/
– Men vafan!!! Ni gör det inte lätt att vara fanboy
https://www.engadget.com/microsoft-windows-11-edge-deflector-block-171516494.html
https://www.theverge.com/2021/11/15/22782802/microsoft-block-edgedeflector-windows-11
– Microsoft kommer inte släppa x64 Emulation till windows 10 på ARM
https://www.thurrott.com/windows/windows-11/259318/microsoft-will-not-bring-x64-emulation-to-windows-10-on-arm
– Men däremot så finns nu Edge på Linux
https://www.zdnet.com/article/microsofts-edge-browser-for-linux-is-now-available-for-all-users/

APPLE
– Apple skapar tjänst för Device management
https://techcrunch.com/2021/11/10/apple-introduces-device-management-solution-aimed-at-small-business/
– och JAMF vd har svarat att det är SUPERBRA att apple har släppt:
https://appleinsider.com/articles/21/11/12/jamf-ceo-calls-apple-business-essentials-a-terrific-opportunity
– David brukar klaga på att hans bärbara är jättedyra…
https://appleinsider.com/articles/21/11/10/rare-apple-i-computer-sold-for-500000-at-auction
– Apple gör fler chip
https://www.macrumors.com/2021/11/16/qualcomm-2023-modem-chips-iphone/

GOOGLE:
– Ooops, “har du ryckt ut nått??”
https://www.engadget.com/internet-outage-google-cloud-spotify-snapchat-down-183917361.html

PRYLLISTA
David: Extern 4TB SSD med USB-C
https://www.inet.se/produkt/4301670/asus-rog-strix-arion-m-2-nvme-ssd-kabinett-usb-gen-3-2
https://www.inet.se/produkt/4302132/corsair-force-mp510-4tb
Björn: En grej som kommer göra mitt liv så SJUKT mycket enklare:
https://www.etsy.com/listing/674084974/takeout-dice-over-35-takeoutfood
Mats: En Imperial Star Destroyer
https://www.lego.com/sv-se/product/imperial-star-destroyer-75252
Johan: Bagage tag
https://www.lego.com/sv-se/product/the-child-bag-tag-5006368

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. 🙂

Finding the PC name of a POS register

In my previous post I showed you how to get the installed version of the POS software on each register. In some cases you might need to manually update this if the update has not worked correctly you will need to connect to the actual PC (or even go on site).

Unfortunately the information in D365FO does not contain the computer name. To get the computer name we need to look in LCS Telemetry. The only value I found to map between the export from D365FO and LCS is Physical Device ID. In order to be able to match the two Excel spread sheets we will need to add the field Physical Device ID to the Export from D365FO.

To export telemetry from LifeCycleServices, Log into LCS, select the environment you are looking at and click in Environment Monitoring.

The maximum number of loglines is 5000 and in order to see what we want to see we will need to limit the results a bit. First of all set Query Name to Retail Channel events. Select a time interval (10 days or so) and set log source to Retail Modern POS. To further limit the results the query return I add 1018 on the search terms. Export the information by clicking Export Grid.

Copy the entire sheet and paste it into a second tab in the D365FO Excel. Name the two tabs D365FO and Telemetry. In the Telemetry tab go to Data and click Remove Duplicates. Click Unselect All and then choose the Role Instance column and click OK.

In the D365FO tab, choose the first cell in the first empty column and paste the following in the formula field

=XLOOKUP(LEFT([@[Physical device ID]];25);Telemetry!Q:Q;Telemetry!G:G;;-1)

Note: You might need to adjust the Column name at the start of the formula in order to fit your export. The columns pointing to the Telemetry tab should be OK if you keep it standard. Fill all the cells in the columns with the same formula. This should add the PC Name to the Excel.

That is it for today 🙂

10.0.23

In this episode Gustav and Johan discuss what is new in version 10.0.23 of Dynamics 365 for Operations

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

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

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

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

Finding current POS package version for registers

When doing a version upgrade of the POS registers in a Retail installation it might be necessary to verify if all registers have been updated correctly. If you are running a large organization with multiple hundreds of registers this needs to be done efficiently.

Start by going to Registers by entering Registers in the search box and pressinng enter.

Right-click in the white area to the right of the Registers Grid. Click Personalize: TerminalGrid and then click Add a field.

Select Currently installed package version in the Retail Devices table and click Update.
Note: If you have multiple Legal Entities you might want to add that one too

To use this information and maybe create nice graphs… Click the Office icon and choose Export to Excel – POS registers

Printing a testpage from PowerShell

Todays challenge comes from trying to troubleshoot printers om AX 2012.

Some of the printing flows are not that straight forward and might require printing from a service account. If you do not want to log in as that user to the UI or mabee you are not able to you can use PowerShell to do a test print from the account. This functionality is not available directly in Windows but I found a PS function that does this which I modified a bit (original links below).

This function uses WMIC to list all printers and then send a test print to the printer. You can also use it without modifying the $printername by adding the parameter -printername.

Function out-TestPage
{
Param(
  [string]$printername = “\\printserver\printername”)

  $Printers = Get-CimInstance -ClassName Win32_Printer
  $Printer = $Printers | Where-Object Name -eq "$printername"
 Invoke-CimMethod -MethodName printtestpage -InputObject ($printer)
 Write-Host "Printing to $($printer).Name"
}

To run this as the service account, simply launch PowerShell och Powershell ISE as the account and run the Function Block. Then call the function using out-TestPage -printername “[the name of your printer]”

Links
Use PowerShell to Send Test Page to a Printer – Scripting Blog (microsoft.com)
[SOLVED] Print Test Page from PS – Printers & Scanners – Spiceworks