0

Error with jet report when updating GL budget template exported from NAV

Nastassja

January 09, 2020 07:12

None

Follow

I found this How to link to Import Jet Budgets data into NAV/BC (https://support.jetglobal.com/hc/en-us/articles/360012317994-Import-Jet-Budgets-Data-into-Dynamics-NAV-or-Business-Central) and have hit a roadblock. 

I followed the steps to turn off the data validation, then used the NL for the Dept dimension value and upon closing the Jet Function Wizard, the dimension value cell remain as a formula and did not return the "ADM" dimension value. May I know what set up am I missing? 

The guide from the link showed NL rows for one dimension value. May I know how to go about dimension combinations ie DEPT; PROJECT etc etc? How do we get the Excel budget to display the different dimension combination values? 

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Nastassja January 10, 2020 05:12

  An update to the previous post, I have managed to get the Dept dimension values display and successfully run the report. Budget values are coming across correctly per Jet Budget entries for a single dimension value. 

  Next question I have is if the jet report can go down another level by adding a second dimension value; eg combination of Dept and Proj dimension values.