I am trying to create a JET Report that will list out a particular G/L account number by line item by value. I know how to get a trial balance, but I require help in drilling down to the detail in the account and then running a report which will list this detail.
Hope this makes sense to anyone reading. It's probably quite an easy formula but I am very new to JET and am probably missing some simple things.
Date
Votes
3 comments
-
Jet Reports Historic Posts So where you wanting a list of G/L Acc Numbers that have a certain "Item No." in their entries?
-
Jet Reports Historic Posts Let me give an example of the required output to make it a bit clearer.
Posting Date ; G/L Account No. ; G/L Account Name ; Amount ; Entry No.
01/01/09 ; 21000 ; Sales ; 200,000 ; 305971
14/01/09 ; 21000 ; Sales ; 400,000 ; 305972
21/01/09 ; 21000 ; Sales ; 500,000 ; 305973
31/01/09 ; 21000 ; Sales ; 100,000 ; 305978
Jan ; 21000 ; Sales ; 1,200,000
This would be the output that I needed for the month of January during which we sold £1,200,000 worth. This is just a simple example I know but hopefully it sheds some light on what I'm looking for. -
Jet Reports Historic Posts GL Account Entries.xlsi think i understand what you are wanting.
try this out
is that what you meant?
Please sign in to leave a comment.