Browse By Tags

  • No longer able to Import Data into Excel

    Across our network users have previously been able to run the data query as explained in the Sage article https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=51308&sliceId=1&noCount=true&isLoadPublishedVer=&docType=kc&docTypeID…

  • Successfully querying customer notes field BPCREM in BPCUSTOMER

    I'm trying to pull the customer notes into a spreadsheet along with delivery text information for a migration. Whenever I bring over this field , it spills over onto other lines and as a result when I export the data it is all choppy and screwy. I'm assuming…

  • RE: Query for job costing across three databases

    Well, this has proven to be a bit of a wild goose chase so far! I've had a few offline discussions with Richard Ridings as well, and I now have a query that works fine (thanks Richard!) - as long as it is run manually. I can run all three - manually…

  • Query for job costing across three databases

    I would like to construct an SQL query, which dumps to Excel, an analysis of the job costing for a range of jobs across three different organizations. All have virtually identical structures and naming conventions. There is not a ton of data to grab,…

*Community Hub is the new name for Sage City