Search found 41 matches

by BrianJet
Tue Aug 04, 2015 5:10 pm
Forum: Suggestions and Feature Requests
Topic: Dynamics NAV accounts schema transformation
Replies: 1
Views: 1985

Re: Dynamics NAV accounts schema transformation

Hi Michael, This has been something that we've been looking into for a while now. The issue is that it becomes very hard to standardize because of how "creative" people can get with the use of .., |, *, <>, etc. This makes it extremely difficult to parse everything in a manner that will work properl...
by BrianJet
Tue Aug 04, 2015 4:15 pm
Forum: Suggestions and Feature Requests
Topic: Documentation Export to Excel
Replies: 2
Views: 615

Re: Documentation Export to Excel

Also, here is a quick overview of Team Development which I meant to include in the previous reply:

http://kb.jetreports.com/article/AA-00674
by BrianJet
Tue Aug 04, 2015 4:14 pm
Forum: Suggestions and Feature Requests
Topic: Documentation Export to Excel
Replies: 2
Views: 615

Re: Documentation Export to Excel

Hello Michael, Thank you for the suggestions! I will pass this along. Have you looked into using Team Development at all (or is this what you are referring to in your post?). This allows the backend users to create Work Items outlining the work to be done as well as saving notes about what was done ...
by BrianJet
Tue Aug 04, 2015 3:36 pm
Forum: How do I?
Topic: Adding fields from posted transactions to sales cube
Replies: 1
Views: 628

Re: Adding fields from posted transactions to sales cube

Hello, Since the data that you are looking to get into the Sales cube is related to the sales documents as a whole I would take the approach of adding the fields to the Sales Header (which it sounds like you have already done) and then dragging these up to the Sales Document table in the data wareho...
by BrianJet
Tue Aug 04, 2015 3:34 pm
Forum: How do I?
Topic: Synchronization of accounts string error
Replies: 1
Views: 413

Re: Synchronization of accounts string error

Hello, Since this appears to be support related please email support@jetreports.com to ensure that a member of our staff can assist in the resolution. The community forums aren't manned as frequently and are meant more for user to user interaction so I want to make sure that you are getting the assi...
by BrianJet
Tue Aug 04, 2015 3:31 pm
Forum: How do I?
Topic: [SOLVED] Jet Enterprise with NAV 2015
Replies: 2
Views: 558

Re: Jet Enterprise with NAV 2015

Hello Elena, There is a KB article that address this here: http://kb.jetreports.com/article/AA-00260/0/ The proper fix is to upgrade to the latest service pack of SQL as it is a known SQL issue. The workaround is to close the JDM which will force the SSIS connection to close and then reopen it. Unle...
by BrianJet
Tue Aug 04, 2015 3:26 pm
Forum: How do I?
Topic: Dimensions in NAV 2013
Replies: 1
Views: 608

Re: Dimensions in NAV 2013

Hello, It sounds to me like the Analysis Views may not be getting updated in NAV. If you run the Analysis by Dimensions report in NAV does this reflect correct totals? If not, you may need to speak with your NAV partner or go into the Analysis View card and either click the Update button to have NAV...
by BrianJet
Fri Apr 24, 2015 8:58 am
Forum: How do I?
Topic: Balance per month ...
Replies: 3
Views: 1202

Re: Balance per month ...

Hi Stoffer, It sounds to me like what you want is simply the ending balance at the end of each month. For Balance Sheet accounts this will be the summation of all transactions for all time and for Income Statement Accounts it will only be for the current year. Assuming that you are closing your year...
by BrianJet
Fri Apr 24, 2015 8:51 am
Forum: How do I?
Topic: How to rollback if the package Fails during execution?
Replies: 2
Views: 695

Re: How to rollback if the package Fails during execution?

Hello Franco, The tables are executed in a specific order and when a table is executed two things happen: - Data is transferred from the data source into the destination table, typically through a SSIS package - The data is then cleansed through a SQL stored procedure which brings in lookup values (...
by BrianJet
Tue Nov 18, 2014 9:57 pm
Forum: How do I?
Topic: Project is protected
Replies: 1
Views: 1405

Re: Project is protected

Hi Renata, This issue generally comes up when a project was downloaded from the Cubestore with one activation code and then the Jet Data Manager was reactivated with a different activation code. When a project is downloaded it is tied to the activation code it was downloaded with, so if a different ...
by BrianJet
Mon Sep 29, 2014 10:07 pm
Forum: How do I?
Topic: Jet Data Manager -> Activation Code.
Replies: 6
Views: 3667

Re: Jet Data Manager -> Activation Code.

Hi Johanna,

I'm glad that it's working! Have a good evening. :)
by BrianJet
Tue Aug 05, 2014 10:41 am
Forum: How do I?
Topic: GP Cube 3.1 Improvements
Replies: 2
Views: 1018

Re: GP Cube 3.1 Improvements

Hi Carl, This forum is primarily monitored and driven by end users so if you do not receive a reply please feel free to send your request to support@jetreports.com. The differences between the GP projects are documented in the change log on our KB site here: http://kb.jetreports.com/article/AA-00840...
by BrianJet
Tue Aug 05, 2014 10:35 am
Forum: Suggestions and Feature Requests
Topic: Easy setup of Execution packages
Replies: 1
Views: 1414

Re: Easy setup of Execution packages

