Sage 100

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…

I need to restrict certain divisions from use in AP Invoice Data Entry for certain roles. The division restriction is the challenge. One cannot use a Pre or Post Validate script on the VendorNo field as would be done in S/O with CustomerNo. Since VendorNo…

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…

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…

I am trying to script some sort of data flow from the receipt into the Landed Cost panel / table, but nothing seems to work. I want to calculate a value based on receipt lines (conditional percentage), and write that value as a Landed Cost... without…

(Tested on v2017.2 Standard and 2018.3 Standard). I stripped my script to just a loop through oLines on a panel UI script (see below script code ). With this active, when I add / edit lines, then click off the tab then back to pLines, the lines on an…

v2018 (so scripting in JC is possible). I'm writing a script to override the GL account for Job Posting Entry lines. (Detail PreWrite event). I can get the override to work, with a SetValue but the grid does not refresh with the new value. retSet…