Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
I have encountered a strange issue with a button script that enters data into a UDT. I have been using this script in testing for about a month now and it hasn't had any issues until yesterday - even after a server restart.
The first time clicking this…
Sage 100 Code: CI_ValGrpPORequired,
Message: A purchase order number is required. when calling nSetValue with parameters InvoiceNo$, {InvoiceNumber}
Could anyone please help me with the meaning of the error code CI_ValGrpPORequired. I have made…
Greetings all,
I was wondering if there is a way of updating a UDT whenever a Sales Order is printing via script.
I have a customer that would like to keep track of the time between when the SO is printed and when the order is shipped. I figured I…
We are experiencing an error 88 on Sales Order Lines. The error occurs only on large orders with numerous lines, especially when adding inventory items to the order on the fly. The line prewrite script is failing and referencing different UDT objects…
New to this forum, and new to using the Business Object Interface.
Scenerio: I'm on Sage 100 2022 Standard, and am about to implement Sage Alerts & Workflow. One of the tasks I will be creating will periodically look at all open Sales Orders and automatically…
I am on Sage 100c Standard 2016 (Version 5.30.5.0) (yes, I know it is very old, and have plans to upgrade to a supported version). I am attempting to create a program in C# that creates a sales invoice from a sales order.
When my program executes the…
I took the BOI class, but that seems to be intended as a high-level overview, not so much a function-by-function breakdown. I checked the documentation, but it just says "Set module date". Not exactly helpful.
So, what's the effect of setting the module…
Hi all,
First script first post. Task is simple for one customer set freight amount field to negotiated amount that is based on the sales order total amount. Script is attached to pre-total event and it always works BUT only if sales order has more…
Hello
I am trying to find any doc on "oScript.Execute", i am facing an issue i want to call a 3rd party app and want the script to wait till the exe completes its execution. Thanks
Hello Every one
I am running a script to get line level values in sales order,
I am getting a "OLE error 424" error, can any one please help
Code:
******************************************************************
Dim taxReqXML Dim intx dim…
Hello Everyone,
I am trying to run a 3rd party exe on a button click using VB Script ,
The code is trowing (OLE ERROR -2147024894)
i have added the code and also the error message i got
********************************************************…
Hello
I am trying to read data from SO_SalesOrderDetial
i tried setting key value to read data for a given sales order
i am able to get data using GetResultSet but i am not able to read values like price , ordered etc
and when i am trying to use…
Hello
i am trying to read data for each line in sales order and i am getting a error , i am not sure why i am getting this error cause the same code is working for few lines but not for few
this is my code ##################################################################################################…
hello,
i am trying to read data("SO Line" line level data for a sales order) from the grid to a vbscript
but i am only able to access data of selected line .....
can any one help me out in how i can read the data from the gird( read all lines…
Hello
I am trying to edit a existing sales order using BOI,... i am able to make header level changes but when i am trying to change line level data ( ie: item code) a new line is getting created....
And when i am trying to add a new line and over…
Hi
i am trying to read item code, item description,and item price of all the items, i am able to read both item code and item description in an object but i am getting item price as null or empty string .
can any one help me out on how to read a…
hello
i am trying to override tax of a sales order ,, i have used the following code
*************************************************************************************************************************
Public Function sales_details() dim xx…
Hello,
I am new to sage100 BOI and i am trying to understand the workflow of BOI,
i am able to read data of a customer from sage but when i am trying to change a value i am getting error's
This is a sample code that i tried:
'****************…
I have a simple test script that I wrote based on a script that Elliott posted a couple of years ago
oTest = 0 Set oTest = oSession.AsObject(oSession.GetObject("CM_UDTMaint_bus", "SY_UDT_SY_TEST")) dateStamp = "" timeStamp = "" userKey = "" retVal …
Hello Everyone,
I am trying to build a 3rd party C# application for my client on sage 100, i read several things but was not able to achieve this,
i have been trying few sample codes to connect with sage using BOI but i am not able to read data from…
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.
We have a client who recently upgraded from Sage 100 2013 to Sage 100 2016 on the same server. When we call a NewObject using software that we had written in VB.NET on the server, we will get an RPC error at random times throughout the day. I've also…
I have been using UDS and BOI for a while and understand how to launch UIs. I'm just having trouble finding how to open the screens for searching. Specifically the Contact Code List that can be opened from Customer Maintenance by clicking on the magnifying…
I just spent a few hours troubleshooting something and figured that someone else might benefit from my experience. We have a receipt of goods integration that runs from AP invoices in our ECM system and creates a receipt of goods entry in Sage 100 ERP…
I'm trying to script against IM_PhysicalCountWrkst_rpt but keep getting "The Module Code is Required" when calling nSetKey(). Script sample is below. We are running 5.10.4.0. Anyone have any suggestions on what to try?
Const HKEY_CURRENT_USER = &H80000001…