x Want to participate? Join the group to interact

  • What is the best way to clear data from non financial accounts each year?

    I keep 5 different non financial data accounts as well as a non financial clearing account. I planned to reverse the totals from the previous year as an entry on 1/1/2022. This works, but skews data in January. Is there another way to do this? On the…

  • AP and Cash issue - An invoice was paid once by check and a second cash ACH sent after the check didn't clear, then the vendor refunded the overpayment

    We paid an invoice three months ago by paper check for say, $100. The check didn't arrive to the vendor, and so we then paid the invoice by ACH for $100. The ACH cleared, and then they also received and cashed the check. When the vendor realized they…

  • Is Sage Intelligence 2015 and Microsoft 365 compatible?

    I'm running Sage 100 Premium 2020 version 6.2, and have Sage 100 Premium Intelligence 2015 installed. Our IT department installed office 365 yesterday, and now I'm getting an error message in excel about the BI extension. No values in cells in my intelligence…

  • Sage 100 2021.1 slow module opening

    The slow performance within a module that I complained about last month seems to be cured by rebuilding the search index, but performance when opening a screen (eg. item inquiry) is quite a bit slower than 2018. (old thread: https://www.sagecity.com/support_communities…

  • "the lock information was not found"

    When I try to open a sales order I get the following error dialog "the lock information was not found" This is from Sales Order Entry on Sage 100 2019 Premium.

  • Is it possible to export the security roles and user settings from any version of Sage but in particular from Sage Premium?

    I need to re-migrate system settings during go live after a long pilot testing period. Multiple changes have been made in the source version since the pilot began. I was wondering if I can export the security roles and user settings from the upgraded…

  • HRMS and Sage 100 coexisting on the same PC

    I know there is an order for installation that will allow HRMS and Sage 100 to peacefully co-exist on the same PC, however I am not sure what the exact order is. Also when ever we do a quarter update with HRMS, we invariably break Sage 100 (specifically…

  • Sage100 Crystal Report designer preview asking for a password

    I'm editing accounts payable checks in crystal reports. I click on "View" and then "Preview". It then has a popup that says OLE DB, and then has the following fields: Server: OURSERVER\SAGE100V2017 User ID: Mas_Reports Pasword: *blank Database:…

  • Merging files taking 2 hours or more when updating Sage 100 2019 Premium

    I recently installed Payroll 2.20.1 and the PR hot fixes to an installation of Sage 100 2019 Premium. Today I installed the Fixed Assets module and the Canadian Zip Codes to an existing installation of Sage 100 2019 Premium. In both cases the "Merging…

  • How can I do consolidated non-financial reports in Sage Intelligence for Sage 100 Premium

    Our client owns the connector. I know how to do this for Sage 100 Standard and Sage 100 Advanced installations but can't seem to figure out how to do it in Sage 100 Premium. Any ideas would be appreciated.

  • Sage Alerts SQL Statement

    Would anyone be willing to share a SQL statement that tracks “Changes” in a SQL Server Database? I'm trying to use Sage Alerts and Worksflow w/Sage 100 Premium and I want to be alerted when a SO field changes from "Y" to "N" and have to use the SQL view…

  • 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…

  • Has anyone experienced slow performance In Sage 2019 Premium running on MS Server 2019?

    When I open sales order entry it may take up to 20 seconds to open the module. I don't know what's causing the system to run slow. My environment has two MS Server 2019 instances in VMware one for SQL the other for the sage application. I don't see any…

  • 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…

  • Sage 100 Premium

    We have a new client that would prefer to use the Premium (SQL) version over the Providex version. We currently do not have any Premium installations. Just checking in to find out if there are any "quirky" installation/implementation issues that we should…

  • Sales Order History files not created?

    Hello, We had something strange happen once last week, and now once again today. We had an order which was not acceessible through Sales Order and Quote History, so accounting contacted me. After checking our database, I noticed that there was no…

  • Error 19: Program size is too large (During SO Journal update)

    Hello, During our end of day procedures we had the following error come up while trying to update the SO Journal: We had an average day of sales, and have had many days which had greater sales. However, the error says 'PROGRAM size too large', not…

  • Accessing Business Objects with a Client side script?

    Hello, I have a script complete that runs a SQL Query and returns the results back in a MsgBox. The very last part I need to do is access the Sales Order Number to include this in my "Where" clause for my Query. This needs to be run on the Client…

  • 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…

  • SDATA with Sage 100c 2016 Premium installed on Windows 2016 Server

    Hopefully someone here can assist as Sage Tech Support could not answer the question. Is the SData connector compatible with Sage 100c Premium (SQL) on Windows 2016 Server? If yes, what version of the adapter? (Extra love for a link to it!) …

  • 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…

  • Unable to get previous Sales Order Lines on table - Pre Write?

    Hello, I'm simply wanting to write the previous item code to a UDT when the line is changed in a sales order. For example, if the item code was abc123 and a user changed it to def456, I want to write abc123 to the UDT. However, each time I try to access…

*Community Hub is the new name for Sage City