VAT Corrections S/L - Row Fields
The fields that you can use when you design the Form Template to be used by the VAT Correction form are listed on two pages, as follows:
---
Row fields will be printed once for each VAT Correction 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.
| Field in Form Template | Prints (from VAT Correction) | | | | Cost Price | Cost | | Description 1 | Description | | Description with EKN Code | Prints Description from the VAT Correction row + the EKN Code from the Item record, separated by a space | | Discount | % | | Document Date, row | Trans. Date (from the header) | | Item Code | Item | | Item Code 2 | Item | | Item Price | If the prices in a VAT Correction include VAT, this field will print the Unit Price including discount but excluding VAT. If the prices in a VAT Correction do not include VAT, it will print the Unit Price excluding discount but including VAT | | Object, row | Objects (from flip B) | | Object Name, row | Names from each Object in the row, separated by commas, up to a maximum of 250 characters | | 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 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 VAT Corrections 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" | | Quantity | Qty ("0" will be printed for zero quantities, use "Quantity In" if you need blank to be printed) | | 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) | | Row Base | Sum excluding VAT (i.e. prints Sum in VAT Corrections 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 VAT Corrections 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 VAT Corrections 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 VAT Correction or the Language in the Company Info setting | | Row Sum | Sum | | 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 VAT Corrections 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 | | Sales Account | A/C (from flip B) | | Sum, FIFO | Row FIFO. | | 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 of the Invoice from which the VAT Correction was created), 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 VAT Corrections 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 VAT Corrections 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 VAT Corrections in which prices include VAT, or Sum + VAT otherwise), converted to Base Currency 2 | | Total Row | Sum including VAT (i.e. prints Sum in VAT Corrections 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 Price | Unit Price. This field prints the Unit Price as shown on screen in the VAT Correction record (i.e. including VAT in VAT Corrections 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 Including Discount | Prints the Unit Price including discount, calculated using the formula Row Sum / Qty. This figure will include VAT in VAT Corrections in which prices include VAT, or exclude VAT otherwise | | VAT Code | V-Cd (from flip B) | | 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 | | Volume, row | Qty * Item Volume from the Item record | | Weight | Qty * Weight from the Item record |
Item InformationThe following fields print information from the records in the Item register for the Items specified in each VAT Correction 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 | | Commodity Code | Commodity Code | | Conversion 1 | Conversion 1 | | Conversion 2 | Conversion 2 | | Country of Origin (origincountry) | If the Item has a Default Purchase Item, Country of Origin from that Purchase Item | | Depth | Depth | | EU Code | Commodity Code | | Item Department | Department | | Item Group | Group | | Item Group Name, row | Name from the Item Group | | Item Group, row | Group | | Height | Height | | Shelf Code | Shelf Code | | Sales Price | Base Price | | Unit | If the Item has a Unit, the correct translation for the Language of the VAT Correction of the Comment from the Units setting, the Comment itself or the Unit Code | | Volume | Item Volume | | Warranty | Warranty Months | | Weight, Item | Weight | | Width | Item Width | | 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 VAT Correction 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 |
Country-Specific Row Fields - UkraineIn these fields, you should specify a Line Height and set the Format to "Matrix":
| Field in Form Template | Prints (from VAT Correction) | | | | Row Sum excl. VAT,Normal 20% | Sum excl. VAT, 20% i.e. prints Unit Price * Qty if the VAT Code has a Tax Rule belonging to the "Normal" Type and if the VAT rate is 20% | | Row Sum excl. VAT,Normal 0% | Sum excl. VAT, 0% i.e. prints Unit Price * Qty if the VAT Code has a Tax Rule belonging to the "Normal" Type and if the VAT rate is not 20% | | Row Sum excl. VAT, Export | Sum excl. VAT, Export i.e. prints Unit Price * Qty if the VAT Code has a Tax Rule belonging to the "Export with Deductable VAT" Type | | Row Sum excl. VAT, No VAT | Sum excl. VAT, No VAT i.e. prints Unit Price * Qty if the VAT Code has a Tax Rule belonging to the "No VAT" Type | | | | The following fields will only be used when printing VAT Corrections created from Credit Notes or Returned Prepayments: | | | | Quantity Difference | From a row in a VAT Correction created from a Credit Note, Qty as a negative figure. | | From a correction row in a VAT Correction created from a Correction Invoice, prints (Qty in the correction row - Qty in the corresponding row in the original Invoice) | | Price Difference | From a row in a VAT Correction created from a Credit Note, Unit Price as a negative figure. | | From a correction row in a VAT Correction created from a Correction Invoice, prints (Unit Price in the correction row - Unit Price in the corresponding row in the original Invoice). | | From a row in a VAT Correction created from a Prepayment in which the Sum is negative, Unit Price as a negative figure | | Corrected Row Sum excl. VAT,Normal 20% | Corrected row sum, 20% VAT. | | From a row in a VAT Correction created from a Credit Note, prints (Unit Price * Qty) if the VAT Code has a Tax Rule belonging to the "Normal" Type and if the VAT rate is 20%. | | From a correction row in a VAT Correction created from a Correction Invoice, prints ((Unit Price * Qty in the correction row) - (Unit Price * Qty in the corresponding row in the original Invoice)) if the VAT Code has a Tax Rule belonging to the "Normal" Type and if the VAT rate is 20%. | | From a row in a VAT Correction created from a Prepayment in which the Sum is negative, prints (Unit Price * Qty) if the VAT Code has a Tax Rule belonging to the "Normal" Type and if the VAT rate is 20% | | Corrected Row Sum excl. VAT,Normal 0% | Corrected row sum, 0% VAT. | | From a row in a VAT Correction created from a Credit Note, prints (Unit Price * Qty) if the VAT Code has a Tax Rule belonging to the "Normal" Type and if the VAT rate is not 20%. | | From a correction row in a VAT Correction created from a Correction Invoice, prints ((Unit Price * Qty in the correction row) - (Unit Price * Qty in the corresponding row in the original Invoice)) if the VAT Code has a Tax Rule belonging to the "Normal" Type and if the VAT rate is not 20%. | | From a row in a VAT Correction created from a Prepayment in which the Sum is negative, prints (Unit Price * Qty) if the VAT Code has a Tax Rule belonging to the "Normal" Type and if the VAT rate is not 20% | | Corrected Row Sum excl. VAT,No VAT | Corrected row sum, no VAT. | | From a row in a VAT Correction created from a Credit Note, prints (Unit Price * Qty) if the VAT Code has a Tax Rule belonging to the "No VAT" Type. | | From a correction row in a VAT Correction created from a Correction Invoice, prints ((Unit Price * Qty in the correction row) - (Unit Price * Qty in the corresponding row in the original Invoice)) if the VAT Code has a Tax Rule belonging to the "No VAT" Type. | | From a row in a VAT Correction created from a Prepayment in which the Sum is negative, prints (Unit Price * Qty) if the VAT Code has a Tax Rule belonging to the "No VAT" Type | | Corrected Negative VAT Sum,Normal 20% | Negative Corrected row. | | From a row in a VAT Correction created from a Credit Note, prints the VAT on (Unit Price * Qty) if the VAT Code has a Tax Rule belonging to the "Normal" Type, if the VAT rate is 20% and if the VAT figure is negative. | | From a correction row in a VAT Correction created from a Correction Invoice, prints the VAT on ((Unit Price * Qty in the correction row) - (Unit Price * Qty in the corresponding row in the original Invoice)) if the VAT Code has a Tax Rule belonging to the "Normal" Type, if the VAT rate is 20% and if the VAT figure is negative. | | From a row in a VAT Correction created from a Prepayment in which the Sum is negative, prints the VAT on (Unit Price * Qty) if the VAT Code has a Tax Rule belonging to the "Normal" Type, if the VAT rate is 20% and if the VAT figure is negative | | Corrected Positive VAT Sum,Normal 20% | Positive Corrected row. | | From a row in a VAT Correction created from a Credit Note, prints the VAT on (Unit Price * Qty) if the VAT Code has a Tax Rule belonging to the "Normal" Type, if the VAT rate is 20% and if the VAT figure is positive. | | From a correction row in a VAT Correction created from a Correction Invoice, prints the VAT on ((Unit Price * Qty in the correction row) - (Unit Price * Qty in the corresponding row in the original Invoice)) if the VAT Code has a Tax Rule belonging to the "Normal" Type, if the VAT rate is 20% and if the VAT figure is positive. | | From a row in a VAT Correction created from a Prepayment in which the Sum is negative, prints the VAT on (Unit Price * Qty) if the VAT Code has a Tax Rule belonging to the "Normal" Type, if the VAT rate is 20% and if the VAT figure is positive |
---
Go to:
Forms in the Sales Ledger:
Go back to:
|
Introduction to Forms in the Sales Ledger
