Introduction
...
Uninvoiced Costs
This report shows completed projects where supplier invoicing has not been completed
| Filters | Purpose |
| Completed Date | The report will show completed projects within the selected date range |
| Supplier | Filter projects by specific suppliers |
...
Uninvoiced Sale
This report shows completed projects where supplier invoicing has not been completed
| Filters | Purpose |
| Completed Date | The report will show completed projects within the selected date range |
| Supplier | Filter projects by specific suppliers |
...
| Column | Description |
| Customer | The name of the customer on the order |
| User | The name of the customer user on the order |
| Group | The group of the customer users within the Customer |
| Customer Tag | The tag assigned to the customer Customer |
| Purchase Order | The purchase order number on the project |
| Order Ref | The order reference |
| Date Ordered | Date the order was placed |
| Delivery Date | Delivery Date set on stock order |
| Despatch Date | The date the project was despatched |
| FAO | The user set as the FAO on the order |
| Company | The company on the delivery address |
| Street | The street on the delivery address |
| City | The city on the delivery address |
| County | The county on the delivery address |
| Postcode | The postcode on the delivery address |
| Country | The country on the delivery address |
| Courier | The courier set on the order |
| UID | The unique ID for each stock order |
| Delivery Ref | The delivery reference |
| Item Ref | The item code being ordered |
| Description | The item description |
| Unit Price (GBP) | The price of each unit |
| Quantity | The quantity of the item being ordered |
| Boxes (GBP) | The quantity of the item being ordered if in boxes |
| Value | The total value of the stock item being ordered |
| Delivery Cost (GBP) | The delivery cost value |
| Delivery Sale (GBP) | The delivery sale value |
Sourcing by Order Date
Summarises minimum, maximum, average and selected supplier costs for each ordered job
| Filters | Purpose |
|---|---|
| Order Date | Search for Project Parts that were ordered within the date range |
| Customer Tag | Select customers by their customer tag or all customers to report on |
Output
| Column | Description |
|---|---|
| Customer | The customer on the project |
| Contact | The customer user on the project |
| Product Category | The category set against the item being ordered |
| Service | The service requested by the customer |
| Project Ref | The project reference |
| Order Ref | The order reference |
| Project Title | The project title |
| Created | The date the project was created |
| Quoted | The date the project was quoted |
| Ordered | The date the project was ordered |
| Quote Days | The amount in days between the quote request being sent and responses received |
| Quantity | The total quantity of the project |
| Number of Suppliers | The total number of suppliers on the project |
| Number of Responses | The total number of responses received |
| Selected Supplier | The winning supplier |
| Other Suppliers | Other suppliers selected on the project |
| Max Cost | The maximum cost possible on the project |
| Avg Cost | The average cost across the project |
| Min Cost | The minimum cost possible on the project |
| Selected Cost | The cost of the selected supplier |