Erik Hougaard

Erik Hougaard

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 KZread, 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.

Пікірлер

  • @chriswatson2407
    @chriswatson2407Күн бұрын

    If you right click the AL Extension in the Extension part of vscode there is an option to 'Install Another Version..'. I haven't tried it but I assume that this makes it easier to switch.

  • @4s6ryd
    @4s6ryd2 күн бұрын

    Wow, Erik! That was an hour well spent! As always, your videos are incredibly informative. I particularly liked the way you coded everything - we might just have to experiment with that in our future tests for page field orders. Thanks!

  • @kasimnaqvi4789
    @kasimnaqvi47893 күн бұрын

    Hi Erik How to apply "And" operate in setfilter ? Eg : I'm doing like this Rec.setfilter(tripno, dnl.tripno::1); Rec.setfilter(tripno, dnl.tripno::2); I need to do multiple filter based on condition How can we use "and" operater in setfilter like you did for "or" operater

  • @navnav3134
    @navnav31343 күн бұрын

    Dear Eric, if i have an RDLC report, Is there any way from report layout selection to export the RDLC layout as word Layout? we tried it and we get the report .docx but empty, can be filled same RDLC layout includes fields from report data items? Regards, Nav

  • @gagelink7620
    @gagelink76203 күн бұрын

    Thank you! I was having an issue with non-ascii characters making generated emails fail, and didnt just want to implement a catch-1 check. This is exactly what i needed!

  • @335LINZ
    @335LINZ3 күн бұрын

    Hey Erik I just got the, "What have you done for us in QA lately?", spiel yesterday, excellent timing! 😀

  • @independentnavbcdeveloper3342
    @independentnavbcdeveloper33424 күн бұрын

    i YELLED! LOL next time do it in live stream so we can collaborate? :)

  • @akzil2420
    @akzil24205 күн бұрын

    Hello from Calgary! thank you for your content, if you don't mind could you help me with my situation: I've been a developer working with 1C:Enterprise (very common system in post Soviet union countries), I am interested in showcasing my skills and demonstrating my adaptability. Could you suggest what aspects or projects would make a good showcase for a developer like me transitioning into MS Dynamics 365 Business Central? thank you in advance!

  • @Hougaard
    @Hougaard4 күн бұрын

    Success in the Business Central comes from an deep understanding of the fundamentals, learn what it takes to customize the sales posting routine...

  • @ant1d0te
    @ant1d0te5 күн бұрын

    there is field Sequence in the PageFields (0-based)

  • @71moinmoin
    @71moinmoin5 күн бұрын

    This is amazing! Not just the concrete possibilities, but your relaxed coding style and your genuine smile at the end. Thank you Erik!

  • @Hougaard
    @Hougaard5 күн бұрын

    Glad you enjoyed it!

  • @user-uk2dk3jq7k
    @user-uk2dk3jq7k6 күн бұрын

    Please Make Video to authenticate JWT token.

  • @Noctornal
    @Noctornal6 күн бұрын

    Thank you very much for this video. I got the implementation of Business Charts assigned as my qualification's final project and the lack of documentation really threw me off. After a little digging, I believe the bubble chart type is not even considered in the underlying .js file, so it's not like you had any chance except breaking it with that option. Did you ever figure out what the second parameter is used for?

  • @Hougaard
    @Hougaard4 күн бұрын

    Nope

  • @NeilJavier-zu9dn
    @NeilJavier-zu9dn7 күн бұрын

    i know this is a bit of an old video but I was hoping to hear more about what the virtual table IS. You mentioned in the beginning that we have these native tables that 'exist' like Customers and what now. Then, went on to create a table but I didnt hear you explain the difference between what you created and what already exists. What would the use case be for a virtual table in the power platform?

  • @Hougaard
    @Hougaard4 күн бұрын

    These virtual tables are NOT the power platform virtual tables...

  • @CezaryMroczkowski
    @CezaryMroczkowski8 күн бұрын

    +1 for Field Service Integration

  • @tedcjohnston
    @tedcjohnston9 күн бұрын

    Once again, a great video, short and too the point which solved my immediate question! Thanks Erik.

  • @navnav3134
    @navnav313410 күн бұрын

    Dear @eric, we have Github repository, and we need to publish it for many versions of BC, we don't need to create a repository for each version, since only the runtime, and platform in app.json will be changed in each version. so, is there any way to skip all common files in same repository, and switch between versions to add more customizations? Regards, Nav

  • @Hougaard
    @Hougaard10 күн бұрын

    Branches?

  • @YannSaintLaurent
    @YannSaintLaurent11 күн бұрын

    I should show you the one I built to create email accounts in BC…

  • @gonzaloriosley2
    @gonzaloriosley212 күн бұрын

    I thought you were going to build your own Chrome extension

  • @Hougaard
    @Hougaard11 күн бұрын

    Maybe next time, what should I build?

  • @YannSaintLaurent
    @YannSaintLaurent11 күн бұрын

    Here is one for you… color code pages… change the vendor related pages to yellow, the customers, red…etc!

  • @gonzaloriosley2
    @gonzaloriosley211 күн бұрын

    @@Hougaard For me it is clear. We need a left menu like in D365. And it needs to be adjustable by the user :)

  • @mauriciovillatoro9361
    @mauriciovillatoro936112 күн бұрын

    I always wonder, why that is not a Page Property or a View Property.

  • @FrancescoLanza
    @FrancescoLanza12 күн бұрын

    I think it would be great if they allowed to build html layouts. Why not? both Word and RDL layouts are very painful to manage. Also, BC is pointing to the future, and dealing with RDL looks like stone age.

  • @nemanjavelickovic9062
    @nemanjavelickovic906212 күн бұрын

    A nerve saver extension, I'm in! Very nice video, thank you!

  • @khoivu8172
    @khoivu817212 күн бұрын

    tks a lot

  • @derhustlerderhustler2589
    @derhustlerderhustler258914 күн бұрын

    It would be very nice if you could put the Link to the Website somewhere where the watchers of the video could access it very easy. Finding the right version is quite Difficult. What did you use as USER ID?

  • @Hougaard
    @Hougaard10 күн бұрын

    Ohh.. some of the old videos doesn't have the github link: github.com/hougaard/KZread-Video-Sources

  • @mattymattffs
    @mattymattffs15 күн бұрын

    This tool is no bueno. AL XML Documentation was much easier to use, use it right in vs code, create docs only for the one codeunit I care about. MS really went out an overcomplicated this for no reason.

  • @Hougaard
    @Hougaard12 күн бұрын

    It's the tool they built for themselves. I think this needs to be part of a pipeline, it's already build into AL-Go now.

  • @gilbertronoh5929
    @gilbertronoh592915 күн бұрын

    Hi, I hope you are doing good, could you please make a video of Alternating row colors in Business Central Reports, Kindly.

  • @Hougaard
    @Hougaard11 күн бұрын

    Isn't that just a table style in Word?

  • @18ggvk
    @18ggvk15 күн бұрын

    tanks, this is great . This amazing . The best video

  • @streichersit
    @streichersit16 күн бұрын

    3 years on and still solving problems! I just used this technique to import some data that required special processing.

  • @crisvdwijst
    @crisvdwijst16 күн бұрын

    Hi Erik , thanks again fot this video , can you do a video about singing an APP with a code with hardware token? Or do you know if there is a good checklist for it.. (it's a mystery to me)

  • @Hougaard
    @Hougaard15 күн бұрын

    Check this: katson.com/code-signing-in-2024/

  • @crisvdwijst
    @crisvdwijst15 күн бұрын

    @@Hougaard Thanks Erik , Azure Vault seems to be the new standard I suppose..

  • @Tsiqara13
    @Tsiqara1316 күн бұрын

    I remember on Pages and also Reports in BC16 and probably BC17 as well, [InDataset] was required to make things work, otherwise fields would not Dynamically disappear and etc. Probably it has been already updated on BC18+ Versions and currently it's being depreciated. So If someone is still on BC14 .. BC17 I would still use those.

  • @LarsLohndorf-Larsen
    @LarsLohndorf-Larsen17 күн бұрын

    Every time before I code something that I haven't coded before, I ALWAYS check your channel first on how to do it. And I am NEVER disappointed. Thanks for another great explainer!

  • @GeekUpdates
    @GeekUpdates17 күн бұрын

    no code?

  • @Hougaard
    @Hougaard15 күн бұрын

    It's there (On github)

  • @GeekUpdates
    @GeekUpdates8 күн бұрын

    ​@@Hougaard how to use jwt token in BC?

  • @TidusConsult
    @TidusConsult18 күн бұрын

    Thank you so much for theses videos. They are very helpful.

  • @weinicht1953
    @weinicht195318 күн бұрын

    Hi Erik. How about a video of the use of the page triggers 'OnFindRecord' and 'OnNextRecord' (e.g. on the Item List). Thanks :)

  • @nemanjavelickovic9062
    @nemanjavelickovic906218 күн бұрын

    Infinity loop so smooth that it doesn't have time to report it (6:33)

  • @reneasmussen358
    @reneasmussen35818 күн бұрын

    Great 😄 I do use Rec when I work on temporary records. Often you can fix the "weird" behavior by remembering your current state, manipulation on whatever you want, and then make a get to return to your state as it was before execution.

  • @Pharrious82
    @Pharrious8219 күн бұрын

    Funny how the 'Date Filter' only shows when you select multiple records :) Another place where Rec is often being messed with, is the posting rutines OnRun SalesHeader := Rec; // Silly global variabel Code(); Rec := SalesHeader; // Overwrites Rec with whatever changes happened to SalesHeader during the posting

  • @angelmedina8340
    @angelmedina834019 күн бұрын

    Hi there, this help me a lot, i do this 3 montbs ago and it wprks BUT now it is crashing, it opens and add the body correctly but if i want to change the sender,m or add a receivers even if i go back it crash and only shows "working on it" any idea of how fix it?

  • @angelmedina8340
    @angelmedina834019 күн бұрын

    I find that the issue occurs when I set "true" on the email message method but I need to convert the word template :(

  • @angelmedina8340
    @angelmedina834019 күн бұрын

    Update, after the weekend on Monday morning it works! I didn't make any changes

  • @Hougaard
    @Hougaard19 күн бұрын

    I believe Microsoft had a html editor issue

  • @cuperativa
    @cuperativa22 күн бұрын

    Hey Erik thank you for explaining the altool. Do you known why the WebDeploy.exe is no more there and which tool is used instead?

  • @Hougaard
    @Hougaard15 күн бұрын

    no

  • @lkilper75
    @lkilper7522 күн бұрын

    Funny that Microsoft is depending on Newtonsoft.JSON although there is System.Text.Json :)

  • @nemanjavelickovic9062
    @nemanjavelickovic906222 күн бұрын

    Thanks for the nice video, I really liked the poetry of dictionaries.

  • @484sd
    @484sd23 күн бұрын

    Hey Eric, we are currently consideriung if this tool can help us in our pipelines. I guess it will. Instead of spinning up a container you can now just download BC artifacts, un-package the visx and use the altool to build up a dependency tree from an app or runtime file. GetLatestSupportedRuntimeVersion gets handy if you have scripts that updates the application and runtime in you app.json. Runtime can be now updated based on the application version. CreateSymbolPackage might be become usefull if someone creates a repository/service for symbols to download symbols from this service instead from a BC environment.

  • @HazardNY
    @HazardNY23 күн бұрын

    Hey Erik, great content as always! One thing - sometimes video has a slight delay from audio, any way to fix that for future videos?

  • @Hougaard
    @Hougaard22 күн бұрын

    Working on it!

  • @lukaszjessa8650
    @lukaszjessa865024 күн бұрын

    [EN] Thanks Eric! Once again great video. [PL] Dzięki bardzo Andrzej! AZ tool robi mega robotę!

  • @tristancliffe
    @tristancliffe25 күн бұрын

    Any news on the field guide (for v24), or are you no longer updating that book?

  • @Hougaard
    @Hougaard25 күн бұрын

    Working on it, should be updated "soon" :)

  • @waltergodoy2755
    @waltergodoy275525 күн бұрын

    Greetings sir, i need help with a topic, how to backup and restore database based in Business Central Online, all the info i found its on-premise

  • @Hougaard
    @Hougaard8 күн бұрын

    Backups are done automatically in the cloud, and you restore from the Admin Center.

  • @peterbuchanan8546
    @peterbuchanan854625 күн бұрын

    Could you please provide the code? I could not find it in the Git repository. This is exactly what I need to integrate BC 365 with RS232 scales.

  • @Hougaard
    @Hougaard25 күн бұрын

    Sorry, this is not an open source project, code is not available

  • @mohammadnouritani
    @mohammadnouritani26 күн бұрын

    you can install vscode per comupter not per user that would change the location make it permenent per computer if that helps

  • @Hougaard
    @Hougaard25 күн бұрын

    ... no, the main issue is that it's installed in a folder that named using the version number of the extension.

  • @mohammadnouritani
    @mohammadnouritani26 күн бұрын

    suggestion put a polarizer filter on the camera so we don't see reflection on your eyeglasses and book and screen

  • @Hougaard
    @Hougaard25 күн бұрын

    Yeah, the lighting situation in the new office is a bit more complicated that the old place.

  • @mdallauddin-ks9lf
    @mdallauddin-ks9lf26 күн бұрын

    Erik sir, I'm from India please make a playlist for beginners ❤❤❤

  • @Hougaard
    @Hougaard25 күн бұрын

    kzread.info/head/PLnldREWlGR0vmyMwB5lmqWjK9KBMwn05s

  • @andredevantier6878
    @andredevantier687826 күн бұрын

    Hey Erik! Im working on a project and im in a "sticky" situation - therefor a request for a new vid. Red Asterisk on pagefields dynamicly - is this even possible? I've been thinking about it for a long time, and the only solution i see, is to modify every field on a page with a unique variable, and set this variable based on some code in the "onOpenPage" or "onAfterGetRecord" - But this seems like soooo much extending, for the sole purpose of setting "showmandatory" on fields :D

  • @Hougaard
    @Hougaard11 күн бұрын

    No great way of doing this...