Standard Crystal Report - Daily Material/Other Timesheet

Owned by Claire Aleman
04 24, 2023

Issue/Symptom/Question

Standard Crystal Report - Daily Material/Other Timesheet

Applies To

Penta for Windows

Crystal Report - Daily Material/Other Timesheet

Project Management

Resolution/Fix/Answer

Use the Crystal Daily Material/Other Timesheet report to provide frequent listings of material and other (not labor or equipment) amounts that will eventually be billed for cost plus contracts. This provides substantiation for job cost entered through the accounts payable module or general journal entries.

At the end of each shift or day, you can give the report to the owner, who then reviews and approves the cost incurred. This provides your client with their cost (i.e., your cost plus the applicable markup).

Notes:

  • The customer who requested this report calls it an Approval Document.
  • The owner does not remit funds due to this report, since this report and process generate no accounting entries or billings.

Prerequisite

  • A cost plus contract line item exists for billing materials.
  • The Calculate Customer Cost process completed prior to running this report.
  • A PENTA user (optionally) used the Calculate Customer Cost window to initiate PENTA’s process that prepares the data. Refer to the Calculate Customer Cost Window Description for information. This process does the following:
  • Applies the appropriate billing markup or billing rates to calculate the billable cost incurred during the period.
  • Creates a new Timesheet for all billable costs not previously included on a timesheet. Timesheets contain costs as follows:
  • Equipment Timesheet, costs are entered on the Equipment timecard.
  • Labor Timesheet, costs are entered on the Labor timecard.
  • Material/Other Timesheet, costs are entered on the (AP) Invoice and Credit Memo Entry window, (AP) Manual Payment Entry window, and Journal Entry and Distribution.

Selection

You can limit records displaying on this report by:

  • Job Id – You can include All Jobs or enter a specific Job Id.
  • Timesheet Id
  • To reprint a report, you can include All Timesheet Ids or enter a specific Timesheet Id. Use the Calculate Customer Cost window to determine the specific Timesheet Id.
  • If you do not specify a Timesheet Id, the report contains the data from the most recent Timesheet created by the Calculate Customer Cost window.

Sort - PENTA sorts this report in sequence by Job Id.

Page Break - There is a page break for each job and vendor.

Totals - This report contains totals for each Job Id.

Report Code: jc_DailyMatlTS_p65_cr11.rpt

Available Parameters:

Example Report Results:

Report Heading

Date - This is the Through Date entered on the Calculate Customer Cost window.

Customer - This is the name of the customer.

Client Charge # - This is the description of the contract line item.

Contract Number - This is the Invoice Reference field on the Job Information window.

Internal Job Number - This is the Job Id.

Timesheet Number - This is the unique number that identifies this generation of the report. If you need to reprint this exact version of the report, select this Timesheet Number.

Detail Fields

Vendor Name - This is the vendor name associated with the invoice, purchase order, or subcontract.

Item Description

  • If the corresponding detail relates to a purchase order, this is the purchase order description.

  • If the detail relates to a subcontract, this is the subcontract description.

  • If the detail relates to an invoice, this is the description associated with the first corresponding distribution of the invoice.

Type

  • If the corresponding detail relates to a purchase order, this is the purchase order number.

  • If the detail relates to a subcontract, this is the subcontract number.

  • If the detail relates to an invoice, this is the invoice number.

  • This report does not include invoices charged against a purchase order or subcontract, so any item with a type of purchase order or subcontract is a commitment.

Cost - This is either the committed amount from a subcontract or purchase order, or an invoice amount from a non-purchase order or subcontract related invoice. The subcontract or purchase order is included if the issue date is less than or equal to the report ate, and it has never been included on the report previously. An invoice associated with a subcontract or purchase order never prints on this report.

Markup - This is the billing markup associated with the cost amount.

Extended Cost - PENTA calculates this value as: Cost + Markup