• User Defined Script causing an error

    I created the following script to populate ShipWeight$ in the CI_Item table when either of 2 UDF's are changed. I am now receiving an error 88 type mismatch (error window below). Any thoughts? START OF CODE Dim retVal Dim cpwgt Dim cpwgtstr Dim…
  • I can't seem to set an event for an item change

    I am trying to get an event trigger when an item quantity changes so I can perform a real time update in a UI. I have tried setting Post Write Events on IM_ItemWarehouse and IM_ItemTransactionHistory, but although I can see the DB Tables changing/updating…
  • Error Attempting to Open Crystal Reports via Script.

    Hello, I'm working on a project where I need to pass a parameter to and open a custom crystal report. I have done a lot of searching, and understand that it is possible, but I can't even open crystal let alone pass parameters. I keep receiving the…
  • Script to change payment type works for all except "Credit Card" ?

    Hello, I am working on a script to change the payment type based on the terms code that is entered in the sales order. This script fires fine for setting the field to "None" or "Check", but when the script is supposed to change the value to "Credit…