Exchequer Purchase Order Report¶
The Exchequer Purchase Order Report is a vital tool tailored for Exchequer, an accounting software provided by The HBP Group. It simplifies the purchase order process by compiling essential transactional data into a format compatible with Exchequer's requirements. By extracting data from different database tables and applying filters to exclude specific invoice statuses, it guarantees accurate and pertinent output.
Before you start¶
Before getting started, there are a couple of helpful things to know:
- The report is designed to create purchase order upload data for Exchequer, an accounting software by The HBP Group.
- The date from and to fields relate to the credit note date.
- The report includes only purchase orders with an "Authorised" status. Make sure that all relevant purchase orders have been authorised in the system to appear in the report.
Exchequer
Exchequer is an accounting software by The HBP Group. If you have not heard of or use Exchequer then you do not need to use this report.
Fields in the report¶
| Field Name | Format Type | Description |
|---|---|---|
| Link Ref | Text | Reference linking to the purchase order |
| Alt Ref | Text | Alternative reference for the purchase order |
| Your Ref | Text | Your reference for the purchase order |
| Type | Text | Type of transaction (e.g., purchase order) |
| A/c Code | Text | Account code associated with the purchase |
| Order Date | Date/Time | Date when the purchase order was placed |
| Delivery Add1 | Text | Delivery address line 1 |
| Delivery Add2 | Text | Delivery address line 2 |
| Delivery Add3 | Text | Delivery address line 3 |
| Delivery Add4 | Text | Delivery address line 4 |
| Delivery Add5 | Text | Delivery address line 5 |
| Header Currency | Text | Currency used for the header of the purchase order |
| Line Currency | Text | Currency used for each line item in the purchase order |
| Stock Code | Text | Code identifying the stock or item ordered |
| Location | Text | Location where the order will be delivered |
| Qty | Number | Quantity of the item ordered |
| lineDescription | Text | Description of the line item |
| Unit Price | Number | Price per unit of the item ordered |
| VAT Code | Text | VAT code applied to the item |
| Vat Amount | Number | Amount of VAT applied to the item |
| GL Code | Text | General ledger code |
| Cost Centre | Text | Cost centre associated with the purchase |
| Dept | Text | Department associated with the purchase |
| Other_ref | Text | Any other reference related to the purchase order |
| Order_Number | Text | Number identifying the purchase order |
Frequently asked questions¶
What is a field?
A field refers to a single piece of data within a dataset, also known as a column or attribute. It represents a specific characteristic or attribute of the data being collected or analysed. For example, in a dataset of opportunity information, fields may include "department," "salesType," "customerSite," and "lostReason".
Why do your field names look funny?
We use a computer programming convention called camel case (more accurately lower camel case) where multiple words are combined into a single word, with each word (except the first one) capitalised and no spaces between the words. The name "camel case" comes from the capitalisation's resemblance to the humps of a camel.