Share
ReportHi Experts,
We want to import General journals using excel through code in D365FO.
Please share your information.
Thanks & Regards
Rahul
Categories:
You’re offline. This is a read only version of the page.
630
Hi Experts,
We want to import General journals using excel through code in D365FO.
Please share your information.
Thanks & Regards
Rahul
I agree with what is suggested above , instead of using custom code you should use data management . Here is another blog post from me which shows , how you can utilize data management workspace to import General journal from Journal screen . Its very minimal code just to open data management workspace with your pre configured data project and rest is standard data management . You can utilize any format you want , for example csv , excel , data package etc.. Some of the code is to modify data management workspace , you can do that using security as well.
Hello Rahul.p.,
I agree with Nikolaos that this can be achieved with the standard tools in Dynamics and the powerplatform.
Making a system modification is not needed for that.
Best regards,
Ludwig
I really suggest you go with the existing standard feature which you can use without any additional cost.
But if you want to develop your own button, Sukrut has written a blog about how to add a button that reads CSV file: community.dynamics.com/.../d365fo-use-of-fileupload-control-to-read-csv-file
If you want to upload Excel instead of CSV, you will find plenty of information on how to handle Excel files in x++ by searching the web.
If you mean that you want your users to be able to import when they are on the General journals form, you can just use the "Open lines in Excel" button that you already see on that form. You can use it to import data.
Could you perhaps share more details about your business requirement, if I did not manage to answer your question.
Import from where? You can use data management projects and data entities to set up an endpoint in D365FO. Then you can send excel files to that endpoint from any source by using LogicApps, Flow, Recurring integration scheduler, Biztalk or similar.
This is the simplest way and doesn't require any coding.
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
