Hi,
every time, a user submits a new purchase order in navision we want to calculate a Excel worksheet and print it out, without any user interaction.
How it is possible to trigger Excel to calulate and print out this report every time, a new order is submitted?
Would be glad for any suggestions
Kind Regards,
Christian
Date
Votes
2 comments
-
Jet Reports Historic Posts How does the "Submit" work in your system?
Does the user push a button? Do you use the "Release" function?
If yes you can put the code behind the button or in the function.
If not its quite complicated to run a code as you never know whether the order is finished or not.
How it could work is described here http://kb.jetreports.com/article/AA-00486
Cheers
André -
Jet Reports Historic Posts Hi André,
thanks for the answer!
The solution I am searching for should not be started by the user in navision - otherwise every user needs excel and a licence of jetreports.
I try to find a solution in excel. Excel should look weather there is a new order (no matter which navision user) and then start the report an print it out.
My first idea was, to start Excel every minute via the sceduler to run the report which print out all orders, which are generated in navision in the last minute - if there are some. The problem is, that in the header of the order in navision, there is only the date, but not the time of the generation of the order.
The second method could be, to store the code of already printed orders and only generate a report for the new ones. But how can
I store the codes of the already printed orders?
Cheers
Christian
Please sign in to leave a comment.