Open topic with navigation

GL Detail By Job Report - JC

Make the following menu selections to display this tab:

Job Cost—Reports—Job Cost Reports—GL Detail By Job Report

Use this page to print the GL Detail by Job report.

This report can be printed as part of a Series of Reports.

The GL Detail By Job report lists job related transactions for Journal Entries, AP invoices and payments, and AR Billings and Receipts. 

The report includes the following.

Account number

Period

Transaction Date

Trans Type

Transaction Types include JE (Journal Entry), RT (Returns) and SH (Shipments)

ID

For Invoices and Payments this is the Vendor ID

For Billings and Receipts this is the Customer ID

Name

For Invoices and Payments this is the Vendor Long Name

For Billings and Receipts this is the Customer 

Transaction Type

Transaction ID

Amount of the transaction

Cost Type for the transaction

Description of the transaction

Project Manager

Superintendent

Last Cost

Phase, Cost, and Job Estimate Description

Totals for Cost, Phase, and Job

Gross Billings amount

The report prints for all currently selected entitiescompanies in entitycompany ID order.

ClosedTo Print the Report

  1. From the Job Cost menu, select Reports—GL Detail By Job.
  2. Click Select EntitiesCompanies. Select the entitiescompanies for which you want to print the report and click Save.
  3. At Date Range select a date range for the report. Options are Date and Posting Period.

    Date      - When you select this option, enter into the fields that appear a From Date and a Thru Date using the electronic calender.

    Posting Period     - When you select this option, enter into the fields that appear a From Prd/Fiscal Year and a Thru Pre/Fiscal Year using the electronic calender.
     
  4. Select an option for Include Jobs.
    Options are: Open and Closed (default), Open, Closed.
    If you select Closed, enter From and Thru dates in the new fields that appear.
  5. (Optional) For the various From and Thru fields (for Job, Phase, and Cost), use the Lookup icon for each field to enter a starting and ending entry for the range.

    To run the report for only one Job, Phase, or Cost Type, select the same entry for the From and Thru fields.
     
  6. Check or uncheck check boxes, as applicable, to define how you want the report to print. Options include:

    New page for each job     - The default is unchecked. Check the box if you want to print a new page for each job.

    Include unapproved     - Check the box to include unapproved transactions in the report. Uncheck to report on only approved transactions.
  7. At Transactions, select check boxes for all transactions you want to include on the report. Options include: All, Journal Entries, Billings, Receipts, Invoices, Payments, and Inventory Shipments.

    Uncheck boxes for the transactions you do not want to include in the report.
     
  8. At Totals, select how you want the totals to print on the report. Options are:
    Job
    Job and Phase
    Job and Cost
    Job, Phase, and Cost
  9. Select one of the following report printing options:
  1. Click Print. If you selected Create Spreadsheet, you are prompted to open or save the report Excel file. Otherwise, the report opens in PDF format.

See Also

Reports Introduction

 

Copyright © 2018 Infor. All rights reserved. www.infor.com.