Sage 100

I can now successfully create an A/R batch. I am trying to post it. The batch number is saved in sBatchNo. Here is the code I am using to try to post this which I pulled off of another issue in this forum. if (bBatchEnabled) { using (var arInvoice = sySession…

Hi all, I am trying to create a SO Invoice using the BOI using C# in Sage 2018 This is part of the code: soInvoice.PvxObject.nGetNextInvoiceNo(ref invoiceNo); result = soInvoice.SetKeyValue("InvoiceNo$", invoiceNo); var setKey = soInvoice.SetKey…

I have been able to successfully read and write records for AR_Customer. I am trying to do the same thing for AR_CustomerContact in exactly the same way. I am seeing two problems: 1. I can set the values of the first 12 fields (through Salutation) without…

I am trying to add and edit customers. I can successfully edit a record where the customer already exists. I get a 1 return from nWrite. However, when I am adding a new record I get a 0 return. I checked LastMsg and nothing is set. I am trying to figure…

I'm having trouble trying to figure out how to access Cash Receipts History, any examples anyone can share? I'm using .Net Sage100.ObjectManagement. Thanks

I am trying to connect to AR_Customer. using (DispatchObject pvx = InitializePvx()) { using (DispatchObject oSS = Sage100Connect(pvx, "A/R")) { using (DispatchObject arCustomerBus = new DispatchObject(pvx.InvokeMethod("NewObject", "AR_Customer_bus", oSS…

I'm working on an integration that will write AR invoices to Sage 100 from another system where the sales tax is already being calculated and managed. I'm using the Sage100.ObjectManagement library and some of the examples I found here ( RE: Sage100.ObjectManagement…

I am exporting G/L accounts GL_Account_svc) from Sage 100 to our product. One client has thousands of G/L accounts. After the initial export I would like to only export accounts that have changed after a given date. Is there any way to do this uising…

I am looping through g/l accounts with this line: while ((int)glAccounSvc.InvokeMethod("nMoveNext") == 1); It loops through just fine until it gets to the end where there is no MoveNext but it still returns a 1. How do I check for EOF using C#?

I've tried both of these and I get an empty object { } ======================================== string programName = "SO_SHIPPING_UI"; object objProgramName = new object [] { programName }; object result = oSS.InvokeMethod( "nLookupTask" , objProgramName…

Dear Support Team, I hope this message finds you well. I am currently in the process of integrating Sage 100 APIs into our system and require access to the "Returns all Countries" API as outlined in the Sage 100 documentation. To proceed, I understand…

Does VI allow running an import script via a BOI script? If so, could you point me to an example? Thanks!

We have successfully been able to post AR & AP invoices without batches enabled. Now we require that Batch Entry be enabled, so each time we create an invoice it properly assigns a Batch with no issues. However how do we programmatically post/close a…

What is the best approach with running an external BOI application on a Sage 100 workstation? DCOM or running the app on the server with a network file link?

What documentation and/or training courses are there to help in the creation of BOI processes? Currently we use Sdata and need to start learning/converting before support ends for Sdata. Sage 100 Premium.

Good Day, I hope this message finds you well. I am currently facing an issue with a control I've created in MS Access that interacts with Sage100 (Standard 2020 v6.20.4). I'm reaching out to seek your assistance in resolving this matter. The control…

Good Day, I hope this message finds you well. I am currently facing an issue with a control I've created in MS Access that interacts with Sage100 (Standard 2020 v6.20.4). I'm reaching out to seek your assistance in resolving this matter. The control…

I have the following code working properly to post AR Invoices. var homePath = @"C:\Sage\Sage 100\MAS90\Home"; var userName = "test"; var password = "test" var companyCode = "test"; var sessionLogon = new SessionLogon { CompanyCode = companyCode, UserLogon…

Hey all, As I've been learning how to implement BOI within a C# project I was really bothered by the amount of code reuse in my project surrounding instantiating the main BOI connections. This led me to refactor out that common code into a helper class…

Hi, I would like to extract the customer data from customer master using business objects. Can someone let me know, how to do the same. We are planning to integrate the customer master from Sage to Odoo

On sales order invoice items can successfully use BOI to retrieve the SO_Invoice items, and for each item access the lines, however have not been able to collect item serial numbers for each line. For reference a screen capture showing these serial numbers…

Hi all, I am working on the JobCost Maintainance module using BOI, Can you please anyone let me know what object I need to initiate for this?? Thank you in advance !! Thanks SF

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…

I am trying to duplicate the following UI process using the BOI: 1) Create RMA Receipt (header/details) for an Invoice. (Note that the procedure for us is to skip creating the RMA return in the UI.) 2) Distribute RMA lines. 3) Generate Transactions…