Below is a description of the Spire Fields for this Import. 

Please refer to the User Manual for more information on how to do Imports.


Spire 3.11 Fields
Explanation
Example
Vendor No. (Required)Vendor NoABC123
NameVendor nameABC 123 Co.
Address 1Address Line 1PO Box 123
Address 2Address Line 2
Address 3Address Line 3
Address 4Address Line 4
CityCityLangley
ProvinceProvince (2 digit code)BC
CountryCountry (3 digit code)CAN
Postal CodePostal Code V2E 0E2
PhonePhone number555-555-5555
FaxFax number555-555-5555
EmailEmail addressABC@email.ca
Web pageCompany URL

www.abc123.com

Ship Via CodeShipping Method Code01
Contact #1 NameFirst Contact nameJane
Contact #1 Tel No.
First Contact phone number555-555-5555
Contact #1 cell
First Contact cell phone555-555-5555
Contact #1 other
First Contact otherOffice Admin.
Contact #1 email
First Contact emailJane@email.ca
Contact #1 type

First Contact type;

Not working in version 3.11

Accounting
Contact #2 Name
Second Contact nameBill
Contact #2 Tel No.
Second Contact phone number555-555-5555
Contact #2 cell
Second Contact cell phone555-555-5555
Contact #2 other
Second Contact other
Bill Junior
Contact #2 email
Second Contact emailBillJunior@email.ca
Contact #2 type
Second Contact type;
Nit working in version 3.11
Sales
Contact #3 Name
Third Contact nameBill Senior
Contact #3 Tel No.
Third Contact phone number555-555-5555
Contact #3 cell
Third Contact cell phone555-555-5555
Contact #3 other
Third Contact otherCEO
Contact #3 email
Third Contact emailBill@email.ca
Contact #3 type
Third Contact type;
Not working in version 3.11
Main
Sales Tax 1First Sales Tax Code1
Sales Tax 2Second Sales Tax Code2
Sales Tax 3Third Sales Tax Code3
Sales Tax 4Fourth Sales Tax Code4
Sales Tax 1 Exempt NoFirst Sales Tax Exempt Number123456
Sales Tax 2 Exempt NoSecond Sales Tax Exempt Number234567
Sales Tax 3 Exempt NoThird Sales Tax Exempt Number345678
Sales Tax 4 Exempt NoFourth Sales Tax Exempt Number456789
Last P.O. NumberLast Purchase Order number0000700055
Last Payment ReferenceLast Payment Reference1001
Last P.O. DateLast Purchase Order date01/01/2024
Credit Type

Vendor’s Credit Limit Type;

0 = No Credit

1 = Unlimited Credit

2 = Limited Credit

2
Credit LimitVendor's Credit Limit1000
On HoldVendor's on hold flag;

F = Not on hold

T = On hold

F
Status

Vendor's current status;

A = Active

I = Inactive

A
GL Payables AccountPayables GL Account 21120
GL Expense AccountExpense GL Account82320
Vendor Account NoThe companies account number with this supplier
123456789
NotesNoted field of the General tabNote
BuyerBuyer field of the General tabFrank
Terms CodePayment Terms CodeNET30
CurrencyVendor currencyCAD
Print ChequesPrint cheques by default;
F = No
T = Yes
F
Purchase Order TypeNot in use, to be removed
N/A
ReferenceReference field of the General tabReference
Print CPRSPrint CPRS;
F = No
T = Yes
T
Tax ID TypeCPRS/1099 Type flag; B = Business Number U = Social Insurance Number
B
Tax ID

Business number or Social Insurance number

123456789
Remit NameRemit Address NameABC 123 Co, Head Office
Remit Address 1Remit address line 1PO Box 123
Remit Address 2Remit address line 2

Remit Address 3Remit address line 3
Remit Addres 4Remit address line 4
Remit CityRemit cityLangley
Remit ProvinceRemit province (2 digit code)BC
Remit CountryRemit country (3 digit code)CAN
Remit Postal Code
Remit postal codeV2E 0E2
Remit PhoneRemit phone number555-555-5555
Remit FaxRemit fax number555-555-5555
Remit EmailRemit email addressABC@email.ca
Remit Web pageRemit URLwww.abc123.com
Remit Contact #1 NameFirst remit contact
Jane
Remit Contact #1 Tel No.
First remit contact telephone nuber555-555-5555
Remit Contact #1 cell
First remit contact cell phone555-555-5555
Remit Contact #1 other
FIrst remit contact otherOffice Admin.
Remit Contact #1 email
First remit contact emailJane@email.ca
Remit Contact #1 type
First remit contact typeAccounting
Remit Contact #2 Name
Second remit contact nameBill
Remit Contact #2 Tel No.
Second remit contact phone number555-555-5555
Remit Contact #2 cell
Second remit contact cell phone555-555-5555
Remit Contact #2 other
Second remit contact otherBill junior
Remit Contact #2 email
Second remit contact emailBill@email.ca
Remit Contact #2 type
Second remit contact typeSales
Remit Contact #3 Name
Third remit contact nameBill Senior
Remit Contact #3 Tel No.
Third remit contact phone number555-555-5555
Remit Contact #3 cell
Third remit contact cell phone555-555-5555
Remit Contact #3 other
Third remit contact otherCEO
Remit Contact #3 email
Third remit contact emailBillABC@email.ca
Remit Contact #3 type
Third remit contact typeMain