Sage 100

Hello, I have a bunch of custom scripts that get triggered Post-Write on different tables, for example, sales order, item, alias, etc. Only one script would not trigger, and I can't find why. The script should trigger Post-Write on the table IM_ItemWarehouse…

Hello, We have a custom-defined script that triggers Post-Write on the table CI_Item. This script then reads the field 'ItemCode' of that table. We also want to extend this by triggering this script with other tables. I am seeking a way to retrieve…

Hello, We currently have Windows services (written in C#, .NET) that push data out from some Sage tables to a custom API, which then stores it in a private SQL Server Database. Depending on the service, it might trigger every minute, every 5 minutes…

Does anyone else have trouble with the Sage Time clock not matching the atomic time clock in the cloud? Is there a time clock in Sage somewhere that can be adjusted? Mine gets off a minute or two and drives the employees crazy. They cannot clock in until…

We are strongly considering moving to Sage Partner Cloud on Azure. One issue we can see right away is linked files. We scan all documents related to a SO invoice and create a memo on the invoice and attach the scanned documents which are saved on the…

Not sure if anyone else has experienced this, but it appears that if you add a UDF in Sage 100 2022 Premium, but only update it via the 'Pending Changes Summary', the UDF is created in the data dictionary, but is NOT added to the corresponding SQL table…

We are having several issues with updates in HRMS transferring to Sage 100 when we run the link. These include Wages, New Empoyees, Terminations. I run HRMS as an Admin. If I unselect all employees and select the employees that have changed from the audit…

I'm pulling data from across several Sage companies into a postgreq db to do some reporting on sales trends. What is the difference between ar_invoice_header (psuedo) and ar_invoice_header_history? ..and if you can tell me, at what point do they move…

Sage intelligence has stopped refreshing when I change the Period or Year. I have formulas linked to a Year and Period so that changing either cell with the Year or Period changes the data to that time frame. It worked fine in a previous report version…

I was attempting to create a VB Script (to be executed via an External Link button) that would update the billing address within a sales order from the customer's AR address. Currently our admins do not have the ability to manually change a customer's…

We are having an issue where we are modifying a custom report in Crystal (minor change such as adding a column) and adding the updated report back into sage. Users are not able to run the custom report anymore. The get a "The database login failed. No…

We need to be able to track who is making changes to a bank code in the bank code maintenance module. We are currently able to track when a change is made. Is this possible or would it require a custom script to do?

Hi Forum, Just did an upgrade from Sage 2016 to Sage 2021.2 Premium, We install Sage on a SQL database with MAS_XXX being updated thru SQL Mirroring (DSD) because the customer had internal tables already in it and instead to creating a fresh MAS_XXX…

Version: Sage 100cloud Premium 2020 (Version 6.20.0.01) Additional software: Scanco Operations Management & Multi-bin, Some custom DSD programming Hello all! First post here. Looking for some assistance when it comes to replicating data for reporting…

Hello, We've recently started populating our Bin Location from within Reorder Maintenance in order to start utilizing the Physical Count Entry screen sorting by Bin Location. The locations do not seem to sync properly between the two panels though.…

An overdistribution tier is created when we un-issue an item from a work ticket in which the item was never originally issued and the item has an on hand quantity in inventory of zero. This scenario occurs when we create a "rework" work ticket to add…

I was able to setup my Maintenance Wizard, but when I go into Display Dashboard, I get " Can't Reach this page" make Sure the web address is correct.

With the NEWS that DSD is retiring their SQL Mirroring solution as of the end of the year, I wanted to mention that I wrote a SQL mirroring solution for Sage 100 using the open source and free Postgres SQL 64 bit server. If you're looking for a DSD replacement…

(I think I figured this out as I typed out the question... answer below... posting in case it helps someone else). I have a custom report (for the purpose of detecting imported invoices with over-shipments by 3rd parties) which links invoice OrderLineKey…

Looking for other users that use Sage 100 Std (providex) with Sage Enterprise Intelligence. I'm working with Tangerine and they are having trouble connecting the data sync to my odbc connection.

We have a team of quote specialist who put an original quote together, using the best fit items for quoting purposes. However, once it gets turned to an order, subs occasionally have to be made to fulfill the order. We want to keep track of what they…

I just noticed some of our Item Inquiry screen are not correct. In the 1. Main tab it will show, for instance, 250 units on PO. In the 7. Orders tab it shows 250 On Order under Purchase Orders. When I double click the PO to open the PO Inquiry…

Is there a way to purge old data in time tracking. Client upgraded to 2.2 and now all of the data history for past 7 years is showing when they go to make an entry.

After we post each day the SO_SalesOrderHistoryHeader is not updating the DateLastUpdadted field. This is causing major problems with our B2B site. does anyone know what we may be doing wrong? We just switched to Sage 2019 2 months ago and it seems…

Have a client that's been using Sage Intelligence for several years. After upgrading Sage 100 to the 2019 version and moving to a new server, one report is not calculating correctly. Most rows are fine, but we have a range calculation that's not including…