Sage 100

Hello how do I obtain install files??

Hello, I made a change to the ReOrder Maintenance screen for myself when I view it in Sage all looks good. I now want to copy the panel to another user so I copy just the ReOrder Panel it doesn't show the changes in the other user. I then delete that…

I've been using Sage 100 since 2014. While the reports I pull from Sage are good for viewing and provide general information, they're not well-organized for analysis work. For instance, I have an Open Sales Order report sorted by Order Number, which makes…

In Sage 100 v2023, client has rights to see PII info and can see Tax ID number in Vendor Maintenance. However, it shows as masked in an ALE Lookup AND they can no longer search by that field. Their procedure when adding a new vendor is to search first…

I am trying to update the Alias Item for new items created for a POS system. I need to create an Alias Item for each new item created and the Alias Item needs to be = UDF_UPC, it also needs to be a "General" type with the Alias Item Description ="SKU…

Hi Everyone, I do not see the memo button on my customer maintenance screen. Where can I add the function for all of my users who will need to be able to see and change the memo when needed under the customer maintenance. I tried going into the AR Memo…

I created a task in the Sage 100 task scheduler to update PO batches. If I hit 'Run Now' button in the Task Scheduler module, it all works perfectly. However, I can't get it to execute at a certain time each day. Windows task history shows it's executing…

Hello... I created and updated a second BIN location field I wanted to add to the REORDER Maintenance screen. However during customizing screen when I display all fields and UDF's it doesn't show??

I am trying to find a way to return the description of a UDF using SQL. I am currently using the following: Select * FROM JT_Employee But I need to bring forward the descriptions of the UDF's. So for example, "UDF_F_Name" would return "Employee…

For anyone familiar with setting up AR invoice printing form codes, do you know how the crystal report determines the maximum number of digits a field can be? We have one where it's saying a field has a maximum character limit of 15, but it's set higher…

I'm using the line of code below, but I'm getting an error stating: "The Description is greater than 30 character(s)." No doubt this is because the step description is stored in the JT_WorkTicketText table (much like the CI_ExtendedDescription table)…

Hello, I'm creating a UDF field to duplicate a stock field so I can add the udf to the Open Sales Order Report Selection filter area do I need a script to make the ud field equal the stock field. I believe I read a post here that I did if so does anyone…

Is there a way to import new UDFs into Sage and to place multiple fields on a panel at one time? I have 50 UDFs that need to be created and I would prefer not to have to manually create and place each one of these fields. Is it possible to mass create…

Hello, I am hoping to find a way to add a tab (or a few) to the "Employee Maintenance" screen in Sage to allow for more fields to be added under different department specific details. Running Sage 100 Premium 2021 (Sage Version 7.00.2.0) (Payroll…

With identical UDF names in both tables, the original value set into the SO Header UDF via a ColumnPostValidate script from a standard field works to flow the value to SO History Header, but subsequent successful updates directly to that SO Header UDF…

I am calculating a UDF (by script) on each SO Line. I need a script that will accumulate those Line amounts and save it to a header field. I'm hoping some smart guys knows how to do this.

I am attempting to write a Sage BOI VBS program to read and write to the SO Shipping Data Entry Package Tracking By Item object and am receiving the error <NewObject Error: 200>. I am using a Sage user that has full access to Sage and have the company…

We use Sage 100 Advanced 2023. We have an item, Honey Straws that we make up into 50 packs to sell. We buy these in boxes of 2000. There are about 2 dozen flavors we offer, but for the examples, I will use Apple as the flavor. All items have similar setup…

Hi Forum, I've been trying to update Standard Sales Order line promise date from Master Order Lines with no luck. I am getting The Promised date from the last line in the Master Order updated only, all lines on Standard order with same date. Here…

I should start off by saying we are still on v2020 for compatibility reasons. It appears that the `oBusObj.DocumentTotal` property (Sales Order Bus) doesn't calculate on quotes (it's value is 0). Is this intended behavior? The moment I change the order…

Dear all, Is there a way to have a short script alone with the BI script to show error message on why my script doesn't work. In other word, how to trigger error message on a BI script, something related to this code - oBusObj.LastErrorMsg. Correct…

After reading a few post about updating UDT's from scripts I am wondering if my events are wrong or do I need to SetKey before SetValue? In the debug I couldn't get any return values, so I am guessing my events are wrong, I've tried a PRE-WRITE and a…

We currently use Instadocs to attach specific files to SO's and PO'S, etc.. Is it possible to attach a pdf to a specific PO and then print the PO to pdf with that specific attached file in the same pdf file? I would not think it's possible but....

'Error 88: Invalid/Unknown property' on reference to a business object from within the same object I am trying to browse the records in the 'SO_SalesOrderDetail' from within a Column Pre-Validate script on ItemCode in the same table'. This works from…

Getting an error when trying to add in the zeroingll to a spreadsheet tab. There are no non-numeric fields in the column used for checking. What else to look for?