Invoice - Item fields

Reports and forms > Customising forms > Lists of fields that can be added to forms >>

The following fields are available in the Customise Item Sales window. Basic fields appear in the basic form layout. Custom fields can be added by using the Select from List [multiple selection] window for fields on this form.

Data field name

Data that will print in this field

Basic/Custom field (Basic field text label)

[*Inv/PO No.*]

The transaction number, with an asterisk before and after it

Custom

[Addr2 - Contact]

The name of the contact entered on the Card Information window -- Profile view for the Address 2 Location

Custom

[Addr2 - Country]

The entry in the Country field from the Card Information window for the Address 2 location

Custom

[Addr2 - E-mail]

The email address entered on the Card Information window -- Profile view for the Address 2 Location

Custom

[Addr2 - Fax]

The fax number entered on the Card Information window -- Profile view for the Address 2 Location

Custom

[Addr2 - Phone1]

The No.1 phone number entered on the Card Information window -- Profile view for the Address 2 Location

Custom

[Addr2 - Phone2]

The No.2 phone number entered on the Card Information window -- Profile view for the Address 2 Location

Custom

[Addr2 - Phone3]

The No.3 phone number entered on the Card Information window -- Profile view for the Address 2 Location

Custom

[Addr2 - Salutation]

The name or title entered in the Salutation field on the Card Information window -- Profile view for the Address 2 Location

Custom

[Addr2 - WWW]

The World Wide Web address entered on the Card Information window -- Profile view for the Address 2 Location

Custom

[Addr3 - Contact]

The name of the contact entered on the Card Information window -- Profile view for the Address 3 Location

Custom

[Addr3 - Country]

The entry in the Country field from the Card Information window for the Address 3 location

Custom

[Addr3 - E-mail]

The email address entered on the Card Information window -- Profile view for the Address 3 Location

Custom

