Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. A customer order has been received for the part and at least 1 supplier order (PO) has been sent.
  2. The project has not been marked as ‘closed’.
  3. All of the sales invoicing has NOT been issued (i.e. there are still sales invoices pending for this project part).
  4. Not all of the supplier invoices have been received.

Filters


FiltersPurpose
Date OrderedSearch for Project Parts that were ordered by Customer within the date range
CustomerSelect which customer or range of customers to report on.


Output

ColumnDescription
Project RefThe project reference.
Part RefThe project part reference.
Customer POThe purchase order entered when placing the order
StatusThe status of the project part
CustomerThe customer
ContactThe end user who placed the order.
Part TitleThe title of the project part.
QuantityThe quantity ordered
Costs to dateThe total of the authorised supplier purchase orders for the part.
Sale to dateThe ‘sale’ value currently showing on the project.
Rep CodeThe ‘rep-code’ of the ‘rep’ associated with the project’s Customer.
Order DateThe date the job part was ordered.
Delivery DateThe date the project part will be delivered.
Customer InvoicedDate the customer invoice was issued
Suppliers InvoicedThe most recent date a supplier invoice was received
Nominal LedgerThe nominal ledger code for the Customer
AdministratorThe administrator assigned to the project part


...