I am using the Jet Table Builder using tables G/L Entry, GL - Item Ledger Relation, and Value Entry. I am filtering on Posting Date, Department, Company, and G/L Account No.
My goal is to be able exclude records where the sum of Amount for each Item No. = 0
This would effectivly not return items with a total amount of 0.
I can do it in SQL, but can't figure out how to create such a statement in a Jet Table
Much appreciated!
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi there,
I don't know exactly what you are doing but I don't think you can eliminate the lines that add up to zero from within the TableBuilder.
Can you get to the same information by using a PivotTable off of the table the report creates? -
Jet Reports Historic Posts I could drop the table and then create a pivot table, however wanted to limit the datat returned as I am pulling hunders of thousands of lines and sometimes am getting an "Out of memory error" which I interperet to mean too much data.
This doesn't have to be a table by any means. I actually started building via the function wizard. The "out of meory error" seemed to lessen if I used the Table builder, but here is what I started with in the function wizard:
=NL("Rows","G/L Entry",,"Posting Date",$E$2,"Company Code",$M$2,"G/L Account No.",$J$2,"Department Code",$N$2)
If someone can tell me how to accomplish this via the function wizard I am happy to go that route as well. Let me now if more information is needed.
Please sign in to leave a comment.