I have for a while now meaning to write a blog post about dependencies in Electronic Reporting in Dynamics 365 for Finance and Supply Chain… and now I finally got a reason since I had a customer that needed to move ER configuration to a Cloud hosted Environment. In Tier2+ environments, you can do this by using the RCS repository but that is not possible for cloud hosted environments.
So I want to move ISO20022 Credit transfer (IE) to another environment.
In order to that we need to move all upstream dependencies. As you can see in the image there are different levels in the ER config. To move Level 3 we first need to create level one and two…
Otherwise we will get a Unresolved references left – Reference of the object ‘Object Name’ to the object ‘Model’ (GUID,version) cannot be established
Unfortunately I have not found the GUID useful here since I am not able to see the GUID anywhere in the UI (maybe someone who understands better can explain), but the version (61) gives us a hint. If we look at the ISO20022 Credit transfer (IE), we can see that it has a dependency to ISO20022 Credit transfer version 43.61
and if we look at ISO20022 Credit transfer version 43.61, it has a dependency to Payment model version 43
This means that we start with exporting and moving Payment model version 43.
Then we import it in the new environment
Then we do the same with ISO20022 Credit transfer version 43.61 and when that is done we repeat for ISO20022 Credit transfer (IE) version 43.61.13
Normally I do this by using the RCS repository but that is not possible for cloud hosted environments
One of my customers pinged me a while ago and mentioned that she had notifications in her Dynamics 365 Finance and Supply Chain environment saying that she was missing some batch jobs.
Scan for orphaned document references
Scan for document files that have been scheduled for physical deletion
Scans for temporary files that have expired
Deletes expired email history.
Recommendation batch job
All jobs had to do with optimizing how the solution works and are all part of Microsoft Best Practice… that means that if you are contacting support and have a performance related issue, this is one of the tasks you might get.
First of all, we need to take a step back and think about why these jobs are needed. Since FnO is a cloud hosted “SaaS” solution, we have access to a limited amount of performance and one of the reasons for running optimization and clean-up jobs in the solution is to keep it performant. We also pay for storage capacity, or at least we will once the new environments based on the Power Platform architecture is in full swing and keeping the database and storage lean means that we are paying less.
Back to the issue at hand… There are 5 batch jobs the system is saying are best practice. To enable these, you can eighter just go to the Batch Jobs in your system and set them to waiting, or you can just click the link in the notification to enable them. In my case there was actually one job missing from batch jobs and in that case the job was recreated and set to waiting.
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 464 spelades in den 5 Junli och därför så handlar dagens avsnitt om:
INTRO: – Alla har haft en vecka… David har gjort presentationer och grejer på jobbet, och hela familjen har börjat med duolingo. Björn har jobbat, och tagit hand om saker (barn och hundar). Johan har varit borta två veckor, men han har bland annat varit på konferens och fått en inramad avatar, har haft lite otur med pendeltåg,
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 463 spelades in den 28 maj och därför så handlar dagens avsnitt om:
FEEDBACK AND BACKLOG: – Johan hade otur när det gäller växelkurs för tangentbordet vi pratade om förra veckan. Tydligen är en dollar nästan 20 spänn när det gäller tangentbord!!
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 461 spelades in den 14 maj och därför så handlar dagens avsnitt om:
INTRO: – Alla har haft en vecka… Pollen är här med besked!! David har kollat på mello, fixat med altanen, å ska flyga till Rumänien för att presentera lite. Björn har haft en vanlig vecka, och byggt lite på altanen. Johan har inte gjort nånting, han vänter på att folk ska bygga om saker så att de inte ruttnar, har inte titta på Mello, har tittat på TV-sport, och prokrastinerat lite.
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 460 spelades in den 8 maj och därför så handlar dagens avsnitt om:
INTRO: – Alla har haft en vecka… David har byggt vidare på altanen, och lekt Ronja rövardotter, cyklat i skogen, varit ute och sprungit, hängt en del på Twitter (x) och sett ett fenomen, oå jobbat på en presentation igen. Björn har varit på Comiccon. Johan har upptäckt att alla björkar har 5 miljoner pollen korn PER BJÖRK(!!!), åsså har han tittat på Clarksons farm och Rostiga Roadtrips. BONUSLÖNK: Clarksons Farm ( https://www.imdb.com/title/tt10541088/ ) BONUSLÄNK2: Rostiga roadtrips ( https://www.imdb.com/title/tt31948873/ )
Todays troubleshooting was for a customer where we are implemnting DualWrite. When one of my colleagues was changing then owner of an account in Dynamics 365 CE, the got the following error:
{"Write failed for entity Customers V3 with unknown exceptionFor information on troubleshooting see https://go.microsoft.com/fwlink/?linkid=2244045. - Worker does not belong to the current legal entity\nvalidateWrite failed on data source 'CustTable (CustTable)'"}
This was a bit strange I thought… We are not even synchronizing Owner – Employee Responsible because we had not gotten around to it yet (because of reasons).
I asked the colleague for a couple of example accounts that I could have a look at to try to figure it out.
First I looked at the user we are trying to add as an owner. The user belonged to the correct Business Unit in CRM and the user also belonged to the correct Legal Entity in Dynamics 365 for Finance and Supply Chain… Really Strange.
I the looked at the customer in FnO and noticed that there was a user set as Employee Responsible on the customer under Sales Demografic. The user was not the same as the user I was adding from CE, so I simply tried to delete it and then I tried to save the Account in D365 CE. SUCCESS!
I looked at one of the other customers in FnO and noticed that there was an Employee Responsible set on that customer, I removed it and try to change Account in D365 CE, and it worked…
I looked at another customer… Turns out the customer had a worker set as an Employee responsible, but the employee was no longer employed at the company. Remove it and it works
There are two learnings from this issue; “even if you get an error in CE when you are doing a change in CE, the issue might be totally unrelated to CE”, “data quality is important” and finally “FnO does not clean out employees that has left the company”
In this episode we discuss the conference DynamicsMinds in Portoroz in Slovenia in May. Our guests in the episode are Dr. Ludwig Reinhard, Nathan Clouse and André Arnaud de Calavon.
We talk about what we will be doing at the conference, what we thyought about last years session and what we are looking forward to this year.