Browse By Tags

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…

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 trying to copy a header field (PO_PurchaseOrderHeader - UDF_REQ_SHIP_DATE) to a field in (PO_PurchaseOrderDetail - UDF_HEADERSHIPDATE) I tried the following script: retVal = 0 headershipdate = "" retVal = GetValue("UDF_REQ_SHIP_DATE$",headershipdate…

I'm creating a script to auto-populate an SO_Detail UDF (UDF_SHIP_REF1) so that I can pass data to StarShip. The goal is to concatenate the item number with the Customer PO Number (i.e. "3131000 / 123456789" ) I have developed a more detailed script…

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…

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…

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

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…

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 a bit new to scripting on Sage and would like some assistance if anyone is willing. I am writing a script to update a UDF date field based on any change on the specifications Tab in Item Maintenance. I have attached my script below. I am…

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…

Is there a way we can add an "on-the-fly" text field that will show up on printed labels through Inventory Label Printing ? Our previous ERP system had a textbox on the print screen that allowed the user to type in a custom remark that then printed out…

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.) '-------------------------------------------------------------------------------…

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…

I know I can create a field in the SO detail and total it in the header, but they have hundreds of existing orders and we are changing the calculation which would then go to zero. I have it on the SalesOrderHeader Table Pre-totals. So I want to read…

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?

I have been using MAS since 1987, but have never used the above features. With the demands of customers lately I need to be able to email a variety of forms to multiple people within a company. Right now it is taking way too long to scan documents in…

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…

I want to link data in a detail line of PO Material Requisition Issue Entry through to IM_ItemTransactionHistory. But when I try to pull a data value into the IM_TransactionPosting table, none of the Business Object sources listed are from the PO Mat…

I'm trying to update a user defined field in the Sales Order Header table using a script from Sales Order Invoice entry from the Table - PreWrite event. The script saves the USERCODE from the session object into a UDF in the Invoice and then tries writing…

I want to add field [Category4] from CI_Item to the Item Maintenance, but can not seem to find it in Custom Office User-Defined Field and table Maintenance. Can anybody help with that? Thanks.