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.
Field | Format | Comments |
Name | Max 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 |
City | Max 35 chars | Optional |
Province/State | Max 20 chars | Optional |
Country | Max 9 chars – unformatted | Optional |
Phone 1 | Max 30 chars | Optional |
Phone 2 | Max 25 chars – unformatted | Optional |
Fax | Max 25 chars – unformatted | Optional |
Max 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.