Difference between revisions of "Reports"

From Marathon Documentation
Jump to: navigation, search
Line 1: Line 1:
  +
<htmltag tagname="style">p a.image{border:1px rgb(0,0,0) solid;box-sizing:content-box;}</htmltag>
 
__FORCETOC__
 
__FORCETOC__
 
<translate>
 
<translate>
  +
= Reports =
   
  +
Reports can be printed out and created in Projects | Reports.
== General == <!--T:1-->
 
  +
   
  +
== General ==
<!--T:2-->
 
  +
{|class=mandeflist
Print and create new reports in Project: Reports.
 
  +
!New
 
  +
|Use for creating new report template.
<!--T:3-->
 
{{ExpandImage|pro-rep-en--grafik1.png}}
 
 
<!--T:4-->
 
{| class=mandeflist
 
|'''New'''
 
|Create a new report template.
 
 
|-
 
|-
  +
!Edit
|'''Open'''
 
|Select report in the list and click open if you want to edit an existing report template.
+
|Use for editing existing report templates.
 
|-
 
|-
  +
!Printout
|'''Print'''
 
|Select a report and Print (or double click) to print out a report.
+
|Select a report and press Printout. You can also double click on a report to print it.
 
|-
 
|-
|'''Data definition'''
+
!Data definitions
  +
|Button for creating or editing own definitions in the report. Read more in separate chapter.
|Create or edit your own defined data (further instructions later in this manual)
 
 
|-
 
|-
|'''Copy company'''
+
!Copy company
|Click Copy company and select company to be copied from. Click OK. if there are existing reports in the company you are copying to, they will be overwritten. Remember that there can be reports that not are global, i.e. can only be seen by the one who has created it.
+
|You can copy reports from another company. If you have own reports, they will be replaced with the company’s that you copied from. Keep in mind that not all reports are global, i.e. only the person who created the report can use it.
 
|}
 
|}
   
  +
== Print report == <!--T:5-->
 
  +
== Print report ==
  +
* Select the report and press Printout or double click on it.
  +
  +
* Make a printout selection. The selection view varies depending on what settings has been made in the report template.
  +
Press Start.
   
  +
{|class=mandeflist
<!--T:6-->
 
  +
!Cancel printout
Select the report and press Print.
 
  +
|Use if you want to cancel the printing process.
A selection view appears.
 
The view varies depending on settings that has been made when the report was created.
 
You can print the report as PDF or export it to Excel.
 
 
<!--T:7-->
 
{{ExpandImage|pro-rep-en--grafik2.png}}
 
 
<!--T:8-->
 
{| class=mandeflist
 
|'''Start'''
 
|Starts the printout. Make selections first.
 
 
|-
 
|-
  +
!Save selection
|'''Cancel printout'''
 
  +
|This function saves the user’s selection.
|Stops the printout.
 
 
|-
 
|-
  +
!Reset
|'''Pdf'''
 
|Prints the report as PDF
+
|Resets the saved selection.
 
|-
 
|-
  +
!Pdf
|'''Spreadsheet'''
 
|Exports the report to Excel.
+
|Prints the report in Pdf format.
 
|-
 
|-
  +
!Spreadsheet
|'''No sums'''
 
|Check if you don&apos;t want the report summarized.
+
|Prints the report to Excel.
 
|-
 
|-
  +
!No sums
|'''Currency'''
 
  +
|Prints to excel with or without subtotals.
|You can print a report in all currencies in your currency register.
 
 
|-
 
|-
  +
!Currency
|'''Elimination'''
 
  +
|Used to print the report in a currency other than the company's base currency.
|Only in use if your company is using the multiple currency system.
 
 
|-
 
|-
  +
!Elimination
|'''Comment'''
 
  +
|Used only in companies using the multiple currency system.
|Comment shown under the report heading.
 
 
|-
 
|-
  +
!Comment
|'''Subtotals'''
 
  +
|A comment that will be printed out under the report heading.
  +
|-
  +
!Subtotal
 
|Select subtotals for the report.
 
|Select subtotals for the report.
 
|-
 
|-
|'''Sorting'''
+
!Sorting
|Select sorting column.
+
|Select column for sorting.
 
|-
 
|-
|'''Reversed'''
+
!Reversed
|Reversed sorting shows the largest values first.
+
|Presents the highest values on the top.
 
|}
 
|}
   
  +
== Create new report == <!--T:9-->
 
  +
Create report
  +
 Press New to create a new report.
  +
  +
New report template
  +
 Click on the heading New report template and give the report a name and a heading.
  +
 Select a standard setting for subtotals; it can be changed at printout.
  +
 Click on New column
  +
New columns
  +
You can change the size of the columns and move them by dragging the column heading.
  +
  +
 Press the New column button.
  +
 Select Data definitions. There are some standard definitions already, but you can add more, see later chapter in this manual.
  +
 Change suggested heading, if you wish.
  +
 Choose format for balance presentation:
  +
# ##0 Integrals
  +
# ##0,00 Amounts with decimals
  +
| 1000 Thousands
  +
NAME E.g. the project manager
  +
CODE E.g. the project manager code
  +
 If a certain period always shall be shown in the column, enter it here.
  +
Acc accounting year shows the balance for the current year.
  +
Previous year shows the balance from previous year.
  +
 Use Operator for calculations. It can be used for both columns and data definitions.
  +
 You can make a selection for the column.
  +
 Save the column with OK button. Make new columns if you wish.
  +
 Click the Format button to make the report landscape or portrait so that all columns fit.
  +
 Resize columns and move them by grabbing the column header.
   
  +
Format and selection
<!--T:10-->
 
  +
Decide how the report should be presented and the selection screen when printing.
Click the button NEW.
 
 
<!--T:11-->
 
{| class=mandeflist
 
|'''New report template'''
 
|Click on the text and give the template a name and a heading.
 
|-
 
|'''Subtotals'''
 
|Select a standard setting for subtotals (editable at printout).
 
|}
 
 
<!--T:12-->
 
{{ExpandImage|pro-rep-en--grafik3.png}}
 
 
<!--T:13-->
 
{| class=mandeflist
 
|'''New column'''
 
|Click to open the view for creating new columns
 
|}
 
 
<!--T:14-->
 
{{ExpandImage|pro-rep-en--grafik4.png}}
 
 
<!--T:15-->
 
