Stock Movement Invoices - Row Fields
The fields that you can use when you design the Form Template to be used by the Stock Movement Invoice form are listed on two pages, as follows:
---
Row fields will be printed once for each row in a Stock Movement, so remember to specify a Line Height in each one and to 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.
Stock Movement Row Fields | Field in Form Template | Prints (from Stock Movement row) | | | | Item Cost Price Sum | Rcvd. Qty * Cost Price from the Item record | | Quantity Conversion 1 , Quantity Conversion 2 , Quantity Conversion 3 | If the Item record has a Conversion 1 and a Conversion 2, these fields print the Rcvd. Qty converted as appropriate. Please refer to the description of these fields here for details and an example | | Volume, row | Rcvd. Qty * Item Volume from the Item record | | Weight | Rcvd. Qty * Weight from the Item record |
Order Row Fields Row fields will be printed once per row in the Order from which a Stock Movement was created, so remember to specify a Line Height in each one and to set the Format to "Matrix".
This list describes the row fields that will be printed from "normal" Order rows: please refer to subsequent sections for other types of row (e.g. "Subtotal" rows, etc). An Order that contains rows of one of more of these types will usually contain "normal" rows as well. You can include row fields of all kinds in a Form Template: they will be printed as appropriate from each row, printing the appropriate information for the type of row.
If you need fields in rows of different types to be printed with different Styles and Line Heights, use the 'Row Styles' function on the Operations menu of the Form Template window.
| Field in Form Template | Prints (from Order row) | | | | Amount Rounded | (Unit Price * Qty) rounded to the nearest whole number | | Cost Price | Cost (from flip C) | | Customer Item Code | Cust. Item No. (from flip B) | | Delivered Quantity | Del. | | Delivered Quantity (antallev) | Prints the Qty if the Item has a Default Purchase Item (for the Location in the Order row or, if blank, in the header) or blank otherwise | | Delivery Date, row | Desp. Date (from flip G) | | Delivery Time, row | Desp. Time (from flip G) | | Depth per unit | Depth (from flip H) | | Description 1 | Description | | Discount | %. | | The number of decimal places will be as shown on screen in the Order record, 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" | | Discount Specification | % formatted as a negative percentage. For example, if the % is "5", it will be printed as "-5%" | | Discount, Supplier | Prints the % if the Item has a Default Purchase Item (for the Location in the Order row or, if blank, in the header) or blank otherwise | | Height per unit | Height (from flip H) | | In-loading Date, row | Inl. Date (from flip G) | | In-loading Time, row | Inl. Time (from flip G) | | Item Code | Item | | Item Code 2 | Item | | Item Price | If the prices in an Order include VAT, this field will print the Unit Price including discount but excluding VAT. If the prices in an Order do not include VAT, it will print the Unit Price excluding discount but including VAT | | Item Varieties | The portion of the Item Description representing Varieties. For example, if the Item Description is "Shirt, Green, Small", "Green, Small" will be printed. If the Item does not have Varieties, nothing will be printed | | Item Without Varieties | The basic Item Number, without any portion representing Varieties. For example, if the Item Number is "10126.GRE.SM", "10126" will be printed | | Left to Deliver | Qty - Del. (blank will be printed for zero quantities, use "Remaining Quantity" if you need "0" to be printed) | | Left to Deliver in Weight | (Qty - Del.) * Weight from the Item record | | Location, row | Location (from flip F) | | Order Row Description | Prints the Description if the Item has a Default Purchase Item (for the Location in the Order row or, if blank, in the header) or blank otherwise | | Ordered Quantity | Qty | | Picking Date, row | Pick. Date (from flip G) | | Picking Time, row | Pick. Time (from flip G) | | Planned Delivery Date, row | Plan. Del. (from flip E) | | Price Factor | Price Factor (from flip E) | | Price in Base Currency 1 | Unit Price, converted to Base Currency 1 | | Price in Base Currency 1, row | Unit Price * Qty, converted to Base Currency 1 | | Price in Base Currency 2 | Unit Price, converted to Base Currency 2 | | Price in Base Currency 2, row | Unit Price * Qty, converted to Base Currency 2 | | Price including Discount, row | Prints the Unit Price including discount, calculated using the formula (Unit Price / Price Factor) - (Unit Price / Price Factor) * Discount / 100). This figure will include VAT in Orders in which prices include VAT, or exclude VAT otherwise | | Price per Unit (incl. Price Factor) | Unit Price / Price Factor (if there is a Price Factor) or Unit Price | | 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) | | Recipe Code | Recipe (from flip D) | | Remaining Quantity | Qty - Del. ("0" will be printed for zero quantities, use "Left to Deliver" if you need blank to be printed) | | Row Base in Base Currency 1 | Unit Price * Qty excluding VAT (i.e. Unit Price * Qty in Orders in which prices exclude VAT, or (Unit Price * Qty) - VAT otherwise), converted to Base Currency 1. | | | Usually, the number of decimal places will obey the Default for Currency rounding rules set in the Currency Round Off or Round Off settings. 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". The rounding resulting from the Field Argument will occur before the conversion to Base Currency 1 | | Row Base in Base Currency 2 | Unit Price * Qty excluding VAT (i.e. Unit Price * Qty in Orders in which prices exclude VAT, or (Unit Price * Qty) - VAT otherwise), converted to Base Currency 2. | | | Usually, the number of decimal places will obey the Default for Currency rounding rules set in the Currency Round Off or Round Off settings. 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". The rounding resulting from the Field Argument will occur before the conversion to Base Currency 2 | | Row Number | Row number | | Row Sum | Sum excluding VAT (i.e. prints Sum in Invoices in which prices exclude VAT, or Sum - VAT otherwise) | | Row Sum Total | Prints (Unit Price * Qty) + VAT + Extra Tax if prices exclude VAT, (Unit Price * Qty) + Extra Tax if prices include VAT or (Unit Price * Qty) if prices include VAT and Extra Tax | | Row Sum with VAT | (Unit Price * Qty) + VAT. You should only use this field in Orders in which prices exclude VAT | | Serial Number (serienr) | Serial No (from flip E) | | Source | Source (from flip F) | | Supplier Item No. | Prints the Item Number if the Item has a Default Purchase Item (for the Location in the Order row or, if blank, in the header) or blank otherwise | | Supplier Unit | If the Item has a Unit, prints the correct translation for the Language of the Order of the Comment from the Units setting if the Item has a Default Purchase Item (for the Location in the Order row or, if blank, in the header) or blank otherwise | | Tag/Object Name, row | Names from each Tag/Object in the row, separated by commas, up to a maximum of 250 characters | | Tag/Object Text (objekttext) | Names from each Tag/Object in the row, separated by commas, up to a maximum of 250 characters | | TAX Value, row | Extra Tax value of the row (calculated by applying the Tax % on flip B of the VAT Code to (Unit Price * Qty)) (only printed if the VAT Zone of the Order is "Domestic", "Inside EU (Post VAT)" or "Outside EU (Post VAT)") | | Total in Base Currency 1, row | (Unit Price * Qty) including VAT (i.e. (Unit Price * Qty) in Invoices in which prices include VAT, or (Unit Price * Qty) + VAT otherwise), converted to Base Currency 1 | | Total in Base Currency 2, row | (Unit Price * Qty) including VAT (i.e. (Unit Price * Qty) in Invoices in which prices include VAT, or (Unit Price * Qty) + VAT otherwise), converted to Base Currency 2 | | Unit | If the Item has a Unit, the correct translation for the Language of the Order of the Comment from the Units setting, the Comment itself or the Unit Code | | Unit Code | Unit (from flip H) | | Unit Comment | If the Order row has a Unit (on flip H), the correct translation for the Language of the Order of the Comment from the Units setting, the Comment itself or the Unit Code | | Unit Price | Unit Price excluding VAT (i.e. prints Unit Price - VAT in Orders in which prices include VAT, or Unit Price 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 Including Discount | Unit Price. This figure will include VAT in Orders in which prices include VAT, or exclude VAT otherwise. | | | Usually, the number of decimal places will obey the Default for Currency rounding rules set in the Currency Round Off or Round Off settings. 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". The maximum number of decimal places you can display is three | | Unit Price of Unit | Unit Pr. of Unit (from flip H) | | Unit Quantity | Unit Qty (from flip H) | | VAT %, row | VAT rate, without "%" character, always with two decimals | | VAT Code | V-Cd (from flip B) (if an Order row contains a Reverse VAT Code, this will be printed instead of the VAT Code. Reverse VAT Codes can be used if the VAT Law in the Company Info setting is set to "Default", "Lithuanian" or "Polish" for Items that you sell on a reverse charge VAT basis to Customers in the Domestic VAT Zone) | | VAT Value, row | VAT value of the row, calculated from (Unit Price * Qty) | | VAT Value in Base Currency 1, row | VAT value of the row, calculated from (Unit Price * Qty), converted to Base Currency 1 | | VAT Value in Base Currency 2, row | VAT value of the row, calculated from (Unit Price * Qty), converted to Base Currency 2 | | Width per unit | Width (from flip H) |
Item InformationThe following fields print information from the records in the Item register for the Items specified in each Order row. In these fields, you should specify a Line Height and set the Format to "Matrix":
| Field in Form Template | Prints (from Item) | | | | Alternative Code | Alternative Code | | Barcode | Barcode. If you need this to be printed as a barcode, you should give this field a Style in which the Barcode has been set to the relevant option (Code 128, Code 39 or EAN 13) and that uses a suitable barcode font. Fonts in the IDAutomation family are supported | | Classification of Products and Services | Classification of Products and Services | | Coefficient | Unit Coefficient | | Commodity Code | Commodity Code | | Conversion 1 | Conversion 1 | | Conversion 2 | Conversion 2 | | Department on Item Record | Department | | Depth | Depth (use the "Depth per unit" row field if you need this information to be taken from the Order row) | | EU Code | Commodity Code | | Height | Height (use the "Height per unit" row field if you need this information to be taken from the Order row) | | Item Barcode BC39 | Barcode from the Barcodes setting in the Stock module, or Barcode or Item Number from the Item record, printed using the Code 39 barcode format. You should give this field a Style that uses a Code 39 barcode font | | Item Barcode EAN 13 | Barcode from the Barcodes setting in the Stock module, or Barcode or Item Number from the Item record, printed using the EAN 13 barcode format. You should give this field a Style that uses an appropriate EAN 13 barcode font | | Item Cost Price | Cost Price | | Shelf Code | Shelf Code | | Supplier Item Number | If the Item has a Default Purchase Item (for the Location in the Order row or, if blank, in the header), the Supplier Item in that Default Purchase Item | | Supplier Item Purchase Price | If the Item has a Default Purchase Item (for the Location in the Order row or, if blank, in the header), the Price in that Default Purchase Item | | Supplier Shipment Deal Text | If the Item has a Default Purchase Item (for the Location in the Order row or, if blank, in the header), the Desc. in that Default Purchase Item | | User Date Item 1 | The first user defined date field | | User Date Item 2 | The second user defined date field | | User Date Item 3 | The third user defined date field | | User Text Item 1 | The first user defined text field | | User Text Item 2 | The second user defined text field | | User Text Item 3 | The third user defined text field | | User Text Item 4 | The fourth user defined text field | | User Text Item 5 | The fifth user defined text field | | User Value Item 1 | The first user defined value field | | User Value Item 2 | The second user defined value field | | User Value Item 3 | The third user defined value field | | Volume | Item Volume | | Weight, Item | Weight | | Width | Item Width (use the "Width per unit" row field if you need this information to be taken from the Order row) | | XItemCode | If the Item has a Recipe, the Code from the Recipe. This field will only be printed if the Item is a Structured Item in which Paste Components during Entry has been ticked | | XItemName | If the Item has a Recipe, the Comment from the Recipe. This field will only be printed if the Item is a Structured Item in which Paste Components during Entry has been ticked | | XItemUnit | If the Item has a Unit, the correct translation for the Language of the Order of the Comment from the Units setting, the Comment itself or the Unit Code. This field will only be printed if the Item is a Structured Item in which Paste Components during Entry has been ticked |
Reverse Charge VAT InformationWhen you print a domestic Invoice in which you have used the reverse charge VAT procedure, you must have a reference printed on the document to make it clear that the reverse charge applies and that the Customer is required to account for the VAT. You can do this by including the fields listed below in your Form Template designs. The ability to use the reverse charge VAT procedure in domestic Invoices is only available in Lithuania, Poland and the UK (i.e. it is available when the VAT Law in the Company Info setting is "Lithuanian", "Polish" or "Default"). You should specify a Line Height and set the Format to "Matrix" in these fields.
| Field in Form Template | Prints | | | | Reverse VAT Code | This field will print the Reverse VAT Code in each row | | Row reverse VAT text | In Lithuania and the UK, this field will print the text "Subject to Reverse VAT Charge" for each row that has a Reverse VAT Code |
"Perception Tax" RowsThe following additional fields will only be printed from "Perception Tax" rows (added to Orders automatically for Customers with records in the Regional Perception Taxes for Customers setting). You should specify a Line Height and set the Format to "Matrix" in these fields:
| Field in Form Template | Prints | | | | Region, row | Region Code | | Region Name, row | Name from the Region record | | TAX 2 %, row | Perception Tax rate |
The following standard row fields will also be printed from "Perception Tax" rows. 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 "Perception Tax" rows.
| Field in Form Template | Prints | | | | Description 1 | The text in the "Perception Tax" row (the default is the phrase "Perception Tax " followed by the name of the Region) | | Row Sum | Perception Tax amount | | Row Text | Prints "Perception Tax" | | Sales Account | Perception Tax Account |
"Subtotal" RowsThe following additional field will only be printed from "Subtotal" rows (rows added to Orders using the 'Add Subtotal' function). You should specify a Line Height and set the Format to "Matrix" in this field:
| Field in Form Template | Prints | | | | Subtotal Amount | Sum (i.e. the subtotal figure) (will also be printed by the "Row Sum" row field) |
The following standard row fields will also be printed from "Subtotal" rows. You may have included 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 "Subtotal" rows.
| Field in Form Template | Prints | | | | Description 1 | Prints the text entered in the "Subtotal" row, to the right of the word "Subtotal" | | Row Sum | The subtotal |
If you need fields in "Subtotal" rows to be printed using a different Style and Line Height to the fields in "normal" rows, use the 'Row Styles' function on the Operations menu of the Form Template window.
The Stock Movement Invoice form:
---
Go back to:
|
Introduction to Forms in the Stock Module
