Hi all. I did a search and couldn't find any other instances of this particular situation in the forums, so I apologize ahead of time if I missed it.
We have 7 computers running in our department, and all of them have JetEssentials installed and configured for the users. Six of those computers have Windows 7, MS Office, and JetEssentials 2013 32-bit installed on them. The newest one has Windows 7, MS Office, and JetEssentials 2013 64-bit installed. I have a report that we have been using on the 32-bit machines without any problems for at least a year. From an unposted AP Invoice header, it pulls the vendor information with the City, State, and Zip code in the same cell. When we run the report on any of the 32-bit machines, the information comes into the report fine. When we run it on the 64-bit machine, it returns a #VALUE in that cell and throws the error that the "Buy-from State" field is invalid. Is there something different about the 64-bit version that won't let JetFunctions be combined this way?
I've attached a snip of the section of the report in question and its associated formula. Any suggestions as to how to fix it would be greatly appreciated!
Date
Votes
7 comments
-
Jet Reports Historic Posts Hi Brian,
Is Buy-from State a caption possibly? On your 32-bit machines, perhaps you have exported your NAV language module and specified it in the Jet Data Source Settings, but maybe you didn't do this on the 64-bit machine? Jet Essentials only knows the default NAV captions unless you export your NAV language module and point your Jet data source at it, so if you have custom tables/fields with captions and you want to report from those, you would have to do this. Could this be the problem?
Regards,
Hughes -
Jet Reports Historic Posts Hughes,
Thanks for your response. It is very possible that is the problem. I will see if I can point our IT folks in the right direction regarding how that is to happen. I'm not sure they have had to do it before, is that a step that has to be done on each machine, or is it something that is done once on the server?
Thanks again! -
Jet Reports Historic Posts Actually, our Language module folder setting in Data Source Settings is blank on all of our machines, do you think that might be the problem with the 64 bit machine even though it's not a problem on the 32 bit machines?
-
Jet Reports Historic Posts Nope, it won't be a problem. When the language module folder is blank, Jet will look for the language module in the language folder of the NAV client. So if you are using English then you would have an ENU folder in your NAV client and in that folder you may have an English language module file which would be called ENU.flm. If there is no language module file there, then Jet will fall back to its own default set of captions. Is there a language module in this folder for the 32-bit clients?
Regards,
Hughes -
Jet Reports Historic Posts On my 32 bit system, I have under 6.0 classic client a ENU folder, but no ENU.flm file. I also have, under the RTC, a folder called en-US, but it doesn't have anything resembling an ENU.flm file in it either. As a matter of fact, I just ran a search for all *.flm files and returned nothing on my computer at all.
Thanks, Hughes, for your continuing assistance, I do appreciate it. -
Jet Reports Historic Posts Hmmm, well the problem may not be the language module in that case. It was just my first thought. Probably you ought to create a case with Jet Reports Support so that someone can look at your setup on the 32-bit and 64-bit machines and figure out what is happening.
Regards,
Hughes -
Jet Reports Historic Posts Thanks, Hughes, that is my next step. I just wanted to confirm that it wasn't something obvious that I was missing first.
I appreciate the help!
Please sign in to leave a comment.