{| class=mandeflist
 
|'''Header'''
 
|Automatically suggested header. Changeable after the data definitions are selected.
 
|-
 
|'''Format'''
 
|Determines how the balance shall be shown: # ##0 = shows integrals# ##0,00 = shows with decimals/1000 = shows in thousandsNAMN = shows the name (e.g. project manager)KOD = shows code KOD+NAMN= shows code + name
 
|-
 
|'''Data definitions'''
 
|A number of standard definitions exist by default, but you can add more definitions in the list. See further chapter in this manual.
 
|-
 
|'''Column'''
 
|Shows all columns in the report.
 
|-
 
|'''Period'''
 
|Possibility to select a certain period, used if a certain period always shall be shown in the report. Period can also be chosen at the time of printout, if that has been selected as |printout criteria.
 
|-
 
|'''Accounting year'''
 
|Shows the accumulated balance for the current accounting year.
 
|-
 
|'''Previous year'''
 
|Shows balance for the previous year.
 
|-
 
|'''Operator'''
 
|Used for addition of columns, showing discrepancies, etc. The operator can be used for both columns and for definitions.
 
|-
 
|'''OK'''
 
|Saves the column.
 
|-
 
|'''Delete column'''
 
|Deletes the column.
 
|}
 
 
 
  +
 Set Format to portrait or landscape.
{|class=mandeflist
 
  +
 Choose selection that will be suggested.
  +
  +
Show periods Dissenting periods shows periods in columns where periods are available.
  +
All shows selected period in all columns
  +
No doesn’t show periods in columns
  +
Global A global report allows all users with authorisation to reports to use this report.
  +
Authorisation group If the report is made global, you can select an authorisation group for it.
  +
Size 100 % is automatically suggested.
  +
Copy from Here, existing reports within the company can be copied.
  +
  +
  +
  +
  +
  +
  +
  +
  +
New data definitions
  +
There are a number of standard definitions that can be used in the report columns, and you can also add your own definitions.
 
 
  +
 Click on Data definition and select New.
{{ExpandImage|pro-rep-en--grafik5.png}}
 
  +
|-
 
  +
 Select Basic definitions and click on the right arrow so that the basic definition is shown in the box Variables.
|'''Save'''
 
  +
 You can select more basic definitions, and Formula +-* | % to calculate basic definitions
|Saves the report.
 
  +
 Select format for balance presentation.
|-
 
  +
 Choose Selection for Fees, Purchases. Select Project type and optional Project label.
|'''Cancel'''
 
  +
 Write a clear heading.
|Cancels the report without saving.
 
  +
 Save. The new data definition can now be fetched into a report template.
|-
 
|'''Selection'''
 
|Here you can make the selection that will be shown at printout.
 
|-
 
|'''Format'''
 
|Choose between vertical and horizontal printout.
 
|-
 
|'''Show periods'''
 
|Dissenting periods = shows periods in those columns where period is statedAll = shows selected period in all columnsNone = does not show periods in columns
 
|-
 
|'''Global'''
 
|A global report can be used by all authorized users.
 
|-
 
|'''Only auth.group'''
 
|You can limit the access to a global report with authorization groups.
 
|-
 
|'''Size'''
 
|100 % is suggested.
 
|-
 
|'''Copy from'''
 
|You can copy existing reports within your company.
 
|}
 
   
== Add data definitions == <!--T:16-->
 
   
  +
Report definitions
<!--T:17-->
 
Go to Data definitions and select NEW.
 
   
  +
Actual p-price Registered purchase price. For purchases, it means the price before mark-ups, for fees, the calculated cost of the employee and for other it is the purchase price stated on the code.
<!--T:18-->
 
  +
Actual Amount Number of registered entities
{{ExpandImage|pro-rep-en--grafik6.png}}
 
  +
Actual Registered Registered sales price. For purchases it means the price before mark-up and for fees, the hourly price.
  +
Actual Adjusted Adjusted entries
  +
Invoiced p-price Like Actual purchase price, but only entries that are invoiced.
  +
Invoices s-price Like Actual registered, but only entries that are invoiced.
  +
Pre-invoiced Pre-invoices
  +
WIP purchase price Like Actual purchase price, but only entries that are not invoiced.
  +
WIP Sales price Like Actual registered, but only entries that are not invoiced.
  +
WIP Pre-invoiced Pre-invoices that haven’t been deducted.
  +
Project estimate Hours Estimated hours on the project
  +
Project estimate Amount Estimated amount on the project
  +
Project estimate p-price Estimated purchase price. See Actual p-price for definition.
  +
Regular price | hour The employee’s regular hourly price set in the employee register in base registers.
  +
Regular working time The employee’s work time requirement in Time report.
  +
Fixed price A fixed price set on the project
  +
Not updated hours Hours not updated in Project | Backoffice | Transactions | Update WIP
  +
Resource planned time Hours that are resource planned
  +
Collective client manager Client manager that is registered on the collective client in the base registers
  +
Client manager Client manager that is registered on the client or the project
  +
Project manager Project manager that is registered on the project
  +
Production manager Production manager that is registered on the project
  +
Master The master project that is connected to the project
  +
Project type E = external, I = internal, 9 = Not project related (900-codes), J = Speculative job and G = group common
  +
Project status 0 = active, 9 = closed, 8 = pending
  +
Project group The group that is connected to the project
  +
Created Date when the project was created
  +
Last entry Shows date for last registered entry
  +
Filing number Filing number registered on the project
  +
Archiving status J If the project is archived, N if not
  +
Filing date Date for archiving the projectt
  +
Closed Closing date for the project
  +
Latest invoice is paid Payment date of the last paid invoice
  +
Team The project’s team
  +
