Skip to content
logo Knowledgebase

.IMP File Format details

Created on  | Last modified on 

Summary

Detailed information about the IMP file format.

Resolution

File Layout:

  • The import file consists of two parts: the header information and one or more transactions. Each part is enclosed in a pair of tags <>

Header Information:

  1. The header section is enclosed between two tags: <version> and </version> and consists of the version number of the import file version, and the country code
  2. For the version, please enter 12001 (version 2005)
  3. Country Code based on the status of your version of Sage 50 data file:
    • Canada Country Code = 1
    • USA Country Code = 2
    • French Country Code = 3
    • Australia Country Code = 5
    • International Country Code = 7
  4. For example:
    <Version>
    "12001", "1"
    </Version>"

Transactions:

  1. The supported transaction types are as follows:
    • Purchase Invoice
    • Sales Invoice
    • Sales Order
    • Purchase Quote
    • Adding a Vendor
    • Adding a Customer
    • Time Slips
  2. Each transaction is wrapped in a pair of case-insensitive tags. The detail lines within the tags are comma separated, and strings must be in "".
  3. For all transactions other than adding customers and vendors, the first line contains the vendor's or customer's information. The second line contains transaction options followed by a list of one or more detail lines.
  4. All lines beginning with <! are comment lines and these lines are ignored.

Adding Customers or Vendors:

  1. To add customers and vendors, use the <customers> and <vendors> transaction types.
  2. This consists of one or more customer/vendor lines.

Image

For example:
<customers>
"Customer A", "0", "Contact", "A Street", "More Street Info", "A City", "A Prov", "V3M7Q3", "A Country", "6045558471", "", "6045559132", "an@emailaddress.com"
</customers>

Adding Purchase Invoices and Purchase Quotes

  1. To add a purchase invoice, use the <purinvoice> transaction type.
  2. To add a purchase quote, use the <purquote> transaction type.
  3. Within the tags, there is one vendor line, one transaction option line, and one or more detail lines.

Purchase Invoice/Quote Transaction Options:

Image


Purchase Invoice/Quote Detail Lines:

Image


Sales Invoices

  1. To add a sales invoice, use the <salinvoice> transaction type.
  2. This consists of one customer line, one transaction option line, and one or more detail lines.

Sales Invoice Transaction Options:

Image


Sales Invoice Detail Lines:

Image


Sales Orders

  1. To add a sales order, use the <salorder> transaction type.
  2. This consists of one customer line, one transaction option line, and one or more detail lines.

Sales Order Transaction Options:

Image


Sales Order Detail Lines:

Image

Tax Information:

For each tax authority in the tax code:

Image


Timeslips:

  • To add a timeslip, use the <Timeslip> transaction type
  • This consists of one employee line, one transaction option line and one or more detail lines

Employee Line:

Image


Time Slip Transaction Options:

Image


Time Slip Detail Lines:

Image


Sample Import File:

<Version>
"12001", "1"
</Version>

<customers>
"name", "0", "Contact", "street", "street2", "city", "prov", "postal", "country", "phone", "phone2", "fax", "email@emailaddress.com"
"name2", "0", "Contact", "street", "street2", "city", "prov", "postal", "country", "phone", "phone2", "fax", "email@emailaddress.com"
</customers>

<vendors>
"name", "0", "Contact", "street", "street2", "city", "prov", "postal", "country", "phone", "phone2", "fax", "an@emailaddress.com"
"name2", "0", "Contact", "street", "street2", "city", "prov", "postal", "country", "phone", "phone2", "fax", "an@emailaddress.com"
</vendors>

<PurQuote>
<! This is the vendor line "name"
"UNIVERSAL CONSTRUCTION"
<! This is an option line
<! "no. of details", "quote no.", "entry date", "ship date", "total amount", "disount rate",
<! "discount days", "net days", "freight amt", "tax information"
"1","203","3-15-2000", ,"69.98","2.00","30","60","10.00","GST","0","1","7.00","0.70"
<! This is a detail line
<! "item no.", "quantity", "price", "amt", "tax information"
"C1020","20.0000","2.6000","52.00","GST","0","1","7.00","3.64","PST Charged","0","0","7.00","3.64"
</PurQuote>

<SalInvoice>
"UNIVERSAL CONSTRUCTION", , ,"102-3701 East Hastings St.", ,"Vancouver","British Columbia","V5C2H6", , , , ,
"2", ,"","3-15-2001", "3", "VISA", "67.84","0.00"
"C1020","2.0000","4.7500","9.50","GST","0","1","7.00","0.67","PST","0","0","7.00","0.67"
"H1020","2.0000","25.0000","50.00","GST","0","1","7.00","3.50","PST","0","0","7.00","3.50"
</SalInvoice>

<Timeslip>
“Sianos, Janice”
“2”,”1242”,”3-15-2001”
“Customer5”,”C1020”,”02:00:00”
“Customer6”,”C1020”,”02:00:00”
</Timeslip>