x Want to participate? Join the group to interact

  • Information on fields from Wrk tables? Needed for Knowledge Sync.

    Hello, I'm looking to re-create a Crystal report so that it can be run by Knowledge Sync. I initially wanted to just use the report provided by SAGE, but it looks like I can't use this report as the information the SAGE report pulls is only generated…

  • SQL Table for batch history? AKA Batches not located in GL_CompanyActiveBatch?

    Hello, I am creating a report for our accounting department which shows all A/P batches that either remain open, or were created today. I have the first part, where I can pull up all active batches through GL_CompanyActiveBatch. However, I am having…

  • How to you link the SY_RoleSecurity table to the SY_Tasks table

    I need to link these 2 tables in order to see a report of user roles and related tasks. But there doesn't seem to be a clear link. The SY_RoleSecurity table has key field called TaskKey which ha values of 9 characters, whereas the SY_Tasks table has a…

*Community Hub is the new name for Sage City