Accounts Payable reports that include Job Cost information

Reports to review how you entered the Accounts Payable (AP) invoice batch and the Job Cost cost code information included.

• The journal that's printed after you finish from Accounts Payable, Tasks, Enter Invoices.
• The Reprint Journal report found at Reports, Invoice Register, Reprint Journal.

 NOTE: You can add a condition to print the report for a specific job. In the Add Condition window, click Index to select the AP-Distribution record and add the job condition. 

Reports in the Accounts Payable menu

You can find these reports in the Accounts Payable Reports menu.

• AP Invoices by Job - (Reports, Invoice Registers, Invoices by Job):
  • Use this report to review invoices by project manager or by job. Only invoices with job information print. The report sorts the invoice distribution records by project manager or job, then by vendor and invoice. Prompts allow you to:
    • Specify a payment date cutoff (clear the Payment date cut off field to print all invoices)
    • Sort by job or project manager
    • Print open or paid invoices
• AP Invoice Aging by Job with Cut-off Date - (Reports, Cash Management, Invoice Aging by Job w/Cut-off):
  • Use this report to age invoices as of a specific date. It prints the non-job invoices first, and then the invoices that have job information.
• AP Cash Requirements by Job - (Reports, Cash Management, Cash Requirements by Job):
  • Use this report to project the cash requirements for the next four check runs. You can start with a tentative check run date and assume a future check runs every seven days. The report prints the invoices in job, vendor, and invoice order.
• AP Check Register by Job (CM) - (Reports, Cash Management, Check Register by Job):
  • This report is similar to the AP Check Register by Job (AP) report. However, it includes the reconciled status of the check from Cash Management.

Reports in the folder

 You can find these reports in the Sage 300 CRE Report folder. The default location for this folder is typically \Timberline Office\9.5\Accounting\Report.

Run the report from Report Designer, or add it to your Reports menu.

• AP Invoices by Job (HB) - (Report folder):
  • Use this report to review invoices by job. Only invoices with job information print. The report sorts the invoice distribution records by job, vendor, and invoice. Prompts allow you to specify a payment date cutoff, and whether to print open or paid invoices. You can’t sort by project manager.
• AP Check Register by Job (AP) - (Report folder):
  • Use this report to review the amount of each check paid for each job. This report sorts the Accounts Payable distribution payment records in job, bank, and check order. It summarizes the records by check. This results in one print line for each check and job. The prompts allow you to specify certain check dates and numbers. A check box allows you to print non-job related checks.
• AP Vendor Checks by Job (HB) - (Report folder):
  • Use this report to review vendors, cost codes, and invoices by job. It also includes the check numbers, check dates, and check amounts. This report sorts the distribution payment records in job, vendor, and invoice order. The report only includes job-related checks. There’s a prompt for a range of job numbers.

Reports in the knowledgebase

You can also download and save the attached report for Report Designer. The report shows both job and vendor or invoice information.

Attachment: JCCostEntriesByJobVendorAdded.rpt