iiinova — where your digital self keeps evolving

Matthew Perren

@matnav.co.uk

373 followers 194 following 1.2K posts

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

Posts Replies Media

Matthew Perren @matnav.co.uk · 16/08/2026

I miss #MSDyn365BC Twitter so it was excellent to finally meet my friend from those days, @thedoubleh.dev and his lovely wife face-to-face for lunch in Edinburgh.

Henrik and I grinning at the camera in The Cumberland Bar in Edinburgh

Matthew Perren @matnav.co.uk · 29/07/2026

And one for the monitors!

My desk

Matthew Perren @matnav.co.uk · 05/03/2026

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

TRAINED BY COSMOS

000

Matthew Perren @matnav.co.uk · 13/11/2025

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?

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')

000

Matthew Perren @matnav.co.uk · 21/10/2025

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

000

Matthew Perren @matnav.co.uk · 18/06/2025

That’s exactly it. I’ve got a wee button in excel that lets the user browse for the file. The cell it returns to is a named range “Path” That is then stored in PQ in a single value list called Path but Csv.Document(File.Contents(Path)) returns this error

Formula.Firewall: Query ‘BLAE3685 DD’ (step ‘Source) references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

100

Matthew Perren @matnav.co.uk · 30/04/2025

Anyone having trouble adding a new distribution line to an allocation account in #MSDyn365BC?

The Alloc. Account Distribution does not exist. Identification fields and values: Allocation Account No.=*8001HO-
BUSINESSSTREA', Line No.='0*

000

Matthew Perren @matnav.co.uk · 29/03/2025

This is a preview feature. To sign up for it, fill out the https://aka.ms/bcAgentsEarlyAccess form. Learn more
https://go.microsoft.com/fwlink/?linkid=868966

100

Matthew Perren @matnav.co.uk · 03/03/2025

The top right corner of the book I’m currently reading

Matthew Perren @matnav.co.uk · 03/03/2025

BC Sandboxes at the minute, man! So slow! Anyone else? Just me? #MSDyn365BC

#MSDyn365BC screen shot showing a process message saying “working on it”

000

Matthew Perren @matnav.co.uk · 05/01/2025

You don’t know do you, @o2?

A message from O2 telling me there’s maintenance in my area that will be fixed by <Day Month Year>

000

Matthew Perren @matnav.co.uk · 04/01/2025

Legendary DJ and champion of the obscure and odd, John Peel

Matthew Perren @matnav.co.uk · 04/01/2025

A picture of sunlight backlighting yellow autumn sycamore leaves. A quote overlays the image in an ornate cursive font. It reads, “Try not to hate yourself even though you’re worthless “

Matthew Perren @matnav.co.uk · 02/01/2025

I mean, do they? I’ve literally heard no one - not one single end user - articulate this wish. Ever.

A highlighted quote from Microsoft’s Satya Nadella, saying, “People want more AI native biz apps right?”

Matthew Perren @matnav.co.uk · 01/01/2025

That’s next year’s Christmas card sorted.

A sheet of chipboard lies on the pavement with the words “XMAS TREES” spray painted on it. An arrow is also painted on it. The arrow points to a supermarket trolley lying next to the sign.

Matthew Perren @matnav.co.uk · 28/12/2024

He’s been fighting again.

Our tuxedo tom cat, Noodles, with a big red scratch on his nose.

Matthew Perren @matnav.co.uk · 28/12/2024

Amazing. Selena Gomez follows me. She’s from Leeds. “Began me career as a child actress”

A clearly fake account for the actress Selena Gomez. Features the ludicrous phrase “began me career as a child actress”

Matthew Perren @matnav.co.uk · 25/12/2024

Just let me know when this crops up. I can explain it.

Baffling Christmas cracker joke:
What kind of cough medicine does Dracula take?

Answer: Con medicine.

Matthew Perren @matnav.co.uk · 25/12/2024

Faked up inspirational quote style picture of mountains rising out of a lake. The text says “Was it DNS again? Yes. Yes it was.”

100

Matthew Perren @matnav.co.uk · 25/12/2024

Merry Christmas to all my #MSDyn365BC pals. I’m so glad we’ve managed to rebuild our community on Bluesky this year. You’re all fabulous.

The Perren/Anderson Christmas tree before the carnage!

Matthew Perren @matnav.co.uk · 24/12/2024

Lotta has a fold in her ear just now. Didn’t seem bothered. It’s been a couple of hours now and I can’t breathe.

Lotta the golden labradoodle looking quizzically at the camera. The look is compounded by the slight quirk in her left ear which is making the big floppy pice of hairy rag stick out sideways.

Matthew Perren @matnav.co.uk · 23/12/2024

This glass?

1970s dimple style pint glass tankard

100

Matthew Perren @matnav.co.uk · 22/12/2024

They thought quite a lot of themselves, the victorians, eh?

Gravestone in Warriston Cemetery, Edinburgh. Easily 7 or 8 metres tall. It’s a huge stone cross covered in Celtic knot work. It’s a lovely thing but the price would have fed a couple of hundred people for a year.

Matthew Perren @matnav.co.uk · 22/12/2024

