Importing sales/order data

SOLVED

My company has a separated ordering system storing all the sales data on SQL Server. I have just downloaded and installed the Sage 50 Accounting to try out the features.

I wonder if there is any way to import our invoice amount data to Sage 50 Accounting using something like CSV files, or do I have to interact with the Sage MySQL database directly? Are there any standard practices for linking/importing data from other database systems to Sage 50 Accounting?

Thank you.

Parents
  • 0
    verified answer

    Hi Jackrp,

    To import sales invoice to Sage 50,  you have to create a .imp import file which meets certain format requirements.

    For the format, you can download the SDK (Software Developers Kit) by following the Knowledge Base article below.

    How to import purchase invoices, purchase quotes, sales invoices and sales orders? - KB10376

    After installing the SDK, go to the Manuals in the SDK folder under C:\ and follow the format written in in the dev-import.pdf file

    Hope this helps

     

     

Reply
  • 0
    verified answer

    Hi Jackrp,

    To import sales invoice to Sage 50,  you have to create a .imp import file which meets certain format requirements.

    For the format, you can download the SDK (Software Developers Kit) by following the Knowledge Base article below.

    How to import purchase invoices, purchase quotes, sales invoices and sales orders? - KB10376

    After installing the SDK, go to the Manuals in the SDK folder under C:\ and follow the format written in in the dev-import.pdf file

    Hope this helps

     

     

Children