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…
I'm trying to create a production entry. It works fine if I add lines but if I don't add any lines I get an error message saying I need at least one line. In the Sage UI you can select a Bill Number and it pre-populates the lines, I'd like to do the same…
We're currently using the Sage100 C# NuGet package noted below.
We've run into a situation whereby a miscellaneous item (CI_Item) is visible in the UI and via OBDC connection however, we're unable to find the item using the MASRecordset utilities…
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…
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…
{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"…
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'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…
Hi,
I've been working on automatic registration of transactions for Bill of materials.
but I've been encoutering this issue for a couple of days now.
its been throwing me an error that says "Invalid or missing posting date encountered"
I opted…
Hi,
I've been wondering if someone else encountered or might have a solution for this.
Im getting the error "The register must be printed prior to posting"
oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI"))
objTransactionRegister…
I've found how to get a list of the Accounting Periods through the SDK (Using .net API). Is there a place to find the current period so I'm not entering or updating records from an accounting period?
Hi community!
I need some help. I have an almost perfect code here in C# posting a payment in cash receipts. The only problem is that the batch amount is duplicated. The batch total is $520.00 instead of $260.00.
What am I doing wrong?
Here…
Hello Friends,
I am using SAGE 2019.1 SDK for importing invoice in my application. I am getting error at the time of SetShip date "The field you are trying to change or function you are calling is not accessible under current circumstance.". I am getting…
var companyId = GetCompany();
try { // Request authorization from Sage 50 for our third-party application. AuthorizationResult authorizationResult = Session.RequestAccess(companyId);
This line Session.RequestAccess throws a PeachtreeException: FileNotFound…
Hi,
A little background... We were asked by a client to create a.Net application to do a few things. The more effort we put in the less success we seem to be having.
We are trying to create POs, Time records, and add Cost Codes to the DB.
Reading…
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…
Hi,
I have sage 50 accounting, the data are on a local server (within same network). We have no issue with the performance when using Sage 50 but when using the SDK it's really [:@]tooooooooooooo[:@] slow
Listing companies takes 45 seconds!
Finding…
I'm working on extracting data from the database sage 50 CA, but in the documentation containing the data definition , I have not found the relationship of the payment terms with customers, or where it is stored ( table).
Here is the information that…
I'm working on the integration of Sage 50 CA with a third party application with .NET. And price levels are within the required information extracted from the database Sage 50 CA, but so far I have not found any information to verify the existence of…
Does anyone have an example of how to receive a payment via the Sage SDK? It's looking to me like you have to go directly at the tables (which is a HUGE gap in the SDK in my opinion) but that sounds risky. Anyone know how to do this?
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 am trying to use the SDK (COM) to transfer a journal entry to Sage 50 (Peactree) but cannot make it work. I can see the import status screen flash out and there is no error occurs during the import; but nothing appears in the sage 50 journal entry report…
I have an Application ID and I can start a new session and open our production company, but every time I (or anyone) runs this c# .net app it always says that I have to open Sage and allow access. I open Sage and select 'Always Allow' but we have to do…