Reports - Project Accounting - Journal Details

Overview

This report will provide a view of the Unanet Journal detail information that has resulted from a Post or Invoice Completion process.  This may be useful if attempting to investigate the supporting detail of a number displayed on other billing reports.

Roles

This report is available to users having any of the following roles:  Administrator, P&R Administrator, Billing Manager, Billing Viewer (and their alternates).

License

This report is available with the Project Tracking and Project Portfolio family of licenses.

Topics covered on this help page include:

• Selection Criteria   (options available to tailor report output)

• Example Report Output

You may also be interested in:

• Project Accounting > Instructional Guide   (search for this topic in the Knowledge Center)

• Billing > Instructional Guide    (search for this topic in the Knowledge Center)

• Post                                       (to view additional information about posting data)

• Journal Summary Report  (to view a summary report containing journal information)

Selection Criteria

 Note: For Saved Reports: If the report includes Labor Cost Post as the Document Type selection criteria, then Billing Managers, Billing Viewers, and their alternates will not have access to that report.

Field Descriptions (click on a link below for additional information)

Example Report Output

Note that the Quantity and Rate columns are used as a label to help identify the item that the journal entries are associated with.  That is, the Quantity times the Rate do not necessarily relate to the Amounts shown in the Debit / Credit columns, but rather the amounts reflects some type of activity for the item (identified in part by the Quantity and Rate columns).

Field Descriptions

• Document # column will include either the Invoice # or the document # of a post process that created the transaction.  This column will not be empty.
• Journal Date
• Post to GL column will only appear if your site is running with one of the Project Financials family of Unanet licenses.  When present, it will display a Y if the item has been posted to the general ledger.
• Account Code/ Account Description
• Org Code / Org Name fields together represent the complete identifier of the posting organization. Both of these columns can be empty if the transaction was generated without a posting org (for pre-Unanet 10.0 transactions, or for transactions for which an org could not be derived via Posting Groups).
• Project Org / Project / Task
• Category column will include:
• • Funding Cap Adjustments - will contain the following verbiage "Funding Cap Adjustment"
  • Fee Cap Adjustment - will contain the following verbiage "Fee Cap Adjustment"
  • All labor charges - labor category (this applies to T&M, CP Direct, CP Indirect, and CP Fee charges for labor)
  • All expense charges - expense type name, if it exists, or code (this applies to T&M, CP Direct, CP Indirect, and CP Fee charges for expense or fin document expense)
  • All item charges - item name and item code (this applies to T&M, CP Direct, CP Indirect, and CP Fee charges for labor)

  • Note: Financial document expense/labor/item are not supported for intercompany transactions, only labor and expense

• Base Cost Element column will include:
• • For time - comes from the timesheet cell
  • For expense - comes from the allocated expense line item
  • For item - comes from the allocated item line item
  • For Financial Documents it come from the Financial Document Detail Expense item
  • For all others it will display a dash
• Cost Element column will include:
• • Direct charge (labor or expense) - cost element description if exists, cost element code otherwise
  • Indirect cost - cost element description if exists, cost element code otherwise
  • Fee or Fee Cap Adjustment - fee method name
  • all other charges - empty
• Customer/Vendor column:
  1. Applicable to financial document expenses only
  2. Values derived as follows:
     o Journal Entry – fin_document_detail > customer_key
     o Vendor Invoice – vendor_invoice > vendor_org_key
     o Vendor Payment – vendor_payment > vendor_org_key
     o Customer Payment – customer_payment > customer_org_key
     o Deposit – fin_document_detail > customer_key
• Person
• Source Document Type column will include:
• • For expense reports - ER
  • For Financial Documents:
  • • CP - Customer Payment
    • D - Deposit
    • JE - Journal Entry
    • VI - Vendor Invoice
    • VP - Vendor Payment
  • For all others it will display a dash
• Source Document Number column will include:
• • For expenses, it is the expense report key
  • For Financial Documents, it is the document number
  • For all others it will display a dash
• Item Date
• Quantity - When applicable to labor, shows timesheet cell hours for direct charge rows only. This column will be empty for any labor-related indirect charges. Will show quantity for items.
• Debit column will include:
• • Assets - Any positive amount
  • Income or Liabilities - Any negative amount
• Credit column will include:
• • Assets - Any negative amount
  • Income or Liabilities - Any positive amount
• Extract Date