x Want to participate? Join the group to interact

  • Possible to use a lookup for a UDF validating against a UDT?

    Hello, I have a UDF/script combo on sales order entry which requires the user to input a customer of type "A" into the UDF if the customer placing the order is of type "B". The values allowed are located on a UDT which I use the UDF to validate against…

  • Setting Fields Based on Checkbox Click

    Hello everyone, I'm trying to populate 3 UDFs based off a button click to approve a Receipt of Goods. Here is the UI script I have linked to the button 'Triggered to write the date/time/name to receiver UDFs approved=PO_ReceiptOfGoodsHeader_bus_UDF_RECEIVER_APPROVED…

  • Scripting help - Contracting

    Forgive me if this is against the rules, but I'm trying to find resources to help create a script in SO_SalesOrder Entry. I used to reach out to a particular individual but they are not responding so I'm looking for other folks that could help. In short…

  • Print Sales Order with Button Script - Not Working for SO on Hold

    Scripting Experts, I am working on a SO Print Script that works fine for regular Sales Orders. But when I try to print a SO that is on hold, I get the following error message. Does anyone know if I have to (and how I would do it) set the Print Orders…

  • Copying the Date value into new date UDF on the Invoice Data Entry

    Hi We have a requirement, where when a new invoice is getting entered in AP, using a VBScript copy the Invoice Date to a new UDF. I did try to put the same using the Post Validate event on the Invoice Date, but it's not copying the data into the new…

  • Trying to set PO ROG batch as "Private" through scripting

    Hey all, I'm having a fun time trying to do a seemingly easy task. We have a customer that would like to set all their PO batches to be private when they are entered, even when they are not selected to be when they are created. I figured I could set…

  • SO Line Script Not working

    Wrote a simple script for client that has a pop up if when entering SO, you forget to put in qty ordered on lines page and you try to go to the next line pop up says please enter qty ordered. The script works great on my install. Tried to install on client…

  • Simple Script to put New Orders on Hold not working as intended

    Hello, One of our customers inventory is showing up incorrectly and we need to temporarily put their orders on hold until we can go through them individually to ensure they are correct. However, I have been unable to get these new orders to be put on…

  • Accessing Business Objects with a Client side script?

    Hello, I have a script complete that runs a SQL Query and returns the results back in a MsgBox. The very last part I need to do is access the Sales Order Number to include this in my "Where" clause for my Query. This needs to be run on the Client…

  • script a button for multiple keystrokes

    Is it possible to create a button with a script that is a sequence of keystrokes? Sage 100c 2016 sp5 from item Maintenance or Item Inquiry I would like to create a button that would take the user through a series of keystrokes. ALT 5 ALT W ALT Y…

  • Post-Write Script is firing before the record is written.

    Hello, I am trying to write a simple tracking script that records the number of items within a specific product line a salesperson has purchased. I currently have this script as "Table: Post-Write", but even if I cancel my order in Sales Order Entry…

  • Scripting Dilemma (Pre vs Post Table write)

    Hello, I am working on a scripting solution that sets a hard cap on the number of free sample items a salesperson can receive. I currently have a UDT set up that tracks how many of each product line a sales person has, and am able to write to that table…

  • Script time stamp not recording consistently.

    I've created a custom script to record changes made to the order status of a sales order through a generic shadow table format but I'm having issues getting the time to record properly in the UDF_TIME field specifically. I'm not sure what could be causing…

  • Help updating Vendor Email Via Script

    Hello, I am trying to update the vendor email address with a concatenation of some UDF email addresses that we have. I have used this same code to update UDFs, but I guess this is the incorrect syntax to update non-UDFs, but I can't figure out how to…

  • VB Script to compare and update the date values for 2 date fields

    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…

  • UDS on IM_ItemWarehouse Table_Post-Write doesn't get triggered?

    Hi everyone, could someone please tell me if a different object is processing IM_ItemWarehouse? I was testing out copying QuanaityOnHand of a certain warehouse to a UDF in CI_ITEM but it appears the script attached to Table_post-Write wasn't even firing…

  • Button Script to open Sales Order UI with parameter.

    Hello, I have been struggling to get this to work for quite some time and am starting to go crazy! I have created a button on the Invoice History Inquiry which opens up the Sales Order UI, but I want to pass through a parameter so that the Sales Order…

  • Is there a way to update AP_InvoiceRegister in a UDS

    Hi Forum, I cannot seem to find a way to update the AP_InvoiceRegisterWork table and AP_InvoiceRegister.upd. We have a Vendor that need to print checks to with different Names. One vendor hundreds of different Names the invoices need to be updated…

  • Sage100ERP.Reporting.dll

    I have been using the Sage100ERP.Reporting.dll to automate Crystal Reports and export data at a number of clients without issue. I am in the middle of an upgrade to version 2018, and my script is coming back with an error on this line: Set report =…

  • Sales Order Detail script bypass backordered quantity

    I created this script for sales order detail lines that works if I key a number into the backordered quantity field but does not work if I tab past the field with no entry. tmpQtyOrd = 0 tmpQtyBkOrd = 0 retVal = oBusObj.GetValue("QuantityOrdered…

  • Script to transfer data to secondary company

    Is it possible to write data into different company within some Sage 100 company. For Example add a button on Sales Order Entry to copy order to secondary company. I know how to do it outside of Sage with a script but not sure if session to different…

  • script on SO Invoice Qty shipped after "Ship Complete"

    running Sage 2018 sp3. I have this script running on quantity shipped in SO Invoice Data Entry. tmpQtyShip=0 tmpGrWt=0 retVal = oBusObj.GetValue("QuantityShiped", tmpQtyShip) retVal = oBusObj.GetValue("UDF_GROSS_WEIGHT", tmpGrWt) retVal = oBusObj…

  • automatically recalc prices on all sales orders

    Hi Folks, my company has to changes prices on a number of items on a somewhat regular basis, every month or so. having someone open each sales order that those items are on to hit the "recalc" button is a huge time spend. is there a way to create…

  • Looking for field location in SQL: Accounts Receivable Posting Date

    Hi all, I have recently created a script for the field "invoiceDate" that restricts how far into the future a user can enter the date for. I am wanting to apply these restrictions as well for the posting date. This should be relatively easy, except…

  • Script to Validate date - Need help

    Hello, I am trying to create a script to restrict users from entering a date too far into the future for invoice entries. I think I am close, but the date I am getting is in the wrong format, and is showing the date and the time. I have tried a few…

*Community Hub is the new name for Sage City