You’re offline. This is a read only version of the page.
511
Hi all,
Happy new year :)
I am working on an upgrade project from NAV 2009 to NAV 2016 and I would like to automate some manual tasks. The customer is updating Access DB with invoices and credit notes from Navision, and that happens manually.
The report generates an xls file so the user can copy into Access. The user also needs to make sure the layout is the same as the Access DB table before paste.
When the window for parameters pops up, the user clicks on the sort button in the bottom right-hand corner to make sure it’s set to entry number.
What's the best way to automate this task based on your experience?
Thanks!
*This post is locked for comments
Thanks Jonathan
Thanks Suresh
Thanks Amol
You can schedule job using job queue to generate excel file from Navision and then user can copy in Access DB.
Chris,
Are you referring of creation of excel file from NAV or the whole process of creating the excel file and then copying into Access DB ?
In NAV you can automate all your tasks using job queue. You can create an excel file using a report or code and then by using OleDB or ADO connection you can connect to the Access DB and Import the file or even without creating an excel file you can directly insert the data into the access database.
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...
290,867
Super User 2024 Season 2
#2
Martin Dráb
229,173
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (