Matthew Perren's Avatar

Matthew Perren

@matnav.co.uk

#MSDyn365BC consultant. Reporting specialist #PowerBI #JetReports #SQL #Cosmos Professional profile of @matthewperren.bsky.social

370
Followers
194
Following
1,126
Posts
16.09.2023
Joined
Posts Following

Latest posts by Matthew Perren @matnav.co.uk

Preview
a man with a mustache is laughing while looking out of a car window . Alt: a man with a mustache is laughing while looking out of a car window .

Aaaaahhhh!!!

MB-800 expired on the 4th. I thought I had until the end if the month. Now I have to sit an exam!

08.03.2026 14:51 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

Yeah it was about Intercompany setup and operation. Something I’ve done a fair bit of. I refreshed my previous stuff to reflect all the streamling and improvements in BC over recent years.

06.03.2026 07:33 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
TRAINED BY COSMOS

TRAINED BY COSMOS

Just earned my "Trained by Cosmos" badge! Ready to help businesses transform complex Business Central data into clear, actionable insights.
#DataClarity #CosmosReady

05.03.2026 23:33 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Not doing THAT again!

20.02.2026 12:27 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

I got asked to speak at a β€œthing” that I’ve spoken at before. I’ve spent a couple of days of personal time preparing slide decks and demo environments

The organiser has been uncommunicative to put it lightly (unlike previous occasions). The agenda is out and I’m not on it

I’m somewhat pissed off

20.02.2026 12:26 πŸ‘ 2 πŸ” 0 πŸ’¬ 3 πŸ“Œ 1

I’ve given up trying to understand what Fabric is.

I think it’s for the young people.

19.11.2025 07:11 πŸ‘ 2 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

I’ve been able to create US and Netherlands environments so I can help my customers with VAT and sales tax set up.

I use them to test features on new release waves and train my colleagues.

Astonishing that this is something I’ve basically had to cheat MS to get.

13.11.2025 07:29 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

I have two such tenants both of which have been on the go for over six years.

13.11.2025 07:27 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

One upon a time you could create a free M365 developer environment and then use the email address/es to start a BC trial. As we all know, a BC trial never runs out if you don’t use Production. The multiple β€œusers” you get with the M365 enables you to test approval flows and permission and roles.

13.11.2025 07:26 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
Start Time (Use dynamic content/Expression): Concat(formatDateTime(utcNow(),'yyyy-MM-dd'),'T17:00:00+08:00Z')
	β€’	End Time (Use dynamic content/Expression): Concat(if(equals(dayOfWeek(utcNow()),5),formatDateTime(addDays(utcNow(),3),'yyyy-MM-dd'),formatDateTime(addDays(utcNow(),1),'yyyy-MM-dd')),'T07:59:59+08:00Z')

Start Time (Use dynamic content/Expression): Concat(formatDateTime(utcNow(),'yyyy-MM-dd'),'T17:00:00+08:00Z') β€’ End Time (Use dynamic content/Expression): Concat(if(equals(dayOfWeek(utcNow()),5),formatDateTime(addDays(utcNow(),3),'yyyy-MM-dd'),formatDateTime(addDays(utcNow(),1),'yyyy-MM-dd')),'T07:59:59+08:00Z')

I’ve read a couple of articles about #PowerAutomate flows to automate the setting of an out of office in Outlook. However the formulas they recommend for start/end date times all feature utcNow() but in ways that make no sense. It’s volatile so would need to be part of an extended if statement no?

13.11.2025 07:06 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Oi. Microsoft. Put back the option to send #MSDyn365BC reports to excel data AND layout.

You scamps.

12.11.2025 17:12 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

In case anyone was interested, the issue preventing VAT Returns being done from #MSDyn365BC in the UK was that the GovTalk app hadn’t been updated for v27

10.11.2025 09:07 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

God no!

07.11.2025 15:13 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

A lot of the MVPs don’t post here anymore. Steve Endow never arrived and Jeremy, Kristen, Shannon, Christian and others hardly ever post.

07.11.2025 15:04 πŸ‘ 0 πŸ” 0 πŸ’¬ 2 πŸ“Œ 0

Yeah but customers tended to not be on Twitter. Plus I couldn’t stay there once Musk started making increasingly destabilising changes to the platform

Shame. We had really good thing going there

07.11.2025 12:56 πŸ‘ 4 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

You can’t ask for help on LinkedIn because it’s a b2b platform so the likelihood is that the customer who you’re doing the work is also there.

07.11.2025 12:48 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

LinkedIn is vile. It’s a platform for self aggrandisement and no place for the kind of supportive warm community we built on Twitter.

07.11.2025 12:45 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

Anyone else having fun with MTD and the VAT Statement box numbers?

#MSDyn365BC

06.11.2025 14:36 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

That new logo is a bit copiloty

Does that mean the copilot elements are going to be useful.

Or…not.

(Rhetorical question)

05.11.2025 08:54 πŸ‘ 5 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Inspirational quote style photo with the wording, β€œWas it DNS again? Yes. Yes it was.”

Inspirational quote style photo with the wording, β€œWas it DNS again? Yes. Yes it was.”

21.10.2025 07:57 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

I’m migrating my client from a heavily modified Navision 5 to BC SaaS so it’s not straightforward.

But your suggestion is really helpful thank you

21.10.2025 07:52 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

I just needed β€œunputdownable” for bingo

15.09.2025 06:15 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Migrating open jobs into #MSDyn365BC

Discuss

12.09.2025 10:11 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

So he thinks the current serving army, navy and air force are not warriors, β€œjust defenders”?

06.09.2025 08:02 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

If I want the right expression, I google it and then extrapolate the correct answer from the results. As I go I learn who to rely on. I don’t need a flaky third party to do it for me.

I’ve yet to be persuaded that AI is really worth exchanging humans for when looking for help.

08.08.2025 12:13 πŸ‘ 2 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Presupposing the query is right. You need to check. So you might as well write it yourself.

07.08.2025 21:40 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Other modest paramilitaries

04.08.2025 18:54 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

Scouts

04.08.2025 18:53 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

I’m also β€œin IT” and have wasted far too much time explaining to customers why ChatGPT is wrong. Again.

04.08.2025 18:50 πŸ‘ 2 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

What sort?

02.08.2025 21:42 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0