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?

great example thank you

thanks

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

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?

is only on my maschine the video and the audio async?

Eric, is it better to use these API queries instead of the web services? Please comment as to why or why not. Thx much.

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?

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?

Hi, thank you for that Video, what type of addon ist the replace Word addon? Like Replace Medusa with RDI?

And here I thought you where dealing with the service module, and the medical industry! :D P.s, tale synk er lort.

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?

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.