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?

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

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

That new logo is a bit copiloty Does that mean the copilot elements are going to be useful. Or…not. (Rhetorical question)

Migrating open jobs into #MSDyn365BC Discuss

Someone on LinkedIn bigging up copilot for knowing how a MID function works in excel. Oddly enough, google knows too. Not sure what the value copilot added there but our correspondent wants us to know about it.

I have a shared diary at work. All the project managers have the right to edit. I’d like to put an approval workflow in place that requires them to ask for my permission to add or edit an entry to the diary. I’ve googled and the words “outlook” and “approval” bring up a LOT of irrelevant stuff

Client: we need a feature that does “this” Us: Builds a feature that does “this” C: Oh, it needs to also do “that” Us: Adds “that” C: Why can’t it do “x” I’m sure we asked for “x” (they did not) Us: Gives them “x” C: We’ve decided that you’ve made it too complicated and we don’t want it.

The new #MSDyn365BC feed seems to work ok. Find it here. bsky.app/profile/did:...

Just created a new #MSDyn365BC feed and I’m testing it out. It includes #BCALhelp and a couple of other common hashtags but I could do with a reminder of others we might commonly use. I’m testing it in a sandbox before publishing it to replace the now defunct one.

Apologies to everyone who is waiting for me to find a replacement feed service for #MSDyn365BC and #BCALhelp I’m really busy with work just now but I will get to it shortly.

For every person saying everyone will become an AI vibe coder, there’s 743,000 people who are still unaware of Tables in Excel. #MostPeopleDontCare

I famously do not like or trust AI. But Kurt has a more measured and hopeful view. I hope he’s right.

Wrote a #PowerBI dashboard for a client. The guy I wrote it for was sacked shortly after for… reasons Today I got a support ticket. The company they have hired to write the *same* dashboard (that they clearly don’t know they have) need me to explain the relations between tables in #MSDyn365BC

You can’t have negative fixed assets anymore in #MSDyn365BC can you? Despite what Magnus says here bc365.co/2022/08/27/f...

There’s an irony in having to switch off Teams and Outlook in order to get any work done don’t you think?

Any Power Query nerds here? I’ve got some VBA looking up a file path into a named range in my excel workbook I want to use that file path as the data source for my main query The idea is that the user searches for the file, hits refresh and PQ returns the nice clean data in a new tab Any ideas?

Father’s Day card featured pictures of my favourite activities but there was no excel spreadsheet. It’s like they don’t know me at all.

Ongoing chat in the Dynamics team at work about just how shit Copilot in #MSDyn365BC is and how AI in general has just made our jobs much harder.

Who’s at #BCTechDays? Say Hi to my pal and our Senior Dev, Ian Silvers.

Why in the name of all that’s holy is there no way for a non-dev to add a Send Approval Request button to the Project G/L Journal page (1020) in #MSDyn365BC???? Why is it not there by default in the first place? Aaaaahhhhh!!!!

If you write garbage and need AI to tidy it up, how will you know it’s not made your garbage more garbagey if all you can write is garbage?

Each month the #MSDyn365BC consultant team meet for skills-sharing. We prep something a feature and present to the group. Or we troubleshoot an issue one of us is struggling with. Yesterday this cropped up. Most of us had never heard of it. learn.microsoft.com/en-us/dynami...

Meagan hits the nail squarely on the head. Generative AI products are, at best, prototypes of prototypes. I’ve yet to see any where the output doesn’t have to be checked or where the job would be done faster by a person.

Data Exchange Definitions in #MSDyn365BC are a bit of a nightmare. I’m struggling to render a date dd/MM/yyyy. And I cannot for the life of me work out how to insert a column that comprises of 14 spaces The internet is coming up blank and the MS documentation is sparse to say the least.

Am I alone in thinking that, compared to competitors like Jet Reports and Cosmos, the #PowerBI connection to #MSDyn365BC is poor?

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

What’s happening with the Sales Agent stuff in #MSDyn365BC? I’ve got a preview environment in the GB localisation and it’s still not appearing. I’m having to go to the link and give my email address and then…nothing! Anyone know?

When you write a 9,000 word FRD for a client, share it with them for comment and it comes back with all the formatting altered. That. Guys…it’s our corporate format. It’s OUR document.

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

Realised that my renewal for my MB-800 was nearly due. I’ve got a full week so I did it just now. Passed it by the skin of my teeth 😬 Those questions are like none ever asked by a normal person

Is there a standard feature in UK localisation of #MSDyn365BC that allows a live link to the customer’s bank? Some of the smaller systems (Xero, Free Agent) offer it as standard but not BC. Anyone know why? Could use Yaviro but it’s v expensive.

Want to test something in #MSDyn365BC Does anyone know how to lay hands on a trial BC Team Member Licence. I’ve a couple of trial environments that I’ve used for years and a CDX environment too but I can’t seem to work out how to get those licences to assign to one of my test users.

No response to my subscription billing q I’m demoing it to a client on Mon &, while I’ve spent several hours trying to figure it out, it’s still baffling me Client ONLY supplies services such as rent & cleaning so there’s no item to attach a service commitment to Any good resources? #MSDyn365BC

Anyone used Subscription Billing? #MSDyn365BC

I have spent all of today presenting and answering questions and now I think my brain may be broken.

So when do Job/Project Posting Groups do their work? Is it just when WIP is calculated? #MSDyn365BC

To save everyone (other than my BC contacts) the tedium of hearing me batter on about business processes and reporting and data, I’ve set up a second account for non-work related stuff. I’ll be following the relevant folk there and unfollowing here. bsky.app/profile/matt...

You don’t know do you, @o2?

Listening to some old school hip hop on BBC 6 Music. I’m so glad we sorted out the whack MCs issue. I’d forgotten what a huge problem that used to be.

Musk is attacking UK democracy, and we need a proper response. So let’s get this petition going viral, and force a grownup course of action at the highest level. petition.parliament.uk/petitions/70... Want to do even more? Join MVTFWD.com - because coordinating our votes is true leverage.

That’s next year’s Christmas card sorted.

Bloke in Lidl yesterday buying multiple packs of fire logs and cases of lager, publicly inviting anyone in earshot to a New Year party in his front garden. Wouldn’t get that in Waitrose.

I hate New Year. Too many expectations: You have to * Have “plans” * Have a drink * Make resolutions * Stay up for “the bells” And then you have to say Happy New Year to everyone until - I dunno - July or something Well, you don’t. It’s just another day. I’ll be in bed by 10:30. Have fun.

I’m seeing a lot of commentary in the IT community (and in particular the #MSDyn365BC community) about AI. None of it seems to mention the environmental impact or any of the ethical concerns around the source material used to “teach” the model. What do we think? These things worry me. Am I wrong?

The song, “So Close, So Close and Yet So Far” is about my children’s relationship with the dishwasher.

Just tried to book in at the gym for next week. I’d forgotten it was January and I’ll have to lurk for cancellations until all those new-year-new-you types finally crumble and return to the couch.

Maybe the prompt bar should include the word “reckon”. And instead of Alexa, all AI assistants should be called “Deano.” “Deano. Who do you reckon wrote the Mill On The Floss?”

He’s been fighting again.