Hi,

You can export a sales invoice by emailing it to a customer.   The .IMP file format created will be a Payable invoice.

There is a document that explains it at:

https://partners.sagenorthamerica.com/irj/go/km/docs/sageKM/Simply%20Accounting%20by%20Sage/Assets/dev-import.pdf

and in this thread:

http://sagecity.na.sage.com/support_communities/sage_50_accounting_ca/f/160/t/67239.aspx

There are also 'third party' utilities that will import data into Sage 50.  One that I know of is from Swagman Systems.

I hope that helps, please post back.

Randy

I tried emailing an invoice to myself, but all I got in the email was a confirmation of having received the invoice.  I can't find where I can email the actual invoice, whether as an attachment, or in the email text.

Where can I do this?

I think that emailing out a Sales invoice will create a .IMP attachment, that is in Purchase Order format.

It's very similar to the Sales Invoice format.  

If there's an application in Access and you have access to the table data, you can create invoice import files for Sage 50.  It should be do-able with some VBA code.

The import format built into Sage 50 doesn't import anything other than the line item details and overall transaction detail - that is, notes and such in the description fields can't be imported.

I think that emailing out a Sales invoice will create a .IMP attachment, that is in Purchase Order format.

It's very similar to the Sales Invoice format.  

If there's an application in Access and you have access to the table data, you can create invoice import files for Sage 50.  It should be do-able with some VBA code.

The import format built into Sage 50 doesn't import anything other than the line item details and overall transaction detail - that is, notes and such in the description fields can't be imported.

Ok.  I will talk with my co-worker who is in charge of the invoices in Access and see what he can do.

Thanks!

mirasong

When you email to yourself, first go to the customer's ledger and on the Import/Export tab check the first box "This customer has Sage 50 and can import invoices and quotes".  That should get you the imp file.