• Where is the AP File Format for importing?

    I can easily find the GL file format, but not the AP file format for importing. How can I import into the AP Module? Where is the file format?
  • Generating shipments per line

    I am using the data import manager API to migrate sales orders into Sage 500. After they are imported and picklists are created however, the shipments that are generated only include the first line of every sales order. I need the shipments to include…
  • Data import manager: Cannot create a multi-format text import job

    FormerMember
    FormerMember
    For reasons I won't go into in this post, I cannot use Excel as a source for my data imports. Because of that, I'm looking at other formats. I got a flat text file to work for a very simple import which had only one staging table, but now I'm looking…
  • header record is missing

    Upon attempting to migrate StgSOLine table to the tsoSOLine table an error comes up saying: "Header record is missing". What exactly is contained in this header record?
  • Import customer

    Hi all, I would like to import customer and sales order details in Sage 500. Any API/ Web service example is available in vb or c# ? Please let me know if documentation is available for API or Web service list. Thank you.
  • Import AP Vouchers

    hello! we're working on automating processes and making use of data export and imports. the feed from our credit card service can include a return transactions, and consequently a negative numbers. the data import process is throwing a fit saying…
  • Data Import Manager- process AP payments

    Hi I'm trying to run a using upload manager a way to update payments. I see that there's an AR pending payments, but i can't find an AP pending payment. is there one? and if so, where can i find that? what's the name of the destination entity? …
  • GL Import

    We have been importing Journal Entries for year through the GL Import, however we decided to begin to import more Journal Entries to save time. Currently when we are importing the system will assign a Journal Number to it but it there a way for us to…
  • access to database

    hello i want to access sage 500 database , i am creating an application where we get the data from the client and we are going to run few calculations and implement it on sage 500 thank you