x Want to participate? Join the group to interact

  • UDF From AP Open Invoice to Manual Check Entry

    I have a UDF in AP Open Invoice and AP Open Invoice History. I have it flow through check printing to check printing history. What I cannot get to work is if I do a Manual check and select an invoice, the UDF does not populate. I have it in the AP…

  • Time Difference In Query

    Does anyone have the syntax on how to perform a time difference in a Sage Query? Here is an example query: SELECT "SO_SalesOrderHistoryHeader"."SalesOrderNo", "SO_SalesOrderHistoryHeader"."CustomerNo", "SO_SalesOrderHistoryDetail"."ItemCode", "SO_SalesOrderHistoryDetail…

  • ODBC Query question.

    I have to run several queries on SalesOrder and SalesOrderDetail in both current and history tables on a list of job status codes. Processing the queries takes way too much time. The status codes I am interested in start with a letter and end in two…

*Community Hub is the new name for Sage City