Export Transactions from Sage to .IMP file

Hi,

I'm looking for a way to export transactions from Sage 50 Accounting to a .IMP file so I can import it in another Sage database. I asked support and it looks like it is not supported by Sage but there are partners who can help. I just need a one time exportation for a week of transactions.

Thanks

  • I'm looking for a way to export transactions from Sage 50 Accounting to a .IMP file so I can import it in another Sage database.

    The required .IMP format is a little different for each type of transaction (GL, AR, AP) that can be imported, and there are some types of transaction (Payments / payroll) that can't be imported.

    So depending on which type of transactions they were, you wouldn't be able to import them anyway. 

    The .IMP file format was designed to allow (non-payroll, non-payment) integrations - i.e. a CRM sales system can dump out an order that Sage can import.  I suppose that if it was really quick and easy to do the work in one file and 'move' it to another file, it could become a method of executing a fraud - except that is how 'batching' systems work. 

    I asked support and it looks like it is not supported by Sage but there are partners who can help.
    I just need a one time exportation for a week of transactions.

    It's a bit more complicated than that, Just the data dictionary (listing of most user-accessible Sage 50 data fields) runs past 200 pages of small print, so it would take too much time just to map out the fields to collect the data from.  (and as I mentioned above, for maybe half the data)

    If you were to offer to pay me to reconcile these two Sage company files by the job, rather than by the hour, I would:

      - open both files, (preferably with two monitors)

     - run a journal entry report (without corrections) for the source and print it,

     - then drill down into each transaction and copy / paste / keyboard the information into the destination file and check it off the printout.