I am using a 12 period P&L report with the GL function with the option "include closing entries".
I am wondering whether it would be possible to add the criteria "include prior year entries"? In that case it would be possible to eliminate "Period 13" corrections from the P&L.
Anton
Date
Votes
4 comments
-
Jet Reports Historic Posts Official comment Hi Anton,
Including or excluding prior year entries is not an option in the GL function. This is a specific field in the G/L Entry table. You need to create an NL(Sum) function on the G/L Entry tabel to get the amounts you want to report. In that function you can filter your G/L Account(s), period etc. and the "Prior year entry" field (field ID 30).
Does that help? -
Jet Reports Historic Posts Hi Anton,
I'm not quite sure I understand what you want here. In a P&L account, the closing entry at the end of the year zeros out the account, right? So if you actually want to include values from prior years, why wouldn't you just exclude the closing entries?
Even though I'm not positive what you're trying to do, I'm guessing you might be able to achieve the result you want with an NL(Sum) formula instead of a GL formula. You probably want to sum the Amount field on the G/L Entry table (unless you're retrieving budgets or using an Analysis View). You can filter on the Posting Date field for your date range. With Jet, you can use a filter that starts with <>C& to exclude closing entries like this:
"<>C&1/1/2011..12/31/2012"
With closing entries in NAV, the date starts with a C, Jet would turn this filter into this:
"<>C12/31/2011&<>C12/31/2012&1/1/2011..12/31/2012"
Does this help?
Regards,
Hughes -
Jet Reports Historic Posts I am aware how closing entires work and how to filter them.
What I am trying to achieve is a filter on "prior year entries". When posted in closed periods the entry is flagged as a prior year entry. And I have not yet found a solution how to filter (include/exclude) these journals from a P&L report similar to how to filter closing entries in the GL function.
Anton -
Jet Reports Historic Posts Yes thanks.
Anton
Please sign in to leave a comment.