The Row fields that you can use when you design the Form Template to be used by the 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.
For brevity, the term "VAT" has been used in the descriptions: it should be read as including other sales taxes (e.g. sales tax calculated using Tax Templates if you are using the Use Tax Templates for Tax Calculation option in the Transaction Settings setting in Nominal Ledger).
The list on this page describes the row fields that will be printed from "normal" Invoice rows: please refer here for other types of row (e.g. "Credit of Invoice" rows in Credit Notes, "Interest" rows in Interest Invoices, "Prepayment" rows added by the 'Connect to Prepayment' function, etc). An Invoice 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 Invoice) |
| |
| Coefficient | Coeff (from flip F) |
| Cost Price | Cost (from flip C) |
| Country of Origin | The correct translation for the Language of the Invoice from the Countries setting of the Country of Origin (from flip G), or the Country Text itself. If there is no Country of Origin but there is a Serial Number on flip D of the Invoice row, the correct translation of the Country of O. on flip F of the Goods Receipt row that brought the Serial Number into stock |
| Country of Origin 1 | If there is a Serial Number on flip D of the Invoice row, the correct translation for the Language of the Invoice of the Country of O. on flip F of the Goods Receipt row that brought the Serial Number into stock, or the Country Text itself. Blank if there is no Serial Number |
| Country of Origin (origincountry) | Country of Origin (from flip G) or, if blank and 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. |
| Custom Number, row | If there is a Serial Number on flip D of the Invoice row, the Customs No. from flip F of the Goods Receipt row that brought the Serial Number into stock. Blank if there is no Serial Number |
| Customs Declaration Date | If there is a Serial Number on flip D of the Invoice row, the Customs Date from flip F of the Goods Receipt row that brought the Serial Number into stock. Blank if there is no Serial Number |
| Customs Declaration Number | Customs No. (from flip G) or, if blank and if there is a Serial Number on flip D of the Invoice row, the Customs No. from flip F of the Goods Receipt row that brought the Serial Number into stock |
| Customer Item Code | Cust. Item No. (from flip F) |
| Delivered Quantity | In an Invoice that was created from an Order or Delivery, Del. in the relevant Order row (i.e. the quantity delivered, including Deliveries that are OK and not OK yet) |
| Delivery Date, row | If you are not using the Invoice Based on Delivery option in the Order Settings setting and you created the Invoice from an Order, prints the Date of the last Delivery created from that Order (i.e. the same date will be printed for each Invoice row). If you are using the Invoice Based on Delivery option, the Date of the Delivery connected to the Invoice row will be printed (i.e. different dates will be printed for each Invoice row if appropriate). If you created the Invoice from a Delivery, the Date of that Delivery will be printed |
| Depth per unit | Depth from the Invoice row (flip E) |
| Description 1 | Description |
| Discount | %. |
| The number of decimal places will be as shown on screen in the Invoice 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" |
| Environment Tax | Environ. Tax (from flip F) |
| Height per unit | Height from the Invoice row (flip E) |
| Item Code | Item |
| Item Code 2 | Item |
| Item Price | If the prices in an Invoice include VAT, this field will print the Unit Price including discount but excluding VAT. If the prices in an Invoice do not include VAT, it will print the Unit Price excluding discount but including VAT. |
| Usually, the figure 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" |
| 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 |
| Location, row | Location (from flip B) |
| Number of Boxes | In an Invoice that was created from an Order or Delivery, prints the total number of Packages from the 'Packaging' card of the relevant Delivery or Deliveries |
| Tag/Object, row | Tags/Objects (from flip B) |
| Tag/Object Name, row | Names from each Tag/Object in the row, separated by commas, up to a maximum of 250 characters |
| Ordered Quantity | In an Invoice that was created from an Order or Delivery, Qty in the relevant Order row (i.e. the quantity ordered) |
| Packages, row | In an Invoice that was created from an Order or Delivery, prints the number of Packages specified on flip F of the relevant Delivery row |
| Price Factor | P. Factor (from flip F) |
| Price in Base Currency 1 | Unit Price, converted to Base Currency 1 |
| Price in Base Currency 1, row | Sum, converted to Base Currency 1 |
| Price in Base Currency 2 | Unit Price, converted to Base Currency 2 |
| Price in Base Currency 2, row | Sum, converted to Base Currency 2 |
| Price in Base Currency 2 including commission, row | Unit Price including Commission, converted to Base Currency 2 (Commission from the 'Price List' card of the Invoice will be distributed proportionally based on Qty * Unit Price, and the Unit Price + Commission figure will then be 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 Invoices in which prices include VAT, or exclude 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" |
| 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, use "Quantity In" if you need blank to be printed) |
| 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) |
| 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 relevant quantities. Please refer to the description of these fields here for details and an example. |
| Quantity In | Qty (blank will be printed for zero quantities, use "Quantity" if you need "0" to be printed) |
| Quantity Out | Qty * Coeff or Qty / Coeff (depends on the Unit 2 Conversion Calculation options in the Stock Settings_Part_2 setting) |
| Remaining Quantity | In an Invoice that was created from an Order or Delivery, Qty - Del. in the relevant Order row (i.e. the quantity remaining to be delivered) |
| Row Base | Sum excluding VAT (i.e. prints Sum in Invoices in which prices exclude VAT, or Sum - 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" |
| Row Base in Base Currency 1 | Sum excluding VAT (i.e. Sum in Invoices in which prices exclude VAT, or Sum - 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 | Sum excluding VAT (i.e. Sum in Invoices in which prices exclude VAT, or Sum - 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 (only printed if a row has an Item) |
| 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 excl. Discount | Qty * Unit Price. This figure will include VAT in Invoices in which prices include VAT, or exclude VAT otherwise |
| Row Sum If No VAT | Sum. This field will only be printed if the VAT value of a row is zero |
| Row Sum If VAT | Sum excluding VAT (i.e. prints Sum in Invoices in which prices exclude VAT, or Sum - VAT otherwise). This field will only be printed if the VAT value of a row is greater than zero |
| Row Sum Total | Sum including VAT and Extra Tax |
| Row Sum with VAT | VAT value of the row |
| Row Sum without VAT | Sum excluding VAT (i.e. prints Sum in Invoices in which prices exclude VAT, or Sum - VAT otherwise) |
| Row Text | Prints "Cash". "Credit Card", "Gift Received", "Gift Sold", "Loyalty Points", "Perception Tax", "Void" or "Withholding Tax", depending on the Invoice row |
| Sales Account | A/C (from flip B) |
| Securities ISIN Code | Prints the Unit Price including discount, calculated using the formula Row Sum / Qty. This figure will exclude VAT |
| Serial Number (serienr) | Serial No (from flip D) |
| Sum, excluding VAT | Sum excluding VAT (i.e. prints Sum in Invoices in which prices exclude VAT, or Sum - VAT otherwise) |
| Sum, FIFO | Row FIFO (from flip D). |
| The number of decimal places will be as shown on screen in the Invoice 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" |
| TAX Value, row | Extra Tax value of the row (calculated using the Tax % on flip B of the VAT Code) |
| To Pay in Base Currency 2 inc commission | Total Incl. Com. (from the 'Price List' card), converted to Base Currency 2 |
| Total If No VAT, row | Sum. This field will only be printed if the VAT value of a row is zero |
| Total If VAT, row | Sum including VAT (i.e. prints Sum in Invoices in which prices include VAT, or Sum + VAT otherwise). This field will only be printed if the VAT value of a row is greater than zero |
| Total in Base Currency 1, row | Sum including VAT (i.e. Sum in Invoices in which prices include VAT, or Sum + VAT otherwise), converted to Base Currency 1 |
| Total in Base Currency 2, row | Sum including VAT (i.e. Sum in Invoices in which prices include VAT, or Sum + VAT otherwise), converted to Base Currency 2 |
| Total in Base Currency 2 including commission, row | Row sum including Commission, converted to Base Currency 2 (Commission from the 'Price List' card of the Invoice will be distributed proportionally based on Qty * Unit Price, and the (Qty * Unit Price) + Commission figure will then be converted to Base Currency 2) |
| 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 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" |
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 (from flip E) |
| Unit Comment | If the Invoice row has a Unit (on flip E), the correct translation for the Language of the Invoice of the Comment from the Units setting, the Comment itself or the Unit Code |
| 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, 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 | Prints the Unit Price including discount, calculated using the formula Row Sum / Qty. This figure will include VAT in Invoices 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 E) |
| Unit Quantity | Unit Qty (from flip E) |
| VAT Code | V-Cd (from flip B) (if an Invoice 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 % excl., row | VAT rate, with "%" character, only with decimals if necessary |
| VAT %, row | VAT rate, without "%" character, always with two decimals |
| VAT Value, row | VAT value of the row |
| 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" |
| VAT Value in Base Currency 1, row | VAT value of the row, converted to Base Currency 1 |
| VAT Value in Base Currency 2, row | VAT value of the row, converted to Base Currency 2 |
| VAT Value in Base Currency 2 incl commission, row | VAT value of the row including Commission, converted to Base Currency 2 (Commission from the 'Price List' card of the Invoice will be distributed proportionally based on Qty * Unit Price, VAT will then be calculated on (Qty * Unit Price) + Commission, and that VAT value will be converted to Base Currency 2) |
| Volume, row | Qty * Item Volume from the Item record |
| Weight | Qty * Weight from the Item record |
| Width per unit | Width from the Invoice row (flip E) |
Introduction to Forms in the Sales Ledger
