reporting expenses

Member for

18 years 9 months

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

Member for

18 years 11 months

okay now you’ve 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 can’t find what you’re looking for select customise and then select from the many grouping categories



Once you’ve done that click on tools and select report wizard, as you’ve 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 that’s quite a practical way of analysing data.



Alternative way, navigate to the reports window. Now I’m assuming there isn’t an expenses report there - otherwise you would have done it already and you wouldn’t 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!!










Member for

18 years 9 months

I added a price unit for each expense.

Member for

18 years 11 months

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?