The fields that you can use when you design the Form Template to be used by the Stock Movement Invoice form are listed on two pages, as follows:
Header Fields will be printed once for each Stock Movement record. You can use the fields listed below when you design the Form Template to be used by the Stock Movement form. 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.
The following fields print information taken directly from the Stock Movement being printed:
| Field in Form Template | Prints (from Stock Movement) |
| |
| Currency | Currency or, if blank, Base Currency 1 |
| Document Type | Prints the words or phrases "Normal", "Transport of own goods", "Sales Consignment Stock", "Transport of 3rd Party Goods" or "Global Transport", depending on the Type of the Stock Movement |
| Invoice Date | Invoice Date |
| Invoice No. | Invoice No. |
| Note | Prints the text of the first Note attached to the Stock Movement. If you specify a Field Argument, the Note whose Comment is the same as the Field Argument will be printed |
| Official Serial Number | Prints the Official Ser. No. with prefix "MOVST", "MOVGA", "MOVGC", "MOVGT" or "MOVGL", depending on the Type of the Stock Movement (if the VAT Law in the Company Info setting is "Portuguese" ) or the Official Ser. No. (otherwise) |
| Official Serial Number 2 | Prints the Invoice Official No. with prefix "FCCS" (if the VAT Law in the Company Info setting is "Portuguese") or the Official Ser. No. (otherwise) |
| Order Date | Received Date |
| Order Number | If the Stock Movement was created from a Sales Order, prints the No. of that Sales Order |
| Original/Copy | Prints "Original" (if the Stock Movement has not previously been printed) or "Copy" (otherwise) |
| Our Reference | Comment |
| Portuguese SAFT Hash Control | Prints a string constructed from characters 1, 11, 21 and 31 of the hash signature of the Stock Movement, a hyphen and the phrase "Processado por programa certificado n? 2020 /AT Standard ERP" (only printed if the VAT Law in the Company Info setting is "Portuguese") |
| Reason Text | Prints the three Description lines from the Standard Problem record for the Reason. This will be printed on separate lines, so you should specify a Line Height for this field |
| Stock Serial Number | No. (i.e. Stock Movement Number) |
| Tax Authority Approval Code | Tax Seal (only printed if the VAT Law in the Company Info setting is "Portuguese". The Tax Seal is obtained using 'Send to Tax Authorities' function on the Operations or Tools menu. Please refer to the description of the Legal Record Numbers setting in the Sales Ledger for more details) |
| Type | Type |
The following fields print information from the records in the Locations setting for the From, Via (if there is one) and To Locations specified in the Stock Movements:
The fields listed below will print information from the Order from which you created the Stock Movement:
| Field in Form Template | Prints (from Order) |
| |
| Address | Customer Name and Invoice Address. The first line will only be printed if you are using the Organisation name option in the Form Settings setting. This information will be printed on separate lines, so you should specify a Line Height for this field. Use the Form Settings setting to set the format of this field (e.g. to specify whether blank lines will be printed, whether parts of the address will be printed on the same line, etc.) |
| Country Code (Customer) | Code from the record in the Countries setting for the Country specified in the Customer's Contact record |
| Country Code (Customer ISO2) | Code (ISO 2) from the record in the Countries setting for the Country specified in the Customer's Contact record or, if the Code (ISO 2) is blank, the Code if it has two characters |
| Country Code (Customer ISO3) | Code (ISO 3) from the record in the Countries setting for the Country specified in the Customer's Contact record or, if the Code (ISO 3) is blank, the Code if it has three characters |
| Customer Name | Name (i.e. Customer Name) |
| Customer Number | Customer (i.e. Contact Number of the Customer) |
| Customer Type | Prints the phrase "Not VAT Registered" (only printed if the VAT Law in the Company Info setting is "Portuguese" and if the Type on the 'Company' card of the Customer's Contact record is "Person") |
| Customer VAT Reg. Number | VAT Reg. No. |
| Delivery Address | Delivery Address. The first line will only be printed if you are using the Organisation name option in the Form Settings setting. This information will be printed on separate lines, so you should specify a Line Height for this field. Use the Form Settings setting to set the format of this field (e.g. to specify whether blank lines will be printed, whether parts of the address will be printed on the same line, etc.) |
| Discount Total | Sum of Extra Tax for each row (in Orders in which prices include VAT) or Sum of (VAT + Extra Tax) (otherwise). In both cases, the VAT and Extra Tax will be calculated from (Qty * Unit Price) |
| Invoice Address | Customer Name and Invoice Address. The first line will only be printed if you are using the Organisation name option in the Form Settings setting. This information will be printed on separate lines, so you should specify a Line Height for this field. Use the Form Settings setting to set the format of this field (e.g. to specify whether blank lines will be printed, whether parts of the address will be printed on the same line, etc.) |
| Payment Terms | The correct translation for the Language of the Order of the Payment Term Text from the Payment Terms setting, or the Payment Term Text itself |
| Quantity, summarised | Sum of Qty from each row |
| Quantity 2, summarised | Sum of the values in the "Quantity 2" row field |
| Shipment Address | Delivery Address. The first line will only be printed if you are using the Organisation name option in the Form Settings setting. This information will be printed on separate lines, so you should specify a Line Height for this field. Use the Form Settings setting to set the format of this field (e.g. to specify whether blank lines will be printed, whether parts of the address will be printed on the same line, etc.) |
| Subtotal without discount | Sum of (Qty * Unit Price) for each row |
| Subtotal without packages | Sum of Sum in each row in which the Item belongs to an Item Group in which the Type is "Default" or "Transport" and in each row in which the Item does not belong to an Item Group |
| Sum | Sum of Sum for each row (in Orders in which prices include VAT) or Sum of (Sum - VAT) (otherwise) |
| Total Cost | Sum of (Qty * Cost) for each row |
| Total Discount | Sum of (Qty * Unit Price) for each row - Subtotal |
| Total Discount Base Currency 2 | Sum of (Qty * Unit Price) for each row - Subtotal, converted to Base Currency 2 |
| Total Discount without packages | Sum of the discount in each row in which the Item belongs to an Item Group in which the Type is "Default" or "Transport" and in each row in which the Item does not belong to an Item Group |
| Total for Packages Item | Sum of Sum in each row in which the Item belongs to an Item Group in which the Type is "Packages" |
| Total Goods | Sum of Sum in each row in which the Item belongs to an Item Group in which the Type is "Default" and in each row in which the Item does not belong to an Item Group |
| Total In Price | Sum of (Qty * Cost Price from the Item record) for each row |
| Total Transport Cost | Sum of Sum in each row in which the Item belongs to an Item Group in which the Type is "Transport" |
| Total Volume | Sum of (Qty * Volume from the Item record) for each row |
| Total Weight | Sum of (Qty * Weight from the Item record) for each row |
Introduction to Forms in the Stock Module
