Purchase Ordering:

Suppliers:
A standard form is featured to maintain and append Suppliers details. This incorporates the following:

1.	A combo for rapid record finding
2.	A ‘Get-Data’ command button. This is used to launch an in-built ‘Raw-Data’ MS Excel worksheet template named RawData.xls, providing for name and address lists to be copy/pasted en-masse. When the template is populated in accordance with the specified columns, its contents are automatically imported into the Suppliers facility

The Supply List:
The ‘Supply List’ sub-form displays the contents of an MS Excel worksheet template named SupplyList.xls. This provides for supplier catalogue items to be copy/pasted en-masse. It is launched automatically by means of a command button, featured within the sub-form. All of the contents of this template populate the material items pick-posting lists within the Job Quoting/Costing and the Purchase Order Processing facilities. Importantly, changes that are instigated within the template will be mirrored in the pick-lists.

The Purchase Ordering Facility:
A standard form is provided to record individual purchase order details, within which the supplier is pick-posted and ‘Order Date – Required Date’ are directly typed, along with the Order No. An accompanying sub-form list displays all previously posted items. A supplementary ‘Post Stock Item’ form is brought into view when the ‘Post Item’ command button is used. Within this, items relating to the chosen supplier are pick-posted and the required quantities are directly typed. On the completion of a particular item posting operation, the form closes and the accompanying sub-form list automatically updates to show the newly posted item.

Users are forced to amend the accompanying sub-form list in compliance with delivery situations. Initially, the ‘Delivered Quantity’ field defaults to zero and the ‘Due’ field shows the ordered quantity. When the ‘Delivered Quantity’ field is amended, the ‘Due’ field automatically re-calculates – ordered minus delivered – but the ‘On Order’ field remains checked until its tick is manually removed. With the completion of delivery amendments the ‘In-Stock’ list is automatically adjusted.

Customers:
A standard form is provided, to append and amend customer details. Within this, a ‘Rapid Find’ combo is featured. Where the Quoting/Job Costing facility operates within the INTREPs ‘Bespoke’ framework, the displayed customers details are linked to ‘Bespoke’s Sales Order Processing’ facility. Changes completed in one are always mirrored in the other.

Job Finding and Job Details Reporting:
The jobs ‘Find’ list within the job costing form is divided, to separate long-term finished records from current ones. The divisions are as follows:
  FINISHED
  NOT QUOTED
  QUOTED – NOT STARTED
  STARTED – NOT FINISHED

Summary reports are included within each of these choices, displaying:
1. Job No
2. Customer name
3. Quote date
4. Job drawing description
5. Total labour value
6. Total materials value
7. Total job value
8. Mark-up value

---