• Questions on Advanced Architecture of SAGE 100 Accounting

    Hello everyone, I'm reaching out to the community for clarification on certain aspects of the SAGE 100 Accounting solution's architecture and communication protocols, which I haven't found detailed information on. Application Server and Database…
  • Remoteapp and mutiple version of sage

    Has anyone ran two versions of Sage 100 Accounting software using RemoteApp on a remote desktop?
  • Sage 100 2021.5 slow data entry / auto complete

    Sage 100 2021.5 running on a Hyper V Server 2019 instance, 8cores and 24gigs of RAM. The server presently serves no other funcdtions other than some very light IIS tasks. CPU and RAM usage is minimal throughout the day. Sage is connected to SQL Server…
  • 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…
  • Sage 100 Premium migration failed...'KPRIMARY_SY_System' is already in the database.

    Test conversion from 5.40.3 to 7.0.1 Sage 100 Premium with multiple integrations. 5.40 instance and 7.0 instance are on same SQL server. This is the 2nd test migration, so MAS_XXX and MAS_SYSTEM databases currently exist in the new SQL instance. During…
  • Custom Panels Disappeared, need help!

    Hello, We have added many panel customizations including additional tabs, buttons with scripts, etc that are important for many of our users. I was just resizing a field in customizer, and when I went to exit the customizer an error popped up saying…
  • Two separate errors: Sales Order Batch Authorization (oScript.UIObj error, and 'Referenced statement invalid')

    Hello, We have been having issues with Sales Order Batch Authorization. Nothing errors out until the final step where accounting actually tries to process the credit cards .Here is the first, which I'm unfamiliar with: The second one, I have…
  • Simple Script to put New Orders on Hold not working as intended

    Hello, One of our customers inventory is showing up incorrectly and we need to temporarily put their orders on hold until we can go through them individually to ensure they are correct. However, I have been unable to get these new orders to be put on…
  • CR Entry not matching Customer Inquiry 'Invoices'

    Hello, We have an issue where we are trying to adjust an invoice balance. We are trying to set the balance due to 'x', but the adjustments keep showing up as 0 under customer inquiry (picture below). The amount is adjusted correctly in the Cash Receipts…
  • Misc item charges not being billed?

    Hello, We have a miscellaneous charge we add to certain customers sales order. I was just informed that although these are showing up on the Sales Order, the customer is not being billed for this. How would I go about ensuring that this miscellaneous…
  • Order was removed from SO Entry, but is "Active" in sales order History?

    Hello, We have an issue where an order is currently marked as an "Active Order" under Sales Order and Quote History, but this file is not accessible inside of Sales Order Entry. We get the message: "The Sales Order number already exists in the History…
  • Error Attempting to Open Crystal Reports via Script.

    Hello, I'm working on a project where I need to pass a parameter to and open a custom crystal report. I have done a lot of searching, and understand that it is possible, but I can't even open crystal let alone pass parameters. I keep receiving the…
  • Remove "Delete Customizer Modifications" for assigned panels?

    Hello, We are trying to set up our customer maintenance screen to look identical to customer inquiry, except for one tab so that a certain department can access just that one tab. To do this, I am creating a custom panel which locks all fields except…
  • 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…
  • Post-Write Script is firing before the record is written.

    Hello, I am trying to write a simple tracking script that records the number of items within a specific product line a salesperson has purchased. I currently have this script as "Table: Post-Write", but even if I cancel my order in Sales Order Entry…
  • Unable to create or copy company in Sage 100 Premium version 2018. Databases are not added and 42000 Modify File Failed errors occur

    Good evening. I have tried to create new companies and activate them in Sage 100 Premium. Currently creating a new company does not add a new database. Attempting to activate the company also fails Attempting to copy a company to a new company…
  • Scripting Dilemma (Pre vs Post Table write)

    Hello, I am working on a scripting solution that sets a hard cap on the number of free sample items a salesperson can receive. I currently have a UDT set up that tracks how many of each product line a sales person has, and am able to write to that table…
  • Visual Process Flow: Open file instead of download.

    Hello, I'm curious if it is possible to have a visual process flow button simply open a file instead of download it? I have a button set up linked to an excel document and another linked to a crystal report, but clicking these buttons causes an internet…
  • Help updating Vendor Email Via Script

    Hello, I am trying to update the vendor email address with a concatenation of some UDF email addresses that we have. I have used this same code to update UDFs, but I guess this is the incorrect syntax to update non-UDFs, but I can't figure out how to…
  • Abnormally High/Rapidly increasing Fragmentation Levels?

    Hello, We have been trying to troubleshoot our slow performance with SAGE 100 PREMIUM 2018 and are running out of options. I have read all the articles here and on the knowledge-base, and nothing seems to be improving our performance. My last inquiry…
  • Lines showing in Sales order History Detail, but not in sales order Detail?

    Hello, We are having stomething strange going on where 11 lines from an order are showing up in both the "Detail" and "History Detail" tables, but 3 are missing from the "Detail" table and are in the "History Detail" table. Any ideas? Apart from straight…
  • 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…
  • Purge Utility vs SQL Deletion: AR History

    Hello, We are looking to remove some data from the "Customer Maintenance" screen as some customers take roughly 30 seconds to load all of their history. I am specifically talking about records under tab 6 "Invoices", and tab 7 "Transactions". I am…
  • Cash Receipts Journal: Full amount is posted in General Ledger, but not to accounts?

    Hello, We had a strange event occur a few days ago. For one of our batches, the Cash Receipts Journal processed all of our checks except for the last 4 in the batch. However, the full batch was posted to the General Ledger, and the full amount shows…
  • 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…