Turns out bins round our way is Christmas Eve and New Year’s Eve. I’m buying a box of biscuits for the lads this year.

Edinburgh bin collection calendar showing bin collections on Christmas and New Year’s Eve

Matthew Perren @matnav.co.uk · 21/12/2024

Happy Christmas?

BBC news headline “What are Royal Christmas cards trying to tell us?” Illustrated by a picture of a happy looking family who also happen to be royal.

Matthew Perren @matnav.co.uk · 20/12/2024

Here you go!

Matthew Perren @matnav.co.uk · 20/12/2024

Still have mine from when I was small.

Cover of a 1962 edition of “Box of Delights” by John Masefield.

Matthew Perren @matnav.co.uk · 20/12/2024

Today’s #MSDyn365BC workplace.

A picture of the main doors at Celtic Park in Glasgow

Matthew Perren @matnav.co.uk · 15/12/2024

I just read the article. It’s perfect but this, THIS is the best thing I’ve ever seen

A beautiful statue of a doe and faun. Both have huge googly eyes.

Matthew Perren @matnav.co.uk · 15/12/2024

Recently on the South Bank

Base of the street lights on londons south bank with the face of Neptune. Some wag has added googly eyes.

Matthew Perren @matnav.co.uk · 14/12/2024

To be fair he does have backup, but she’s so ridiculously good natured that it’s hard to imagine a fox doing anything other than laughing.

Big stupid hairy blond labradoodle

Matthew Perren @matnav.co.uk · 14/12/2024

This idiot chases foxes. But they run so clearly they’ve seen a side to him that I haven’t.

Black and white cat

Matthew Perren @matnav.co.uk · 13/12/2024

Wow. So it does! I assume it’s because it needs to post it immediately in case it’s left overnight and the exchange rate changes.

Matthew Perren @matnav.co.uk · 02/12/2024

That we know of.

Duo the Duolingo owl emerging from a hole in the ground for some reason, in order to cheerfully announce “You made 364 mistakes this year.”

Matthew Perren @matnav.co.uk · 30/11/2024

Just rejigged my office space. Very pleased with the result.

A large alcove in which one corner is floor to ceiling bookcases and in the other a desk with two laptops and two monitors. A large, comfortable office chair sits in the middle with a pale blue blanket draped over the back.

Matthew Perren @matnav.co.uk · 24/11/2024

I added you yesterday! 🙂

000

Matthew Perren @matnav.co.uk · 23/11/2024

Kids! Get your mittens! Grab the sledge! The slush is settling!

A thick layer of grey slush neither freezing nor melting in the street outside our house. Car tracks cut through it emphasising how thick and unpleasant it is

Matthew Perren @matnav.co.uk · 20/11/2024

I promise you that they are there! As it’s my starter pack I’m not sure what others are seeing. Sorry!

Screen shot of Business Central starter pack with three feeds showing as being included.

100

Matthew Perren @matnav.co.uk · 19/11/2024

Time to wheel this old chestnut out.

Christmas lights box. It ought to say “Flickering lights” but, because of a horrible kerning error, it appears to read “fuckering lights”

Matthew Perren @matnav.co.uk · 19/11/2024

🎵Whaaaaooo you’re living on a prayer🎵

Computer screen showing the update message “you’re 8% there”

Matthew Perren @matnav.co.uk · 13/11/2024

Weird!

A search for “dara o briain” showing no results.

Matthew Perren @matnav.co.uk · 13/11/2024

Yes. That’s been what’s missing.

Screen shoot from BBC News showing a picture of Elbow Munk, mouth agape, wearing a baseball cap (of all things), and double punching the air like some dainty child pretending to like sport. The headline reads, “Musk promises to ’Make government fun again’”

Matthew Perren @matnav.co.uk · 08/11/2024

Bit bleak

The Duolingo icon with the words “last chance!” It shows the owl standing in front of a house that is on fire.

000

Matthew Perren @matnav.co.uk · 08/11/2024

Lotta was not happy on bonfire night

Lotta the blond shaggy labradoodle uncomfortably sitting halfway up the stairs. She looks nervous and unhappy.

000

Matthew Perren @matnav.co.uk · 08/11/2024

What’s your sign?

The last four letters of the huge “Edinburgh” sign at Edinburgh Airport

000

Matthew Perren @matnav.co.uk · 03/11/2024

100

Matthew Perren @matnav.co.uk · 03/11/2024

I couldn’t say for sure but I think…I think…Lotta may have rolled in something

Lotta the labradoodle is absolutely FILTHY.

000

Matthew Perren @matnav.co.uk · 29/10/2024

I found this hanging in the woods behind our house. So, noting to worry about them. Everything is fine. Maybe we should all split up to search?

A crude human figure made of sticks - literally a stick figure - hangs from a branch suspended by a rope made from dead ivy. A smaller figure hangs behind. The rising sun is just visible in the background, through the last leaves on the trees.

Matthew Perren @matnav.co.uk · 28/10/2024

Matthew Perren @matnav.co.uk · 26/10/2024

That was Cavalcade of Shit in session. More from them later

Iconic UK new music DJ John Peel. He was famous for featuring obscure and sometimes barely listenable bands on his weekday late evening show on BBC Radio 1. It was awesome.