Hello,
I have a bunch of custom scripts that get triggered Post-Write on different tables, for example, sales order, item, alias, etc.
Only one script would not trigger, and I can't find why. The script should trigger Post-Write on the table IM_ItemWarehouse…
How would I go about adding a description field that displays the corresponding description record for a UDF? Does this require scripting or can these be linked in Custom office? I dont want someone to be able to select available descriptions from the…
I have created a user defined table with a key field name and six additional fields. I have added created a field in AR_RepetitiveInvoiceHeader so I can select the key field from my table. Is there a way I can also show the other fields in the table on…
Hi,
I want to add a UDF in the JT_Employee table and within the UDF maintenance I see i should be able to use a UDT to limit the options being chosen. When I select the UDT validation button, a few UTDs are available but not the one I want. How do I…
Why would a Sage 100 2022 Customizer Utility import fail if it is used to copy from a ".M4X" file a P/R UDT, VI jobs, and event script to the same level (Both are Sage 100 Standard 7.10.2.0 and P/R 2.23.0.0) from which it was created?
Receive an error message - unable to draw folder control on any customized panel where an extra tab has been added. It works in 2022.0 but errors out after installing PU 1. Deleting and recreating the tab in version 2022.1 works. I'm working with Sage…
I created a Date UDF in PO Receipt of Invoice. it populates correctly. I'm trying to get this data into the AP_InvoiceHistoryHeader & AP_TransactionPaymentHistory.
I've tried several links and can't seem to get the correct combination.
Can someone…
I have created a UDF in A/P Invoice Header to hold a document number (separate from the invoice number) on our A/P invoices being imported from a 3rd party solution. That will work for invoices being created now. What would be the best way to update existing…
Looking for opinions on if the the one to many scenario in Sage 100 can be created with Custom Office: one item # to many different models for example. The goal is to be able to search a model # and see all the item numbers that are compatible with that…
User selected all fields and made the lookup default. Lookup no longer works. Gets a message "No table entry for file CI_UDT"
Does anyone know how to make this "NOT the default" and then we will have access and can delete:
Or is there another…
We have different types of picking sheets that we use and print multiple types per sales order. Everyone always forgets to change the form code so we waste a ton of paper. Is there a way to add another button to the Sales Order Entry page to open up a…
I'd like to modify the order in which lines are displayed in the secondary grid in the Sales Order Module (Sales Order Entry).
We have several UDF's in that grid, but I am having trouble seeing the list of fields within that secondary grid. Using customizer…
Sage 100 2018 Customizer question All Inventory items are FIFO Valuation Client wants a Date UDF added to the PO Receipt of Good Lines I added the Date UDF to the PO Receipt of Good grid I need to know the steps on how to get this Date UDF to post thru…
We just did the SAGE 2021 update and something all of our people are finding an issue with is In SO entry screen under the lines tab we used to be able to have the columns in the order we wanted and have what we wanted to see and it would remember it…
I have 20+ UDFs in ROG entry and they have been working fine over the past 2 years. Now managers want some of these UDF to be required. When I mark just 1 or several or all of the UDFs in ROG as Required, no Item code appears when I select 'Yes' to "Do…
Just discovering the power of Custom Office (I'm a newb). I am running into a wall with one particular item. I have worked my way through creating user defined fields and tables and can successfully customize panels in screens and modules, but I'm stuck…
Hi Everyone,
I created the following Script and there are no errors. I am trying to figure out how many packages are needed by dividing the Quantity Shipped / Pack Qty. The issue is I do not know how to ROUNDUP in the Sage 100 Scripts.
Example #1…
We are on Sage 100c 2019 and I'm trying to find out a way, that when BOM Production Entry is launched and we go to the lines tab, that the line sequence is NOT alphabetical/numeric ascending (which appears to be the default), but based on the way the…
Since the default customer price level is only 1character, I'm considering making a UDF and then having SO and SOI reference that column to populate the price instead of the default column.
I haven't played with Custom Office since I haven't really…
I am trying to export a report, by vendor (or product line), of the quantity of items sold AND issued for the last 12 months. We would like to be able to export it using any custom date range that we want. What is the best way of getting this data? I…
Hi Community,
We have just upgraded a customer from V2015 Standard to V2020.1 Advanced and I have noticed that the UDFs in the selection grid on reports are no longer in alphabetical order - we have a couple of UDFs (12) but in the selection grid without…
I have a script for Item Maintenance that is connecting to Item Warehouse, summing up QtyOnHand and then writing it to a UDF on the Main Panel. The script works when I can get it to run, but I am having trouble figuring out which Event I can associate…
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…
Created a UDT for customer type and now trying to set validation on CustomerType field in AR_Customer to my UDT for customer type. It will only let me do this if I choose all users, all companies in advanced field settings. I don't want this validation…
This UDS is a Column Pre-Validate on QuantityShipped against the SO Sales Order Tier Distribution table at version 2016 Std through 2020 Advanced. The SetError doesn't always trigger the error message, but it does fail (i.e. clear) the distribution number…
