Cost transactions enquiry

Use the Cost Transactions enquiry to inspect your project cost transactions. You can view all the details, such as the date, cost type (timesheet or purchase order), reference number, source (supplier account or resource), project and project item, details (narrative), cost quantity, cost and charge rates, total cost, bill value, and transaction URN.

You can set the reports to show only fully billed transactions or outstanding transactions.

To use the cost transactions enquiry

Open: Project Accounting > Project Enquiries > Transactions > Cost Transactions.

  1. By default, all cost transactions are displayed. To filter the information displayed in the enquiry, use the criteria to select the information that you want to show.

    • To see fully billed transactions only, select Billed Status Is Fully Billed.
    • To see outstanding transactions only, select Billed Status Is Not Fully Billed.
  2. By default all document types are displayed. To filter the information, use the criteria to select the document type that you want, for example, purchase order or sales invoice.
    • If you filter by document type, you can also filter by document number, using the criterion which appears beneath the selected Document Type.
  3. You can filter on Transaction type to see different types of transaction, including Confirmed Price Adjustment transactions.
  4. Use the Customer filter to view cost of sales transactions relating to a project that you have a billing contract for.

    5. Note: The label for the Customer filter is configurable.

  5. Click OK. The project enquiry appears.

    6. Depending on the SOP Setting, Update stock quantities when, and the Document Type filter selected, transactions are displayed as follows:

    Update stock quantities when Document Type Displays cost transactions of type

    Invoice is posted

    		 SOP Invoice

    Stock Issues

    Confirmed Price Adjustments

    Invoice is posted

    		 SOP Credit Note

    Stock Returns

    Order despatch is confirmed

    No cost transactions are returned.

    Transactions are displayed that link back to the Document Type selected.

    Document Type Transactions displayed
    Purchase Order Actual and Potential
    Purchase Return Actual and Potential
    Sales Order Actual and Potential
    Sales Return Actual and Potential
    Sales Quote Actual and Potential
    SOP Invoice Actual
    SOP Credit Note Actual
  6. To display further information about a transaction, right-click on the item and select:
    • Transaction Detail, to display details of the project transaction, including WIP Nominal code, WIP value, Finalised Bill no and Finalised date.
    • Project Record, to display the project structure and details.
    • Supplier Record (for purchase orders or credits), to display details of the supplier account (Purchase Ledger).
    • Stock Record (for project stock issues), to display the stock item details (Stock Control).
  7. To search for a transaction, right-click in the window and select Find.
  8. To export the details of the transactions to Excel, right-click in the window and select Export and then select All to Excel or Selected to Excel.
  9. To print the information displayed in the enquiry, click Print.
See also

Overview

Project workspaces and enquiries

Reference

Project reports

Understanding project budgeting

Project Accounting billing