Import Transactions into Sage 50 Using .IMP File Format

Today below article is available with all the points and information about how to import transactions into Sage 50 using .IMP file format. Sage 50 is one of the biggest known accounting software for organizations.

While using the software most people think that how can they import the transactions to Sage 50 through a .IMP file.

Speak to a Specialist about Your Sage Software

Get instant assistance with Sage accounting software. Our Sage experts are available 24x7 and resolve issues within minimum turnaround time. We support both US & Canada Editions of Sage 50 Software.

Steps to Import Transactions into Sage 50 Using .IMP File Format

Follow above all steps to import.

Step 1: Import File from Sage 50

  • Click on File >> import/export >> Import Transaction
  • Select Import purchase invoice >> Purchase quotes >> sales invoices >> sales order and time slips
  • Now click on next >> and create a backup and click on Next
  • Locate the location of the .IMP file and click on Open.

Step 2: Import Transactions using an executable

  • Go to the location where Sage 50 is installed and invoke the Sage _SA_import.exe
  • Get the location of the Sage 50 database file and click on Open
  • Click on ok to select yours .IMP import file and click on the “open” option.
May be helpful- Import Invoices into Sage 50

Import Transactions into Sage 50 Using .IMP File Format- Directly you Can’t Import the Payroll but yes you can Import Timeslips

File layouts
The import file consists of two parts, header information, and one or more transactions. Every part of the information is closed in <>.

Header Information

• The Header section is inserted between tags and contains a various number of import file versions and the country code
• Enter 12001 for the version
• Below are the country code based on the status of the version of Sage 50
1. Canada – 1
2. USA -2
3. French – 3
4. Australia – 5
5. International Country Code – 7
• Example –

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

Transactions

The Transactions which are Consultanted are mentioned below :

• Sales invoice
• Purchase invoice
• Sales order
• Adding a customer
• adding a vendor
• Purchase Quote

  • Each part of the transaction is inserted in a pair of case-sensitive tags. The details lines with tags are separated by a comma and the string should be in”
  • All the information except other than adding customers and vendors, the initial first lines contain the customer or vendor information and the second line consists of transactions options after that a list of one or more details line
  • All the lines started with <! are the comments line

How to add customers or vendors

  • You can add customers and vendors by using the transaction types
  • It will contain one or more customer/vendor line.
FieldFormatComments
NameMax 52 Chars  Compulsory
OneTimeFlag  1 = one-time Customer or vendor, 0= Existing customer or vendor  Optional
Contact Name  Max 30 chars  Optional
Street 1  Max 50 chars  Optional
Street 2  Max 50 chars  Optional
CityMax 35 chars  Optional
Province/State  Max 20 chars  Optional
CountryMax 9 chars – unformatted  Optional
Phone 1  Max 30 chars  Optional
Phone 2  Max 25 chars – unformatted  Optional
FaxMax 25 chars – unformatted  Optional
EmailMax 50 chars  Optional

How to Add Purchase Invoices and Purchase Quotes

  • To add purchase voice, you can use the transaction type
  • To add a purchase quote, you can use the transaction type
  • Inside the tags, there is a single vendor line, one transaction option line, and one more details line

Sales Invoices

  • To add a sales invoice you can use the transaction type
  • It consists of one customer line, one transaction option line, and one or more detail line

Sales order

  • Use the transaction type to add a sale order
  • It consists of one customer line, one transaction option line, and one more details line

Timeslips

  • use the transaction type to add the timeslips.
  • it consists of one employee line, one transaction option line, and one or more details line.

For any help import data into Sage 50 using .IMP file format, get connected with the Sage team. The sage team is available 24*7 to assist you with the latest tools, information, and software. Experts are polite, professional, and quick listeners to solve all your queries in a given time with complete satisfaction. You can also email at [email protected] and soon one of the Sage 50 Consultant experts get back to you with the desired details.

Speak to a Specialist about Your Sage Software

Get instant assistance with Sage accounting software. Our Sage experts are available 24x7 and resolve issues within minimum turnaround time. We support both US & Canada Editions of Sage 50 Software.

Leave a Reply

Your email address will not be published. Required fields are marked *

Phone

+1-347-967-4078