x Want to participate? Join the group to interact

  • VI JOB Cash Receipts Import - How do you set up the job to validate INVOICE TYPE in the user's source column/field to be either IN or PP and never blank or null?

    Please help!!! Very simple VI job has been in use since 2015, maybe earlier. But within the last year, we have had at least 3 incidents, and want to make sure that if user forgets to populate this column of the AR cash receipts excel template, the record…

  • Sage Database Query with parameters of past year

    Hello Everyone, I am attempting to put together this ODBC query against the Sage database, and I am trying to return values from the past year, specifically using this parameter: WHERE AR_InvoiceHistoryHeader.InvoiceDate > DATE_SUB(now(), INTERVAL…

*Community Hub is the new name for Sage City