Hi,
With the table builder I am reporting all gl postings in a period. There for I use table GL entry (17) I'd like to add in the table builder the field totalling from table "GL account (15) –> NL("Rows";"G/L Entry")
Is it possible to add the total accounts to this report (total accounts are not mentioned in table GL entry).
I'd like to make a report with detailed postings (including dimensions 1, 2 & 3) and subtotal them by totalizing the gl accounts.
I have tried with formula IF(GL account no. <40095;"400 total salary";"other.."). Somehow the Gl account no. is not seen as number.
Kind regards,
Saskia
Date
Votes
5 comments
-
Jet Reports Historic Posts Hi Saskia,
It's fairly easy in the Table Builder to add a linked table. You just add G/L Entry first and then you add G/L Account. Then you can add fields from G/L Account such as the Totaling field. This is not something you should do with a formula. You can of course already add dimensions from the G/L Entry in the Table Builder (they should appear by name in the list of fields). As far as subtotally, that sounds like something you should probably do with a pivot table created from the table. Does this help?
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
The Gl accounts with type "End-total" are not in table "Gl entry". So I don't understand how I can add these total accounts to my report.
Hope you know what I mean…
Kind regards,
Saskia -
Jet Reports Historic Posts Okay, maybe I didn't read your original post well enough. Your screen shot doesn't look like you are using the Table Builder. It looks like you are using NL(Rows) to make the report (which would probably be easier anyway in this case). Can you attach the report? Maybe that would help make things more clear.
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
Attached you will find the file. The intention is to navigate from the summary P&L to detailed information (postings)
Hope the attached file helps.
Kind regards,
Saskia -
Jet Reports Historic Posts Saskia,
The Jet GL function knows how to deal with totalling accounts. You don't need to manually detect whether it is a totalling account and use the totalling range. Jet will do that automatically. When Jet evaluates a GL function to a totalling account such as 40095, it will automatically get the range of accounts in the totalling account and evaluate the function using that range. I think what you are trying to do here is unnecessary.
Regards,
Hughes
Please sign in to leave a comment.