Sage 100

For most tables, when I create a user defined field (UDF), the history table automatically gets the same field added and the data gets copied into the history table automatically. It looks like AR_InvoiceHistoryDetail may be getting records from both…

We are trying to add a UDF to Cust Maint. The purpose is to select another customer in the Cust Maint tabble to be used as a referral. Eg; If a new customer is created "ABC" and an existing customer referred the new customer, we want to use the…

Need a tutorial on Pick Tickets Other than SO_PickingSheetWrk.M4T, where Sage end the picking process? There are no fulfillment functions in Sage, correct? How do the Pick transactions end in Sage 100 (without AddOn/Exteneded features Scanco etc…

Silent ODBC is working, but cant add a SQL linked server. error code below Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "SAGE200". OLE DB provider "MSDASQL" for linked server "SAGE200" returned message…

Has anyone used the new v2020 feature under File, Desktop Utilities, Customization Import? I have an upgrade from 2017 to 2020 and have classic users on the 2017 version with shortcuts and the boxes to check for importing are blank. There doesn't seem…

Is it possible to modify the name of a report that was added to our AR Custom Reports menu?

Hello, In Sage 100, I've added a UDT with a list of items, and a UDF onto Sales Order Header which enables user to select an item from the UDT. After selection, I also want to pop up other fields (also UDF) based on the selected item. Basically, pop…

Sentence two: "Clear this check box to include existing records" doesn't make sense for this field. v2020 and 2018, so it's probably been that way for a while. Can someone correct the above sentence in Help?

Is there somewhere in Sage 100 that I can see the field lengths for each field in each table? Here is why I ask: the stock Sales Order printing report shows only the first 100 characters of SO_SalesOrderWrk.CommentText. We have many records having…

Haven't had any luck finding an answer to this so hoping you all can help. Currently when you search using the "Description" option on a web search, it only searches Item Name (short description?) and not the Long Description (extended description?…

I have successfully been able to create queries that can access the data in Sage but I am now trying to query data from a UDT and I am getting an error. Can anyone advise how to workaround or solve this error? This query runs fine: select * from …

Hello, I have been playing around with Visual Process Flows and am curious whether or not it is possible to link to a specific VI job? I know that I can link a button to job select, but how do I make this button open up a specific VI job? I have tried…

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…

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…

Hello, I am scripting a button that, when clicked, opens up the sales order history lookup from the Invoice History Inquiry panel. I am trying to get this lookup to already have the sales order number entered that is shown on the current panel. For…

Using Sage 100 ERP v2017. I am trying to run a very basic MS Excel query in order to build a database for our new website. Literally, all I am trying to get is the product part number, description and the name of the item image. My query is as follows…

Hello, Our users are having problems seeing the invoice number inside of Customer Maintenance when clicking on an invoice, and then clicking away. The invoice number is all white on a grey background..I know that I can change the color of the panel…

Hi Super Heroes, 1. we used TCP 9500 as the port id, and it is working fine after we disabled the firewall for domain users. What other ports do we need to open other than the 9500, because after i opened 9500 inbound and outbound, server pop up with…

Hello, Our accounting team is having trouble with people posting to future periods which I am trying to resolve. In our test company, I have tried using the "Restrict Accounting Date to Current and One Future Period" in the company maintenance tab,…

Is there a combination of settings that will make SAGE 100c readable in all windows? I can enlarge the font in the launcher, but the field labels font in the module windows is so small and hard to read. If I change to the Classic theme, the fonts are…

Hello. I have noticed that Loaded Weight on the Shipping Ticket is usually about double the actual weight so we have to write the weight on the piece of paper. On one Shipping Ticket I checked the weights in the system and it adds up to about 13,000 lbs…

Hello All, I have added one custom Report to Custom Reports to one of the menu, by using the report manager, Now I would like to change the name of the report, so if I go back to "Report Manager" and open a "Custom Reports" in "General Ledger",…

I have a VI job that is exporting just 2 little fields. However, I need to do the Select criteria based on two fields in two files being equal. My base file is the IM_ItemWarehouse file, and I only want to export records where the warehouse field is equal…

I'm trying to pass a field from PO Receipt Details to the PO_ReceiptOfGoodsInvoiceWrk table which is used to generate the Receipt of Goods Register. We have added a field in PO Details which is passed to Receipt Details which I want to pass to this Work…

Is it possible to change the name of the modified canned report? if so, how? Thank you.