Topic Options
#8874 - 04/23/07 09:39 AM GridView - Prior Yr Postings
GT Offline
Adagio Virtuoso

Registered: 08/14/03
Posts: 626
Loc: Antigua
Need to know if Gridview can be used to create a view of the prior year postings done in this financial year. Tracking to 263 pgs of the Detail Listing report is a bit trying. **I've created a view of the transactions, but I've not been able to find a filter/field that would allow me to define those 'special postings**.
_________________________
Ishana Alexander
Grant Thornton

Top
#8875 - 04/23/07 09:53 AM Re: GridView - Prior Yr Postings [Re: GT]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hello PwC,

In the Posted Transaction file, prior year postings have a fiscal period between 1 and the number of periods in the fiscal calendar (1-12 in a 12 period fiscal year). Current year postings have fiscal periods offset by the number of periods (13-24 for periods 1 to 12 in a 12 period fiscal calender).

You can isolate all the prior year transactions by a filter that selects only those transactions with a period < 13 for a 12 period fiscal calendar.
_________________________
Andrew Bates

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (Hugh), 205 Guests and 3 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14492 Topics
70766 Posts

Max Online: 432 @ 01/20/25 10:17 PM
May
Su M Tu W Th F Sa
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31