You’re offline. This is a read only version of the page.
1,858
Hi,
Let's say I have 100 journalnums in an Excel file and I want journal entries of these journalnums (specific columns from the 2 above tables) from ledgerjournaltable and ledgerjournaltrans.
What's the best way to implement it? Shall I implement it as a report or form?
How Can I give file input in report dialog box?
*This post is locked for comments
Hi MyGz,
There are so many options for implementing this...
a. Read file and then show data in report
b. Read file and then show data in form
c. read file and use SQL
d. leverage reporting tools etc...
So you have to determine what make sense.. based on what you are trying to do...below make more sense as this allow you to download data and then cross verify in different ways with other systems etc..
a. Read data from a file that will give you all journal names
b. Based on data that you have read, get all the data from LedgerJournalTable and LedgerJournalTrans
c. Write data back to another file
d. Use the exported file to do comparisons etc.
The link below will help you on reading data.
axaptacorner.blogspot.com/.../how-to-read-csv-files-in-ax-2012.html
Once you read data from file above.. then iterate through data in LedgerJournalTable/Trans table and write data to csv file.
community.dynamics.com/.../export-data-to-csv-file
How to load the file..use link below:
www.tech.alirazazaidi.com/file-load-dialog-in-dynamics-ax-2012
These tasks can be accomplished in a single request from user.. user upload file and get prompted to save the file with results.
Hi, Do you want to export and analyze those data or do something else? What is the purpose of doing this? Best regards, Ludwig
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (