Exchequer Credit Note Report¶
The Exchequer Credit Note Report provides a comprehensive overview of credit transactions processed within the Exchequer accounting software, developed by The HBP Group. This report is designed to assist users in tracking and managing credit note activities effectively. It includes details such as credit note numbers, transaction types, customer codes, dates of issuance, currency information, VAT calculations, line item details, reference numbers, and status filtering to exclude voided or draft credit notes. With its detailed insights, the report enables users to monitor credit transactions, reconcile accounts, and ensure accurate financial management within the Exchequer system.
Before you start¶
Before getting started, there are a couple of helpful things to know:
- The report is designed to create credit note 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 excludes credit notes with status labels such as "Voided" or "Draft" to focus on valid credit transactions.
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 |
|---|---|---|
| Credit_Note_Number1 | Text | The prefixed credit note number, formatted for Exchequer. |
| Transaction_Type1 | Text | The transaction type, typically denoted as "SCR" for credit notes. |
| Customer_Code1 | Text | The customer code associated with the credit note. |
| Credit_Note_Number | Text | The credit note number. |
| Credit_Note_Date1 | Date/Time | The date of the credit note issuance. |
| Currency | Number | The currency used for the credit note. |
| Ex_Rate | Number | The exchange rate for currency conversion. |
| Total_VAT1 | Number | The total VAT amount. |
| Total_VAT2 | Number | The total VAT amount (duplicate field). |
| Manual_VAT1 | Text | Indicates if VAT is manually calculated ("Yes" or "No"). |
| ID | Text | Identification or reference for the credit note. |
| AnalysisCode | Text | Analysis code for categorising or analysing the credit note. |
| Dep__Sales_Rep | Text | Department or sales representative associated with the credit note. |
| G_L_Code | Number | General ledger code or account code. |
| Quantity | Number | Quantity of items associated with the credit note. |
| Price | Number | Price per item. |
| VAT_Code | Text | VAT code or rate applied to the credit note. |
| VAT_Amount | Number | Amount of VAT applied. |
| Other_ref | Text | Other reference or description for the credit note. |
| Order_Number | Text | Order number associated with the credit note. |
| customerorderno | Text | Customer order number related to the credit note. |
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.