> > > >

Use this report to analyze how totals of project transactions are posted to profit and loss accounts in the General ledger module.

You can use the report to reconcile ledger transactions that are generated in the module.

The relationship between figures in this report and the posting setup

Cost price accounts

Not applicable - This is not a relevant combination.

Included - This field is included in the report list:

Included 1. Only hour transactions

Included 2. Only cost transactions

Included 3. Only item transactions

Included 4. Only when posted to profit & loss accounts

Included 5. Calculation: Employee + Cost + Inventory

Included 6. Calculation: Accrued turnover + Invoiced turnover

Posting -

Posting -

Posting

Calculation 1)

Posting-

Posting -

Calculation 2)

Included 1

Included 2

Included 3

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Included

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Sales price accounts

Not applicable - This is not a relevant combination.

Included - This field is included in the report list:

Included 1. Only hour transactions

Included 2. Only cost transactions

Included 3. Only item transactions

Included 4. Only when posted to profit & loss accounts

Included 5. Calculation: Employee + Cost + Inventory

Included 6. Calculation: Accrued turnover + Invoiced turnover

Posting -

Posting -

Posting -

Calculation 1)

Posting-

Posting -

Calculation 2)

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Included

Included

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Included 4

Included 4

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Included

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Included

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Included

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Tip Tip

By default, information on the report is sorted by project and then by ledger account. Alternatively, information on the report can be sorted by ledger account and then by project.


Navigating the report

The following links and tables provide descriptions for the controls in this report.

Enter criteria on the General tab

Prepare batch processing on the Batch tab

Buttons

Button

Description

Open a query, and select the data to include. View the data selections of some reports in the query.

Return to the default settings of the query.

Set up report delivery, such as formatting for a printer, printing, or saving as a file.

Change the start time and start date of the batch job, or set up a recurring batch job.

Fields

Field

Description

/

Specify a start date and end date to include in the report profit and loss transactions that are posted to the ledger.

Select how to display the first column of the report.

  • Specify the number of subproject levels. Select 0 to display all projects that are summarized in one line, 1 to display only parent projects, and 2 to display subprojects.

  • The projects below the parent project level are summarized on one line, and an asterisk (*) indicates if the summarized number includes subprojects below the first subproject level.

Select whether to exclude all rows in the report where the amounts are equal to zero.

See Also



!