Jet Reports Homepage |  Community Forum |  Downloads |  Submit A Ticket |  Jet Express Support
Feedback

Jet G/L Budget Import Tool for Navision


This tool is no longer supported by Jet Reports.  This information is provided here for the convenience of users with older versions of Jet Reports and Microsoft Dynamics NAV.
This tool is compatible with Navision 3.7 through NAV 2009 - ONLY.


Before you begin


You will need the following components before you can use the Budget Import Tool from Jet Reports.

  1. Jet Reports v7 - Jet Reports 2009 installed and configured properly on your workstation.
  2. Navision 3.7 - NAV 2009 installed and configured properly on your workstation (If using Jet 2009 or higher, NAV 4.0 SP1 or higher is required.  If using Windows 7, NAV 5.0 or higher is required).
  3. Since the Budget Upload Utility installs at form 50000, you will need to check your NAV implementation to be sure you do not already have an object at that location.  If you do and you need the have the Budget Upload Utility to install at a different location, please contact Technical Support (support@jetreports.com) with the speciific location you need.
  4. The JetBudgetImport.fob (Jet Reports v7) or JetBudgetUploadV9.fob (Jet v9).  See below for instructions on installing this file on your Navision database.  You must be a super user in Navision to install the .fob.  (The file extension on the attached file needs to be changed from .fob.txt to .fob for this process to work correctly.)
  5. The “ GL Budget_Upload.xls ” or similar report. This workbook is provided by Jet Reports as a template and may need to be modified to meet your budget import needs.

Installing JetBudgetImport.fob
  1. The .fob file is available for download from the link above.
  2. From Navision, go to “Tools” then select “Object Designer”.
  3. Go to “File” then select “Import.”
  4. Browse to the directory with the .fob file.
  5. Select the .fob file and then choose “Open.”
  6. One of the following messages will appear…
    • If you get this message, choose “No”.


    • If you get this message, choose “OK”.
  7. You are now in the Import Worksheet
  8. Click the Replace All button at the bottom.
  9. Then click OK.
  10. The object is now installed on your database.

Additional Jet Reports Settings For Jet Reports V7

Before you can use the upload feature in Jet Reports V7, you will need to configure Jet Reports to use the correct object in your Navision database to handle the importing of the data generated by the Upload tool.
  1. In Excel, select Jet, Options, and select the Data Source tab.  Make sure that you have the correct Data Source selected and then click on the “Advanced Options” button (not the “Advanced” tab).
  2. In the “Navision Upload” section you will see 2 options called “Form No.” and “Source Table No.”.
  3. In “Form No.” type 50000, and in “Source Table No.” type 2000000041.
  4. Click on the “Update” button to save your settings, then click on the “Close” button.
  5. Click on “OK” to close the Options form.

Using GL Budget Upload.xls

This workbook have been designed based on the Navision 4.0 SP2 CRONUS USA, Inc. database and may have to be modified to meet your needs.  This workbook has the following features:
  1. Report Options.  When you click on the Jet “Report” button, the Report Options panel will appear.  From here, you can specify the filters you want to use in creating the budget. It allows you to retrieve current G/L Account balances for a specific date range with the date periods replicated across the workbook in columns.
  2. Stored User Data.  There are columns (marked in light yellow) for the entry of budget figures.  Notice that the data entered in these columns is stored between report runs.  So if you enter data in the yellow columns and re-run the report, the data will still be there.  Once the new budget amounts are entered in these columns, you can upload them to Navision.


Uploading data to Navision

Once you have completed the entry of information on the budget, you can now upload it to Navision.  If this is your first time, it is a good idea to create a backup of your existing budget before starting this process, or use a new budget name to inform the system to automatically create a new budget during the upload process.

For Jet Reports V7 users:

  1. Select Jet, Tools, User Data, Upload to trigger the upload of the data to Navision.
  2. A message will appear informing you that “Your workbook must be saved to upload User Data.  Do you want to save your workbook and upload your User Data?”.  By selecting “OK”, an upload file will be generated and Your Navision client software will start.  You may need to enter in your login name and password for Navision.
For users of Jet Reports 2009:


  1. Begin the upload process by selecting Upload from the User Data option in Jet.  When prompted, enter 50000 in the "Form No." field and click OK
  2. Once Navision as started, you will be presented with Jet Budget Import form.

  3. From this form, you will be presented with a list of “Key” fields that were found in the upload file generated by Jet Reports.  The second column contains the closest match that was found in your database for the Key.  By click on the lookup button in each field, you are presented with a list of possible fields that the key should be matched to.  Once the list of matched keys is correct, you may click on “Next” to continue.


  4. The next screen informs you what Budget the data will be imported into. Click on “Finish” to import the data.


  5. Once the import is complete, you will be presented with the standard Navision Budget Form.  Use this form to review the imported data.  Corrections can be made here to the budget, or you can make correction to the workbook and run the import again.  If you re-import the workbook, you will overwrite any changes to the budget that you make within Navision.


This information is only applicable to Navision users.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments