• Set Up 1099 Boxes Based On an Existing Year

    I know the below are instrcutions to create 1099 boxes based on an existing year. However, I accidentally clicked "No" in step 4 when I tried to setup Year 2022 and 2023. And I'm not getting the prompts again. How do I setup 1099 boxes now? Is there…
  • 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…