Hi,

Try this in the Search bar of your Help.  Availability may be conducive to your Sage version.  This is taken from Sage 50 Cdn Premium 2023.

Importing a File Formatted for Sage 50 Accounting

On hindsight, this seems to only cover Vendors themselves, not the purchases but maybe you can work with it.

Hope this helps,

Linda

Also try.....Open a Vendor and try the Import/Export tab.  It is a matter of matching their Order #'s and yours.

Good luck,

Linda

You can get the import format by searching the Knowledgebase for "import transactions"

You can also get the format by emailing a customer invoice to yourself after turning on the flag that This Customer has Sage and can... 

This can be turned on in the Customer ledger on the Import/Export tab.

This is the most helpful information I have found for importing invoices. I have sent an invoice to myself as per instructions listed above. How do I use ethe IMP file? I tried opening it, but it only wants to import that into Sage. I also tried saving it as a csv file. But it doesn't work. 

The easiest way to open it to see the details is open Notepad and then open the *.imp file you saved to your hard drive.

Thank you! Have you found an efficient method to import invoices? I managed to open the file. But it doesn't appear to be very user friendly.

I'm sorry but I am a little confused.  Your last message said

Hilda Blain said:

I tried opening it, but it only wants to import that into Sage.

Have you set up a test file and tried this?  This seems efficient.

The other option would be to open your test file and select File, Import/Export, Import Transactions and follow the dialogs.  This is the import wizard as mentioned in the first message in this thread.  You must be in single-user mode and possibly logged in as a Full Accounting Rights user or sysadmin.  It's been a few years since I used this method so I don't remember exactly which users can import.

Hilda Blain said:

But it doesn't appear to be very user friendly.

This is not specific enough for me to help with other than saying that nothing in programming is user friendly unless you know the language.  So I can only suggest you follow the advice I posted last month about searching the Knowledgebase.

CAMK

If you are still looking for a solution contact me at [email protected]