I am working on a BC Premises.
I need to automate upload of excel files to general journal lines without posting them from a folder which is on the same server as BC.
The process should be unassisted, I mean, we do not expect any person to execute the tasks or initiate the upload.
How would you do this?
I would recommend you put them on a Azure blob storage instead of putting them on a local server.
It is easier to automate the process within Business Central if you put your files on an azure blob storage.
Here are some sample codes that reads a CSV file from a azure blob storage and imports it as General journal lines in BC.
The same method can be used for Excel files using the Excel buffer instead of the CSV buffer that I am using in this code.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156