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.
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…
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…
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…
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[] { …
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
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!
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 there's a way to get the latest revision number from A Bill of Materials.
I've tried to get the value by uising oProduction.nGetValue("Revision$", strRevisionNo) but im still getting the "000" revision number.
Thanks…
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…
Where I can find the work order header & material details in C# language?( help-sage100.na.sage.com/.../index.htm In which table I can find those?
Eg: For purchase order I fetch the details from PO_PurchaseOrder_bus. Where I can find the details of…
How to get PurchaseOrderNo using PurchaseOrder Details & LineItems data from Sage 100 desktop application using C#?
I have using DispatchObject and done login and select company functionality.
Can you please help me to get PO detail using C#?
Hi all,
I'm experiencing issues trying to new up a AR_Customer_bus object, my eventual aim is to be able to create a new customer using the BOI. The error I'm getting is a 200 error.
This is my code so far, also note that I've written this off the…
Hello,
I am having difficulty getting some code to work. I have found examples, but translating it to C# is making it harder to solve the problem.
I am trying to export a sales order through the SO_SalesOrderPrinting_UI BOI.
the following settings…
I am working on a C# .net desktop application that needs to be able to connect to Sage 100 2017 and retrieve available inventory quantities for all products. I've run into a complete brick wall trying to figure out how to do this. I have several questions…
I have a dev environment setup where I am using eBusiness Web Services to communicate with Sage100 2018 on prem.
I am attempting to add a payment to an existing SalesOrder however I receive the error “Payments may only be appended to an existing list…
I am currently attempting to sync product information from MSCRM online to Sage100 on prem...
Is there anyway to manage the Inventory Items through the eBusiness Web Services? I am able to retrieve customers, sales orders, etc. but do not see any options…
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
I'm trying to read from AP_VendorElectronicPayment and not having a whole lot of luck. I've verified that electronic payments are enabled for the vendor, and I can access electronic payments settings using the same credentials as this code runs under…
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,
We recently ran into a problem while importing AP invoices as a batch. Here is a summary of our code in C#:
// Loop though AP invoices a batch
foreach (var invoice in batch.NonInventoryInvoices) { try {
service.Call("nCLEAR"); service…