x Want to participate? Join the group to interact

  • User Defined Script for Sales Order

    I am calculating a UDF (by script) on each SO Line. I need a script that will accumulate those Line amounts and save it to a header field. I'm hoping some smart guys knows how to do this.

  • Invalid expression when in advanced logic filter

    I'm trying to create an advanced logic filter that will only capture a few specific customers. With the operand's available I've tried just about every way I can think of including all 20 of the companies. Does anyone have any examples for formatting…

  • Split Sales order with a script

    Hello everyone, I was wondering if anyone has been able to split a sales order into two separate orders based on line information using a script. Would something like that be feasible?

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

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

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

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

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

*Community Hub is the new name for Sage City