Hello Eric, There will be functionality similar, but not identical, to what you mention in the next release of the JDM which we hope to release in the coming weeks. This functionality will manage the execution of the packages so that the order in which the objects are executed is determined optimall...
by BrianJet
Tue Nov 26, 2013 9:30 am
Forum: How do I?
Topic: Jet Data Manager -> Activation Code.
Replies: 6
Views: 3667

Re: Jet Data Manager -> Activation Code.

Hello Johanna, I just tested the web service and it appears to be working fine. Can you try activating again? If you still have issues please send an email to Enterprise@jetreports.com including your company name and activation code and request a manual activation file. Jet Reports will generate thi...
by BrianJet
Wed Apr 17, 2013 9:09 am
Forum: How do I?
Topic: NAV Adapter - "Read Aggregation Tables - SIFT"
Replies: 1
Views: 1484

Re: NAV Adapter - "Read Aggregation Tables - SIFT"

Hello,

Checking this box will allow SIFT tables in NAV to be used as source tables in the staging database. I have attached a screenshot of what this would look like with one of the Item Ledger Entry SIFT tables.
by BrianJet
Wed Apr 17, 2013 9:02 am
Forum: How do I?
Topic: Manual Deploy & Execute - "Script All Objects"?
Replies: 1
Views: 1180

Re: Manual Deploy & Execute - "Script All Objects"?

Hello, Checking the box for "Script all objects" will create a more detailed log of the scripts used to process data once the deploy and execution process is finished. I have included an attachment that shows the difference. You can see in the first screenshot that there are a lot more detailed show...
by BrianJet
Fri Dec 14, 2012 11:04 am
Forum: How do I?
Topic: Jet Data Manager Exception
Replies: 1
Views: 1401

Re: Jet Data Manager Exception

Hello, I believe that there was an issue with the version of the Jet Data Manager that you are using (12.4.8) that would cause this error on occasion. Upgrading the Jet Data Manager to the latest version should resolve your problem. You can download the latest version of the Jet Data Manager (12.7.0...
by BrianJet
Wed Apr 18, 2012 11:44 am
Forum: How do I?
Topic: Jet Enterprise for OLAP server
Replies: 1
Views: 1780

Re: Jet Enterprise for OLAP server

Hello,

Can you ensure that Analysis Services is installed and running on the machine? You can check this by opening the Service on the machine (Start -> Control Panel -> Administrative Tools -> Services normally) and then looking for "SQL Analysis Services". This should be installed and started.
by BrianJet
Mon Mar 26, 2012 10:31 pm
Forum: How do I?
Topic: nl("Picture")
Replies: 2
Views: 1202

Re: nl("Picture")

Hi Tim, I did a bit of testing and believe that I have something that will work. This is the function that tested fine on my machine: =NL("Picture","Item","Picture","No.",IF(B2="A",C2,"@@")) In this scenario, cell B2 was the condition to test for (so in this case it will return the picture if the va...
by BrianJet
Thu Dec 22, 2011 11:09 am
Forum: How do I?
Topic: Dimension Value Code empty in some NAV companies
Replies: 1
Views: 1681

Re: Dimension Value Code empty in some NAV companies

Hello Tomek, The relationship between the Item Ledger Entry table and the Value Entry table should probably be set as a "relationship", not a "restriction". If you open up the staging database and go down to the Value Entry table and open it you will see a relationship at the bottom (there will be a...
by BrianJet
Tue Oct 04, 2011 3:32 pm
Forum: How do I?
Topic: Aged Accounts Receivable
Replies: 2
Views: 1639

Re: Aged Accounts Receivable

Hi Andrew, There is actually an Aged Accounts Receivable report that was shared over in the forums. I'm not sure if you are using NAV or GP but here is a link to the download for the NAV one. It may not be everything that you need but at least it's a good start! I hope it helps. http://community.jet...
by BrianJet
Wed Sep 07, 2011 3:39 pm
Forum: How do I?
Topic: Jet Enterprise and SQL Editions
Replies: 2
Views: 2032

Re: Jet Enterprise and SQL Editions

Hello Ian, I will look into this more closely and request a suggestion if necessary. In the meantime, I believe that you could create a Business Function that would achieve the same thing without having to use the AverageOfChildren type measure that is only available in SQL Enterprise. The Business ...
by BrianJet
Fri Jul 08, 2011 9:03 am
Forum: How do I?
Topic: JetReports Configuration Without Dynamics NAV installed
Replies: 2
Views: 1745

Re: JetReports Configuration Without Dynamics NAV installed

Hello, It appears that you may not have properly set up the NAV Adapter. This is a small set of objects that is loaded into NAV that allows Jet Enterprise to see all of the custom tables and fields that you may have. We have a video that covers this portion of the installation process out here: http...
by BrianJet
Fri May 20, 2011 8:51 am
Forum: How do I?
Topic: Enhancements NAV adapter
Replies: 1
Views: 1351

Re: Enhancements NAV adapter

Hello Willem,

Thank you for the feedback. I will put in a request for the transformations and conditions for a future version, but the scripts and stored procedures are hand typed and therefore wouldn't be subject to the language settings in NAV. These will always have to be changed manually.
by BrianJet
Fri May 20, 2011 8:41 am
Forum: How do I?
Topic: Referenced dimensions and visibility of dimensions
Replies: 1
Views: 1520

Re: Referenced dimensions and visibility of dimensions

Hello Willem, I'm glad that you found a workaround for the first issue that you were having. I have noted this and will pass it on as a feature request for a future version of the Jet Data Manager. With regard to the second question, you cannot make dimensions invisible but can you can dimension lev...

Go to advanced search