Hello,
I have a problem to import the delivery time from Navision to Excel.
Our delivery time exist of two numbers and two letters (15WD), it seem like excel doesn’t recognize this kind of set-up.
Is there someone that had the same problem and knows the solution for this?
Thanks in advance.
Date
Votes
6 comments
-
Jet Reports Historic Posts Can you explain in a little more detail what you mean by 'excel doesn't recognise this kind of setup'? Are you using the 15WD as a filter?
I presume you're using Jet to extract from Navision? -
Jet Reports Historic Posts We have different delivery times for different items. The information I want to extract from Navision (version 3.10.A) is positioned in field, Stock Keeping Unit (SKU). This information contains number and text, as in my example (15WD). This means that the delivery time is 15 Working Days. When I make a link from Nav. to Excel thru JetReport, everything is going good until the cell with the delivery time is coming up. In Excel nothing is showed in the cell with the delivery time. I tried to change the cell format in Excel but this didn`t work, I`m out of options so I hope you or somebody else can help me with it!
-
Jet Reports Historic Posts Goeiemorgen Piet,
What version of Jet are you using? If you download and install version 7.1.2 build 1820 your report should be fine. I've seen this in a previous version of Jet - it was a bug that's been solved in the latest release. -
Jet Reports Historic Posts Hi Hans,
How are you going? A few months ago I was sitting in one of your classrooms.
The version I work with is, 4.0.7 Build 1528. It is an older version of JetReport, I know. Is there a other possibility to work around it?
Hope to hear from you soon. -
Jet Reports Historic Posts Version 4…. hmmmm… I really have no idea if the bug was ever fixed for that version. You could ask the Jet Reports support guys - my suggestion would be to post a ticket via support.jetreports.com
But if I were you you, I would upgrade to version 7. You will benefit from new features in and performance of Jet Reports.
Groetjes en fijne Kerstdagen! -
Jet Reports Historic Posts Hans,
Tanx for your answer!
I`m going to mobilize the guys from IT to upgrade the JetReport to the newest version.
Same to you, fijne kerstdagen en een goed uiteinde!
Grtjes Piet
Please sign in to leave a comment.