• Sage 100 Premium 2021.3 company background colors stopped working

    I set the company background color last week and now they are all the same. In Company Maintenance on the Theme tab I tried to turn it back to standard, then change back to classic and choose a new color, but it still isn't showing the background or frame…
  • Need help getting "Invoice History Printing" data in SQL database.

    Hello, I'm working on a project and I need to be able to pull the same information the "Invoice History Printing" report pulls for a date. For my selected date, in our database we have about 3,000 invoices. The report, however, only pulls about 140…
  • 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…
  • Possible to add editable UDFs to Invoice History?

    Hello, Our accounting team inquired about the possibility of making the "Comment" field on Sales Orders editable even after they are put into the history table.I do not believe this is possible, but was hoping that it IS possible to add a NEW "Comments…
  • Automate Statement Printing?

    Hello, We are looking to automate statement printing for our customers. I looked through the "Task Scheduler" provided by MAS and noticed that this was not an option. I have no experience with this sort of thing, but it seems that this should be possible…
  • 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…
  • Permissions working as intended?

    Hello, Our accounting department was trying to limit who has access to Vendor Maintenance, and instructed me to remove permissions for all users except for a select few. Unfortunately, when one user was trying to use "Receipt of Invoice Entry," and…
  • "The integrate to bank rec is required" error.

    I am currently doing Period End processing for my company, and have successfully completed it for our active company. However, we have an old company we still do maintenance on in SAGE, and while I was trying to change the Fiscal Period in GL I receive…