Deadline Deadline date, registered on the project
  +
Start date Start date of the project, registered on the project
  +
VAT code The VAT code of the project
  +
Comment Comment from the time sheet row in Projects | Time reporting
  +
Own ID Registered on the client
  +
Reporting-ID Registered on the client
  +
Intercompany code Registered on the client
   
<!--T:19-->
 
{| class=mandeflist
 
|'''Header'''
 
|Give the definition a clear and detailed header. It will become its identification.
 
|-
 
|'''Format'''
 
|Determines how the balance shall be shown
 
* <code># ##0</code> = shows integrals
 
* <code>#|##0,00</code> = shows with decimals
 
* <code>/1000</code> = shows in thousands
 
* <code>NAMN</code> = shows the name (e.g. project manager)
 
* <code>KOD</code> = shows code
 
* <code>KOD+NAMN</code> = shows code + name
 
|-
 
|'''Formula'''
 
|Calculate with basic definitions with <code>+</code> <code>-</code> <code>*</code> <code>/</code> <code>%</code>
 
|-
 
|'''Basic definitions'''
 
|Shows the content of the definition
 
|-
 
|'''Selection'''
 
|Select what codes, if any, shall be shown regarding fees, purchases and other
 
|-
 
|'''Project type'''
 
| The project types are: E= external G= joint types within the company I= internal J= speculation/pitch projects 9= internal, not project related
 
|-
 
|'''Project labelling'''
 
|Your internal definitions (requires use of project labelling on projects)
 
|}
 
   
== Quick guide– Create a new report == <!--T:21-->
 
 
<!--T:22-->
 
* Click on the header New report template, give the report a name.
 
 
<!--T:23-->
 
* Select New column and Data definition for the column content (rename the column header, if necessary).
 
 
<!--T:24-->
 
* Click on Selection and choose the selections for printout.
 
 
<!--T:25-->
 
* Depending on how many columns the report has, choose between horizontal and verical layouts.
 
 
<!--T:26-->
 
* Select period display in columns.
 
 
<!--T:27-->
 
* Choose between making the report global (available to all authorized users), your own, or available for a certain authorization group.
 
 
<!--T:28-->
 
* Select possible standard subtotals
 
 
<!--T:29-->
 
* Save.
 
 
== Quick guide – Create new definitions == <!--T:30-->
 
 
<!--T:31-->
 
* Select basic definition and click on the right arrow to see the definition in the Variables&apos; field.
 
 
<!--T:32-->
 
* Select optional more basic definitions and formulas.
 
 
<!--T:33-->
 
* Make selections regarding fees, purchases and other and project types and possible project labelling.
 
 
<!--T:34-->
 
* Write a clear heading.
 
 
<!--T:35-->
 
* Save.
 
 
<!--T:36-->
 
The new definition can now be fetched into the report template.
 
 
<!--T:37-->
 
''In the example below, the definition ”Sales price-Purchase price for purchases” will fetch invoices sales price minus invoiced purchase price only for purchases, if it is used in a report template.''
 
 
<!--T:38-->
 
{{ExpandImage|pro-rep-en--grafik8.png}}
 
 
== Report definitions == <!--T:39-->
 
 
<!--T:40-->
 
