Sage 100

We have a lot of information in our header tab already and when we print our sales order the space is mostly allocated. We have a new UDF field that we need to create and I am trying to figure out a place to put this new information, was hoping in the…

Hello, I have a UDF/script combo on sales order entry which requires the user to input a customer of type "A" into the UDF if the customer placing the order is of type "B". The values allowed are located on a UDT which I use the UDF to validate against…

We have a business that has two locations, so we use a UDT when entering transactions to split them accordingly. In order to show separate income statements, we have been manually creating them in Excel each month. This is tedious and leaves room for…

Hi We have a requirement, where when a new invoice is getting entered in AP, using a VBScript copy the Invoice Date to a new UDF. I did try to put the same using the Post Validate event on the Invoice Date, but it's not copying the data into the new…

UDF is Added to SO Detail but doesn't display on the screen. Verified the UDF is not marked as hidden. Below is what I tried so far: Removed all of the UDFs from the SO lines panel. Deleted the ###-### and all other folders from the SO\custom folder…

Hi I have a business requirement, where we have a Date Field1 and Date Field2 , while entry of the details data, Field1 will get the date auto defaulted from the header date field. And Field2 will be blank . Later when there is an update on the Date…

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…

Hello, Can anyone help me with example code on how to get a User Defined Field in another object? I'm used to using oSession and oLines to get the header values and details for AP_ManualCheckHeader and AP_ManualCheckDetail. But I'm trying to get one…

I was wondering if it is possible to add JT_Employee as a data source under Business Objects when creating a UDF for SO_SalesOrderDetail.

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…

I'm trying to pass a field from PO Receipt Details to the PO_ReceiptOfGoodsInvoiceWrk table which is used to generate the Receipt of Goods Register. We have added a field in PO Details which is passed to Receipt Details which I want to pass to this Work…

I am trying to create a script that writes the current user key when the user prints the picking sheet. Has anyone done this before? My script doesn't appear to work and I am unsure which event I should use to accomplish. My code is below: retVal…

I have a date that I have added to the SO panel. When I add the date and click accept, sometimes the information "saves" and sometimes it drops off. Has anyone experienced this happening to them? Any help will be greatly appreciated.

Hi all, I hope you are up for some puzzles, I've spent 2 hours and I'm now lost. The version is Sage 100 Advanced 2015, 5.20.1 We have a UDF in SO_InvoiceWrk. The purpose of it is to grab the invoice number to which a credit memo will apply and shows…

I am currently using the following (which works), but is there a 'better' way to do this? (I don't like hardcoding the connection string with username and password.) '-------------------------------------------------------------------------------…

Is it possible to create a field (UDF) that replicates the salesperson lookup using business object fields for salesperson? I need to add this secondary salesperson lookup in AR_Customer and SO_Shiptoaddress. I was hoping against hope that I could do…

I am trying to place the <Telephone2> field in AR_CustomerContact on the SO_SalesOrder Header. I am placing it over the Fax Number Field as we don't use fax numbers much. I have created a UDF in SO_SalesOrder Header file to hold the value, and have placed…

I need help. I created 2 numeric UDF's for CI_Item; PACK and EACH_COST. I wanted to automatically calculate EACH_COST by taking the Item's Standard Cost and dividing it by the PACK. I searched SageCity and found a simple script and modified it. I…

We need to track the DPAS (Defense Priorities and Allocations System) Ratings that are entered on Sales Orders and flow this information through to WO's that are generated from SO's, any PO's that are tied to SO's and onto any pack lists, invoice etc…

Hi, If I have UDFs in the SO Header and use the copy from SO feature in SO to create a new Sales Order, should the UDF values copy over as well? In the v2016 and v2017 installs I tested, these fields don't come over. But I think I read on here that…

Business Problem: One of our inventory peeps needs to analyze and see when the PO Required Date changes for an inbound PO. We have a pulling schedule etc... with some partially pulled and staged orders. Those orders are waiting on inventory from inbound…

HI I am new to scripting and am trying to create a script for a client that will bring in the extended item description into t

I wrote a script to disable and enable certain UDF's based on certain conditions. These UDF's have different data types. when the script runs apart from the Date type UDF all others get disabled and enabled properly. Is there a special syntax to control…

I have a checkbox UDF in PO_ReceiptDetail called UDF_LINE_COMPLETED, I have the same UDF within PO_PurchaseOrderDetail. I am trying to map the checkbox from RoG to the purchase order lines. Here is how I have it set up: This however is not working…

we are on MAS100 5.1 using crystal reports 2011 for Sage. I have created a UDF field in Sales Order Detail called UDF_Customer_Item_No , i made this 15 char long as a String, control type multi line. we are using visual integrator to import orders…