• Exporting Data from Sage 300 Pervasive SQL Database on a Recurring Basis

    We are working with a company using Sage 300 on a Pervasive SQL database. They are interested in exporting data such as GL, AR, and AP transactions and other table information, such as accounts, customers, and vendors. I'd like to know if there are…
  • OE import error "Negative Inventory Levels"

    Hi All, I have performed an OE import successfully in most of the cases. However, I have encountered the captioned error for some items at zero stock level at the moment which could be imported as OE successfully for one OE, but not the others at different…
  • The values of "Category" in timecard import sheets

    Hello, I need to know the values I should use for "CATEGORY" in time card import sheets,,,,can someone help pleeeease? BR
  • installation 2016 Server 2008

    We were really hoping to stick with a 2008 box for the Accpac install. Did we miss our window of using 2008 by a version or two or are we long done with those versions? We're also looking at the possibility of using server 2016. Is there any chance…
  • Import Inventory Control Preferred Vendor flag is not working, how do you mass update preferred vendor in the vendor details?

    I am struggling with importing the preferred vendor field in IC Vendor Details, even when I export and force the field to Yes (Check box) on re-import it still does not update the required field. When I check the ICITMV table that field does not even…
  • Bulk Import of Items in I/C

    I'm wanting to add about 600 items to an already existing list of products in our datasbase. So, I exported 3 lists: I opened I/C “Items”. I created a script that would contain all the columns we use in that first tab (of the Items Module), and the…