...
Filters | Purpose |
Date Ordered | Search for Project Parts that were ordered by Customer within the date range |
Customer | Select which customer or range of customers to report on. |
Output
Column | Description |
Project Ref | The project reference. |
Part Ref | The project part reference. |
Customer PO | The purchase order entered when placing the order |
Status | The status of the project part |
Customer | The customer |
Contact | The end user who placed the order. |
Part Title | The title of the project part. |
Quantity | The quantity ordered |
Costs to date | The total of the authorised supplier purchase orders for the part. |
Sale to date | The ‘sale’ value currently showing on the project. |
Rep Code | The ‘rep-code’ of the ‘rep’ associated with the project’s Customer. |
Order Date | The date the job part was ordered. |
Delivery Date | The date the project part will be delivered. |
Customer Invoiced | Date the customer invoice was issued |
Suppliers Invoiced | The most recent date a supplier invoice was received |
Nominal Ledger | The nominal ledger code for the Customer |
Administrator | The administrator assigned to the project part |
Profit By Customer
Profitability by customer for project parts and orders where all invoicing is complete, filtered by invoice date.
...