Sage 100

Hi, I experiencing errors in customer maintenance on a custom tab. I'm using the debug window and found 1k+ lines on several clicks. Error:0 Error:11 Error:12 Error:13 Error:14 Error:2 Error:20 Error:23 Error:26 Error:27 Error:36 Error:65 Error…

Is there a way to disable the information or other clickable links in Sage100? I have a client that does not have web browsers installed on their terminal server and users are clicking on the links and getting errors. They would like to prevent clicks…

How do people manage per diem when employees are using the simple time card app? We're not seeing where it's an option.

I am working on an issue after a new a install of Sage 100. The font on the Sales Order Entry Module is tiny. ( See attached Pic ) . I have adjusted the resolution and scaling in Windows. But this has not made any difference. All other Sage modules and…

I have a request to add an "options" button that will open a custom dialog box with various button scripts performing different functions. One in particular is hiding some elements on-screen for what I suppose is to sanitize some information for screen…

We need to have the ability to use Penny Test to verify bank accounts for a vendor instead of Pre-Notes. There are too many ways that fraud can occur by just using Pre-Notes. I created the following idea. If you agree, please vote for this. www5…

I am trying to hide tabs 3, 4, and 5 for Customer Maintenance for a specific user. I know I could set the fields on the tabs to hidden, but the user wants the entire tab to be unseen when looking at Customer Maintenance/Inquiry. I cannot delete the tabs…

if an employee has a customized panel (which overrides the all user panel ) how can we return the customized panel back to the all user version? we had an employee accidently create a customized panel and it is not correct how can I get her back to…

From the Payment tab in SO Invoice Data Entry I have added a button with the caption "CC Receipt". Upon a user clicking this button I would like a comment (Item code /C) added to the next line number with details from the credit card. First I actually…

I have added a button script to the SO Invoice Data Entry MAIN panel and was wanting to make looking up an invoice that has already been batched a little quicker. Essentially, instead of the user typing the invoice # they would type the sales order…

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…

We recently upgraded to Sage 2022.1 and one of my employees was frustrated because every time she resized columns in the Sales Order lookup window, they would revert back - even after creating a custom view. I tested it on a few other lookup windows…

I have used this code for years me and a handful of others, but we have a few new users that are having issues and can't appear to use my app to open Sage Sales Order. The only indicator they get is SO_SalesOrder_UI in a message box. Here is the…

I have a script to delete CSP pricing on the IM_PriceCode table. I was wondering would there be a way to run this script outside of SAGE say from Task Scheduler?

We have Sage 100 2018. Looking to add the Routing Number/Description to the Work Order Inquiry Header screen. Can this be done? I can only seem to add UDFs in Customizer. Is there a way to add existing fields to an existing panel? Thanks, Ryan

Hello I was just wondering If I can trigger a user defined script, with table IM Item Warehouse? I'm looking to trigger a script when there are changes on an item inventory. I see a field named Available on Item Maintenance > Quantity, I'm assuming this…

Hi friends, We have a business requirement to have a vb script that would pop up a message box on the sales order entry as soon as we tab out of customer no field or set as a user-invoked button. If the customer has any open invoices that are past…

Can anyone tell me how to do a basic SendKeys script for the picking sheet printing window? I tried and I can't get it to work. Not really familiar with scripting, but this seemed like it would be easy.

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…

Is there a way to classify vendors in the AP module to customize access to certain vendors? We handle some employee compensation through the AP module, and would like to restrict access to those "vendors" while allowing the necessary access to all other…

I am attempting to add the same UDF to two different tabs in the same module. But, I receive the following error when I do: Field "UDF_FIELD_NAME" has already been placed on panel "PANELNAME" of this customized library. To add this UDF to this panel…

I would like to limit users to only be able to enter the numbers 0 to 9 or a decimal in the CI_Item.ShipWeight field. What would be the easiest way to do this? Thanks,

Hello Everyone, We are currently on Sage 100 Advanced v2018. I am trying to create a VI Job into table AP_InvoiceHeader to load AP Invoices into AP Invoice Entry. but i keep getting an error during load from my Excel FIle that i am using. adding…

Hi all, I have recently created a script for the field "invoiceDate" that restricts how far into the future a user can enter the date for. I am wanting to apply these restrictions as well for the posting date. This should be relatively easy, except…

Currently I can set the default ShipDate on SO_InvoiceHeader using Custom Office however the moment I link a Sales Order to it the ShipDate changes to whatever the ShipExpireDate is for that Sales Order. How can I prevent that and keep the default of…