Search found 98 matches

by Jackies
Mon Jun 12, 2017 5:27 am
Forum: How do I?
Topic: Countunique Vendor Ledger based on G/L Entry filter
Replies: 1
Views: 104

Countunique Vendor Ledger based on G/L Entry filter

Hey guys I'm trying to count Vendor ledger entries based on a filter in the G/L Entry table (Gen. Posting Type=Purchase). I have used an intermediary filter for the entries to retrieve the entries from the G/L entry table and then filter based on it in the query for the vendor ledger entry table. I ...
by Jackies
Mon Mar 27, 2017 2:28 am
Forum: How do I?
Topic: Question about +LOCK in cell A1
Replies: 5
Views: 2378

Re: Question about +LOCK in cell A1

Old issue but unfortunately not resolved. This time I have created a jet report, our users run that generates ~150 vendor sheets, which then splits and sends to separate recipients. The split has been automated with a tool. The only problem left to fully automate this is protection. The vendors ente...
by Jackies
Mon Jan 25, 2016 6:41 am
Forum: How do I?
Topic: Using two filters in single replicator
Replies: 1
Views: 344

Using two filters in single replicator

Hi all, I'm having difficulties creating a filter. I want to filter only Sales type entries from the VAT Entry table but these should also include reverse charge VAT calculation type, which can be of type purchase. =NL(;"Tax Entry";;"Type";"Sale";;;"Document No.";$B3;"Company=";Options!$D$10) Any id...
by Jackies
Tue Nov 04, 2014 11:07 pm
Forum: Suggestions and Feature Requests
Topic: Add Comments column in Options sheet [SOLVED]
Replies: 4
Views: 2061

Re: Add Comments column in Options sheet

Thanks! Got my activation code ;)
by Jackies
Mon Nov 03, 2014 11:51 pm
Forum: Suggestions and Feature Requests
Topic: Add Comments column in Options sheet [SOLVED]
Replies: 4
Views: 2061

Re: Add Comments column in Options sheet

Thanks Kloser, sorry if I missed this option but when was this added to Jet Reports? Still using version 2012 :oops:
by Jackies
Thu Oct 30, 2014 5:45 am
Forum: Suggestions and Feature Requests
Topic: Add Comments column in Options sheet [SOLVED]
Replies: 4
Views: 2061

Add Comments column in Options sheet [SOLVED]

Hi,

Maybe it's just me but since I create reports used by users in our organisation, I sometimes want an extra field/column next to the Value, where I explain what values to select and why.

Your thoughts?
by Jackies
Wed May 22, 2013 10:32 pm
Forum: How do I?
Topic: Question about +LOCK in cell A1
Replies: 5
Views: 2378

Re: Question about +LOCK in cell A1

You see the problem is we want to create this report for our users to run, but we don't want them to be able to have the ability to manipulate the formulas and/or the generated results.
by Jackies
Wed May 15, 2013 1:05 am
Forum: How do I?
Topic: Question about +LOCK in cell A1
Replies: 5
Views: 2378

Question about +LOCK in cell A1

I have been testing this feature and couldn't find a way to lock a Jet Report, so the end user can use it to re-generate it but not manipulate the data. +LOCK in cell A1 locks the sheet but the user can easilly go under Review tab in Excel and Unprotect Sheet. If I use a password to protect report a...
by Jackies
Thu Mar 21, 2013 7:32 am
Forum: How do I?
Topic: Sum of entries at a specific date with another value date [SOLVED]
Replies: 3
Views: 2002

Re: Sum of entries at a specific date with another value date [SOLVED]

Update: finally pulled if off!!! I have created two separate NL("Sum") in the cell to retrieve Original Amount (LCY) and from Detailed Cust. Ledg. Entry, retrieved the Amount (LCY) excluding initial entries, from incorporation until the report period end. Lastly, I had to change the Filter from Date...
by Jackies
Wed Mar 20, 2013 8:13 am
Forum: How do I?
Topic: Sum of entries at a specific date with another value date [SOLVED]
Replies: 3
Views: 2002

Re: Sum of entries at a specific date with another value date [SOLVED]

I want to filter the entries posted in 2011 but with the Amount LCY values of 2012. I have created a filter that filters the entries made in 2011 and then an NL("Sum") in the Detailed Customer Ledger entry table, that retrieves the entries posted up to the end of 2012 for the entries retrieved in th...
by Jackies
Wed Mar 20, 2013 7:01 am
Forum: How do I?
Topic: Sum of entries at a specific date with another value date [SOLVED]
Replies: 3
Views: 2002

Sum of entries at a specific date with another value date [SOLVED]

First of all I couldn't post the whole title so here is what I want to do: I have created a Customer detailed trial balance report and I use NL("Sum") to retrieve the opening balance of the customer. However, my date filter takes the total of the entries from the previous fiscal year (Amount LCY), b...
by Jackies
Wed Apr 25, 2012 10:50 pm
Forum: How do I?
Topic: Month Function
Replies: 1
Views: 745

