VAT Corrections S/L - Header 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:
---
Header fields will be printed once per VAT Correction. 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.
Basic InformationThe following fields print information taken directly from the VAT Correction being printed:
| Field in Form Template | Prints (from VAT Correction) | | | | Amount in Text | Prints the TOTAL as a phrase. The phrase will be constructed using the relevant record in the Values in Text setting for the Language of the VAT Correction or, if that is blank, the Language in the current user's Person record or in the Company Info setting | | Amount in Text, Basecurrency 1 | Prints the TOTAL converted to Base Currency 1 as a phrase. The phrase will be constructed using the relevant record in the Values in Text setting for the Language of the VAT Correction or, if that is blank, the Language in the current user's Person record or in the Company Info setting | | Amount in Text, Basecurrency 2 | Prints the TOTAL converted to Base Currency 1 as a phrase. The phrase will be constructed using the relevant record in the Values in Text setting for the Language of the VAT Correction or, if that is blank, the Language in the current user's Person record or in the Company Info setting | | Amount without Discount | TOTAL | | Credited Invoice Number | If the VAT Correction was created from a Credit Note, and the Credit Note was created from an Invoice that also has a connected VAT Correction, prints the No. from that VAT Correction | | Credited Invoice Transaction Date | If the VAT Correction was created from a Credit Note, and the Credit Note was created from an Invoice that also has a connected VAT Correction, prints the Trans. Date from that VAT Correction | | Currency | Currency | | Customer Fax Number | Fax from the VAT Correction or, if blank, from the Contact record for the Customer | | Customer Number | Customer | | Customer Telephone Number | Telephone from the VAT Correction or, if blank, from the Contact record for the Customer | | Customer VAT Reg. Number | VAT Reg. No. from the VAT Correction or, if blank, from the Contact record for the Customer | | Day | The day from the Transaction Date. For example, the day from 22/12/2014 will be printed as "22" | | E-mail | Email Address from the Salesman's Person record | | Freight | Freight | | Invoice Comment | Comment | | Invoice Date | Inv. Trans. Date. If you need to use a different date format (e.g. in Ukraine, it is best practice to print this date without separators), you can enter it as the Field Argument (e.g. YYYYMMDD, YY/MM/DD, etc) | | Invoice Due Date | Inv. Due Date. If you need to use a different date format (e.g. in Ukraine, it is best practice to print this date without separators), you can enter it as the Field Argument (e.g. YYYYMMDD, YY/MM/DD, etc) | | Invoice Header | Comment | | Invoice No. | Invoice (i.e. No. of the Invoice from which the VAT Correction was created) | | Invoice Type | Type of the VAT Correction (prints "Invoice", "Cash Note", "Credit Note" or "Interest Invoice" as appropriate) | | Invoice Type (short) | Type of the VAT Correction (prints "Invoice", "Cash Note", "Credit Note" or "Interest Invoice" as appropriate) | | Month | The month from the Transaction Date. For example, the month from 22/12/2014 will be printed as "12" | | Month in words | The name of the month in the current date, taken from the record in the Days and Months setting in the System module for the Language in the Invoice or, if that is blank, the Language in the current user's Person record | | Note | Prints the text of the first Note attached to the VAT Correction. If you specify a Field Argument, the Note whose Comment is the same as the Field Argument will be printed | | Object | Object | | Object Text (objekttext) | Names from each Object, separated by commas, up to a maximum of 250 characters | | Ordering Customer Name | Name | | Ordering Customer Number | Customer | | Our Reference | Our Ref. | | Payment Number for Russia | Prints the No. of the VAT Correction with the first three characters removed | | Postitve/Negative in text | Prints "Amount positive" (if TOTAL is positive) or "Amount negative" (if TOTAL is negative) | | Rate | Exchange Rate, expressed as a ratio | | Rate for Base Currency | Base Currency Rate, expressed as a ratio | | Round Off | Prints the amount lost or gained by the process of rounding the TOTAL according to the Total rounding rules set for the Currency/Payment Term combination in the Currency Round Off setting or in the Round Off setting (i.e. when the TOTAL is rounded to fewer decimal places than the Default). A loss will be printed as a negative figure | | Salesman A | Salesman | | Salesman Name | Name from the Salesman's Person record | | Serial Number (Number Series) | No. | | Subtotal in Base Currency 1 | Subtotal, converted to Base Currency 1. If you enter "-" (i.e. a minus sign) as the Field Argument, this figure will be printed as a negative value | | Subtotal in Base Currency 2 | Subtotal, converted to Base Currency 2. If you enter "-" (i.e. a minus sign) as the Field Argument, this figure will be printed as a negative value | | Subtotal with VAT | Subtotal + VAT (if prices in the VAT Correction exclude VAT) or Subtotal (otherwise) | | Sum | Subtotal. | | The number of decimal places will be as shown on screen in the Invoice record, although you can overrule this by specifying a Field Argument. For example, to round to one decimal place, enter "1" as the Field Argument, or to round to the nearest ten, enter "-1" | | Sum, excluding Freight | Subtotal - Freight (if prices in the Invoice exclude VAT) or Subtotal - VAT - Freight (otherwise) | | sum, Freight | Subtotal - Freight | | Sum, VAT | TOTAL - VAT | | Sum VAT-base incl. zero rate | Subtotal - Freight (if prices in the Invoice exclude VAT) or TOTAL - VAT - Freight (otherwise) | | TAX 1 | Ext. Tax | | TAX Sum | Ext. Tax | | To Pay | TOTAL. | | 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"" | | To Pay excluding Freight | Subtotal - Freight + VAT | | To Pay in Base Currency 1 | TOTAL, converted to Base Currency 1. If you enter "-" (i.e. a minus sign) as the Field Argument, this figure will be printed as a negative value | | To Pay in Base Currency 2 | TOTAL, converted to Base Currency 2. If you enter "-" (i.e. a minus sign) as the Field Argument, this figure will be printed as a negative value | | To Pay in Text | Prints the TOTAL as a phrase. The phrase will be constructed using the relevant record in the Values in Text setting for the Language of the VAT Correction or, if that is blank, the Language in the current user's Person record or in the Company Info setting | | To Pay without Decimals | TOTAL, with decimals removed (for example, 1,234.56 will be printed as 1,234) | | To Pay without Decimals for KID | TOTAL, with thousands separator and decimals removed (for example, 1,234.56 will be printed as 1234) | | To Pay/To Pay Back Amount | If the VAT Correction being printed was created from a Credit Note, the TOTAL (otherwise blank) | | To Pay/To Pay Back Text | If the VAT Correction being printed was created from a Credit Note, prints "To Pay" (if the TOTAL is negative) or "To Pay back" (if the TOTAL is positive) (otherwise blank) | | Total Non Taxable | TOTAL - Subtotal - Freight + VAT. You should only use this field in VAT Corrections in which prices include VAT | | Total Quantity (totqty) | Sum of Qty in each row | | Total Taxable Including VAT | Subtotal - Freight + VAT. You should only use this field in VAT Corrections in which prices exclude VAT | | Total Volume | Sum of (Qty * Item Volume from the Item record) for each row | | Total Weight | Sum of (Qty * Weight from the Item record) for each row | | Transaction Date (transdate) | Trans. Date. If you need to use a different date format (e.g. in Ukraine, it is best practice to print this date without separators), you can enter it as the Field Argument (e.g. YYYYMMDD, YY/MM/DD, etc) | | VAT | VAT. | | 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" | | VAT in Base Currency 1 | VAT, converted to Base Currency 1. If you enter "-" (i.e. a minus sign) as the Field Argument, this figure will be printed as a negative value | | VAT in Base Currency 2 | VAT, converted to Base Currency 2. If you enter "-" (i.e. a minus sign) as the Field Argument, this figure will be printed as a negative value | | VAT in Text | Prints the VAT as a phrase. The phrase is constructed using the relevant record in the Values in Text setting for the Language of the VAT Correction or, if that is blank, the Language in the current user's Person record or in the Company Info setting | | Year | The year from the Transaction Date. For example, the year from 22/12/2014 will be printed as "2014" | | Your (customers) Reference | Attn. |
VAT Correction - Address InformationThe following fields print address information from the VAT Correction being printed: | Field in Form Template | Prints (from VAT Correction) | | | | Address | Name (if you are using the Organisation Name option in the Form Settings setting) and Invoice Address. This information will be printed on separate lines, so you should specify a Line Height for this field | | Address 2 | First line of Invoice Address | | Address 3 | Second line of Invoice Address | | Address 4 | Third line of Invoice Address | | Address 5 | Fourth line of Invoice Address | | Address 6 | Fifth line of Invoice Address | | Address with Attention | Name, Attn. and Invoice Address. This information will be printed on separate lines, so you should specify a Line Height for this field | | Shipment Address 2 | Name and Invoice Address. This information will be printed on separate lines, so you should specify a Line Height for this field |
Customer InformationThe following fields print information taken from the record in the Contact register for the Customer:
| Field in Form Template | Prints (from Customer) | | | | Country Name | Country Name from the record in the Countries setting for the Country | | Customer Comment | Comment ('Company' card) | | Customer Registration No. 1 | Reg. No. 1 | | Customer Registration No. 2 | Reg. No. 2 | | Department | Department | | From Address | Name, Invoice Address and Country. This information will be printed on separate lines, so you should specify a Line Height for this field | | Invoice To | Name and Invoice Address. This information will be printed on separate lines, so you should specify a Line Height for this field |
Contact Person InformationThe following fields print information from the record in the Contact register for the Contact Person specified in the Attn. field in the VAT Correction or, if there is no record for the Contact Person, from the Contact record for the Customer:
| Field in Form Template | Prints (from Contact Person or Customer)
| | | | Contact Person Title | Courtesy Title |
Sales Contract InformationThe following fields print information from the Sales Contract specified in the VAT Correction. The Sales Contract field is only visible in the VAT Correction record if the VAT Law in the Company Info setting is set to "Ukrainian"):
| Field in Form Template | Prints (from Sales Contract) | | | | Sales Contract Date | Date | | Sales Contract No. | No. | | Sales Contract Pay. Term | Pay. Term | | Sales Contract Type | Type |
VAT Code SummaryThe following fields allow you to add a table to the Form listing the VAT Codes used in a VAT Correction together with various totals. These fields will each be printed once for each VAT Code used in an Invoice. In all cases except "Excl. VAT Percentage", "Sum, including VAT", "VAT Code Total" and "VAT Comment", these fields will print negative figures if you specify a minus sign as the Field Argument. You should specify a Line Height in these fields, and set the Format to "Header":
| Field in Form Template | Prints | | | | Excl. VAT Percentage | VAT percentage | | Sum, including VAT | Total. This figure will include VAT in VAT Corrections in which prices include VAT, or exclude VAT otherwise | | VAT Base | Total excluding VAT | | VAT Base in Base Currency 1 | Total excluding VAT, converted to Base Currency 1 | | VAT Base in Base Currency 2 | Total excluding VAT, converted to Base Currency 2 | | VAT Code Total | VAT Code | | VAT Comment | Description from the VAT Codes setting | | VAT Total | Total including VAT | | VAT Total in Base Currency 1 | Total including VAT, converted to Base Currency 1 | | VAT Total in Base Currency 2 | Total including VAT, converted to Base Currency 2 | | VAT Value | VAT value | | VAT Value in Base Currency 1 | VAT value, converted to Base Currency 1 | | VAT Value in Base Currency 2 | VAT value, converted to Base Currency 2 |
Country-Specific Fields - Ukraine| Field in Form Template | Prints | | | | Description 2 | Prints "X" if Org. at our Comp. is not empty (Org. at our Comp. is only visible in the VAT Correction record if the VAT Law in the Company Info setting is set to "Ukrainian") | | Reason | Org. at our Comp. (Org. at our Comp. is only visible in the VAT Correction record if the VAT Law in the Company Info setting is set to "Ukrainian") | | Sequence | Month Seq. No. (Month Seq. No. is only visible in the VAT Correction record if the VAT Law in the Company Info setting is set to "Ukrainian") | | | | | | | | Total Sum Excl. VAT | Sum of the values in the "Total Sum Excl. VAT,Normal 20%", "Total Sum Excl. VAT,Normal 0%", "Total Sum Excl. VAT, No VAT" and "Total Sum Excl. VAT, Export" fields (described immediately below) | | Total Sum Excl. VAT,Normal 20% | Sum of the values in the "Row Sum excl. VAT,Normal 20%" row field | | Total Sum Excl. VAT,Normal 0% | Sum of the values in the "Row Sum excl. VAT,Normal 0%" row field | | Total Sum Excl. VAT, Export | Sum of the values in the "Row Sum excl. VAT, Export" row field | | Total Sum Excl. VAT, No VAT | Sum of the values in the "Row Sum excl. VAT, No VAT" row field. The phrase "No VAT" will be printed under the total, so you should specify a Line Height in this field | | | | | | | | Total Freight excl. VAT,Normal 20% | Total Freight value attributed to rows in which the VAT Code has a Tax Rule belonging to the "Normal" Type and in which the VAT rate is 20% (the Freight figure from the footer of the VAT Correction record will be distributed proportionally to each row based on row sums) | | Total Freight excl. VAT,Normal 0% | Total Freight value attributed to rows in which the VAT Code has a Tax Rule belonging to the "Normal" Type and in which the VAT rate is not 20% | | Total Freight excl. VAT. Export | Total Freight value attributed to rows in which the VAT Code has a Tax Rule belonging to the "Export with Deductable VAT" Type | | Total Freight excl. VAT. No VAT | Total Freight value attributed to rows in which the VAT Code has a Tax Rule belonging to the "No VAT" Type | | | | | | | Total Discount Excl. VAT | Sum of the values in the "Total Discount excl. VAT,Normal 20%", "Total Discount excl. VAT,Normal 0%", "Total Discount excl. VAT. No VAT" and "Total Discount excl. VAT. Export" fields (described immediately below) | | Total Discount excl. VAT,Normal 20% | Sum of ((Qty * Unit Price) - Sum) from each row in which the VAT Code has a Tax Rule belonging to the "Normal" Type and in which the VAT rate is 20% | | Total Discount excl. VAT,Normal 0% | Sum of ((Qty * Unit Price) - Sum) from each row in which the VAT Code has a Tax Rule belonging to the "Normal" Type and in which the VAT rate is not 20% | | Total Discount excl. VAT. Export | Sum of ((Qty * Unit Price) - Sum) from each row in which the VAT Code has a Tax Rule belonging to the "Export with Deductable VAT" Type | | Total Discount excl. VAT. No VAT | Sum of ((Qty * Unit Price) - Sum) from each row in which the VAT Code has a Tax Rule belonging to the "No VAT" Type | | | | | | | | Total Sum Excl. VAT with Discount and Freight | Sum of the values in the "Total Sum Excl. VAT with Discount and Freight,Normal 20%", "Total Sum Excl. VAT with Discount and Freight,Normal 0%", "Total Sum Excl. VAT with Discount and Freight, No VAT" and "Total Sum Excl. VAT with Discount and Freight, Export" fields (described immediately below) | | Total Sum Excl. VAT with Discount and Freight,Normal 20% | Value in the "Total Sum Excl. VAT,Normal 20%" field - value in the "Total Discount excl. VAT,Normal 20%" field + value in the "Total Freight excl. VAT,Normal 20%" field | | Total Sum Excl. VAT with Discount and Freight,Normal 0% | Value in the "Total Sum Excl. VAT,Normal 0%" field - value in the "Total Discount excl. VAT,Normal 0%" field + value in the "Total Freight excl. VAT,Normal 0%" field | | Total Sum Excl. VAT with Discount and Freight, Export | Value in the "Total Sum Excl. VAT, Export" field - value in the "Total Discount excl. VAT. Export" field + value in the "Total Freight excl. VAT. Export" field | | Total Sum Excl. VAT with Discount and Freight, No VAT | Value in the "Total Sum Excl. VAT, No VAT" field - value in the "Total Discount excl. VAT. No VAT" field + value in the "Total Freight excl. VAT. No VAT" field | | | | | | | | Total VAT Sum | Sum of the values in the "Total VAT Sum,Normal 20%", "Total VAT Sum,Normal 0%", "Total VAT Sum, No VAT" and "Total VAT Sum, Export" fields (described immediately below) | | Total VAT Sum,Normal 20% | Total VAT calculated from row sums in rows in which the VAT Code has a Tax Rule belonging to the "Normal" Type and in which the VAT rate is 20% | | Total VAT Sum,Normal 0% | Total VAT calculated from row sums in rows in which the VAT Code has a Tax Rule belonging to the "Normal" Type and in which the VAT rate is not 20% | | Total VAT Sum, Export | Total VAT calculated from row sums in rows in which the VAT Code has a Tax Rule belonging to the "Export with Deductable VAT" Type | | Total VAT Sum, No VAT | Total VAT calculated from row sums in rows in which the VAT Code has a Tax Rule belonging to the "No VAT" Type | | | | | | | | Total Sum Incl. VAT with Discount and Freight | Sum of the values in the "Total Sum Incl. VAT with Discount and Freight,Normal 20%", "Total Sum Incl. VAT with Discount and Freight,Normal 0%", "Total Sum Incl. VAT with Discount and Freight, No VAT" and "Total Sum Incl. VAT with Discount and Freight, Export" fields (described immediately below) | | Total Sum Incl. VAT with Discount and Freight,Normal 20% | Value in the "Total Sum Excl. VAT with Discount and Freight,Normal 20%" field + value in the "Total VAT Sum,Normal 20%" field | | Total Sum Incl. VAT with Discount and Freight,Normal 0% | Value in the "Total Sum Excl. VAT with Discount and Freight,Normal 0%" field + value in the "Total VAT Sum,Normal 0%" field | | Total Sum Incl. VAT with Discount and Freight, Export | Value in the "Total Sum Excl. VAT with Discount and Freight, Export" field + value in the "Total VAT Sum, Export" field | | Total Sum Incl. VAT with Discount and Freight, No VAT | Value in the "Total Sum Excl. VAT with Discount and Freight, No VAT" field + value in the "Total VAT Sum, No VAT" field |
---
Go to:
Forms in the Sales Ledger:
Go back to:
|
Introduction to Forms in the Sales Ledger
