I don't have a copy of Jet Essentials I can try this out with, but I'm wondering if it would be possible to import a Jet Reports formatted report back into NAV without it causing a problem?
Presumably when designing your import routine, you would need the import to ignore cell A1. Other than that, are there any other considerations to be taken?
Or would it not work at all?
Cheers,
Ian
Date
Votes
2 comments
-
Jet Reports Historic Posts hello Ian, I'm sure this is not quite the situation you are thinking of (since my role in Navision is as user and not that of a programer or designer), but my experience might still help in what you are attempting.
Part of my job involves creating and uploading custom pricing into Navision using the "Extended Price Schedule" section (I don't know if this exists on all versions of Navision or not).
I do most of the work in Excel (using Jet to pull in some of the analysis fields), and then upload the resulting completed file back into the Navision database.
I have learned that (at least in that area) - I cannot simply tell the system to start the import at column B - I have to actually delete column A completely or the upload errors out.
I also have to be certain that all fields are static values (so having Jet end with a UM of ="EA" is not acceptable).
Part of my process is to copy and paste/special the entire page I am uploading, delete column A (and row 1 to be safe), and then upload.
Additional Jet formulas in the report on other pages do not seem to interfere. -
Jet Reports Historic Posts Thanks for the reply Heather.
I am aware you can effectively copy and paste values into another excel file, but was ideally looking to avoid having to do any additional steps to suck the file back in again.
Cheers,
Ian
Please sign in to leave a comment.