{|class=mandeflist
 
 
<!--T:41-->
 
|'''Actual p-price'''
 
|Registered purchase price. For purchases, it means the price before mark-ups, for fees, the calculated cost of the employee and for other itis the purchase price stated on the code.
 
|-
 
|'''Actual Amount'''
 
|Number of registered entities
 
|-
 
|'''Actual Registered'''
 
|Registered sales price. For purchases it means the price after mark-ups, for fees it means the hourly rate and for other it means the sales price put on the code.
 
|-
 
|'''Actual adjusted'''
 
|Adjusted records
 
|-
 
|'''Invoiced p-price'''
 
|Like actual purchase price, but only invoiced records
 
|-
 
|'''Invoiced s-price'''
 
|Like actual registered, but only invoiced records
 
|-
 
|'''Invoiced pre-inv.'''
 
|Pre-invoices
 
|-
 
|'''WIP p-price'''
 
|Like actual purchase price but only not invoiced records
 
|-
 
|'''WIP s-price'''
 
|Like actual registered but only not invoiced records
 
|-
 
|'''WIP pre-inv'''
 
|Not deducted pre-invoices
 
|-
 
|'''Project estimate hours'''
 
|Budgeted hours – estimate made in Project: Queries
 
|-
 
|'''Project estimate amount'''
 
|Budgeted amount – estimate made in Project: Queries
 
|-
 
|'''Project estimate p-price'''
 
|Budgeted amount (see actual s-price for details) – estimate made in Project: Queries
 
|-
 
|'''Regular hourly rate'''
 
|The regular hourly rate of the employee set in System: Base registers/PRO/Employees
 
|-
 
|'''Regular working time'''
 
|The working time request in Time reporting
 
|-
 
|'''Fixed price'''
 
|Fixed price set on the project in Project: Queries or in System: Base registers/PRO/Clients ans projects
 
|-
 
|'''Not updated time'''
 
|Time that hasn&apos;t been updated in Project: Registration, correction and update Shows hours.
 
|-
 
|'''Resource planned time'''
 
|Time that is planned in Project: Resource planning
 
|-
 
|'''Collective client manager'''
 
|Client manager stated on the client in Project: Queries or in System: Base registers/PRO/Collective clients
 
|-
 
|'''Project manager'''
 
|Project manager stated on the client in Project: Queries or in System: Base registers/PRO/Clients/Projects
 
|-
 
|'''Production manager'''
 
|Production manager stated on the client in Project: Queries or in System: Base registers/PRO/Clients/Projects
 
|-
 
|'''Master'''
 
|Shows the Master project that the project is connected to
 
|-
 
|'''Project type'''
 
|E= external, I =internal, 9= not project related (900-codes), J=speculation projects and G= common projects within group.
 
|-
 
|'''Project status'''
 
|0= active, 9=closed, 8= deactivated
 
|-
 
|'''Project group'''
 
|Shows the group that is connected with the project
 
|-
 
|'''Registered'''
 
|The date for registration of the project
 
|-
 
|'''Last entry'''
 
|Shows date of last registered entry
 
|-
 
|'''Archiving'''
 
|Archiving number on the project
 
|-
 
|'''Archiving status'''
 
|Y= archived, N= not archived
 
|-
 
|''' Archiving date'''
 
|Date of archiving
 
|-
 
|'''Closed'''
 
|Closing date of the projects
 
|-
 
|'''Last invoice paid'''
 
|Payment date of the last paid invoice
 
|-
 
|'''Deadline'''
 
|Deadline date, set in Project: Queries
 
|}
 
 
[[Category:PRO-REP-EN]] [[Category:Manuals]] [[Category:Projects]]
 
[[Category:PRO-REP-EN]] [[Category:Manuals]] [[Category:Projects]]
 
</translate>
 
</translate>

Revision as of 15:06, 19 January 2026

Reports

Reports can be printed out and created in Projects | Reports.


General

New Use for creating new report template.
Edit Use for editing existing report templates.
Printout Select a report and press Printout. You can also double click on a report to print it.
Data definitions Button for creating or editing own definitions in the report. Read more in separate chapter.
Copy company You can copy reports from another company. If you have own reports, they will be replaced with the company’s that you copied from. Keep in mind that not all reports are global, i.e. only the person who created the report can use it.

Print report

  • Select the report and press Printout or double click on it.
  • Make a printout selection. The selection view varies depending on what settings has been made in the report template.

Press Start.

Cancel printout Use if you want to cancel the printing process.
Save selection This function saves the user’s selection.
Reset Resets the saved selection.
Pdf Prints the report in Pdf format.
Spreadsheet Prints the report to Excel.
No sums Prints to excel with or without subtotals.
Currency Used to print the report in a currency other than the company's base currency.
Elimination Used only in companies using the multiple currency system.
Comment A comment that will be printed out under the report heading.
Subtotal Select subtotals for the report.
Sorting Select column for sorting.
Reversed Presents the highest values on the top.

  Create report  Press New to create a new report.

