Browse By Tags

  • Object Reference & Table name for Customer Price Schedule --> Pricing Method --> Price Discount Amount

    Hi All, Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script. I right clicked on the…

  • Script message won't display

    Can't determine what the problem is for the script message not displaying in SO Entry. Here is my script. Client is Premium version 2021 ' -------------------------SCRIPT START ------------------------------------ If oSession.CompanyCode <> "ZZZ" and…

  • Script to update SO line pricing

    A customer has asked for a way to update pricing on 1000's of SO, for some planned pricing updates they working on. My idea was to have a button script to loop through all SO, and all lines on each SO, triggering the Sage logic to calculate each line…

  • Pull required date from item inquiry to excel sheet from excel

    Hi Everyone, I am wondering if there is a script that can be written in Excel to look up an item number in SAGE and return the required date back to the excel sheet? Following the screenshots below I would like to have excel pull the next required date…

  • How to find different record, change field value, and write the changed record back to the file

    I have a UDF checkbox on the GL_Account maintenance called UDF_DONATION. What I want to do in the Table Pre-Write is to check to see if there is another GL Account record where this UDF_DONATION is already set to "Y". If there is another record with the…

  • Modification d'un traitement vertical

    Bonjour, Est-ce qu'on peut modifier directement le script d'un traitement vertical ? Merci, cordiales salutations

  • Script to retrieve altcountrycode not working

    I get an error whenever I try to set the Country Business object, either as a childhandle or asObject. I have no idea why this keeps getting an error 88. 'Title: UDF_Alt_Country_Code 'Desc: Autofill the UDF_Alt_Country_Code after selecting Country…

  • User Defined Script - Problems Getting Child Handle

    I'm trying to accumulate the quantities of all the detail lines in an AR invoice, but only if the item is of a certain type. I defined a UDF for that checkbox, and put it in the Item Maintenance screen. I would like the total to update whenever a user…

  • Pre-Totals Script - Accessing Item Information Using oLines.GetChildHandle("ITEMCODE")

    I have a script on the pre-totals event, that loops through any line items, and needs to get item related information for a given item. The problem I'm running into, is that in certain cases, the script runs, but the item information is returned as blank…

  • Bill of Materials InvokeProgram Script

    I am trying to launch either BOM Inquiry or Maintenance using an InvokeProgram or Process User Defined Script, but any time I add the Bill I get the error "You do not have security rights to create the record" but I am not trying to create a record. Any…

  • Previous record loaded after refresh

    Hello everyone Our customer wants to copy a plan by clicking on the corresponding right list entry. The copied plan should be shown afterwards. After clicking the right menu entry the following code is executed: This creates the new plan based…

  • Match BOM Production Entry Line Sequence to BOM Maintenance detail line entry

    We are on Sage 100c 2019 and I'm trying to find out a way, that when BOM Production Entry is launched and we go to the lines tab, that the line sequence is NOT alphabetical/numeric ascending (which appears to be the default), but based on the way the…

  • Record mouse and keyboard actions to create new ATP test features

    It could be very useful to have a function within Sage X3 that records all mouse clicks and keyboard actions of a user into a text file that can later be used to generate a new test feature for the Automated Test Platform (ATP). You would not need to…

  • Access the Lines on Transaction Tab in Item Maintenance

    Experts, I got a tricky one here. I have a UDF in IM_ItemTransactionHistory that contains a file path. Now I would like to be able to place a button in Item Maintenance on the Transactions tab that allows me to open the file. The code to open the…

  • oLines not properly filtered for new SO (in header scripts)

    Issue identified on a 2019 Premium system, but verified on unmodified 2021 Standard with ABC data. Column post validate script on SO Header (WarehouseCode). sSalesOrderNo = "" retVal = oBusObj.GetValue("SalesOrderno$", sSalesOrderNo) oSession.WriteLog…

  • Can't figure out Event hook

    I have a script for Item Maintenance that is connecting to Item Warehouse, summing up QtyOnHand and then writing it to a UDF on the Main Panel. The script works when I can get it to run, but I am having trouble figuring out which Event I can associate…

  • Issues opening Sales Order with Script Sales_Order_UI

    I have used this code for years me and a handful of others, but we have a few new users that are having issues and can't appear to use my app to open Sage Sales Order. The only indicator they get is SO_SalesOrder_UI in a message box. Here is the…

  • Copy invoice from AR_InvoiceHistory to flat file

    I have most of this script working but am hung up on the part reading from the line detail object. I have created a button on the AR Invoice History Inquiry panel so that the end user can find the invoice they want to copy, press the button, and the flat…

  • How to Maintain Two Descriptions for a Single Item

    We sell valves for oil and gas pipelines and installations. We use one short description for sales orders and then very long detailed descriptions for purchase orders on how the valves are to be built. As Sage 100 only has one item description field we…

  • Does SetBrowseIndex work without SetBrowseFilter?

    I would like to read through the lines of an invoice in ascending ItemCode order during a SO_InvoiceHeader Pre-Write script, but they seem to be unaffected by a SetBrowseFilter and appear in entry order. Any ideas? Here's my 5 line test case: sItemCode…

  • Launch Sales Order Entry to create new order from Customer Maintenance and pass Customer Number

    Hi Sage City and Happy Friday! I have been working on a button script to launch Sales Order Entry from AR Customer Maintenance. The goal is to click on the button and open SO Entry, automatically select the next Order Number and pass the Customer Number…

  • Forcing Cancellation Code when deleting Sales Orders into history through BOI

    Good morning all, So I figured this would have been a relatively easy script but I can't seem to find a way of accomplishing what I need. I have a customer that would like to force a cancellation reason whenever you delete a Sales Order into history…

  • Is it possible to create records in AR_CustomerDocuments and AR_CustomerDocumentContacts via BOI?

    Hi forum folks and Happy Friday! I have a customer that would like to CC a specific inbox any time we send SO Invoices and orders via Paperless Office. We have been doing this by adding this CC email to the "To Additional Email Addresses" Field under…

  • Using an IF statement with a multi-select field in an OnChange Script

    Hi Everybody, I hope someone can help me understand how to use an IF statement with a Multi-Select field in an OnChange script. This basic IF statement can determine whether Blue has been selected in a Text or Selection field. if (oppo_color.value…

  • Auto send email on entering / invoicing orders

    Is there any ways to enable Sage 100 auto send email notification to a certain group of recipients upon SO is entered / invoiced? I assume this has to involve scripting, right? Thanks, Haibo

*Community Hub is the new name for Sage City