POS Invoices - Row Fields
The fields that you can use when you design the Form Template to be used by the POS Invoice form are listed on two pages, as follows:
---
Row fields will be printed once for each Invoice row, so in each one you should specify a Line Height and set the Format to "Matrix". If you do not want to print the decimal places in numeric fields, choose the Cut Decimals option in the record in the Values in Text setting for the Language specified in the Company Info setting. This will remove the decimals even in fields where you have used the Field Argument to control the rounding.
Please refer to the 'USB/Wifi Receipt Printers with user-definable print-outs' section on the USB/Wifi Receipt Printers with user-definable print-outs page for guidelines that will be useful when designing the Form Template.
| Field in Form Template | Prints (from POS Invoice) |
| |
| Country of Origin (origincountry) | If the Item has a Default Purchase Item, Country of Origin from that Purchase Item. The Default Purchase Item will be chosen in this order: with the Location from the Invoice row, with the Location from the Invoice header, with no Location. |
| Customer Item Code | Cust. Item No. (brought in from the Customer Items setting in the Sales Orders module) |
| Description 1 | Description |
| Discount | % |
| Item Code | Item |
| Item Price | Base Price from the Item |
| Price, row | Unit Price - (VAT value of the row/Qty) (you should only use this field in POS Invoices in which prices include VAT) |
| Row Base | Sum excluding VAT (i.e. prints Sum in Invoices in which prices exclude VAT, or Sum - VAT otherwise). |
| Row Number | Row number (only printed if a row has an Item, use "Transaction Row" if you need a row number printed for every row) |
| Row Number in text | Row number in text (only printed if a row has an Item), taken from the Values in Text record for the Language of the Invoice or the Language in the Company Info setting |
| Row Sum | Sum |
| Row Sum If No VAT | Sum - VAT value of the row (you should only use this field in POS Invoices in which prices include VAT) |
| Quantity | Qty ("0" will be printed for zero quantities) |
| Quantity 2 | Qty * Unit Coefficient from the Item record, or Qty / Unit Coefficient from the Item record (depends on the Unit 2 Conversion Calculation options in the Stock Settings setting) |
| Serial Number (serienr) | Serial No |
| Total Row | Sum including VAT (i.e. prints Sum in Invoices in which prices include VAT, or Sum + VAT otherwise). |
| Usually, the number of decimal places will obey the Default for Calculated Values rounding rules set in the Round Off setting. However, although you can overrule this by entering "0" or a positive number as the Field Argument. For example, to round to the nearest whole number, enter "0", or to round to one decimal place, enter "1" |
| Transaction Row | Row number |
| Unit | If the Item has a Unit, the correct translation for the Language of the Invoice of the Comment from the Units setting, the Comment itself or the Unit Code |
| Unit Code | Unit |
| Unit Price | Unit Price. This field prints the Unit Price as shown on screen in the Invoice record (i.e. including VAT in Invoices in which prices include VAT, excluding VAT otherwise). |
| This figure will be rounded to a maximum of three decimal places if, in the Round Off setting, you have set Discount Calculation to "Row Sum". If you have set Discount Calculation to "Unit Price", rounding will obey the Default for Calculated Values rounding rules in the same setting. However, you can overrule this by entering "0" or a positive number as the Field Argument. For example, to round to the nearest whole number, enter "0", or to round to one decimal place, enter "1" |
| Unit Price excl VAT | Unit Price excluding VAT (i.e. prints Unit Price - VAT in Invoices in which prices include VAT, or Unit Price otherwise). |
| This figure will be rounded to a maximum of three decimal places if you have set Discount Calculation to "Row Sum" in the Round Off setting. If you have set Discount Calculation to "Unit Price", rounding will obey the Default for Calculated Values rounding rules in the same setting. However, you can overrule this by entering "0" or a positive number as the Field Argument. For example, to round to the nearest whole number, enter "0", or to round to one decimal place, enter "1" |
| VAT Code | V-Cd |
| VAT % excl., row | VAT rate |
| VAT %, row | VAT rate |
| VAT Value, row | VAT value of the row. |
| Usually, the number of decimal places will obey the Default for Calculated Values rounding rules set in the Round Off setting. However, you can overrule this by entering "0" or a positive number as the Field Argument. For example, to round to the nearest whole number, enter "0", or to round to one decimal place, enter "1" |
Batch Specification Information (Jewellery module)
If there is a Serial Number in a POS Invoice row, the following row fields will print information from the record in the
Batch Specifications setting for the Item/Serial Number combination (from fields in the Batch Specifications setting that will only be visible if you are using the
Jewellery module). In these fields, you should specify a Line Height and set the Format to "Matrix":
| Field in Form Template | Prints (from Batch Specification record) |
| |
| Bracelet/Strap | Bracelet/Strap |
| Certificate | Certificate |
| Clarity | Clarity |
| Colour | Colour |
| Gender | Gender |
| Length | Length |
| Major Stone | Major Stone Detail |
| Metal | Metal |
| Minor Stone | Minor Stone Detail |
| Movement | Movement |
| Other Comment | Other |
| Other Comment 2 | Other2 |
| Size | Size |
| Style Name | Style Name |
| Supplier Serial No. | Supplier Serial No. |
| Watch Brand | Watch Brand |
| Watch Metal | Watch Metal |
| Weight | Weight |
Receiving Gift Vouchers in Payment
The following additional fields will only be printed from rows recording the receiving of Gift Vouchers in payment. You should specify a Line Height and set the Format to "Matrix" in these fields:
| Field in Form Template | Prints |
| |
| Gift Voucher No. | Gift Voucher Number |
The following standard row fields will also be printed from rows recording the receiving of Gift Vouchers in payment. You may have included some of these fields in the Form Template as a matter of course, because of the information that they print from "normal" rows. Row fields not listed will not be printed from rows recording the receiving of Gift Vouchers in payment.
| Field in Form Template | Prints |
| |
| Description 1 | The Label of the "Gift Voucher" button that was used to receive the Gift Voucher in payment, as defined in the POS Buttons setting |
| Item Code | Gift Voucher Number |
| Quantity | Prints "1" |
| Row Sum | Gift Voucher payment amount |
| Row Text | Prints "Gift Voucher Received" |
Note: these six fields will not be printed (i.e. nothing will be printed from these rows) if you have included the "Payment Mode Summary (Amount)" or the "Payment Mode Summary (Text)" fields in the Form Template.
Selling Gift Vouchers
The following additional fields will only be printed from rows recording the sale of Gift Vouchers. You should specify a Line Height and set the Format to "Matrix" in these fields:
| Field in Form Template | Prints |
| |
| Gift Voucher Expiry Date | Expiry Date of the Gift Voucher |
| Gift Voucher No. | Gift Voucher Number |
The following standard row fields will also be printed from rows recording the sale of Gift Vouchers. You may have included some of these fields in the Form Template as a matter of course, because of the information that they print from "normal" rows. Row fields not listed will not be printed from rows recording the sale of Gift Vouchers.
| Field in Form Template | Prints |
| |
| Description 1 | The Comment from the relevant Gift Voucher |
| Item Code | Gift Voucher Number |
| Quantity | Prints "1" |
| Row Sum | Value of the sold Gift Voucher |
| Row Text | Prints "Gift Voucher Sold" |
---
Go to:
See also:
Guidelines that will be useful when designing the Form TemplateForms in the Point of Sales module:
Go back to:
