Language:


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 Information

The following fields print information taken directly from the VAT Correction being printed:

Field in Form TemplatePrints (from VAT Correction)
Amount in TextPrints 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 1Prints 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 2Prints 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 DiscountTOTAL
Credited Invoice NumberIf 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 DateIf 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
CurrencyCurrency
Customer Fax Number Fax from the VAT Correction or, if blank, from the Contact record for the Customer
Customer NumberCustomer
Customer Telephone NumberTelephone from the VAT Correction or, if blank, from the Contact record for the Customer
Customer VAT Reg. NumberVAT Reg. No. from the VAT Correction or, if blank, from the Contact record for the Customer
DayThe day from the Transaction Date. For example, the day from 22/12/2014 will be printed as "22"
E-mailEmail Address from the Salesman's Person record
FreightFreight
Invoice CommentComment
Invoice DateInv. 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 DateInv. 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 TypeType 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)
MonthThe month from the Transaction Date. For example, the month from 22/12/2014 will be printed as "12"
Month in wordsThe 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
NotePrints 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
ObjectObject
Object Text (objekttext)Names from each Object, separated by commas, up to a maximum of 250 characters
Ordering Customer NameName
Ordering Customer NumberCustomer
Our ReferenceOur Ref.
Payment Number for RussiaPrints the No. of the VAT Correction with the first three characters removed
Postitve/Negative in textPrints "Amount positive" (if TOTAL is positive) or "Amount negative" (if TOTAL is negative)
RateExchange 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 ASalesman
Salesman NameName from the Salesman's Person record
Serial Number (Number Series) No.
Subtotal in Base Currency 1Subtotal, 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 2Subtotal, 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 VATSubtotal + VAT (if prices in the VAT Correction exclude VAT) or Subtotal (otherwise)
SumSubtotal.
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 FreightSubtotal - Freight (if prices in the Invoice exclude VAT) or Subtotal - VAT - Freight (otherwise)
sum, FreightSubtotal - Freight
Sum, VATTOTAL - VAT
Sum VAT-base incl. zero rateSubtotal - Freight (if prices in the Invoice exclude VAT) or TOTAL - VAT - Freight (otherwise)
TAX 1Ext. Tax
TAX SumExt. Tax
To PayTOTAL.
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 FreightSubtotal - Freight + VAT
To Pay in Base Currency 1TOTAL, 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 2TOTAL, 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 TextPrints 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 DecimalsTOTAL, with decimals removed (for example, 1,234.56 will be printed as 1,234)
To Pay without Decimals for KIDTOTAL, with thousands separator and decimals removed (for example, 1,234.56 will be printed as 1234)
To Pay/To Pay Back AmountIf 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 TaxableTOTAL - 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 VATSubtotal - Freight + VAT. You should only use this field in VAT Corrections in which prices exclude VAT
Total VolumeSum of (Qty * Item Volume from the Item record) for each row
Total WeightSum 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)
VATVAT.
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 TextPrints 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
YearThe year from the Transaction Date. For example, the year from 22/12/2014 will be printed as "2014"
Your (customers) ReferenceAttn.

VAT Correction - Address Information

The following fields print address information from the VAT Correction being printed:

Field in Form TemplatePrints (from VAT Correction)
AddressName (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 2First line of Invoice Address
Address 3Second line of Invoice Address
Address 4Third line of Invoice Address
Address 5Fourth line of Invoice Address
Address 6Fifth line of Invoice Address
Address with AttentionName, Attn. and Invoice Address. This information will be printed on separate lines, so you should specify a Line Height for this field
Shipment Address 2Name and Invoice Address. This information will be printed on separate lines, so you should specify a Line Height for this field

Customer Information

The following fields print information taken from the record in the Contact register for the Customer:

Field in Form TemplatePrints (from Customer)
Country NameCountry Name from the record in the Countries setting for the Country
Customer CommentComment ('Company' card)
Customer Registration No. 1Reg. No. 1
Customer Registration No. 2Reg. No. 2
DepartmentDepartment
From AddressName, 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 Information

The 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 TemplatePrints (from Contact Person or Customer)
Contact Person TitleCourtesy Title

Sales Contract Information

The 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 TemplatePrints (from Sales Contract)
Sales Contract DateDate
Sales Contract No.No.
Sales Contract Pay. TermPay. Term
Sales Contract TypeType

VAT Code Summary

The 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 TemplatePrints
Excl. VAT PercentageVAT percentage
Sum, including VAT Total. This figure will include VAT in VAT Corrections in which prices include VAT, or exclude VAT otherwise
VAT BaseTotal excluding VAT
VAT Base in Base Currency 1Total excluding VAT, converted to Base Currency 1
VAT Base in Base Currency 2Total excluding VAT, converted to Base Currency 2
VAT Code TotalVAT Code
VAT Comment Description from the VAT Codes setting
VAT Total Total including VAT
VAT Total in Base Currency 1Total including VAT, converted to Base Currency 1
VAT Total in Base Currency 2Total including VAT, converted to Base Currency 2
VAT ValueVAT value
VAT Value in Base Currency 1VAT value, converted to Base Currency 1
VAT Value in Base Currency 2VAT value, converted to Base Currency 2

Country-Specific Fields - Ukraine

Field in Form TemplatePrints
Description 2Prints "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")
ReasonOrg. 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")
SequenceMonth 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. VATSum 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, ExportSum of the values in the "Row Sum excl. VAT, Export" row field
Total Sum Excl. VAT, No VATSum 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. ExportTotal 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 VATTotal Freight value attributed to rows in which the VAT Code has a Tax Rule belonging to the "No VAT" Type
Total Discount Excl. VATSum 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. ExportSum 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 VATSum 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 FreightSum 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, ExportValue 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 VATValue 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 SumSum 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, ExportTotal 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 VATTotal 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 FreightSum 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, ExportValue 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 VATValue 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: