I have two formulae, one to extract the total value of G/L entry transactions with various filters, and another to extract the transactions from the G/L Entry table that result in that total value: formulae as follows:
=nl("Sum","G/L Entry","Amount","0",$K6,"G/L Account No.",$B8,"DEPARTMENT",$C8,"JOB",$D8,"Posting Date",TEXT(M$3,"dd/mm/yyyy")&".."&TEXT(M$4,"dd/mm/yyyy"))
=nl("Rows","G/L Entry","Amount","0",$K6,"G/L Account No.",$B8,"DEPARTMENT",$C8,"JOB",$D8,"Posting Date",TEXT(M$3,"dd/mm/yyyy")&".."&TEXT(M$4,"dd/mm/yyyy"))
The first of these ("Sum") is working fine and giving me the total value of transactions based on the filters entered; however, the second ("Rows") is outputting no transaction data, even though that data is there. If I set the "JOB" filter to "*", however, I do get data (but unfiltered by JOB), so it appears that JOB filter (which is actually the Shortcut Dimension 4 Code in our G/L setup) is the problem. I'm struggling to understand why what works for one isn't working for the other; has anyone else encountered this, and can anyone help me resolve the issue?
Thanks
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Thanks for your reply. I think I might have solved this, by prefixing the JOB filter with "@@", as in "@@"&$D8; whether is the reason it now works or not I don't know, but it works, so I'm happy!
-
Jet Reports Historic Posts Hello -
That's a very interesting issue that we have tried (but failed) to duplicate.
Let's run through a few basic questions:
1) What type of data source are you using (e.g., NAV?)
2) What version of the data source?
3) What version of the Jet add-in?
4) Finally, could you use the Jet Browser to check your table? Check to see if there is a "Shortcut Dimension 4" listed, as well as "Job"
Please sign in to leave a comment.