Import Purchases

Question

Hi 
 Is there any Import Templates to import transactions into Sage 50? I made the following in csv file and change the extension of the file to .imp but when I try to import it gives an version error.

30001 
 1

XYZ 
 12530 
 04/25/2024 
 5000 
 G 
 0 
 1 
 5 
 250

ABC 
 5630 
 04/24/2024 
 2000 
 G 
 0 
 1 
 5 
 100

Thanks, 
 
 Yatin

Erzsi_I · Answer

Hi Yatin S , 
 Thanks for reaching out. It seems you're encountering a version error when trying to import transactions into Sage 50 using a .CSV file that you've converted to an .IMP file. This could be happening due to a formatting issue or a version mismatch. 
 Here are a few steps to help resolve your issue:

Ensure that the .IMP file format is correct. The file needs to have proper header information and transaction details formatted as per the Sage 50 requirements.

Check the version number in your .IMP file. According to the Sage 50 documentation, you should be using "12001" for the version if you are dealing with Sage 50 version 2005. Make sure the country code is also correct (1 for Canada).

Verify that the dates in your import file match the fiscal year dates in Sage 50.

If you're adding customers or vendors, make sure the mandatory fields are filled in correctly as per the specifications.

Check to ensure that the transaction type you're importing is enabled in your Sage 50 Accounting company settings.

For detailed instructions on formatting the .IMP file, you can refer to the article " How do I import transactions into Sage 50 using a .IMP file format? ".

If you're still encountering issues, you may consider reaching out to a Sage Development Partner for a special solution or use Community Hub to connect with Certified Consultants for advice.

Please try the above solutions, and if you need further assistance, don't hesitate to reach out. If this helps, please mark it as verified :) 
 Warm Regards, Erzsi

Sage 50 Canada

Import Purchases

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING