- 487
- 1 469 192
Erik Hougaard
Canada
เข้าร่วมเมื่อ 20 เม.ย. 2006
Welcome to my channel, where I empower you with the skills and knowledge to navigate the evolving landscape of Business Central (BC) development. Since embarking on my journey within the Microsoft Dynamics community in 1990, I've had the privilege of working with every version of the system, gaining insights from its various facets.
Away from TH-cam, my focus is divided between two businesses. Hougaard.com, where I develop Apps and Tools designed to enhance your ERP without the cost and hassle of custom development. And EFOQUS, where we create word-class Business Central projects for customers across North America.
Away from TH-cam, my focus is divided between two businesses. Hougaard.com, where I develop Apps and Tools designed to enhance your ERP without the cost and hassle of custom development. And EFOQUS, where we create word-class Business Central projects for customers across North America.
Embed resources into your app file with AL and Business Central
Find more information at my blog www.hougaard.com or follow me on bsky.app/profile/hougaard.bsky.social
Source code can be found here: github.com/hougaard/TH-cam-Video-Sources
Source code can be found here: github.com/hougaard/TH-cam-Video-Sources
มุมมอง: 575
วีดีโอ
That time when I wanted to build a better NAV than NA
มุมมอง 956วันที่ผ่านมา
Find more information at my blog www.hougaard.com or follow me on bsky.app/profile/hougaard.bsky.social Source code can be found here: github.com/hougaard/TH-cam-Video-Sources
ELI5 How to use FlowFields
มุมมอง 93614 วันที่ผ่านมา
Find more information at my blog www.hougaard.com or follow me on bsky.app/profile/hougaard.bsky.social Source code can be found here: github.com/hougaard/TH-cam-Video-Sources
Send an E-mail to your own AL code in Business Central
มุมมอง 1.2K21 วันที่ผ่านมา
Find more information at my blog www.hougaard.com or follow me on bsky.app/profile/hougaard.bsky.social Source code can be found here: github.com/hougaard/TH-cam-Video-Sources
Modern Text Search in AL and Business Central
มุมมอง 1.2Kหลายเดือนก่อน
Find more information at my blog www.hougaard.com or follow me on bsky.app/profile/hougaard.bsky.social (Yes, sound is messed up, I have some new equipment ordered, so hopefully, this should be the last video with sound issues). Source code can be found here: github.com/hougaard/TH-cam-Video-Sources
How to deal with Medusa Records in AL and Business Central
มุมมอง 1.4Kหลายเดือนก่อน
Find more information at my blog www.hougaard.com or follow me on eHougaard Source code can be found here: github.com/hougaard/TH-cam-Video-Sources
Runtime dependencies in AL and Business Central, what?
มุมมอง 1.4Kหลายเดือนก่อน
Find more information at my blog www.hougaard.com or follow me on eHougaard Source code can be found here: github.com/hougaard/TH-cam-Video-Sources
I can multitask, also in AL and Business Central
มุมมอง 1.7Kหลายเดือนก่อน
Find more information at my blog www.hougaard.com or follow me on eHougaard Source code can be found here: github.com/hougaard/TH-cam-Video-Sources
Spread some Nuget love on your apps!
มุมมอง 1.3Kหลายเดือนก่อน
Find more information at my blog www.hougaard.com or follow me on eHougaard Source code can be found here: github.com/hougaard/TH-cam-Video-Sources
Installation and Configuration of the Advanced Portal Designer web service
มุมมอง 341หลายเดือนก่อน
Find more information here: www.hougaard.com/portaldesigner
Introducing the Advanced Portal Designer for Business Central. A new way to build custom portals
มุมมอง 971หลายเดือนก่อน
Find more information here: www.hougaard.com/portaldesigner
Let's make User Management better in Business Central
มุมมอง 1.5K2 หลายเดือนก่อน
Find more information at my blog www.hougaard.com or follow me on eHougaard Source code can be found here: github.com/hougaard/TH-cam-Video-Sources
Guide for customers to help their partner with troubleshooting Business Central
มุมมอง 1K2 หลายเดือนก่อน
Find more information at my blog www.hougaard.com or follow me on eHougaard Source code can be found here: github.com/hougaard/TH-cam-Video-Sources
Dual-App Mode for easier Co-Development with the Simple Object Designer in Business Central
มุมมอง 4432 หลายเดือนก่อน
Learn more about the Simple Object Designer here: www.hougaard.com/designer/ Download the free trial version of the Simple Object Designer from AppSource here: appsource.microsoft.com/en-us/product/dynamics-365-business-central/PUBID.hougaard-4699382|AID.designer|PAPPID.4c032704-5c36-4480-b710-29e8565568bc?exp=ubp8&tab=Overview You can use the free trial version of the Simple Object Designer to...
Using Interfaces in the Goldilocks zone in AL and Business Central
มุมมอง 1.7K2 หลายเดือนก่อน
Find more information at my blog www.hougaard.com or follow me on eHougaard Source code can be found here: github.com/hougaard/TH-cam-Video-Sources
What's new in AL for Business Central 2024 Wave 2, The Hacker Edition!
มุมมอง 2.4K2 หลายเดือนก่อน
What's new in AL for Business Central 2024 Wave 2, The Hacker Edition!
Sometimes, two apps are better than one in AL and Business Central
มุมมอง 1.3K3 หลายเดือนก่อน
Sometimes, two apps are better than one in AL and Business Central
See how a consultant uses the Simple Object Designer to build a customer solution w/Business Central
มุมมอง 8933 หลายเดือนก่อน
See how a consultant uses the Simple Object Designer to build a customer solution w/Business Central
Generate demo data from a web service in AL and Business Central
มุมมอง 1.5K3 หลายเดือนก่อน
Generate demo data from a web service in AL and Business Central
Cool trick to run a Report on a Query in AL and Business Central
มุมมอง 1.7K3 หลายเดือนก่อน
Cool trick to run a Report on a Query in AL and Business Central
Does old AL code rot in Business Central?
มุมมอง 1.4K3 หลายเดือนก่อน
Does old AL code rot in Business Central?
Shortcomings in the platform, here comes Base App in Business Central
มุมมอง 1.7K4 หลายเดือนก่อน
Shortcomings in the platform, here comes Base App in Business Central
Get your numbers in sequence with NumberSequence in AL and Business Central
มุมมอง 1.3K4 หลายเดือนก่อน
Get your numbers in sequence with NumberSequence in AL and Business Central
Protect your secret (texts) against prying eyes and debuggers!
มุมมอง 1K4 หลายเดือนก่อน
Protect your secret (texts) against prying eyes and debuggers!
You can build Arrays of everything in AL and Business Central
มุมมอง 1.5K4 หลายเดือนก่อน
You can build Arrays of everything in AL and Business Central
Cookies in AL coming back to bite you!
มุมมอง 1.1K5 หลายเดือนก่อน
Cookies in AL coming back to bite you!
Exciting new folder mapping options with SharePoint Connector and Business Central
มุมมอง 6545 หลายเดือนก่อน
Exciting new folder mapping options with SharePoint Connector and Business Central
What's coming in Business Central 2024 wave 2, aka BC25
มุมมอง 4K5 หลายเดือนก่อน
What's coming in Business Central 2024 wave 2, aka BC25
A shortcut to better UX with shortcut key in AL and Business Central
มุมมอง 1.1K5 หลายเดือนก่อน
A shortcut to better UX with shortcut key in AL and Business Central
Happy New Year Erik..
Happy New Year Erik, I always enjoy watching your videos and learning from them.
Hi Erik, Is it possible to bring directly the scan button on mobile app role center page, because i have a requirement in which the user directly need to hit the scan button from the rolecenter and after scanning the information based on that info it should create a sales order.
Dear Eric, We have business central cloud, and there are some extensions published, in the app.json the resource policies are applied, we are not able to see the AL custimizations in codeunits, tables...., even if we add a variable and go to definition, nothing appear Is there any way to get the extensions source codes? Regards, Nav
In the cloud not that easy. You can contact the vendor and ask them to provide the source code or allow to view it for debugging. OnPremise you can "hack" the access, Erik has a video how to do that on his youtube channel
@matthiasra1806 thank you
If we use namespaces, it should not be necessary to use prefix / suffix on object names. If i want to publish my app to Microsoft appsource, will Microsoft still require the prefix / suffix, even if I have applied namespaces?
Not anymore, still required for things on extension objects.
Thank you, Erik, for the great work you do in promoting software development! As you point out, the most important thing is to keep learning, keep dreaming, and enjoy the journey. Congratulations on such inspiring content!
Good one NB You can not convert quote to invoice but you can convert order to invoice
I was unable to find any BYTE article about LUA. I think you might have read the very DrDobbs 1996 article with a link for downloading the ANSI C source code. In that case you were one of the first LUA users worldwide :-) I admire the GUI of Financials. It is difficult to replicate all the details because Navision Software made the user controls themselves.
Dude, you're right, it was Dr Dobbs :)
Thanks for all your insightful videos this year. Happy Christmas 🎄
Nice app! Det ser da forholdsvis overskueligt ud. Du vil blive overrasket over hvor mange virksomheder der stadig kører C5 her 20 år senere 😂
Awesome app, Erik! 🎉💻 Wishing you a very Merry Christmas 🎄✨. May God bless you and your family 🙏🎁. Thanks again for your amazing work! 👏👨💻🔥
Wish you and your family Merry Christmas and Happy New Year .
Hi Erik, this crazy VAT stuff is needed in Europe. Really nice better NAV;)
No, you don't need to be able to organize your VAT accounts (in the chart of accounts) in a structure that not a subset of your sales/purchase accounting setup :) At least, I have never seen a single customer (and I spend 25 years doing NAV in Europe) with that need.
Hi Erik- thanks for sharing! What is the official opinion of flowfields based on flowfields? Count of special order PO’s. =Count(purchase Header where (doc type = order, special order exists = true)); special order exists is a flow field on purchase header. Exists(purchase line where (document no = field(No.), special order = true)). It works, but I get lots of frowns from people when I tell them I do this…
Very helpful! Thank you so much for the effort!
hi sir, do you have experience for direct print ZPL format to ZPL printer in BC (Online) ?
What about using the Excel Export function? Are flowfiields exported as well?
This video gave me anther great idea which I dev'ed last night for a member of staff and regards cust invoices COUNT, showed them and yep, helps em out in Finance drastically. Thanks again bud!
Hi Erik, I just noticed that changing the Caption of existing pages is not working on Version 25. Any inputs or articles on modifying extensions to be compatible with Version 25 available.
How we can define flowfield on the basis of ENUM field? i.e. FieldClass = FlowField; CalcFormula = exist("Comment Line" where("Table Name" = const(Database::"XYZ"), "No." = field(Code))); As, it shows warning message: An implicit conversion is being performed from a value of type 'Integer' to a value of type 'Enum Microsoft.Foundation.Comment."Comment Line Table Name"'. This conversion can lead to unexpected runtime issues. Is there a way of doing this? Its not working.
you need to define enum value, not table number: CalcFormula = exist("Comment Line" where("Table Name" = const("Comment Line Table Name"::Item)));
@@ProfMaravic thanks for helping, I have tried your suggested way, but results are still not as they should needs to be. As, There are lines available in Commet Line tabe with above filters (in calc formula); But on page where I have use this FlowFleld it shows me "No" - (there is no such comment line) instead of "Yes" - (there is/are such comment lines/lines)
Great video. Which is your latest video on setting up your own sandbox and a demo of Business Central so I can do some dev in Visual Studio to test? Many thanks for all your great videos this year so far.. I've enjoyed all of them.
Thanks EH
Thanks EH
Hi Erik. Is there a way we can use the query to update a record in another table? So after opening the query and we select a record, can we use that record to update another table?
No queries are really read-only.
@@Hougaard Alright
great example thank you
thanks
May I ask for some advice from you about BC, I'm researching ERP for my company.
@trungnguyenquang6032 sure, send an email to support@Hougaard.com
God that seems simple. Great video, can you use a similar function on the posting of Item Reclassification Journals? I cannot figure out of there is a standard flag that changes that in business central. The GL-entries often is called something along the line of "Direct Cost", which doesnt give me much info.
Thanks for the video, btw at 8:53 you could use the Quick Fix "implement interface"
Very helpful video, however, can you create more complex APIs from different joined tables and group values similar like you can do in SQL views?
I tried this and got different results. Checked Feature Management and had to enable for all users- or enable in each search. Specifically, when searching from the No. field on the sales line, the search pop-up has a gear icon in the bottom where you can switch search engines.
There is difference in record count, so one has to loop more records.
&&hoff*&&&erik* actually makes sense if the new "&&" operator means "at the beginning of a new word ..." makes search a little more regex 🤣
I've got a few custom fields. Let's say it's "Wife's Name" in the customer table. I have been unable to add OptimizeForTextSearch to that (or multiple) fields in AL - if I try, it gives an error (with not many details). Does it work for you? (You might need to use your text generstor to fill the field with searchable data of course).
Same here
I cannot wrap my mind around the &&. It’s like the universe is saying, 'Here, have some logic, but only if you really deserve it. Can someone explain what kind of wizardry makes &&keyword spit out its results and what is the meaning? Is it ANDing my soul with confusion?
Yes please! What does the “&&” do? I searched online but couldn’t find an answer. Thanks
is only on my maschine the video and the audio async?
No, new stuff is ordered...
Eric, is it better to use these API queries instead of the web services? Please comment as to why or why not. Thx much.
Web services are slower and are not static...
@@Hougaard Thanks Eric!
Sorry for misspelling your name, Erik
Awesome video Erik. This is very useful and helpful.
Great video, are these the same API queries that can be consumed as a datasource (semantic model) in Power BI?
Yes
Never mind, I should have waited to watch the full video, it answers my question in last 30 seconds of video :)
Thank you Sir Hougaard!
Nice one. Should we start calling you Perseus from now on?
What would happen, if the referenced objects does not exist (because the app is not installed)? Is there any way to check this, before executing the code or, better, set the action to visible=false?
Yeah, decided to leave that part out, it's quite simple, just check AllObj for records in the app you want to check for's number range.
Hi, thank you for that Video, what type of addon ist the replace Word addon? Like Replace Medusa with RDI?
That's just builtin F2 rename.
And here I thought you where dealing with the service module, and the medical industry! :D P.s, tale synk er lort.
Bedre udstyr er bestilt
Hi Eric Can you please make a video on CI/CD using azure DevOps Pipeline on saas environment. I looked for it but did not get it specially for saas version.
Wat??? Why don't you just create publisher? If sharepoint uploader is installed then it can subscribe and handle. If not installed, then just well, nothing happens. Why make THIS?
You can only subscribe if you have a dependency to the app that publishes the event.
this is what was i looking for... i enjoy watching your video..
actually, codeunits could pass themselves around for a long time, but not without external initialization.. cool new stuff
How to change the invoice discount caption in sales invoice report
I have always the same problem with stream direction :D
Erik what would happened if there is no codeunit(749***) or table id 749**? a run time crash? thanks
At Directions EMEA I had a chat about "conditional dependencies". In my case I do have localized version of my app, due to the fact, that MS is publishing different code with the same AppId for various countries. If I now want to offer an addon to those localized apps, I do have to create multiple apps with different dependencies, depending on the localization. In general It could be solved with an Connector/ Bidge extension, but this wil cause a lot of addition effort just to maintain the AppSource offerings. So conditional dependency resolve is something I would like to see in future. Maybe there could be something like "If an app A is installed, also define a dependency to app B." App B is a library extension, that acts a a bride extension. Just somthing that came to my mind right now. One thing I don't like about your solution is that there are no warnings for discontinuations/obsoletions or type mismatches. So the user might run into runtime errors.