Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
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…
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…
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…
Hi
I am trying to see if someone can point me in the right direction to find out how to add an existing column to the data entry screen.
I am currently using PO Entry and i would like for the the quantity on hand field to be displayed when an…
Hi Experts,
I wrote a script that will allow a user to enter a secondary ID number (not the Sage InvoiceNumber) in the InvoiceNo field in CashReceipts Entry detail. The user enters the secondary ID, my script grabs the number, looks up the correct Sage…
We have some standard price level codes we use that are set up for each item, if you are a wholesaler you get X price, MSRP has its own price code, etc. The descriptions for these codes are universal, W always would be described as wholesaler for example…