I have never seen Business Central integrate with Excel like this!

[@Peter-Jones]

Hi Erik, we do not have a use for this ourselves but this does show that there seems to be no end to how Excel can be used.

[@brendanryan5631]

I don't know any AL code either BUT know VBA and have written VBA code to send an HTTP request to the web service to pull down data. It gets tripped up a bit on the auth side so i've moved away from that and instead send BC data to a SQL database and query that via VBA to pull into excel (specifically a trial balance to build financials off of). That being said, what WOULD be a neat example would be to pull trial balance data down to excel using this. Something like "=Table(Fiscal Year, Fiscal Month, GL Account, Dimension 1, Dim 2, Dim 3, etc). For example: =GL(2024,6,7101,Canada,Marketing) --> would pull down 2024 June Travel Expenses for Canada location (dimension 1) Marketing department (dimension 2). --> GL would be the table in BC to query against. There would need to be some mapping/aggregation logic built into the add in/AL code, or a separate pre-aggregated table. there is a lot of capability here. learning AL prob the first step

[@irinafetica8111]

Haven't tried it yet, but just curious, if you have a workflow or subscriber or any other code on Onvalidate trigger of Credit limit, on updating does it also run the workflow/subscriber/onvalidate code?

[@irinafetica8111]

Or maybe just the onmodify trigger of customer table as configuration package or edit in excel does

[@RebeccaBejjani]

please can you make a tutorial video about sharing files with One Drive using Business Central Saas through code.

[@joergrau5689]

I love that idea and can see why you had fun building it. I think this has legs. For reporting and data migration. Let’s see if Microsoft accepts the challenge 😊

[@newbnet]

Erik, I am thinking about how this would help users at different levels. For the I.T. Department, I would use Excel to bulk update item cards (list). An SQL-T query can do the same, but Excel works best for a low-knowledge-level I.T. staff. Example: • Update the price list (retail price) from an external document or scan the PDF into OCR to power-automate the updating of thousands of cards. I want a similar solution for PowerApps. Have you thought about doing a PowerApps canvas app to work with B.C. in the future? Your videos are great, and I think you have a lot of passion and knowledge.

[@HazardNY]

How do you use SQL query on BC SaaS?

[@weinicht1953]

How do you execute AL-Code remotely? Is there some lesser known object that can be used for that? It doesnt seem that obvious…

[@Hougaard]

I use my own app: www.hougaard.com/toolbox

[@weinicht1953]

I noticed, thanks :) But how can the Code be interpreted? What object do you use if any?

[@pungggi]

@@weinicht1953 I think this is the "secret sauce"

[@mohammadnouritani]

His on application he has an application that right a language looks like AL that read that text and execute it

[@weinicht1953]

I figured it out (without using his app). Did everything myself :)

[@damienvince]

I would use this, depending on how extensive it is. Right now, using Simple Object Designer, I'm exposing tables as API, so that I can build reports in Excel for our users to supply to customers. I could see this replacing that if I can just build the code to pull the data from a table rather than a report or API. Great looking demo though

[@NickyLi]

From my understanding, if we want to use it and share the file to production, we would need to limit the ability to modify the code. If we can figure out the security problem, I can see we can combine it with existed excel file, like comparing credit limit before we send out the agreement, or listing different things that needs to be dealt with and create a formula as a button for user to run a batch job after they reviewed those content. Another concern is if we share the file for many production users, would it cause any performance issues to the BC web services?

[@Hougaard]

Plenty of security issues... performance issues ... perhaps...

[@npu3paka2]

In my opinion, most people who work with data in Excel to perform tasks in Business Central (BC) lack the knowledge of how to use AL. For instance, if I know nothing about AL but am proficient with Excel and eager to learn AL to integrate my Excel sheets, I would prefer using Visual Studio Code to carry out my tasks.