Exchequer Invoice Report¶
The Exchequer Invoice Report serves as a crucial tool for generating sales invoice upload data tailored for Exchequer, an accounting software offered by The HBP Group. This report streamlines the process of invoicing by compiling key transactional information into a structured format compatible with Exchequer's requirements. This report has evolved through several updates to enhance functionality and address specific user needs. By extracting data from various tables in the database and applying filters to exclude certain invoice statuses, the report ensures accuracy and relevance in the generated output. With its user-friendly design and comprehensive data fields, the Exchequer Invoice Report facilitates efficient invoicing workflows, empowering users to manage their financial transactions seamlessly.
Before you start¶
Before getting started, there are a couple of helpful things to know:
- The report is designed to create sales invoice upload data for Exchequer, an accounting software by The HBP Group.
- The date from and to fields relate to the invoicing dates.
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 |
|---|---|---|
| Invoice_Number1 | Text | Invoice number for internal reference. |
| Transaction_Type1 | Text | Type of transaction (e.g., sales invoice). |
| Customer_Code1 | Text | Code or identifier for the customer associated with the invoice. |
| Invoice_Number | Text | Invoice number for accounting purposes. |
| Invoice_Date1 | Date/Time | Date of the invoice. |
| Currency | Text | Currency used for the transaction. |
| Ex_Rate | Number | Exchange rate for the currency conversion. |
| Total_VAT1 | Number | Total VAT amount in the invoice currency. |
| Total_VAT2 | Number | Total VAT amount in the local currency. |
| Manual_VAT1 | Text | Indicates whether VAT was manually calculated or not. |
| ID | Text | Identifier for the transaction. |
| AnalysisCode | Text | Code for analysing the transaction. |
| Dep__Sales_Rep | Text | Department or sales representative associated with the transaction. |
| G_L_Code | Text | General ledger code or account code for the transaction. |
| Quantity | Number | Quantity of items or units. |
| Price | Number | Price per unit. |
| VAT_Code | Text | VAT code or tax rate applied to the transaction. |
| VAT_Amount | Number | VAT amount for the transaction. |
| Other_ref | Text | Additional reference or description for the transaction. |
| Order_Number | Text | Order number associated with the transaction. |
| customerorderno | Text | Customer order number or reference. |
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.