New report template  Click on the heading New report template and give the report a name and a heading.  Select a standard setting for subtotals; it can be changed at printout.  Click on New column New columns You can change the size of the columns and move them by dragging the column heading.

 Press the New column button.  Select Data definitions. There are some standard definitions already, but you can add more, see later chapter in this manual.  Change suggested heading, if you wish.  Choose format for balance presentation:

  1. ##0 Integrals
  2. ##0,00 Amounts with decimals
| 1000 Thousands

NAME E.g. the project manager CODE E.g. the project manager code  If a certain period always shall be shown in the column, enter it here. Acc accounting year shows the balance for the current year. Previous year shows the balance from previous year.  Use Operator for calculations. It can be used for both columns and data definitions.  You can make a selection for the column.  Save the column with OK button. Make new columns if you wish.  Click the Format button to make the report landscape or portrait so that all columns fit.  Resize columns and move them by grabbing the column header.

Format and selection Decide how the report should be presented and the selection screen when printing.

 Set Format to portrait or landscape.  Choose selection that will be suggested.

Show periods Dissenting periods shows periods in columns where periods are available. All shows selected period in all columns No doesn’t show periods in columns Global A global report allows all users with authorisation to reports to use this report. Authorisation group If the report is made global, you can select an authorisation group for it. Size 100 % is automatically suggested. Copy from Here, existing reports within the company can be copied.




New data definitions There are a number of standard definitions that can be used in the report columns, and you can also add your own definitions.

 Click on Data definition and select New.

 Select Basic definitions and click on the right arrow so that the basic definition is shown in the box Variables.  You can select more basic definitions, and Formula +-* | % to calculate basic definitions  Select format for balance presentation.  Choose Selection for Fees, Purchases. Select Project type and optional Project label.  Write a clear heading.  Save. The new data definition can now be fetched into a report template.


Report definitions

Actual p-price Registered purchase price. For purchases, it means the price before mark-ups, for fees, the calculated cost of the employee and for other it is the purchase price stated on the code. Actual Amount Number of registered entities Actual Registered Registered sales price. For purchases it means the price before mark-up and for fees, the hourly price. Actual Adjusted Adjusted entries Invoiced p-price Like Actual purchase price, but only entries that are invoiced. Invoices s-price Like Actual registered, but only entries that are invoiced. Pre-invoiced Pre-invoices WIP purchase price Like Actual purchase price, but only entries that are not invoiced. WIP Sales price Like Actual registered, but only entries that are not invoiced. WIP Pre-invoiced Pre-invoices that haven’t been deducted. Project estimate Hours Estimated hours on the project Project estimate Amount Estimated amount on the project Project estimate p-price Estimated purchase price. See Actual p-price for definition. Regular price | hour The employee’s regular hourly price set in the employee register in base registers. Regular working time The employee’s work time requirement in Time report. Fixed price A fixed price set on the project Not updated hours Hours not updated in Project | Backoffice | Transactions | Update WIP Resource planned time Hours that are resource planned Collective client manager Client manager that is registered on the collective client in the base registers Client manager Client manager that is registered on the client or the project Project manager Project manager that is registered on the project Production manager Production manager that is registered on the project Master The master project that is connected to the project Project type E = external, I = internal, 9 = Not project related (900-codes), J = Speculative job and G = group common Project status 0 = active, 9 = closed, 8 = pending Project group The group that is connected to the project Created Date when the project was created Last entry Shows date for last registered entry Filing number Filing number registered on the project Archiving status J If the project is archived, N if not Filing date Date for archiving the projectt Closed Closing date for the project Latest invoice is paid Payment date of the last paid invoice Team The project’s team Deadline Deadline date, registered on the project Start date Start date of the project, registered on the project VAT code The VAT code of the project Comment Comment from the time sheet row in Projects | Time reporting Own ID Registered on the client Reporting-ID Registered on the client Intercompany code Registered on the client