Sage 100

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…

Why would a FedEx FXI-A profile created to access a Sage 100 order table require multiple credential logins when processing orders during the day? A FedEx FXI-A integration data file mapping profile was created to allow access to a Sage 100…

I'm currently trying to integrate SO_Invoice using BOI and needing to override pricing on the line item, below is snippet of the code on the line level retVal = oSOInvoice.oLines.nAddLine() retVal = oSOInvoice.oLines.nSetValue("ItemCode$", "XX"…

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 all, I'm in need of some guidance and help as I'm stuck in my process of inserting an SO Invoice using SO_Invoice_Bus that includes non inventory (like misc or charges item) these items are in sales order with 0 quantity and need to be in the invoice…

Hi, We are looking for consultant to help in installation of Sage API into our sage 100 2020 or someone who has worked on similar projects Please check below link for understanding: https://www.sagecity.com/us/sage100_erp/sage-100cloud-power-platform…

Hi, I have a script to add manualChecks to Sage100. It works. I want to register the checks through in the code. I tried to do it with the code I used to register invoices: invoice.nSelectBatch(batch); invoice.nSetPostingDate("20270531"); invoice…

I created a receipt of invoice, applied PO to it, changed some info- and in the end I called record.nWrite(); where record is the pvxDynamic representing PO_Receipt_bus. I know that after the write, I have a new receipt in Sage and it's valid …

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…

Hi, I'm trying to write a code to create a new invoice from PO set the key ReceiptType$ set the key ReceiptNo$ call setKey() set PurchaseOrderNo$ set InvoiceNo$ Now i want to add the lines of the po to the receipt. In addition, i want…

Hi Sage Family, I'm trying to create a SO_SalesOrderPayment record using an external BOI script. Ebridge is creating the Sales Order and Customer record. The client didn't find out until implemtation that the CC pre-authorization wasn't being done.…

I'm a Sage 100 business partner and I've just performed a server migration from an on-premise server to a cloud server. A third party product that was working fine on-premise, isn't working in the cloud installation. The 3rd party developer believes there…

I have a working Receipt of Goods Visual Studio VB console app. It's an integration project. I have a textfile that has the receiving data. It's easy enough to MoveFirst and MoveNext and match the text data to the PO Line using LineKey (or I could use…

Visual Studio VB app. I want to use SelectNewBatch method. I am using these objects: taskID = oSS.nLookupTask("PO_ReceiptOfGoods_ui") retVAL = oSS.nSetProgram(taskID) oSEC = oPVX.NewObject("PO_ReceiptOfGoods_ui", oSS) oBUS = oPVX.NewObject("PO_ReceiptOfGoodsDetail_bus…

Experts, I need to establish an object handle in PowerShell to a UDT. I know how to do it in VBScript. Does anyone know the proper syntax in PS? If not C# would be helpful as well because I could try to figure it out from there. For regular object…

Hello All! I have an issue with creating a PO via BOI that I was hoping someone can help me with. We're using Sage 100cloud Premium 2019 Version 6.10.4.0. Here's my code: using (DispatchObject poObject = new DispatchObject(pvx.InvokeMethod("NewObject…

Hello, About a year ago we hired a 3rd party company to develop a Sales Order integration for us. Essentially what they are doing is extracting data from our Quotes & Sales Orders application (using Zoho Creator) and using POST functionality to create…

All of the users in my company have separate SAGE 100 credentials and I wanted to see if there's a way to configure it so that they can authenticate through LDAP instead. I also wanted to see what other authentication methods there are out there for SAGE…

Hi the team, I am a developer and we use SAGE 100C in my company. I want to learn how to use BOI for some scripting tasks and integration. After strugling in searching on the web. I have found this forum. Can someone help me to find either an online…

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

Does anyone have direction on how to integrate the credit card pmt option to work with authorize.net (credit card company) so we can process the pmt thru sage verses logging on to credit card processor?

Good day. I am using BOI to add orders into sage and I am having problems with placing orders on Misc items. I get the error "The item type must be Regular, Special or Miscellaneous." but the item is set to type "Miscellaneous" in the Miscellaneous…

hi, Greetings !!! I want c # sample code through which i can create invoice entry through object matrix dll for sage 100

BOI Pros, I'm looking for BOI examples with a NewObject call beyond just passing SY_Session as an iDispatch inherited object. The following code works fine I would like to test other variations. ' Sage 100 - First Customer - Print Selected Columns…

Trying to get some pointers if anyone experienced the same issue or can provide some pointers in this matter. One of our client upgraded to Sage 100 premium 2020 (from 2016) and our scripts we generated and were running okay in 2016 are getting The…