Importing purchase invoices and sales invoices

SOLVED

Hi,

I need to export purchase and sales invoices from a software we have developed and transfer them into Sage 50.  I have followed instructions for using the .imp files to transfer the information and this part is working great up until we have to import it into Sage 50.

Our problem is not the format of the file but the way that Sage 50 imports the file.  For every invoice, there's confirmation window for the vender/customer and for every detail lines.  There is always at least 2 lines of details so that means that if my customer is importing 50 invoices, he has to confirm information at least 150 times.

We've called Sage and they've told us that there is no solution to this.  I've found, in the documentation, a way to workaround this and it is to go to the vendor/customer file and, into the Import/Export tab, to check "This customer uses my item numbers on orders" or to manually match every items number.  It doesn't make sense to handle this on the vendor/customer side because the information is actually coming from and external system that tries to tie with Sage 50.

Is there any other alternatives to the .imp files?  I've noticed that Sage 50 uses a MySQL backend but it doesn't feel right to me to push and update information directly into the backend.

Hope somebody has a good workaround for this.

Thanks,

Denis.

Parents
  • 0
    verified answer

    Hi Denis,

    If you're after a quite straight forward process you might like to look at the Sage Importer.

    At Receipt Bank we've worked with Sage 50 users through using this thirdparty tool; Sage Importer (www.import-web-orders.com) This product allows you to send over purchase invoices from our product to Sage 50 via a CSV or XLS file. I would think that if you can export your information from your proprietary software into a CSV file, the sage importer product also would allow you to send purchase information on mass.

    Good luck with the project.

    Let us know how you get on.

    Steve

    (Data Conversion Enthusiast)

Reply
  • 0
    verified answer

    Hi Denis,

    If you're after a quite straight forward process you might like to look at the Sage Importer.

    At Receipt Bank we've worked with Sage 50 users through using this thirdparty tool; Sage Importer (www.import-web-orders.com) This product allows you to send over purchase invoices from our product to Sage 50 via a CSV or XLS file. I would think that if you can export your information from your proprietary software into a CSV file, the sage importer product also would allow you to send purchase information on mass.

    Good luck with the project.

    Let us know how you get on.

    Steve

    (Data Conversion Enthusiast)

Children