[Addr3 - Fax

The fax number entered on the Card Information window -- Profile view for the Address 3 Location

Custom

[Addr3 - Phone1]

The No.1 phone number entered on the Card Information window -- Profile view for the Address 3 Location

Custom

[Addr3 - Phone2]

The No.2 phone number entered on the Card Information window -- Profile view for the Address 3 Location

Custom

[Addr3 - Phone3]

The No.3 phone number entered on the Card Information window -- Profile view for the Address 3 Location

Custom

[Addr3 - Salutation]

The name or title entered in the Salutation field on the Card Information window -- Profile view for the Address 3 Location

Custom

[Addr3 - WWW]

The World Wide Web address entered on the Card Information window -- Profile view for the Address 3 Location

Custom

[Addr4 - Contact]

The name of the contact entered on the Card Information window -- Profile view for the Address 4 Location

Custom

[Addr4 - Country]

The entry in the Country field from the Card Information window for the Address 4 location

Custom

[Addr4 - E-mail]

The email address entered on the Card Information window -- Profile view for the Address 4 Location

Custom

[Addr4 - Fax]

The fax number entered on the Card Information window -- Profile view for the Address 4 Location

Custom

[Addr4 - Phone1]

The No.1 phone number entered on the Card Information window -- Profile view for the Address 4 Location

Custom

[Addr4 - Phone2]

The No.2 phone number entered on the Card Information window -- Profile view for the Address 4 Location

Custom

[Addr4 - Phone3]

The No.3 phone number entered on the Card Information window -- Profile view for the Address 4 Location

Custom

[Addr4 - Salutation]

The name or title entered in the Salutation field on the Card Information window -- Profile view for the Address 4 Location

Custom

[Addr4 - WWW]

The World Wide Web address entered on the Card Information window -- Profile view for the Address 4 Location

Custom

[Addr5 - Contact]

The name of the contact entered on the Card Information window -- Profile view for the Address 5 location

Custom

[Addr5 - Country]

The entry in the Country field from the Card Information window for the Address 5 location

Custom

[Addr5 - E-mail]

The email address entered on the Card Information window -- Profile view for the Address 2 Location

Custom

[Addr5 - Fax]

The fax number entered on the Card Information window -- Profile view for the Address 5 Location

Custom

[Addr5 - Phone1]

The No.1 phone number entered on the Card Information window -- Profile view for the Address 5 Location

Custom

[Addr5 - Phone2]

The No.2 phone number entered on the Card Information window -- Profile view for the Address 5 Location

Custom

[Addr5 - Phone3]

The No.3 phone number entered on the Card Information window -- Profile view for the Address 5 Location

Custom

[Addr5 - Salutation]

The name or title entered in the Salutation field on the Card Information window -- Profile view for the Address 5 Location

Custom

[Addr5 - WWW]

The World Wide Web address entered on the Card Information window -- Profile view for the Address 5 Location

Custom

[Address 2]

The address entered on the Card Information window -- Profile view for the Address 2 Location

Custom

[Address 3]

The address entered on the Card Information window -- Profile view for the Address 3 Location

Custom

[Address 4]

The address entered on the Card Information window -- Profile view for the Address 4 Location

Custom

[Address 5]

The address entered on the Card Information window -- Profile view for the Address 5 Location

Custom

[Amount + tax]

The amount of the line item plus the amount of the tax for the line item

Custom

[Amount]

The amount of each line item entered on the transaction

Basic
(EXTENDED)

[Applied]

The total of the payments that have been applied to the sale

Basic
(PAID TODAY)

[Applied - Local]

The total of the payments that have been applied to the sale, in your local currency

Custom

[Balance]

Amount of the sale including tax and carriage charges minus any payments that may have been applied; that is, the amount that appears in the Balance Due field of the sale

Basic
(BALANCE)

[Balance - Local]

Amount of the sale including tax and carriage charges minus any payments that may have been applied, in your local currency

Custom

[Card Custom Field 1]

The entry in the Custom Field No.1 field of the Card Information window -- Card Details view

Custom

[Card Custom Field 2]

The entry in the Custom Field No.2 field of the Card Information window -- Card Details view

Custom

[Card Custom Field 3]

The entry in the Custom Field No.3 field of the Card Information window -- Card Details view

Custom

[Card Custom List 1]

The entry in the Custom List No.1 field of the Card Information window

Custom

[Card Custom List 2]

The entry in the Custom List No.2 field of the Card Information window

Custom

[Card Custom List 3]

The entry in the Custom List No.3 field of the Card Information window

Custom

[Card ID]

The Card ID from the Card Information window

Custom

[Card Number]

The card number entered in the Applied Payment Details window when entering a credit or debit card payment for the sale. This field won't print if more than one payment has been applied to the sale.

Custom

[Carriage]

The carriage amount entered on the sale

Basic
(CARRIAGE)

[Carriage - Local]

The carriage amount entered on the sale

Custom

[Carriage + VAT]

The carriage amount plus the VAT on the carriage

Custom

[Carriage + VAT - Local]

The carriage amount plus the VAT on the carriage, in your local currency

Custom

[Category]

The financial tracking category assigned to the transaction associated with this invoice

Custom

[Cheque Number]

The cheque number entered in the Applied Payment Details window when entering a cheque payment for the sale. This field won't print if more than one payment has been applied to the sale.

Custom

[Col]

An X is printed if the terms for the sale are C.O.D.

Basic
(COL)

[Comment]

The comment entered on the transaction

Basic

[Company Address]

The company address entered in the Company Information window

Basic

[Company E-mail]

The email address entered in the Company Information window

Custom

[Company Fax]

The fax number entered in the Company Information window

Custom

[Company Name]

The company name entered in the Company Information window

Basic

[Company Phone]

The phone number entered in the Company Information window

Custom

[Company Reg. Number]

Your company's registration number, as entered in the Company Information window

Custom

[Contact Name]

The name of the contact entered on the Card Information window -- Profile view for the Address 1 Location

Custom

[Country]

The entry in the Country field for Address 1 from the Card Information window

Custom

[Cust PO No.]

The entry in the Customer PO No. field on the transaction

Basic
(YOUR NO.)

[Cust PO No.]

The entry in the Customer PO No. field on the transaction. (This is a duplicate field.)

Custom

[Date]

The date entered on the transaction

Basic
(DATE)

[Delivery Address]

The delivery address entered on the transaction

Basic
(Deliver To)

[Delivery Date]

The date entered in the Promised Date field on the transaction

Basic
(DELIVERY DATE)

[Deliver Via]

The delivery method entered on the transaction

Basic
(DELIVER VIA)

[Description/Backordered Label]

The description of each line item entered on the transaction. The text "Backordered" appears above the line items that are entered in the Backorder column.

Basic
(DESCRIPTION)

[Disc %]

The discount entered in the Disc % column of the sale

Basic
(DISC %)

[Due Date]

The date the payment is due, based on the terms of the sale

Custom

[E-mail]

The email address entered on the Card Information window -- Profile view for the Address 1 Location

Custom

[Expiry Date]

The expiration date entered in the Applied Payment Details window when entering a credit or debit card payment for the sale. This field won't print if more than one payment has been applied to the sale.

Custom

[Ex. Subtotal + Carriage]

The extended subtotal amount including any carriage charges that apply to the item

Custom

[Fax No.]

The fax number entered on the Card Information window -- Profile view for the Address 1 Location

Custom

[Foreign Currency Name]

The name of the foreign currency in which this customer is billed

Custom

[Foreign to Local Exchange Rate]

The exchange rate for converting foreign currency to local currency

Custom

[Invoice No.]

The invoice number entered on the transaction

Basic
(Invoice No.)

[Invoice Type]

The sale status of the invoice (Quote, Order or Invoice)

Basic

[Item Custom Field 1]

The entry in the Custom Field No.1 field of the Item Information window -- Item Details view

Custom

[Item Custom Field 2]

The entry in the Custom Field No.2 field of the Item Information window -- Item Details view

Custom

[Item Custom Field 3]

The entry in the Custom Field No.3 field of the Item Information window -- Item Details view

Custom

[Item Custom List 1]

The entry in the Custom List No.1 field of the Item Information window

Custom

[Item Custom List 2]

The entry in the Custom List No.2 field of the Item Information window

Custom

[Item Custom List 3]

The entry in the Custom List No.3 field of the Item Information window

Custom

[Job Description]

The description of the job whose job number is entered for a line item

Custom

[Job Name]

The name of the job whose job number is entered for a line item

Custom

[Job Number]

The job number entered for a line item

Custom

[Local Currency Name]

The name of your local currency

Custom

[Local to Foreign Exchange Rate]

The exchange rate for converting local currency to foreign currency

Custom

[Mailing Address]

The address entered in the Address 1: Bill To selection of the Location field in the Card Information window -- Profile view

Basic
(Bill To)

[Memo]

The memo entered in the Journal Memo field of the transaction

Custom

[My Item No.]

The number of the item entered on the sale. This is the number for the item entered in the Item Information window.

Basic
(ITEM NO.)

[Name on Card]

The name on the card entered in the Applied Payment Details window when entering a credit or debit card payment for the sale. This field won't print if more than one payment has been applied to the sale.

Custom

[Notes from Card]

Notes entered in the Card Information window -- Card Details view

Custom

[Original Amount in English]

The amount of the sale including tax and carriage charges (but not including any payments that may have been applied). Amounts up to and including 99,999.99 will be printed in words; larger amounts will print in numeric form.

Custom

[Page No.]

The pages of the sale are counted; this field displays the number of the page.

Basic
(PG.)

[Payment Method]

The payment method selected when entering a payment for the sale. This field won't print if more than one payment has been applied to the sale.

Custom

[Payment Notes]

The note entered in the Notes field of the Applied Payment Details window when entering a payment for the sale. This field won't print if more than one payment has been applied to the sale.

Custom

[Phone No.1]

The No.1 phone number entered on the Card Information window -- Profile view for the Address 1 Location

Custom

[Phone No.2]

The No.2 phone number entered on the Card Information window -- Profile view for the Address 1 Location

Custom

[Phone No.3]

The No.3 phone number entered on the Card Information window -- Profile view for the Address 1 Location

Custom

[Ppd]

An X is printed if the terms for the sale are Prepaid.

Basic
(PPD)

[Price + VAT]

The price plus the VAT on the price

Custom

[Price]

The amount entered in the Price column of the sale

Basic
(PRICE)

[Price - Local]

The amount entered in the Price column of the sale, in your local currency

Custom

[Qty.]

The amount entered in the Deliver or Backordered field on the sale

Basic
(QTY.)

[Referral Source]

The referral source entered on the transaction

Custom

[Salesperson]

The name of the salesperson entered in the Salesperson field of the sale

Basic
(SALESPERSON)

[Sales Value]

The total amount of the sale used to compute VAT

Basic
(SALE AMT.)

[Sales Value - Local]

The total amount of the sale used to compute VAT, in your local currency

Custom

[Salutation]

The name or title entered in the Salutation field on the Card Information window -- Profile view for the Address 1 Location

Custom

[Ship Date]

The date entered in the Promised Date field on the transaction

Basic
(SHIP DATE)

[Ship Via]

The ship method entered on the transaction

Basic
(SHIP VIA)

[Shipping Address]

The shipping address entered on the transaction

Basic
(Ship To)

[Subtotal + VAT]

The subtotal amount plus any VAT on the subtotal

Custom

[Subtotal]

The total of the line item amounts on the sale (no tax included)

Basic
(SALE AMOUNT)

[Subtotal - Local

The total of the line item amounts on the sale, in your local currency (no tax included.)

Custom

[Tax]

The amount of tax charged for line items on the purchase

Basic
(Sales Tax)

[Tax Code w/o Import (Consolidated)]

The code that applies to all consolidated taxes applied to this sale; any imported tax codes are not shown here.

Basic
(CODE)

[Terms]

The terms that appear on the top of the transaction, next to the Terms zoom arrow

Basic
(TERMS)

[Total]

The total of the line items plus tax and carriage charges. Doesn't reflect any payments that may have been applied.

Basic
(TOTAL)

[Total - Local]

The total of the line items plus tax and carriage charges, in your local currency. Doesn't reflect any payments that may have been applied.

Custom

[Total + VAT - Local]

The total of the line items plus VAT, in your local currency. (Doesn't reflect any payments that may have been applied.)

Custom

[Unit]

The entry in the Selling Unit of Measure field in the Selling Details view of the Item Information window for the line item

Basic
(UNIT)

[VAT]

The total amount of VAT charged for line items and carriage on the sale

Basic
(VAT)

[VAT Code - Carriage]

An X is printed if the carriage entered on the sale is subject to VAT.

Basic

[VAT Code Description]

The description of the VAT code applied to this sale, as entered in the VAT Code List.

Custom

[VAT - Local]

The total amount of VAT charged for line items and carriage on the sale, in your local currency

Custom

[VAT Rate]

The rate of any VAT to be applied to this sale

Basic
(RATE)

[VAT Reg. Number]

Your company's VAT Registration Number, from the Company Information window

Basic
(VAT Reg. Number)

[VAT Reg. Number (Card)]

The VAT Registration number entered in the Card Information window -- Selling Details view

Custom

[VAT Total]

The total amount of VAT charged for line items and carriage on the sale

Custom

[WWW]

The World Wide Web address entered on the Card Information window -- Profile view for the Address 1 Location

Custom