x Want to participate? Join the group to interact

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

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

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

  • VI PO Receipt of Goods both Lot and Avg items in the same receipt

    I'm trying to recreate PO Receipt of Goods from history. I can't seem to import to a PO where 10 lines are lot distributed and 1 line is not. What field can i add to distinguish between them?

  • <Error: 0 in Method UPDATEINT>

    Hi, I have the code below for automatic registration/update of the production transactions. I've been getting an error on the UpdateInit method. oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI")) objTransactionRegister = oScript2.NewObject…

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

  • Multiple table writes requires multiple Objects? (Audit Script)

    Hello, I am in the process of building a "Change Tracking" system for Sales orders which tracks any changes to a specified list of fields. To do this, on a Table Pre-Write script I simply gather the information from the So History record and compare…

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

  • How to set default value in Lookup button script?

    Hello, I am scripting a button that, when clicked, opens up the sales order history lookup from the Invoice History Inquiry panel. I am trying to get this lookup to already have the sales order number entered that is shown on the current panel. For…

  • BOM Option Description

    We are now setting up bills as kits in BOM, and each one of our bills has options. Ideally I would like to just show the OptionDesc for each component item code on our customized report. The problem is that the BillOptionCategory is not saved per record…

*Community Hub is the new name for Sage City