• How to Flow a UDF from Sales Order Header to SO History Header Reliably

    With identical UDF names in both tables, the original value set into the SO Header UDF via a ColumnPostValidate script from a standard field works to flow the value to SO History Header, but subsequent successful updates directly to that SO Header UDF…
  • Sage BOI SO_PackageTrackingByItem_bus

    I am attempting to write a Sage BOI VBS program to read and write to the SO Shipping Data Entry Package Tracking By Item object and am receiving the error <NewObject Error: 200>. I am using a Sage user that has full access to Sage and have the company…
  • Update UDT from CI_Item

    After reading a few post about updating UDT's from scripts I am wondering if my events are wrong or do I need to SetKey before SetValue? In the debug I couldn't get any return values, so I am guessing my events are wrong, I've tried a PRE-WRITE and a…
  • nFind returns 0 for AP Invoice lookup in AP_OpenInvoice

    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.…
  • Read validation configuration of UDF

    Hi, When creating UDF we can specify that its validated against: - none - range - list - user-defined table Im trying to find a way to get the name of the UDT. In order to get range/list values in c# its enough to do something like that…
  • Customizer- I would like to add a UDF to the AR ship to screens

    I have been looking for the table that is linked in AR Customer maintenance/Ship to. I need to add a UDF field to the ship to screen so when the ship to codes are added and created for a customer we can add another email field we can map to Starship.…
  • Instr Trouble

    Having trouble pinpointing why my script is not ending when a string of text is found in a search string. I am searching in this text string "customer picked up in CS 10/31" for "picked up", I see in the trace window I am getting the full string, I wasn…
  • Update a UDF in purchase order header from sales order not change the value

    we add a UDF UDF_STATUS_UPDATE in both SO_SalesOrderHeader and PO_PurchaseOrderHeader table to track order fulfill status. when change this order fulfill status in sales order, we want all PO generated from this sales order same UDF fulfill status get…
  • New customer field initialization

    Hi All When I am creating a new customer, depending on custdiv, I need to initialize certain field, like custtype, pricelevel, etc. What kind of event would I use? Column event does not have CustDiv. In post-write or pr-write event it did not work.…
  • Troubleshooting Loop in SODetail

    My script is on a table-pre-write on the PO_ReceiptDetail table. I've used the debug window to identify the area where the script is giving trouble, sometimes the script does not write and update the sales order. From what I can see the script should…
  • Kit Components Table Pre-Write

    I have a simple table pre-write to populate an UDF_QTY_PULLED column based on the order qty, if the line is a kit component. I ran into a problem when we have to go and adjust the UDF manually, the script keeps on firing to change the UDF back to the…
  • Add On to Script

    I have a script looking at misc items, item type =5, any item with this type the qty ordered is populated into an UDF with the equal amount. One exception is if the item code is /SMISC, then nothing is populated, the UDF stays = 0. I need to enter another…
  • Button script to update a UDF on SO History Header

    Hello: I'm trying to create a button script to update a UDF field on the SO History Header table. It seems like a simple task, but I can't seem to figure it out. I need to prompt for the date and then update the SO_SalesOrderHistoryInquiry_bus_UDF_RMA_CLOSED_DATE…
  • Script Troubleshooting

    I have multiple scripts on the SO details, 3 on the quantity ordered column as a post val and 9 on table-pre-writes. I am finding some SO's in the system that seem to not have the scripts firing, when I go to that SO and enter another line with all the…
  • Kit Components Triggering Scripts

    Has anyone had any issues when a kit is exploded on an SO to have the components trigger SO details scripts? The kit item triggers the scripts however when the item is exploded the components seem to bypass any scripts attached to the lines.
  • Best Way to Source SODetail UDF from SOHeader UDF

    Is there an easy way to source an UDF from the SOHeader to the SODetail without a script? Thought there might be a work around but can't find it, so cam up with this script to test but will have to wait until I can get everyone out of the system. If…
  • SO Picking Sheet Work Table

    I have an UDF on the SO Details and also created the same UDF on the SO Picking Sheet Work table and linked it to the SO Details. I can't get that UDF to show up on the crystal reports to add it to the form? Other UDF's in the same tables show up, am…
  • System Date

    I leave SAGE up to keep a program up and running to import orders (Insynch), I have a script looking at the system date to populate a UDF date field when a sales order is put into process. I am noticing that I haven't had to restart the SAGE application…
  • Copy UDF Values from AR_CUSTOMER.M4T to Equivalent UDFs on new Sales Orders

    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…
  • Quote to Standard Order not Firing Scripts

    I have a few scripts on column post validates, mostly watching the order quantity. I had them only running for standard orders, however this was an issue when the order starts as a quote. One script is a calculation to mark the udf quantity pulled (basically…
  • DFDM Modifications to Allow UDT Field Lookups

    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.…
  • SO lines loop, updates only one line

    I have a script, which edits line data (conditionally) based on a header event trigger. It works fine in v2020, but in v2022 (Standard, no enhancements) only one line is updated. In order to get it to update all lines, I had to add a check for a changed…
  • Table -Pre-Totals Script to only Run Once

    I have these two scripts on the SO Invoice Header running, one on a "table-pre-totals" and then another one on a "table-post-write" to reverse an action in the first script. I am pretty sure when we open the batch up the "table-pre-totals" script fires…
  • Add ship to address when a new Customer is created

    Hi Forum, I need to update a ship to address code "0000" when a new cusotmer is created. I am trying to do it on a "pre-write event" is entered but I am getting an error. Any suggestions ? Regards, Manuel Roman
  • Date Customer Last Purchased

    Hi Guys I am looking for a field within sage that gives a date that the customer last made a purchase. The only date I found which was similar was LastActivityDate but this can be triggered by lots of different things. Do you guys know if this exists…