• 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…
  • How to script an AP division number restriction in Invoice Data Entry?

    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…
  • Sales Order Entry / Totals Tab / PaymentObj

    I believe the Deposit Payment Type on the Totals panel and other data reside in PaymentObj. What table is associated with this object? Where/how can I find the data?
  • GetResultSets pagination

    Is there a way to paginate the GetResultSets() function in boi? I'm thinking sort of like how in SQL, you can use OFFSET and LIMIT to divide the query results into multiple pages. Is there a way to do that with the GetResultSets() function?
  • 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…
  • Script to check SalesOrder Detail & Update Salesorder Header

    Hello, I am using sage 2018 & am trying to create a script that works alongside scanforce. We received the oSalesOrder.nMBAutoAllocateSalesOrder() command from Scanforce to allocate orders with a VBS, but we're on our own in terms of creating the rest…
  • 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…
  • Button to run AP Aging from Vendor

    I created a button on the Vendor Maintenance screen that runs the AP Aging report. I pass in the AP Division and Vendor numbers, but I can't get the report to filter by those values. (Want to run the Aging for the Vendor displayed, like the Sage button…
  • Script possible with PO RoG Landed Cost panel / table?

    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…
  • UI event script, scrolling through order lines on panel post load, corrupts line entry

    (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…
  • Script for overriding AccountKey in JC Job Posting Entry

    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…
  • Where do I find the KeyValues required to use find for IM_ItemVendor_svc

    Trying to get Standard Lead Time using : oItemVendSvc = oSession.GetObject("IM_ItemVendor_svc") if oItemVendSvc then retVal = oSession.AsObject(oSession.UI).Messagebox("","Able to set handle" & vendNo & itemCode) Set oItemVendSvc = oScript.AsObject…
  • Using SQL in script

    Does anyone have a very basic example of how I can integrate a SQL statement in to a script? I've run into plenty of occasions where I wish I knew how to accomplish this, here is my current goal: We ship using Starship and for a variety of reasons…
  • Retrieve Customer Number from another company code

    Hello All, I'm trying to create a script that would look up the current customer by name in another company code and insert the corresponding customer number into a UDF. Is there code that could be used to run lines of a user defined script on another…