Hello, I have taken over an existing installation that does not have any documentation or support on it. Our website uses a custom sync tool to push orders into Sage. Everyone once in awhile (10% of orders or so), I will see an error, "The column is not…
My apologies if I'm not in the correct forum for this. (It seemed to match the best from the list I was presented with.)
I'm looking for documentation on building modules to run from the Sage 100 desktop. I've taken a number of the courses (including…
I am getting this error "Missing record to calculate taxes." while trying to import Sales order in Sage using BOI.
Has anybody faced this issue before? OR anyone has some idea how to solve this.
Appreciated your help
{solved}
The error was in my KeySet() line. Instead of:
var retval = Core.SageObject.Process(pcObject.InvokeMethod("nSetKey", ""), pcObject).ReturnCode; It should have been:
var retval = Core.SageObject.Process(pcObject.InvokeMethod("nSetKey"…
Hi
I am trying to create an order using C# but I get an error with the "invoke" as below
An unhandled exception of type 'System.Reflection.TargetInvocationException' occurred in mscorlib.dll Exception has been thrown by the target of an invocation…
Experts,
I have a small app that writes to CI_Item. It has been working with no issues in Sage 100 v2017 Premium for my client in a Sage Server / Terminal Server setting. Now they are on v2020 Premium in the same setup (new servers), but we are running…
Hey everyone!
I'm attempting to modify and create/remove work ticket templates via BOI (through C# and Entity Framework) and I'm not having much luck. I'm not sure what object the template table is a part of and I haven't been able to find anything…
I’m trying to develop a c# wrapper to communicate with x3 SOAP web services with the new frameworks NET CORE, NET STANDARD 2.0 (on Xamarin).
With this wrapper:
https://www.rklesolutions.com/blog/x3-soap-web-services
I can easily connect with…
Hi ,
Greetings of the day !!!
I need help integrating Objets100cLib (Sage dll) to third party c# application , can any one help with this ? i want to access data like suppliers/articles etc.
Thanks in advance
Environment: IIS, .net CORE ASP.net web API, ProvideX.Script COM object (Sage 100/ MAS90 2018 v4.5), Server 2012 R2.
Starting with the workaround first: so far my workaround has been to allow my IIS identity pool ID full access to the DCOM computer…
We have a customer that just upgraded their Sage 100 product to the 2020 version and are seeing some issues with integrating to our product. They migrating from Sage 2016.
Below is a code snippet of where the issue is coming from. The error is “CI_NOF…
I see that there are lots of questions about this in the past, but I can't seem to find a concrete answer on how to move forward with it. I realize it has something to do with DCOM, registering the DLL, running client side verse server side.... But I…
Recently, we had a client's Sage 50 server migrated. A full backup of the company file was taken, moved to the new server, and then the backup restored overwriting the company directory on the new server. We are able to log into the Sage 50 company on…
Hello Teams,
We are creating an Interface to Sage X3 PU11 and would like to know if Sage or any other provider has created a common DLL library for the C# programming language. Will be used to call SOAP or REST in Sage X3.
Thank you,
Dennis
I'm trying to import the Unit Cost field among others for Inventory adjustments via the COM Interface. For some reason this one field likes to remain at 0.00 even when making a positive adjustment with a value greater than 0.00.
Here is an example of…
Note the is a .NET application written in C#.
I have an application that imports orders, purchase orders and inventory items into Sage. The customer supplies a file that contains all of the purchase orders w/items. The file is parsed into purchase orders…
I see some older threads discussing some in-progress ideas people were working with, as well as some libraries on the nuget packages out there - but there is no documentation on them that I can see. Does anyone have a recommended usage for them? Have…
Hi Expert,
Currently, I need to get last date and time the item was updated in the inventory and date and time when the item was created ,I did not find the field related from the method which can get the inventory information supported in the Sage…
Earlier this year I created a mobile application for pulling orders. To integrate, I made a rather barbaric implementation: when the mobile application backorders an item, update SO_SalesOrderDetail.QuantityBackordered = External.QuantityBackordered.…
How do I create an Extended Item Desription ??
soLine.InvokeMethod("nAddLine"); soLine.InvokeMethod("nSetValue", "ItemCode$", "NEW IMM"); soLine.InvokeMethod("nSetValue", "QuantityOrdered", qty_p); // DESCRIPTION object[] getIDesc = new object[] { …
I've been using c# to insert customers, now I'm trying to insert an order, I don't get any error but it don't find the order, I reasearched needed values but maybe I'm missing something
int TaskID = (int)oSS.InvokeMethod("nLookupTask", "SO_SalesOrder_ui…
Hello, I already made some vbscripts, I'm trying to build a c# .net application, on examples I saw "STAThread", is there a specific configuration to use this or COM? thanks
I have an issue in the .Net library I have no issue creating a vendor using a macro: Dim mDBLinkCmpRW As AccpacCOMAPI.AccpacDBLink Set mDBLinkCmpRW = OpenDBLink(DBLINK_COMPANY, DBLINK_FLG_READWRITE) Dim mDBLinkSysRW As AccpacCOMAPI.AccpacDBLink Set mDBLinkSysRW…
Hi,
I am trying to update invoice's total tax using below code
TaxSummaryInfo taxSummaryInfo = journal.GetTotalTaxAmountInfo(); if (taxSummaryInfo.GetCount() > 0) { double totalTax = 10; taxSummaryInfo.SetTaxAmountByRow(1, totalTax); taxSummaryInfo…
