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.