Re: Month Function

What is the result you get in column G? I have tried =MONTH(F2) and works fine.
by Jackies
Thu Mar 22, 2012 1:20 am
Forum: MS Dynamics NAV
Topic: G/L Account Detail Report
Replies: 1
Views: 2514

Re: G/L Account Detail Report

This is one I did in the past. It contains "old" code but it should do the job :)
by Jackies
Thu Jan 26, 2012 12:20 am
Forum: How do I?
Topic: Support Alias with SQL tables?
Replies: 4
Views: 1223

Re: Support Alias with SQL tables?

Thank you Hughes for your input!

I will check and let you know about the results.
by Jackies
Mon Jan 23, 2012 11:46 pm
Forum: How do I?
Topic: Support Alias with SQL tables?
Replies: 4
Views: 1223

Re: Support Alias with SQL tables?

Hi fhilton, I use universal (SQL server) to retrieve information from an SQL based database. I have asked the developer to point the tables used to create a report in this system and he told me that besides 2-3 tables, there is a field retrieved from a table using alias. Find below his response: I'v...
by Jackies
Mon Jan 23, 2012 7:14 am
Forum: How do I?
Topic: Support Alias with SQL tables?
Replies: 4
Views: 1223

Support Alias with SQL tables?

Hi All,

I have been playing around with an SQL database and found out that a value is retrieved with the use of alias on a table. Can I do this with Jet (besides writting the SQL query)?

Thanks
by Jackies
Fri Jan 20, 2012 12:38 am
Forum: How do I?
Topic: 2012 AR Payments made to 2011 Customer Invoices
Replies: 1
Views: 695

Re: 2012 AR Payments made to 2011 Customer Invoices

I don't know how you want the answer but this is how I understand it :P : Detailed Cust. Ledger Entry and Detailed Vendor Ledger Entry tables Where entry type = application with posting date = 2012, filter the customer/vendor ledger entry where the entry type = initial entry with posting date = 2011
by Jackies
Mon Dec 26, 2011 11:42 pm
Forum: How do I?
Topic: Jet tab Excel sometimes not showing
Replies: 11
Views: 11437

Re: Jet tab Excel sometimes not showing

Sorry... :oops:
by Jackies
Thu Dec 22, 2011 1:07 am
Forum: How do I?
Topic: Jet tab Excel sometimes not showing
Replies: 11
Views: 11437

Re: Jet tab Excel sometimes not showing

I tried to open an excel file and got the messages attached.

Using latest Jet Essentials build with Excel 2007
by Jackies
Tue Dec 20, 2011 5:40 am
Forum: How do I?
Topic: Jet tab Excel sometimes not showing
Replies: 11
Views: 11437

Re: Jet tab Excel sometimes not showing

http://community.jetreports.com/viewtopic.php?f=6&t=1610 My reported problem with dissappearing Jet tab. I find it more useful to open excel first and then open an excel file using excel's menu. Moreover, sometimes when I double-click an excel file when excel is not open, I occasionaly get a message...
by Jackies
Wed Dec 14, 2011 6:16 am
Forum: How do I?
Topic: Configure Jet Reports on Terminal Server Automatically
Replies: 9
Views: 7381

Re: Configure Jet Reports on Terminal Server Automatically

"Does this work for you?"

I don't know but I will surely find out shortly! Thanks!!
by Jackies
Wed Dec 14, 2011 6:13 am
Forum: Excel Tips & Tricks
Topic: Excel limitations
Replies: 4
Views: 4348

Re: Excel limitations

Sorry fhilton I had to be more precise on what exactly I meant by 5.7 GB :oops:

This was the total Page File usage in the task manager. I believe this was the total memory resulting from the jetfront processes...
by Jackies
Tue Dec 13, 2011 1:16 am
Forum: How do I?
Topic: Configure Jet Reports on Terminal Server Automatically
Replies: 9
Views: 7381

Re: Configure Jet Reports on Terminal Server Automatically

fhilton, All our Navision dbs are accessible through citrix using windows authentication. So to sum up I want to confirm the steps to do a test run: I will need to create a profile on the server with the desired setup and then copy settings.xml in the users' profile folders. Run the two SQL scripts....
by Jackies
Tue Dec 13, 2011 12:53 am
Forum: Excel Tips & Tricks
Topic: Excel limitations
Replies: 4
Views: 4348

Re: Excel limitations

I have reached to the point of seeing 5.7 GB in the task manager :D Using xp 32-bit with 4GB ram.

Of course it crashed after a while because although it wasn't finished! I tried to stress the limits by running a global report on all our Nav datasources ( about 140) with 4 replicators. 8-)

Go to advanced search