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.
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…
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…
I am trying to add a UDF with a one to many relationship with an inventory item.
I created a UDT to store the values of the UDF that will be associated with the items. Then I created a second UDT to store the relationship between the items and the UDF…
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…
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…
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…
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…
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…
I am just curious on the best practice for User Defined Table name vs a User Defined Field name that has the UDT linked to it. I have made both of them the same name in the past but i was talking to someone the other day that stated they usually make…
I need to increase the Length of the Item Maintenance screen to accommodate a large number of UDF fields that will be entered on a new tab. I have never been successful at doing this. I usually get error 65 once it's done. Is there a special trick to…
I added a tab to my Invoice Data Entry panel with UDFs
I want to be able to select an option in "SCAC Code" which will then display the proper name of the carrier outside of the SCAC Code dropdown. I want the SCAC Code and CARRIER NAME to be separate…
Hello everyone,
I created an extra tab in Sales Order/Invoice Data Entry and I have a few questions:
Most importantly, how can I use the data that's selected and inputted here to generate a PDF or other type of document? Each of these fields is built…
Recently upgraded client to v2019 Adv. They wanted some UDF's cleaned up and I am seeing these fields from the report on older tables that are no longer available. How can I clean these up so they do not show on the report anymore? The report I am referring…
I've added a field to the Employee Deduction file for the garnishment account number. Added it to the Deduction tab screen, but then realized I can display it there just fine, but I can't ENTER it anywhere! Can't modify the Deduction ENTRY screen. WHAT…
In general is there a maximum number of UDF's per table.
And is there a maximum number of UDF's that can be added to a form? In particular, I am looking at adding 120 UDF's to the Sales Order Detail line - is that possible? It will be Sage 100 Premium…
Hello,
I am in the process of building a "Change Tracking" system for Sales orders which tracks any changes to a specified list of fields. To do this, on a Table Pre-Write script I simply gather the information from the So History record and compare…
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 have nearly 30 UDFs in PO Receipt of Goods Detail file and linked to posting/update files, work files and history files. These are working great.
Staff wants these same UDFs to appear in IM Transaction Entry for Receipts for those items without a…
Hi Folks,
my company has to changes prices on a number of items on a somewhat regular basis, every month or so. having someone open each sales order that those items are on to hit the "recalc" button is a huge time spend.
is there a way to create…
I'm trying to create a mask for a string UDF that displays <blanks> for missing characters. If I use 000 000 000, the empty field displays the zero mask even when the field is empty. This is confusing as there's no way to tell if the entry is truly 000…
I am trying to write a script that will take numeric values that are currently stored in a string field and perform a mathematically expression on them.
For example:
Field 1 is 10 character String field
Field 2 is 10 character String field
I am…
I'd like to create an additional field in SO Totals that shows a fixed percentage of the sales order total and then, in a separate field, shows grand total (sum of order total + %). How can I achieve it?
