Language:


Invoices - Row Fields Part 1

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:
  • This page:

    • Basic row fields

  • Part 2:

    • Item Information

    • Batch Specification Information (Jewellery module)

    • "Credit of Invoice" Rows

    • "Interest" Rows

    • Payment rows - Cash

    • Payment rows - Credit Card

    • "Perception Tax" Rows

    • "Prepayment" Rows

    • "Subtotal" Rows

    • "Withholding Tax" Rows
Header fields are listed here.

---

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 TemplatePrints (from Invoice)
CoefficientCoeff (from flip F)
Cost Price Cost (from flip C)
Country of OriginThe 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 Item into stock
Country of Origin 1If 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 Item 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, rowIf 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 Item into stock. Blank if there is no Serial Number
Customs Declaration DateIf 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 Item into stock. Blank if there is no Serial Number
Customs Declaration NumberCustoms 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 Item into stock
Customer Item CodeCust. Item No. (from flip F)
Delivered QuantityIn 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, rowIf 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 unitDepth from the Invoice row (flip E)
Description 1Description
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 TaxEnviron. Tax (from flip F)
Height per unitHeight from the Invoice row (flip E)
Item CodeItem
Item Code 2Item
Item PriceIf 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 VarietiesThe 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 VarietiesThe basic Item Number, without any portion representing Varieties. For example, if the Item Number is "10126.GRE.SM", "10126" will be printed
Location, rowLocation (from flip B)
Number of BoxesIn 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, rowTags/Objects (from flip B)
Tag/Object Name, rowNames from each Tag/Object in the row, separated by commas, up to a maximum of 250 characters
Ordered QuantityIn an Invoice that was created from an Order or Delivery, Qty in the relevant Order row (i.e. the quantity ordered)
Packages, rowIn 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 FactorP. Factor (from flip F)
Price in Base Currency 1Unit Price, converted to Base Currency 1
Price in Base Currency 1, rowSum, converted to Base Currency 1
Price in Base Currency 2Unit Price, converted to Base Currency 2
Price in Base Currency 2, rowSum, converted to Base Currency 2
Price in Base Currency 2 including commission, rowUnit 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, rowPrints 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
QuantityQty ("0" will be printed for zero quantities, use "Quantity In" if you need blank to be printed)
Quantity 2Qty * 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 3If 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 InQty (blank will be printed for zero quantities, use "Quantity" if you need "0" to be printed)
Quantity OutQty * Coeff or Qty / Coeff (depends on the Unit 2 Conversion Calculation options in the Stock Settings_Part_2 setting)
Remaining QuantityIn 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 1Sum 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 2Sum 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 NumberRow number (only printed if a row has an Item)
Row Number in textRow 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 SumSum
Row Sum excl. DiscountQty * Unit Price. This figure will include VAT in Invoices in which prices include VAT, or exclude VAT otherwise
Row Sum If No VATSum. This field will only be printed if the VAT value of a row is zero
Row Sum If VATSum 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 TotalSum including VAT and Extra Tax
Row Sum with VATVAT value of the row
Row Sum without VATSum 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 AccountA/C (from flip B)
Securities ISIN CodePrints 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 VATSum excluding VAT (i.e. prints Sum in Invoices in which prices exclude VAT, or Sum - VAT otherwise)
Sum, FIFORow 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, rowExtra Tax value of the row (calculated using the Tax % on flip B of the VAT Code)
To Pay in Base Currency 2 inc commissionTotal Incl. Com. (from the 'Price List' card), converted to Base Currency 2
Total If No VAT, rowSum. This field will only be printed if the VAT value of a row is zero
Total If VAT, rowSum 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, rowSum 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, rowSum 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, rowRow 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 RowSum 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 CodeUnit (from flip E)
Unit CommentIf 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 PriceUnit 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 VATUnit 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 DiscountPrints 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 UnitUnit Pr. of Unit (from flip E)
Unit QuantityUnit 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., rowVAT rate, with "%" character, only with decimals if necessary
VAT %, rowVAT rate, without "%" character, always with two decimals
VAT Value, rowVAT 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, rowVAT value of the row, converted to Base Currency 1
VAT Value in Base Currency 2, rowVAT value of the row, converted to Base Currency 2
VAT Value in Base Currency 2 incl commission, rowVAT 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, rowQty * Item Volume from the Item record
WeightQty * Weight from the Item record
Width per unitWidth from the Invoice row (flip E)

---

Go to:

Forms in the Sales Ledger:
Go back to: