magnify
formats

Report Consolidation Selection Type

A Reporting Consolidation Selection Type is a great way to provide report users with the ability to choose variable consolidation items when running a report. First you need a Selection Type (REPCONGL) then Selection Codes for each of the objects (Account Components, Selection Codes or User Fields you want the user to choose for consolidation.  This means at report run-time the user may choose to consolidate by any of the objects in the list, so they could, for example, run a Profit and Loss report that will list by a summarized Account Group or a more detailed Natural Account. (eg each Natural Account is linked to an Account Group selection code, such as Natural Account for Petrol linked to Account Group Motor Vehicle Expenses)

RepCon_SelectionType

 
 

In order for your Report to work it’s vital that their Description is exactly the same as the account component, selection code or user-field. (no typos!)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Your XLOne Reports needs to include a Report Variable linked to your Reporting Consolidation Type

RepCon_SelectionType_Variable

 

 

 

The Variable Consolidate By defaults to the most commonly chosen option as pictured below

RepCon_SelectionType_Runtime

 

 

 

 

 

 

 

The User can click the Picklist alongside Consolidate by and choose a different option from the list

RepCon_SelectionType_Picklist

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Your XLOne report List commands needs to utilize the variable value chosen by the user at run-time

RepCon_SelectionType_ListBy

 

 

 

Building variable Report Consolidation options into your reports in this way significantly increase management reporting options without having to maintain multiple separate reports.
The XLOne Forum contains more XLOne related content and everyone is welcome to share content and/or pose questions or create discussions points

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

TechnologyOne User Group Agenda 26 September

The next Finance One Melbourne User Group Meeting will be held on Thursday 26th September (Grand Final week) at:
TechnologyOne
Level 6
420 St.Kilda Road
Melbourne Victoria

This meeting includea a Performance Benchmarking survey to enable users to get an understanding of typical system speed and demonstrations of Customised Alerts, and CPM. It also time for people to raise questions and discussion points on the day.
Attached is a copy of the agenda, and you’re invited to submit items for the Agenda and to register your intention to attend using one of the following options:
Make a comment on the t1financials.com.au posting regarding this meeting, or
Join and make a comment on the new Technology One Software Users Group on Linked In .

User Group

 

 

 

Reply to this email or email me at Jamie.Scott@aus.salvationarmy.org or Jamie_Scott@t1Financials.com.au

Arrive at 10:00am for a 10:30am start, the meeting normally conclude in the early afternoon after lunch, which is very kindly being provided by TechnologyOne. There is plenty of parking near TechnologyOne’s offices


View Larger Map

AGENDA

MEETING OPEN – JAMIE SCOTT
t1financials.com.au user community website and Linked In User group update
Performance Benchmarking Survey – users invited to take part in simple tests to measure system speed and provide benchmarks for comparison. These tests would be done by each user at their site and include IT Infrastructure

TECHNOLOGY ONE UPDATE
TechnologyOne will provide an update of what’s happening with TechnologyOne company, staff, events and products
DEMONSTRATION CUSTOMISED ALERTS – TIM FINCH TECHNOLOGYONE
Tim Finch will provide a demonstration of Customized Alerts in TechnologyOne

WHATS NEW IN CPM – EMMANUEL LYGRIS SWINBURNE
Manny will give a presentation of new feature of CPM (Corporate Performance Management) Version 11.09.04.011.
GENERAL BUSINESS / NEW ITEMS

DATE AND VENUE FOR NEXT MEETING

 

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
8 Comments  comments 
formats

Melbourne User Group Meeting will be held on Thursday 26th September

Published on July 29, 2013 by in Current

The next Finance One Melbourne User Group Meeting will be held on Thursday 26th September (Grand Final week) at:

TechnologyOne
Level 6
420 St.Kilda Road
Melbourne Victoria

 

Additional details to follow, suggestions for agenda items welcome and can be added as Comments on this post.NMFC_99_Premier

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Position being advertised at City of Bendigo

Published on June 25, 2013 by in Featured

CityofBendigo
The IT unit has undergone a mini restructure and the position currently advertised is a mix of administration functions on a number of key corporate software products, including Technology One. The position is advertised on the City of Greater Bendigo website in case any staff in the user group member organisations might be thinking about a tree change and think the regional centre of Bendigo might have some attraction.

Systems Administrator
Reference No: 135
Closing Date: 01/07/2013

•Full Time, Ongoing
•Salary Range $68,065 – $74,177 + super
•Position Description Systems_Administrator_PD_CoB
Do you have experience in all aspects of IT software systems management and want to experience new and exciting challenges within a supportive team environment?

As Systems Administrator you will administer, problem resolve, implement upgrades and developments and training of our core business systems including Land Information systems, Finance, HR/Payroll and Document Management. This role is responsible for the provision of business systems support within the Information Management Team to the organisation. In addition, you will play a key role in projects relating to the implementation of new system functionality or upgrades.

Strong research, analytical and problem solving, interpersonal, and project management skills are essential to excelling in this role. You will have extensive experience in systems administration, proven ability/experience in identifying systems improvements, determining appropriate action and facilitating implementation of successful outcomes. Demonstrated experience in managing Infor’s Pathway system is highly desirable.

Applications addressing the key selection criteria must be received by Monday 1st July, 2013.

http://www.bendigo.vic.gov.au/Employment/Current_vacancies/Systems_Administrator

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Melbourne User Group Meeting Notes, March 21st, 2013

Published on May 1, 2013 by in Current

Walter + Eliza Halll Institute
The Melbourne TechnologyOne User Group held a meeting on Thursday 21st March at the Melbourne office of Walter + Eliza Hall Institute in Parkville. It was a great meeting with plenty of news, information and networking occurring in a positive, productive setting. Notes from the meeting are available in the User Group Forum including key points from Jared Evans’s (TechnologyOne Financials Product Owner) on the progress of  the Ci Browser version.

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 

No tweets to display