Browse By Tags

Sage has built-in support for storing dates in a UDF by simply changing the "Data Type" to "Date". Then under default value, "<SystemDate>" to allow the date to be immediately filled upon new record creation. Did they forget that dates are usually paired…

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…

This is now my second customer to show up with this issue after an upgrade to 2021. One had modifications from APS and WSP, the other was completely vanilla. Somehow, the tabs from two entirely different modules/screens were merged together. In the…

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 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…

I have created the same udf in sales order detail and SO invoice detail entities. Both same type - string - and same size (20). In the data source from SO invoice detail I have selected "copy from sales order and for data source I have selected SO_SalesOrderDetail…

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…

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…

Today as well as last Friday, my company reported all our custom-designed and added fields on the Maintain Items screen disappeared. On Friday, I readded them based on a snapshot from a previous DB version... this morning, they were all gone again. …

We are working on an eCommerce site that is linked to our MAS90. I have an import job created that I use for internal price updates that uses the CI_Item table. I am wanting to add an Update Date field to the Import Job, but can't find that anywhere…

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 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 …

Back again with a specific bug... I have customized the Save Event in the frmBatch object in the Process Receipt of Good form: Sub Form_Save(oDM, bSave) Dim objApp, result Set objApp = CreateObject("LMNO.PrintNewLabel.FormSave") result = objApp.PrintBatchLabels…

I there, I'm new in Sage X3 V8 My Company has large Item descriptions with more than 30 chars lenght so we need to use both description fields, description 1 and description 2, but this 30 chars limit start to make a lot of troubles for the user becaus…

During our shipping process we scan all inventory from the pick sheet into shipping data entry. I like to create a process that using a UDF will track that the item the was scanned into shipping data entry. Example: Item A quantity 2 Item A we scan…

Hello: I have an issue where the client needs the ship weight and the freight to carry over to the Totals tab in Sales order data entry. It will not due to the line item setting in sales order options. I believe my options are to write a script to…

Here is what I am trying to do: basically UDF # 1 will have options A, B, and C. UDF # will have options A through Z. If opton A is selected in UDF #1 then the user will be able to select A-D in UDF #2, if option B is selected in UDF #1 then user will…

How do I change the default text for a discount so I don't have to change it each time I apply a discount while entering payments?

Does anyone know how to printing row numbers in takeoffs? Would be great to reference the row numbers on the printed PDF takeoff

Hi, Is it possible to change the Extend Price Calculation in Order Entry? Right now, our products are sold by the item number and the length. For example, a wood pole may have an item number called,"WP". We cut the WPs based upon the customer's request…