Sage 100

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…

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…

HI All! We've put together a netcore API hosted on IIS for integrating with other tools we have. All of our services on the API are scoped to give the requests their own instances and dependencies. public static void AppServices(this IServiceCollection…

var sessionLogon = new SessionLogon { CompanyCode = companyCode, UserLogon = new NetworkCredential { UserName = userName, Password = password }, ModuleCode = ModuleNames.AccountsReceivable, ModuleDate = DateTime.Today }; using (var…

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 have a C# code that integrates with Sage 100 2021 Standard. After performing some action I want to clean and close the session I opened. for this I'm using: session.nCleanup(); session.DropObject(); for some reason the nCleanup() returns null…

Hi, I want to loop through all my not-registered invoices. What I do (in general) is: dynamic obj = pvx.NewObject("AP_ManualCheck_bus", oSession); obj.nMoveFirst(); //To get to the first record //Rest of code The problem is that I have…

How can I access the table object PO_ReceiptReturnMatRqByPO? I need to delete a record from this table which refers to a ghost receipt and locks my PO. There isn't a file with _bus or _svc, so using NewObject returns "NewObject Error 90". When I…

Looking for a Microsoft Power App expert who can develop a power app application that will fetch data from the SQL database in bulk and then send that data to Sage 100 ERP via Sage 100 API connector which is already installed. Data to be picked and sent…

We are looking at a Third-Party software called Master Control for our QA/QC documentation processing. With that, we want to be able to extract data out of Sage 100c Advanced v2019.2 (upgrading to v2021 shortly) from Scanco's Manufacturing module, as…

Hi, We are looking for consultant to help in installation of Sage API into our sage 100 2020. Please check below link for understanding: www.sagecity.com/.../getting-started-with-the-sage-100cloud-custom-connector-for-the-microsoft-power-…

Hi, I'm trying to write a code that gets all the invoices which were fully paid. My idea was to take all the invoice and remove all the open invoices from "AP_OpenInvoice". But, I see invoices in that tables that have 0 balance. So probsbly it doesn…

I'm working on an integration for a client and am trying to create PO Receipts using c# and Sage 100's BOI. The end result shows the vendor when I look at all PO Receipts, but the receipt is empty when I view the full receipt Here are the current…

is there any way by which we can achieve integration between ACT! and Sage 100?

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 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, I've been encountering the error "ProvideX object has been released" on posting production entries. Im using BM_Production_bus and BM_Bill_bus, and dropping those objects if there's any error/component mismatch on the BOM. Thanks!

Is anyone out there utilizing HubSpot? And if so, are you transferring data both to and from Sage 100? Or just transferring data from HubSpot to Sage? Any problems with the integration?

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…

Hi, i've been constantly getting the error "System.Exception: <NewObject Error: 200>" when I register the BM production entries. here's what I have coded: oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI")) objTransactionRegister =…

Hi, I've been wondering for a couple of days now. it seems that the Distribution line is adding a bunch of numbers on my Lot. retVal = oProduction.oLines.oDistribution.nAddDistributionLine("B456") oProduction.oLines.oDistribution.sLastErrorMsg says…

Hi, So i've been trying to put an entry on BOM Produciton entry, it seems to be having an error with the Distribution part. (im using an item with Lot Valuation) retVal = oProduction.oLines.oDistribution.nAddDistributionLine("B456") retVal = oProduction…

Hi All, I have a custom module installed in Sage 100, I need to do insert in it using BOI script. Is anyone has any Idea how I can achieve it? your reply will be Appreciated Thanks, SF

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…