Browse By Tags

I hope this is something easy that I'm overlooking. I'm looking up an invoice in the AP_OpenInvoice table that I know exists. I have confirmed that I'm passing the correct vendor division, number, and invoice number. But I'm getting a 0 return value.…

New to this forum, and new to using the Business Object Interface. Scenerio: I'm on Sage 100 2022 Standard, and am about to implement Sage Alerts & Workflow. One of the tasks I will be creating will periodically look at all open Sales Orders and automatically…

When viewing a multi-line field within DFDM I noticed that one of the UDF fields within the current table (AR_Customer) had a Nomads Tag that suggested I may be able to possibly manipulate a different multiline field to perform a lookup within a UDT.…

Does anyone know of any resources, tutorials, training sessions, etc... on how to edit the Non-conformance screens to add additional fields. I created a custom field to the table NCSRECENT, added it to a custom screen, added that customer screen to the…

I am getting this error message on my bills "The field " " for Timekeeper cannot be blank". I understand that I need to change the Timekeeper Classification setting in the LEDES set up box, and in order to do that, I need to create a custom field. However…

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…

Optional Field Value. Attempt to modify a different record than was retrieved. Im getting this error while trying to enter new value for the optional field. Kindly help. Thank you

I have a UDF on SO_Detail table I'm attempting to populate with a BOI script (written in C#). This field is set to datetime type, the data I'm sending is being parsed from string to datetime format in the script. I'm sending the SalesOrderNo, user credentials…

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…

Getting an error when SetKey method used, saying vendor code is not numeric. Won't insert record into invoice data entry.

Hello, I'm simply wanting to write the previous item code to a UDT when the line is changed in a sales order. For example, if the item code was abc123 and a user changed it to def456, I want to write abc123 to the UDT. However, each time I try to access…

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…

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…

Hi everyone, I'm wondering if I could get your help on this. I have a simple Drop-Down Box UDF with 3 possible values in SO_Header (validated against its own list). At the creation of the UDF, the default value was set to the value "None", which I confirm…

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…

Hi everyone. I am struggling to export the bank details I spent hours loading into Sage one. You can extract Allot of details but not what I need. I tried creating a user field which I named Bank account, Br code and bank name and was hoping there…

I'm trying to write a button script that will copy a single line from a SO and "pull" it into the open PO. I've done this successfully for SO (copying from Invoice or SO/Quote History), but with PO, I'd like to be able to "tie" the SO and PO together…

i am trying to update a UDF in line level using script on a button click Dim count Set fso = CreateObject("Scripting.FileSystemObject") Set dict = CreateObject("Scripting.Dictionary") If (fso.FileExists("C:\XIDT\line.txt")) Then Set file = fso.OpenTextFile…

Hello I am trying to find any doc on "oScript.Execute", i am facing an issue i want to call a 3rd party app and want the script to wait till the exe completes its execution. Thanks

Hello Every one I am running a script to get line level values in sales order, I am getting a "OLE error 424" error, can any one please help Code: ****************************************************************** Dim taxReqXML Dim intx dim…

Hello Everyone I am trying to update UDF in sales order line using script, i am not getting any error but it's not working i am adding the the code that i am using any kind of help will be really great Thanks ____________________________________________________________________________________________________________…

Hi, I am trying to integrate Sage 100 UDFs with our application's UI. I was going to read UDF caption and data type. Our end users are supposed to search Sage 100 orders using a UDF field; so we wanted to show the title properly, and adjust search conditions…

hello, i am trying to read data("SO Line" line level data for a sales order) from the grid to a vbscript but i am only able to access data of selected line ..... can any one help me out in how i can read the data from the gird( read all lines…

Hi All, This is my fist attempt at using GetStorageVar and SetStorageVar, so I hope I'm just doing something silly here. I have a script that runs on table pre-write of the SO_SalesOrderDetail to "SetStorageVar" and another on table post-write to "GetStorageVar…

I have a simple test script that I wrote based on a script that Elliott posted a couple of years ago oTest = 0 Set oTest = oSession.AsObject(oSession.GetObject("CM_UDTMaint_bus", "SY_UDT_SY_TEST")) dateStamp = "" timeStamp = "" userKey = "" retVal …