Sage 100

Hi Forum, I am trying to delete Bill of Materials and i just can get the script to work. I know i am doing something wrong but i cannot figure out what. I need to delete BOM's from a list in a csv file, Delete the Bill and the Item associated…

Hi Forum, i am trying to connect to a MySQL DB from a vbscript. I want to be able to update new customers entered in Sage to a table in a MySQL DB. I setup the script as Table - Pre-Write and also as Table - Post-Write and i am getting an error…

I have encountered an issue attempting to add a post validate script to the quanity invoiced column in PO receipt of invoice. The script does not fire altough it does when entering a invoice while entering PO receipt of goods. In customizer, there is…

I have a script I want to run on SO invoices during journal posting (to write data to a different table, but only for posted invoices during the journal update). UDF's linked through business objects are not an option for this purpose. When set up as…

I have a BOI script that runs fine on one machine, but on another machine I get a NewObject Error: 65 when attempting: Set oSalesOrderBus = oScript.NewObject("SO_SalesOrder_BUS", oSS) The machine that this works on is a Stand alone MAS90 install…

I am looking (did I mention Desperately) for a solution to this: We key orders and quotes with increasing frequency as the summer approaches and through the summer seasonal business. We sell many BOM standard kits and custom kits with 10 to 50 different…

How do you get number of seat licenses available using Providex ODBC? Meaning, is there a Table that stores the number of users taking a seat? I know there is the sy_console table, but that just shows who has what window/process open.

Hi Forum, I am having 2 issues with import sales orders script. I was able to set the key on the header before i started using the passing of the sales order number from a PHP script. I was getting <Error: 0 in Method ADDLINE. Now that i am using…

Hi I am try to loop through the SYSTEM UDT to find the record that within the date range and the while loop always get eof = 0. Here is the script and hope you guys can help. Thanks odis = oSession.GetObject("CM_UDT_svc", "SY_UDT_VOLUME_DISCOUNT"…

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…

We have many items in our system that need to have their alternate items updated. As far as I can tell, if we try to just import 'over' the existing alternates, we get errors saying the alternate/priority already exists, so it looks like we need to delete…

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…