reporting expenses
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
Hello Sufian,
Thank you very much for the help, that is exactly what i needed. I am trying to get used to P3 e/c after P3. It requires some effort!I could not realize the possibility of working with layout. I lost myself in reports section.
Thanks again.
Ceren
okay now youve got a few different ways of reporting this.
first of all, if you can manipulate your current screen to display the information you want to report then you can run a report on the current screen.
For example, if you click on the expenses window (left hand side of the screen) or click on project menu and select expenses.
Tidy this window up:
Right click on your expenses, select columns and then customise. From this window you can have a variety of fields like price unit
Perhaps group your expense items according to category. Right click on your expenses, go to group and sort, if you cant find what youre looking for select customise and then select from the many grouping categories
Once youve done that click on tools and select report wizard, as youve manipulated your screen click on the current screen radio button, bypass all of the options - click on next, next, next save run etc
I think thats quite a practical way of analysing data.
Alternative way, navigate to the reports window. Now Im assuming there isnt an expenses report there - otherwise you would have done it already and you wouldnt be posting a question here ;)
Click on Add
Click on Project Expenses
Click on Next
Click on Next
Use the Columns / Group and Filters to manipulate the data - i would suggest you use grouping like category, use columns to add in price / unit etc
Follow the defaults - save / run etc
Let me know how you get on or if you need more info!!
I added a price unit for each expense.
are you referring to the five price / units you set up in from the admin menu? or are you adding in expenses and typing in a price unit for each expense item?