The Projects module is available in Sage 50 Accounts Professional. If you'd like to discuss upgrading to Professional, submit your details and we'll be in touch. Committed costs reports To find the report: - Click Projects then click Reports then click Committed costs
For details of the information the report contains, refer to the following section.
Committed Costs per Project - PJCOMCOS.report This report shows for each project reference the following information: | Stock Code | The stock code of the product committed to the project. | | Description | The description of the product. | | Cost Code | The cost code assigned to the cost. | | Date | The project transaction date. | | Order No. | The purchase order number. | | Committed Qty | The quantity of stock committed to the project. | | Value | The value of the stock committed to the project. | The report also displays total values for each project as well as an overall report total.
Cost code and cost type reports To find the report: - Click Projects then click Reports then click Cost code and cost type
These reports show project information by cost code or by cost type. For details of the information each report contains, please refer to the following sections.
Cost Code List - PJCCLST.REPORT This report shows all cost codes created in Sage 50 Accounts. These codes are in the Project Costing tab of the Configuration Editor. The report shows the following information for each cost code: | Cost Code ID | The unique cost code ID number. | | Reference | The cost code reference, for example LAB. | | Description | The cost code description, for example Labour Charges. |
Cost Code Summary per Project - PJCCBPRJ.REPORT This report totals each cost code's value by adding product, project, and invoice transactions. The report groups by project reference, and for each cost code it displays the following information: | Code | The cost code reference, for example LAB. | | Description | The cost code description, for example Labour Charges. | | Net | The total net value posted to the project using this cost code. | The report also displays total values for each project, and an overall report total.
Cost Transactions by Cost Code and Project - PJCTBCCP.REPORT This report displays transactions posted for each cost code, grouped by project reference. The report includes stock transactions, project transactions and invoice transactions and for each transaction it displays the following information: | Type | The transaction type, for example PI (purchase invoice). | | Audit No | The transaction number as shown on the audit trail. This only appears for transactions posted to the audit trail - a stock transaction or project charge has no audit trail number. | | Date | The date of the transaction. | | Reference | The transaction reference. | | Acc/Item | The account reference, resource reference or stock code to which the transaction was posted. | | Cost Qty | The quantity used for the transaction. For a stock or project transaction, the actual quantity is displayed. For an audit trail transaction, a quantity of 1.00 is shown. | | Cost Rate | The cost price, rate or net amount of the transaction. | | Net | The total net value. | The report also displays total values for each project and cost code, and an overall report total.
Cost Transactions by Project and Cost Code - PJCTBPCC.REPORT This report displays transactions posted for each project reference, grouped by cost code. The report includes stock transactions, project transactions and invoice transactions and for each transaction it displays the following information: | Type | The transaction type, for example PI (purchase invoice). | | Audit No | The transaction number as shown on the audit trail. This only appears for transactions posted to the audit trail - a stock transaction or project charge has no audit trail number. | | Date | The date of the transaction. | | Reference | The transaction reference. | | Acc/Item | The account reference, resource reference or stock code to which the transaction was posted. | | Cost Qty | The quantity used for the transaction. For a stock or project transaction, the actual quantity is displayed. For an audit trail transaction, a quantity of 1.00 is shown. | | Cost Rate | The cost price, rate or net amount of the transaction. | | Net | The total net value. | The report also displays total values for each cost code and project, and an overall report total.
Cost Type Summary per Project- PJCTBPRJ.REPORT This report shows the project reference, customer reference, project status, date last billed, date of last cost and total amount quoted for each project. The report then lists the following information: | Cost Type | The cost type identification reference. | | Description | The cost type name. | | Net | The total net amount of all transactions and stock items charged.. | The report also displays total values for each project, and an overall report total.
Cost Transactions by Cost Type and Project - PJCTBCTP.REPORT This report displays transactions posted for each cost type, grouped by project reference. The report includes stock transactions, project transactions and invoice transactions and for each transaction it displays the following information: | Type | The transaction type, for example PI (purchase invoice). | | Audit No | The transaction number as shown on the audit trail. This only appears for transactions posted to the audit trail - a stock transaction or project charge has no audit trail number. | | Date | The date of the transaction. | | Reference | The transaction reference. | | Acc/Item | The account reference, resource reference or stock code to which the transaction was posted. | | Cost Qty | The quantity used for the transaction. For a stock or project transaction, the actual quantity is displayed. For an audit trail transaction, a quantity of 1.00 is shown. | | Cost Rate | The cost price, rate or net amount of the transaction. | | Net | The total net value. | The report also displays total values for each Cost Type and Project, and an overall report total.
Cost Transactions by Project and Cost Type - PJCTBPCT.REPORT This report displays transactions posted for each project reference, grouped by cost type. The report includes stock transactions, project transactions and invoice transactions and for each transaction it displays the following information: | Type | The transaction type, for example PI (purchase invoice). | | Audit No | The transaction number as shown on the audit trail. This only appears for transactions posted to the audit trail - a stock transaction or project charge has no audit trail number. | | Date | The date of the transaction. | | Reference | The transaction reference. | | Acc/Item | The account reference, resource reference or stock code to which the transaction was posted. | | Cost Qty | The quantity used for the transaction. For a stock or project transaction, the actual quantity is displayed. For an audit trail transaction, a quantity of 1.00 is shown. | | Cost Rate | The cost price, rate or net amount of the transaction. | | Net | The total net value. | The report also displays total values for each cost type and project, and an overall report total.
Day books reports To find the reports: - Click Projects then click Reports then click Day books
The project day book reports only show transactions which have been linked to a project record. They include both audit trail transactions and stock movement transactions. For details of the information each report contains, refer to the following sections.
Bank Payments to Projects - Detailed - PJDYBPD.report | Id | The project transaction ID. This is the number assigned to the transaction in the project audit trail, and is different from the audit trail number. | | Audit No | The transaction number as shown on the audit trail. | | Type | The transaction type, for example BP. | | Bank | The bank account assigned to the transaction. | | Date | The date of the transaction. | | Reference | The transaction reference. | | N/C | The nominal code assigned to the transaction. | | Dept | The department assigned to the transaction. | | Project | The project assigned to the transaction. | | Cost code | The cost code assigned to the transaction. | | Details | The additional information entered at the time of posting to identify the transaction. | | Net | The total net value. | | T/C | The tax code assigned to the transaction. | | Tax | The total tax value. | | Gross | The total gross value. | The report shows grand totals for the net, tax and gross amounts. Values are in the base currency.
Bank Payments to Projects - Summary - PJDYBPS.report | Id | The project transaction ID. This is the number assigned to the transaction in the project audit trail, and is different from the audit trail number. | | Tp | The transaction type, for example BP. | | Bank | The bank account assigned to the transaction. | | Date | The date of the transaction. | | Reference | The transaction reference. | | Project | The project assigned to the transaction. | | Cost code | The cost code assigned to the transaction. | | Details | The additional information entered at the time of posting to identify the transaction. | | Net | The total net value. | | Tax | The total tax value. | | Gross | The total gross value. | The report shows grand totals for the net, tax and gross amounts. Values are in the base currency.
Project Only Costs - Detailed - PJDYPOCD.report | Id | The project transaction ID. This is the number assigned to the transaction in the project audit trail, and is different from the audit trail number. | | Type | The transaction type, for example BP. | | Date | The date of the transaction. | | Reference | The transaction reference. | | Project | The project assigned to the transaction. | | Resource | The resource assigned to the transaction. | | Cost code | The cost code assigned to the transaction. | | Details | The additional information entered at the time of posting to identify the transaction. | | Qty | The quantity of units. | | Rate | The rate per unit. | | Net | The total net value. This is the quantity multiplied by the rate. | The report shows a grand net total. Values are in the base currency.
Project Only Costs - Summary - PJDYPOCS.report | Id | The project transaction ID. This is the number assigned to the transaction in the project audit trail, and is different from the audit trail number. | | Date | The date of the transaction. | | Reference | The transaction reference. | | Project | The project assigned to the transaction. | | Cost code | The cost code assigned to the transaction. | | Details | The additional information entered at the time of posting to identify the transaction. | | Qty | The quantity of units. | | Rate | The rate per unit. | | Net | The total net value. This is the quantity multiplied by the rate. | The report shows a grand net total. Values are in the base currency.
Purchase Credits to Projects - Detailed - PJDYPCD.report | Id | The project transaction ID. This is the number assigned to the transaction in the project audit trail, and is different from the audit trail number. | | Audit | The transaction number as shown on the audit trail. | | Type | The transaction type, for example BP. | | A/C Ref | Supplier account reference assigned to transaction. | | Date | The date of the transaction. | | Reference | The transaction reference. | | N/C | The nominal code assigned to the transaction. | | Dept | The department assigned to the transaction. | | Project | The project assigned to the transaction. | | Cost code | The cost code assigned to the transaction. | | Details | The additional information entered at the time of posting to identify the transaction. | | Net | The total net value. | | T/C | The tax code assigned to the transaction. | | Tax | The total tax value. | | Gross | The total gross value. | The report shows grand totals for the net, tax and gross amounts. Values are in the base currency.
Purchase Credits to Projects - Summary - PJDYPCS.report | Id | The project transaction ID. This is the number assigned to the transaction in the project audit trail, and is different from the audit trail number. | | Type | The transaction type, for example BP. | | A/C Ref | Supplier account reference assigned to transaction. | | Date | The date of the transaction. | | Reference | The transaction reference. | | Project | The project assigned to the transaction. | | Cost code | The cost code assigned to the transaction. | | Details | The additional information entered at the time of posting to identify the transaction. | | Net | The total net value. | | Tax | The total tax value. | | Gross | The total gross value. | The report shows grand totals for the net, tax and gross amounts. Values are in the base currency.
Purchase Invoices to Projects - Detailed - PJDYPID.report | Id | The project transaction ID. This is the number assigned to the transaction in the project audit trail, and is different from the audit trail number. | | Audit | The transaction number as shown on the audit trail. | | Type | The transaction type, for example BP. | | A/C Ref | Supplier account reference assigned to transaction. | | Date | The date of the transaction. | | Reference | The transaction reference. | | N/C | The nominal code assigned to the transaction. | | Dept | The department assigned to the transaction. | | Project | The project assigned to the transaction. | | Cost code | The cost code assigned to the transaction. | | Details | The additional information entered at the time of posting to identify the transaction. | | Net | The total net value. | | T/C | The tax code assigned to the transaction. | | Tax | The total tax value. | | Gross | The total gross value. | The report shows grand totals for the net, tax and gross amounts. Values are in the base currency.
Purchase Invoices to Projects - Summary - PJDYPIS.report | Id | The project transaction ID. This is the number assigned to the transaction in the project audit trail, and is different from the audit trail number. | | Type | The transaction type, for example BP. | | A/C Ref | Supplier account reference assigned to transaction. | | Date | The date of the transaction. | | Reference | The transaction reference. | | Project | The project assigned to the transaction. | | Cost code | The cost code assigned to the transaction. | | Details | The additional information entered at the time of posting to identify the transaction. | | Net | The total net value. | | Tax | The total tax value. | | Gross | The total gross value. | The report shows grand totals for the net, tax and gross amounts. Values are in the base currency.
Sales Credits to Projects - Detailed - PJDYSCRD.report | Id | The project transaction ID. This is the number assigned to the transaction in the project audit trail, and is different from the audit trail number. | | Audit No | The transaction number as shown on the audit trail. | | Type | The transaction type, for example BP. | | A/C Ref | Customer account reference assigned to transaction. | | Date | The date of the transaction. | | Reference | The transaction reference. | | N/C | The nominal code assigned to the transaction. | | Dept | The department assigned to the transaction. | | Project | The project assigned to the transaction. | | Details | The additional information entered at the time of posting to identify the transaction. | | Net | The total net value. | | T/C | The tax code assigned to the transaction. | | Tax | The total tax value. | | Gross | The total gross value. | The report shows grand totals for the net, tax and gross amounts. Values are in the base currency.
Sales Credits to Projects - Summary - PJDYSCRS.report | Id | The project transaction ID. This is the number assigned to the transaction in the project audit trail, and is different from the audit trail number. | | Type | The transaction type, for example BP. | | A/C Ref | Customer account reference assigned to transaction. | | Date | The date of the transaction. | | Reference | The transaction reference. | | Project | The project assigned to the transaction. | | Details | The additional information entered at the time of posting to identify the transaction. | | Net | The total net value. | | Tax | The total tax value. | | Gross | The total gross value. | The report shows grand totals for the net, tax and gross amounts. Values are in the base currency.
Sales Invoices to Projects - Detailed - PJDYSIND.report | Id | The project transaction ID. This is the number assigned to the transaction in the project audit trail, and is different from the audit trail number. | | Audit No | The transaction number as shown on the audit trail. | | Type | The transaction type, for example BP. | | A/C Ref | Customer account reference assigned to transaction. | | Date | The date of the transaction. | | Reference | The transaction reference. | | N/C | The nominal code assigned to the transaction. | | Dept | The department assigned to the transaction. | | Project | The project assigned to the transaction. | | Details | The additional information entered at the time of posting to identify the transaction. | | Net | The total net value. | | T/C | The tax code assigned to the transaction. | | Tax | The total tax value. | | Gross | The total gross value. | The report shows grand totals for the net, tax and gross amounts. Values are in the base currency.
Sales Invoices to Projects - Summary - PJDYSINS.report | Id | The project transaction ID. This is the number assigned to the transaction in the project audit trail, and is different from the audit trail number. | | Type | The transaction type, for example BP. | | A/C Ref | Customer account reference assigned to transaction. | | Date | The date of the transaction. | | Reference | The transaction reference. | | Project | The project assigned to the transaction. | | Details | The additional information entered at the time of posting to identify the transaction. | | Net | The total net value. | | Tax | The total tax value. | | Gross | The total gross value. | The report shows grand totals for the net, tax and gross amounts. Values are in the base currency.
Stock Issues to Projects - Detailed - PJDYSID.report | Id | The project transaction ID. This is the number assigned to the transaction in the project audit trail, and is different from the audit trail number. | | Type | The transaction type, for example AO. | | Stock Code | The stock code assigned to the transaction. | | Date | The date of the transaction. | | Reference | The transaction reference. | | Project | The project assigned to the transaction. | | Cost code | The cost code assigned to the transaction. | | Details | The additional information entered at the time of posting to identify the transaction. | | Qty | The quantity of units. | | Price | The cost price of the stock code. | | Net | The total net value. This is the quantity multiplied by the price. | The report shows a grand total for the net amount. Values are in the base currency.
Stock Issues to Projects - Summary - PJDYSIS.report | Id | The project transaction ID. This is the number assigned to the transaction in the project audit trail, and is different from the audit trail number. | | Type | The transaction type, for example AO. | | Stock Code | The stock code assigned to the transaction. | | Date | The date of the transaction. | | Reference | The transaction reference. | | Project | The project assigned to the transaction. | | Details | The additional information entered at the time of posting to identify the transaction. | | Qty | The quantity of units. | | Price | The cost price of the stock code. | | Net | The total net value. This is the quantity multiplied by the price. | The report shows a grand total for the net amount. Values are in the base currency.
Stock Returns from Projects - Detailed - PJDYSRD.report | Id | The project transaction ID. This is the number assigned to the transaction in the project audit trail, and is different from the audit trail number. | | Type | The transaction type, for example AO. | | Stock Code | The stock code assigned to the transaction. | | Date | The date of the transaction. | | Reference | The transaction reference. | | Project | The project assigned to the transaction. | | Cost code | The cost code assigned to the transaction. | | Details | The additional information entered at the time of posting to identify the transaction. | | Qty | The quantity of units. | | Price | The cost price of the stock code. | | Net | The total net value. This is the quantity multiplied by the price. | The report shows a grand total for the net amount. Values are in the base currency.
Stock Returns from Projects - Summary - PJDYSRS.report | Id | The project transaction ID. This is the number assigned to the transaction in the project audit trail, and is different from the audit trail number. | | Type | The transaction type, for example AO. | | Stock Code | The stock code assigned to the transaction. | | Date | The date of the transaction. | | Reference | The transaction reference. | | Project | The project assigned to the transaction. | | Details | The additional information entered at the time of posting to identify the transaction. | | Qty | The quantity of units. | | Price | The cost price of the stock code. | | Net | The total net value. This is the quantity multiplied by the price. | The report shows a grand total for the net amount. Values are in the base currency.
Project details reports To find the reports: - Click Projects then click Reports then click Project details
For details of the information the report contains, refer to the following section.
Project Activity - PJACT.report This report shows each project, grouped by customer, with details of the transactions posted against each project. It shows the following information for each transaction: | Id | The project transaction ID. This is the number assigned to the transaction in the project audit trail, and is different from the audit trail number. | | Audit No | The transaction number as shown on the audit trail. This only appears for transactions posted to the audit trail - for example a stock transaction or project charge has no audit trail number. | | Type | The transaction type, for example AI for adjustment in. | | Date | The date entered for the transaction. | | Acc/Item | The account reference, resource reference or stock code to which the transaction was posted. | | Reference | The reference entered to identify the transaction, for example a cheque number. | | Ex Ref | The extra reference entered when the transaction was posted. | | Cost Code | The cost code used for the transaction. | | N/C | The nominal code to which the transaction was posted. | | Dept | The department to which the transaction was posted. | | Details | The additional information entered at the time of posting to identify the transaction. | | Net | The amount of the transaction, exclusive of VAT. |
Project Activity with Sales, Costs and Profit (exc Committed costs) - PJACTSCPX For each project, this report shows the individual sales transactions grouped together, then cost code transactions grouped together, excluding committed costs. It shows total sales, total costs, total profit and profit percentage. The report includes activity from any child projects that are set up in the structure tab.  NOTE: This report excludes updated sales invoices posted to nominal code 9998.
For each transaction it shows the following information: | Id | The project transaction ID. This is the number assigned to the transaction in the project audit trail, and is different from the audit trail number. | | Audit No | The transaction number as shown on the audit trail. This only appears for transactions posted to the audit trail - for example a stock transaction or project charge has no audit trail number. | | Type | The transaction type, for example AI for adjustment in. | | Date | The date entered for the transaction. | | Acc/Item | The account reference, resource reference or stock code to which the transaction was posted. | | Reference | The reference entered to identify the transaction, for example a cheque number. | | Ex Ref | The extra reference entered when the transaction was posted. | | Cost Code | The cost code used for the transaction. | | N/C | The nominal code to which the transaction was posted. | | Dept | The department to which the transaction was posted. | | Details | The additional information entered at the time of posting to identify the transaction. | | Net | The amount of the transaction, exclusive of VAT. |
Project Activity with Sales, Costs and Profit (inc Committed costs) - PJACTSCP For each project, this report shows the individual sales transactions grouped together, then cost code transactions grouped together, including committed costs. It shows total sales, total costs, total profit and profit percentage. The report includes activity from any child projects that are set up in the structure tab. NOTE: This report excludes updated sales invoices posted to nominal code 9998. For each transaction it shows the following information: | Id | The project transaction ID. This is the number assigned to the transaction in the project audit trail, and is different from the audit trail number. | | Audit No | The transaction number as shown on the audit trail. This only appears for transactions posted to the audit trail. For example a stock transaction or project charge has no audit trail number. | | Type | The transaction type, for example AI for adjustment in. | | Date | The date entered for the transaction. | | Acc/Item | The account reference, resource reference or stock code to which the transaction was posted. | | Reference | The reference entered to identify the transaction, for example a cheque number. | | Ex Ref | The extra reference entered when the transaction was posted. | | Cost Code | The cost code used for the transaction. | | N/C | The nominal code to which the transaction was posted. | | Dept | The department to which the transaction was posted. | | Details | The additional information entered at the time of posting to identify the transaction. | | Net | The amount of the transaction, exclusive of VAT. |
Project Audit Trail - PJAUDIT.report This report shows all transactions that have been processed to projects. For each transaction it shows the following information: | Id | The project transaction ID. This is the number assigned to the transaction in the project audit trail, and is different from the audit trail number. | | Audit No | The transaction number as shown on the audit trail. This only appears for transactions posted to the audit trail - for example a stock transaction or project charge has no audit trail number. | | Type | The transaction type, for example AI for an adjustment in. | | Date | The date entered for the transaction. | | Acc/Item | The account reference, resource reference or stock code to which the transaction was posted. | | Reference | The reference entered to identify the transaction, for example a cheque number. | | Ex Ref | The extra reference entered when the transaction was posted. | | Project | The reference of the project to which the transaction was posted. | | Cost Code | The cost code used for the transaction. | | N/C | The nominal code to which the transaction was posted. | | Dept | The department to which the transaction was posted. | | Details | The additional information entered at the time of posting to identify the transaction. | | Net | The amount of the transaction, exclusive of VAT. |
Project Card - PJCARD.report This report shows information about each project, taken from the Details and Analysis tabs of the project record. For each project it displays the following information: | Reference | The unique reference for the project. | | Customer | The name and address of the customer associated with the project. | | Start Date | The date on which the project started. | | End Date | The completion date of the project. | | Price Quoted | The price quoted to the customer for the project. | | Description | The additional information entered to describe the project. |
Project CSV Report - PJCSV.report This report lists the fields from each project record that are exported when the report is run to file and saved as a .CSV file. For each project record it contains the following information: | Reference | The unique reference for the project. | | Name | The project name. | | Status ID | The project status number. | | Start date | The date on which the project started. | | End date | The completion date of the project. | | Description | The additional information entered to describe the project. | | Customer ref. | The account reference of the customer associated with the project. | | Order number | The customer's order number from the project record. | | Contact name | The contact name from the Site Details area of the project record. | | Project address | The address from the Site Details area of the project record. | | Telephone | The telephone number from the Site Details area of the project record. | | Fax | The fax number from the Site Details area of the project record. | | Email | The email address from the Site Details area of the project record. | | Country code | The country code from the Site Details area of the project record. | | Price quoted | The price quoted to the customer for the project. |
Project List - PJLIST.report This report shows a list of all projects. For each project it displays the following information: | Reference | The unique reference for the project. | | Name | The additional information entered to describe the project. | | Customer Ref | The account reference of the customer associated with the project. | | Start Date | The date on which the project started. | | End Date | The completion date of the project. | | Price Quoted | The price quoted to the customer for the project. | The report also shows a total price quoted for all projects.
Project List by Status - PJLSTBST.report This report shows a list of all projects, grouped by status. For each project it displays the following information: | Reference | The unique reference for the project. | | Name | The additional information entered to describe the project. | | Customer Ref | The account reference of the customer associated with the project. | | Project Status | The description of the project status, for example Active. |
Project Summary (exc committed costs) - PJSUMMX.report This report shows details of the costs excluding committed costs, billed amounts and profit for each project. For each project it displays the following information: | Project No. | The project reference. | | Name | The project name. | | Customer Ref | The account reference for the customer associated with the project. | | Net Billed | The amount billed for the project, exclusive of VAT. | | Costs | The total of costs posted to the project, excluding committed costs. | | Profit | The profit made to date on the project, based on the amount billed and the total cost. | | Profit Margin | The net profit shown as a percentage of the net amount billed. | The report also displays total information for all costs and billed items.
Project Summary (inc committed costs) - PJSUMM.report This report shows details of the costs including committed costs, billed amounts and profit for each project. For each project it displays the following information: | Project No. | The project reference. | | Name | The project name. | | Customer Ref | The account reference for the customer associated with the project. | | Net Billed | The amount billed for the project, exclusive of VAT. | | Costs | The total of costs posted to the project, including committed costs. | | Profit | The profit made to date on the project, based on the amount billed and the total cost. | | Profit Margin | The net profit shown as a percentage of the net amount billed. | The report also displays total information for all costs and billed items.
Revenue Summary - PJREVSUM.report This report shows details of the costs and billed amounts for each project. For each project it displays the following information: | Project | The project reference and name. | | Customer Ref | The account reference for the customer associated with the project. | | Status | The current project status, for example Active. | | Date Last Billed | The last date when the customer was billed. | | Date Last Cost | The date of the last cost entered to the project. | | Price Quoted | The price quoted to the customer. | | Total Cost | The total of all costs posted to the project. | | Billed Net | The amount billed for the project, exclusive of VAT. | | Billed Tax | The VAT amount billed for the project. | | Billed Total | The amount billed for the project, inclusive of VAT. | | Outstanding | The amount left to bill for the project, based on the price quoted and amount already billed. | | Profit | The profit made to date on the project, based on the amount billed and the total cost. | The report also displays total information for all costs and billed items.
Status List - PJSTLST.report This report shows each project status you've set up, along with the settings assigned to each status. For each status it shows the following information: | Status Id | The project status number. | | Reference | The unique status reference, for example SNAG. | | Name | The description of the project status, for example 'Completed, open'. | | Is Default | Whether the project status is set as default. | | Allow Posting | Whether posting is allowed to a project with this status. | | Allow Delete | Whether a project set with this status can be deleted. |
Project profit reports To find the reports: These reports provide information about the profit made on projects. For details of the information each report contains, refer to the following sections.
Project Profitability by Customer by Date - PJPROFTRCUST.REPORT This report shows a net profit value for each project and customer, and a total net profit value for all projects included in the report. For each project it shows the following information: | Default Customer Ref | The account reference for the customer associated with the project. | | Project | The project reference and name. | | Project Status | The current project status, for example Active. | | Date Last Billed | The last date when the customer was billed. | | Date Last Cost | The date of the last cost entered to the project. | | Total Quoted | The price quoted to the customer. | The report then calculates the profit by taking the net amount of invoices to each project, minus the net amount of any project costs.
Project Profitability by Date - PJPROFTR.REPORT This report shows a net profit value for each project, and a total net profit value for all projects included in the report. For each project it shows the following information: | Project | The project reference and name. | | Default Customer Ref | The account reference for the customer associated with the project. | | Project Status | The current project status, for example Active. | | Date Last Billed | The last date when the customer was billed. | | Date Last Cost | The date of the last cost entered to the project. | | Total Quoted | The price quoted to the customer. | The report then calculates the profit by taking the net amount of invoices to each project, minus the net amount of any project costs.
Profit Report by Customer and Project - Excluding Committed Costs - PJPROFCU.REPORT This report groups projects together by the customer account and shows the cost and net billed to date for each project and gives a profit based on net billed minus costs. For each project it shows the following information: | Project | The project reference and name. | | Default Customer Ref | The account reference for the customer associated with the project. | | Project Status | The current project status, for example Active. | | Date Last Billed | The last date when the customer was billed. | | Date Last Cost | The date of the last cost entered to the project. | | Total Quoted | The price quoted to the customer. | For each cost code it shows the following information: | Cost Code | The unique cost code reference, for example LAB. | | Description | The cost code description, for example Labour. | | Net | The amount posted using this cost code, exclusive of VAT. | The report also shows total billed, costs and profit values for each cost code, customer and for the whole report.
Project Profitability - Excluding Committed Costs - PJPROFIT.REPORT This report shows the cost and net billed to date for each project and gives a profit based on net billed minus costs. For each project it shows the following information: | Project | The project reference and name. | | Default Customer Ref | The account reference for the customer associated with the project. | | Project Status | The current project status, for example Active. | | Date Last Billed | The last date when the customer was billed. | | Date Last Cost | The date of the last cost entered to the project. | | Total Quoted | The price quoted to the customer. | For each cost code it shows the following information: | Cost Code | The unique cost code reference, for example LAB. | | Description | The cost code description, for example Labour. | | Net | The amount posted using this cost code, exclusive of VAT. | The report also shows total billed, costs and profit values for each cost code and for the whole report.
Project Profitability by cost code (detailed) - PJPROFCCD.REPORT This report shows the individual sales transactions and cost code transactions and gives a profit based on net billed minus costs. For each project it shows the following information: | Project | The project reference and name. | | Customer | The account reference and name of the customer associated with the project. | | Project Status | The current project status, for example Active. | | Date Last Billed | The last date when the customer was billed. | | Date Last Cost | The date of the last cost entered to the project. | | Total Quoted | The price quoted to the customer. | For each sales and cost code transaction it shows the following information: | Project Tran No. | The project transaction ID. This is the number assigned to the transaction in the project audit trail, and is different from the audit trail number. | | Audit No. | The transaction number as shown on the audit trail. This only appears for transactions posted to the audit trail - for example a stock transaction or project charge has no audit trail number. | | Type | The transaction type, for example, AI for adjustment in. | | Date | The date entered for the transaction. | | Acc/Item | The account reference, resource reference or stock code to which the transaction was posted. | | Reference | The reference entered to identify the transaction, for example a cheque number. | | Details | The additional information entered at the time of posting to identify the transaction. | | Actual Net | The amount of the transaction, exclusive of VAT. | For each project the report also shows total billed, total for each cost code, total costs and total profit. It also shows total profit for the whole report.
Purchase orders reports To find the reports: For details of the information each report contains, please refer to the following sections.
Purchase Orders Received Per Project - PJRECPOP.REPORT The Purchase Orders Received Per Project report - PJRECPOP.report, lists the project transaction date, order number and stock details of delivered stock items, including the quantity ordered, quantity delivered, discount rate and value of goods delivered. A total value is shown per project and for the whole report. | Ord No. | The purchase order number. | | Date | The date of the purchase order. | | Stock Code | The stock code on the purchase order. | | Description | The description of the stock code. | | Quantity Ordered | The quantity of stock ordered. | | Discount % | The discount assigned to the item. | | Price | The net price of the item. |
Resources reports To find the reports: - Click Projects then click Reports then click Resources
For details of the information each report contains, refer to the following sections.
Resource Activity - PJRESACT.report | Id | The project transaction ID. This is the number assigned to the transaction in the project audit trail, and is different from the audit trail number. | | Date | The date of the transaction. | | Reference | The transaction reference. | | Project | The project assigned to the transaction. | | Cost code | The cost code assigned to the transaction. | | Details | Further details about the transaction. | | Quantity | The quantity entered. | | Rate | The rate per unit. | | Net | The net value of the transaction. | Resource List - PJRESLST2.report | Resource Id | The resource ID number. | | Reference | The resource reference. | | Name | Description of the resource | | Unit | The unit of measure for the rate. | | Rate | The cost per the unit of measure. | | ID | Default cost code ID. | | Cost Code Ref | Default cost code reference. | | Cost Code Name | Default cost code description. |
Stock allocation reports To find the reports: For details of the information each report contains, please refer to the following sections.
Stock Allocations Per Project - PJSTKALL.report | Stock code | The stock code reference of the product. | | Details | Details of the product. | | Ord No. / Ref. | Purchase order number or allocation reference, depending on the transaction type. | | Date | Date of the allocation. | | Cost Code | Cost code reference. | | Initial Qty Allocated | Initial quantity allocated to the project. | | Qty Issued | Quantity issued to the project. | | Qty left Allocated | Remaining quantity allocated to the project. | | Value to Allocated | Net value of remaining quantity allocated. |
[BCB:19:UK - Sales message :ECB]
|