Hello samtbird,

Thanks for reaching out! Have a look at the resource below. It should answer "How to import purchase invoices, purchase quotes, sales invoices and sales orders?

Supported transaction types are as follows:

• Purchase invoice
• Sales Invoice
• Sales Order
• Purchase Quote
• Adding a Vendor
• Adding a Customer
  

Hope this helps!
Erzsi

Thanks Erzsi, I have looked at that resource and it doesn't indicate whether we can import an account code field. 

Got you, I've forwarded this to the Sage 50 CA Support team to see if they chime in on this.

Hi,

I don't believe you can import an account code using the .IMP file format.  If it's possible, it's not documented. 

That capability was designed to work with exported / emailed .IMP files from a vendor that used Sage 50.  You can map vendor items to your own item codes, and item-to-account mapping in Sage 50. 

You can, however, link most any appropriate account code to an inventory item, but you would have to set up inventory item codes (or just use the account numbers as Inventory or Service Items)

If you want descriptions and account codes without having to set up inventory items, I've played around with AutoHotKey, and it seems to be able to poke in anything that I can do from a keyboard.

If you are proficient in c#, you may be interested in the Sage 50 SDK. 

And if not, or if your time is valuable, I know of at least one third-party developer data import product

I hope that helps,

Randy

Hi,

I don't believe you can import an account code using the .IMP file format.  If it's possible, it's not documented. 

That capability was designed to work with exported / emailed .IMP files from a vendor that used Sage 50.  You can map vendor items to your own item codes, and item-to-account mapping in Sage 50. 

You can, however, link most any appropriate account code to an inventory item, but you would have to set up inventory item codes (or just use the account numbers as Inventory or Service Items)

If you want descriptions and account codes without having to set up inventory items, I've played around with AutoHotKey, and it seems to be able to poke in anything that I can do from a keyboard.

If you are proficient in c#, you may be interested in the Sage 50 SDK. 

And if not, or if your time is valuable, I know of at least one third-party developer data import product

I hope that helps,

Randy