• Issues with Sage 500 latitude and longitude on sales orders

    WE have a custom Sage 500 task that creates sales orders from external data - I am seeing an issue where I get an error in my SQL profiler when creating a sales order and calling the stored proc spsoGetSOLineDist That does an insert into #tsoSOLineDist…
  • Error Creating SO Kit Component Records

    After trying to import an SO using SOAPI, the import fails and I receive this error in the tdmmigrationlogwrk table: "Error Creating SO Kit Component Records". All the items look to be set up as singular items. What could be causing this error?
  • Commit sales order and process invoice through data importer

    Is there a way to commit sales orders and then create invoices for them by inserting into staging tables/executing stored procedures?
  • Migrating Sage 300 to Sage 500

    Hello Community, I have a couple questions that i need help with. We are thinking of moving our sister company, that is using Sage 300, to our Sage 500 software. Has anyone successfully done this before? Can someone point me in the correct direction…
  • Exporting to Excel

    Hi my name is Miguel and I work for a small company. One of my coworkers has been able to export data to Excel before, but suddenly ran into this issue and I haven't been able to find a solution. I believe they are running Office 2010.
  • Data Import Manager

    Hi, We have a vendor that sends us invoices in pdf and an xml file. To save the people in accounting some time, we are looking at importing the vendors invoice(s) into Sage 500. We have the Data Import Module. Is there an example of an XML file or…
  • Data Import Manager - Pending GL Transactions

    Hello! I'm trying to setup a data import task for pending gl transactions and am getting this error when running: Description: "output "JournalDetl$" (9)" contains no output columns. An asynchronous output must contain output columns. We have a…
  • How to Install SQL Component "FlatFileProvider"?

    In Data Import Manager > Maintain Source Connection, I'm creating a new connection to a comma-delimited file. I'm selecting "Flat Text File" as the type. I'm getting the following error when I try to save it: Unable to preview the text file contents…