Sage 100

Hello, I have a user-defined script that calls an API. The URL could have an variable that contains a slash ("/"). Of course, this causes a problem in a URL because it is interpreted as a path. The way to handle this is to encore the string before appending…

I'm just trying to print, or at least view, a list of all of our UDF's from the UDF and Table Maintenance. I'm getting the dreaded error #65: Window element does not exist or already exists:CM_UDFMaintenanceListing_rpt. Tried renaming the existing file…

Hey All, I am having an issue with our Work Ticket in Crystal Report. For reference, I have Sage 100 2019 Manufacturing. The Manufacturing Module houses all of the JT tables pertaining to the creation of Work Tickets. The Crystal Report for our Work…

1) For inventory, I'm trying to get the sum total of all inventory in warehouses where warehouse number in (100,200,300). Additionally, my formula for getting the inventory is: IM_ItemWarehouse.QuantityOnHand -IM_ItemWarehouse.QuantityOnPurchaseOrder…

How do I get the RefId to generate the Link under cases? Can I get the Java language to Create this link? It used to be there and it is gone.

I'm new to these products and a bit intimidated by the extensive documentation. Before I waste a lot of time trying to make a change to a production system work correctly, I'd appreciate a simple answer: Is what I want to do possible with these products…

When I use Sage 100 Customizer to add customized panel, I noticed each panel has a W version, eg, In the task of Sales Order Entry, there's a DMAIN and a DMIANW. What's the difference between the two? Can I set the default display to be DMAIN instead…

When issuing receipt of invoce and added comments, I'm not able to see comments when printing DTR. It only shows PO Receipt entry. Is there a way to show comments added when issuing receipt of invoice.?

I'm trying to create a view in search in Item Maintenance that would have the system display the total quantity available by, in a new field, subtracting from IM_ItemWarehouse.QuantityOnHand, IM_ItemWarehouse.QuantityOnSalesOrder and IM_ItemWarehouse…

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…

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…

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…

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…

Hi everyone I'm trying to write a script that will mimic the quick pick sheet printing (ask if to save the changes & bring up the pick sheet dialog for the order selected). I'm using a new button for that on the sales order. The reason being, I need…

Greetings, We are running an older release of Sage 100 (4.50.40) and we have a third party extended solution called M9-SO-1099 'On Demand' Sales Order Fill Report which was provided by Blytheco. The manual for the add-on is here. https://wiki.blythecodev…

I am trying to get orders from our website to save the CC when they come into Sage. We currently run Sage 100 5.3.2. There is a checkbox in SO Entry on tab 5 to save CC. I created an advanced field setting in custom office to set this value to Y. …

We have just switched to 100c. I, as administrator, can change to the new ribbon, themes, etc. When my employees try to use the "settings" at log in, it says: You do not have permission. Where is the security to turn this on? I have tried searching for…

I know you can print a file layout from the File Layouts and Program Information window but that does not show any custom or UDF field. Is there a way to print the file layout with those fields too? We're preparing to upgrade from Sage 100 v.4.4 and have…

Working on an upgrade for a client from 2015 to 2016. The validate address button seems to be missing in 2016 on the address tab of sales order entry and invoice entry. If you click into the ship to maintenance it is present there. It is also present…

Does anyone know of a function that can be used in VI to evaluate a temp field as to whether it is numeric or not. I need to do conditional value assignment based on whether a temp field is numeric or not. I realize I can do this by adding the field in…

Can someone outline the process to go into AP and change the characters to 50? Appreciate it.

Can someone describe the process that needs to be done for this? Thank you,

MAS 4.5 When adding a new item through the sales order screen, received this error: Error in screen definition Screen item PMAIN Error #2 Invalid Mnemonic or position Name: SuggestedRetailPrice I'm guessing this means the field uggestedRetailPrice isn…

We have a new crystal report that references the largest tables in the database, the sales order header and detail tables, and we had to a UDF field to one of these large tables. The crystal report references this UDF field to make a calculation, and…