วีดีโอ

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?

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

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.

You could extend further by only permitting your example code to run if the dependant app is installed though I haven't got any 'app detection' code to show you.

I have a powerapps managed solution but how to add that in visual studio how to do setups .. please help me

The sound in this video does not seem to be synchronous with the pictures. Do you also get this behavior?

Can we not create a custom connector app to bridge the 2 apps (Sharepoint App and the app you are trying to connect with SharePoint)? The custom connector app will have 2 dependencies and none on our Original App.

I have done this a few times, but always feel like I am cheating :)

How do you debug an AL page which gets triggered by an HTTP request, where there is no UI?

very cool!

Erik, what can one do if one is still on like NAV2016 but wants to build things in a future-oriented way, to make it easy to move to BC? My guess would be to use variables of the DotNet type HTTPClient etc.

Hello Erik, it is still possible to use SELECTLATESTVERSION. If you do so, than you have access to a record BEFORE the end of a transaction. Let me explain. You INSERT a record, call STARTSESSION with the insterted record and SLEEP 10 seconds to delay the end of the transaction. The background session codeunit usually only has access to the record after the end of the transaction in the caller codeunit, i.e. 10 seconds. Unless you use SELECLATESTVERSION in the codeunit of the background session! But I can definitely not recommend using it in this case. Because if you fire an ERROR after the 10 second sleep time then you might got a problem, because you work in the background session with a record wich will be rolled back. (Tested with Dynamics NAV 2016). I prefer to use a small loop that tries to get the record every 1 second, but gives up after 30 seconds. Especially when subscribing to a trigger like OnAfterPost where we don't know whats running after our code and when the transaction ends. An example of the use of SELECTLATESTVERSION is in my opinion to access records which are added to the SQL database without the knowledge of the NAV Servicetier. e.g. through an sql import service. Thanks for your videos. I always enjoy watching them.

Hi @Erik can you help me How to Export data from business central cloud using Excel Buffer table.

I use this a lot for API connections to 3rd parties.

It would be nice if there was an easy way to wait until a started session is completed. Like .NET "Thread.Join()" -> "JoinSession(SessionId)"

Thank you for that nice video! I have two questions: Can I also implement in my sales doc the Tariff number and the origin of country? Second question: I want to add the position number in my sales docs like: 1, 2, 3 and not like the line numbers 10000, 20000, etc.

When should I use Task Scheduler with JobQueue and when Startsession for Intercompany Jobs to validate? I heard about that Startsession would need more Server Ressources, true?

Where is the scalability per user defined?

How did you implement the clearing of all selections with one click?

i cant find source code for this in git

Dear Professor I have a subscription to Microsoft Business Dynamics Is it possible to connect to the database via SSMS I want to specify the data in the table directly Item Ledger Entry Since this table contains tens of millions of records and I want to review the inventory according to special queries Without using the AL language How can I get my contact information in SSMS I am in Saudi Arabia and I took the program through a local intermediary company. Is the SSMS data With the intermediary company or can I get it directly by contacting the parent company directly select * from [Item Ledger Entry] where ....!!!!

tack! new in business central but your videos really help! ALM videos would be a great addition, setting up repos, deployments, source control, how is that done in BC?

Tasks for the great video. What I miss in AL is selecting a symbol element limited by double quotes by doble clicking on it, what we could do in the modern C/SIDE. Ex.: Double click on "Customer Card". Do you know a way to get this back in AL?

Is there a way to disable the OK button until, for example, a field is filled in?

Very nice! BC would be a much stronger product if Microsoft made an out-of-the-box portal solution like this. There is a lot more demand in the B2B market to provide self-service portals for customers and vendors.

This helped me a great deal, thank you Mr. Hougaard! I'm quite new to BC Programming and AL as a language, but so far the videos I've watched from you were always really helpful. You really take time to explain stuff that's specific to AL and BC and give good examples for them.

I think you still need these packages installed in some environment for testing your code, don't you? :) But for al-go and similar pipelines - definitely great way to keep apps elsewhere instead of downloading manually and spreading over your build agents

Hi Erik, If I understand correctly this portal does not have its own database? Your example with sales order update, you updated actual sales order directly in BC? Thank you.

Hi Erik, How are those customer interactions considered regarding bc licensing? Is it abailable for onprem and saas as well?Kind regards, Chris

Can you use putdata to modify records already there. IE I want to add the Shelf No. and ReorderPoint to existing item records.

Should probably ask your partner first. My guess is most partners have a few layers of support a request needs to penetrate before getting to a programmer who would understand what to do with a profiler file.

Hi Erik Would it be possible to use the same portal front end hooked up to multiple separate business central backends. Depending on the user account it knows which BC instance to connect too?

Thank you for talking about how the AL development environment loses its mind if you switch branches. That always drives me crazy, and could certainly be improved.

WUF! Door slams. Love it :D Thanks Erik - didn't know this .exists

Cool

keeping begin end is beneficial. OTBS makes it easier to edit code and not break into the wrong scope. See new developers make that mistake consistently. Instead begin and end should be enforced.

Nice workaround! Thank you!

Hi Erik, thank you for your content. Can you make a video (or give your opinion) about your perspective on what BC Developers will face in 5,10,20 years? I see more and more customers avoiding customizations, less effort for deploying the latest version, standard capabilities being extended and in addition to that, the amount of bc developers on the market is rising. Long story short: Do you think we will face the situation that there are too many developers for the work that needs to be done?

Great vid EH! On-boarding new Users is a fairly disparate exercise and this provides a checklist of sorts and also simplifies access across the system with a single click. Automatically setting some localisation defaults would be a great addition too. Thanks again :)

SalesPerson could have this relation

You would also like to add property Width=1; for each column so they are not so wide :) aha, I wrote before ending :)

It's excellent, I was seeing how all the user tables were used as I wanted to add a field, but I had no idea how it worked, thank you very much for the time. But I have a doubt, as you put the icons in the texts, that's surprising

Hi Eric, I cannot find this Session in Github, what is my mistake? br Chris

Great video! People don't often realise that BC is Unicode so we can use all sorts of Unicode characters to make some thing visually more interesting! Also Erik, I've noticed that you are not using Copilot/Cursor/AI help for coding! Is this intentional? Maybe a video idea for you...I would love to hear your thought on AI coding in general and in terms of BC! Cheers

Congratulations on 10K Subscribers. It is great having a smart people helping others to achieve their goals

Amazing thanks for the update!!!

That is a very helpful Tutorial. Question: I see the Kangaroo file and the Sales invoice. Is it also possible to extract quote (final one in case of changes) and order to SharePoint?