x Want to participate? Join the group to interact

  • AR (or OE) table with unpaid invoices

    I am trying to locate a table from which I could find invoices for all customers that are unpaid.

  • SQL TIMESTAMP from AUDTDATE and AUDTTIME

    I have a requirement to create a SQL view with a timestamp field for synching purposes. Converting the AUDTDATE to a date is old hat - creating a combined field was not intuitive (for me). After pecking at it for a few days, I have an approach that works…

  • Is there a link on How to use sage intelligence using the connectors ODBC Driver in EXCEL to link the data in excel ?

    Is there a link on How to use sage intelligence using the connectors ODBC Driver in EXCEL to link the data in excel ? We are trying to get information from Microsoft Excel data to be use in the integration of ODBC Driver SQL Server of Sage Accpac…

  • Sharing: AUDTTIME to local time via SQL

    I needed to convert the Sage 300 time field to locale time in a SQL query. I put the following together from a Stack Overflow post. It, however, doesn't take daylight savings into account (and apparently that's not the easiest thing to do). SELECT DATEADD…

*Community Hub is the new name for Sage City