Sage 100

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…

Hi I am looking for a script to update "Daily Sales Report/Updates" in sales order (sage100 v2021). Could anyone suggest me what script i can use in BOI suing c# or VB?

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"…

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…

I am getting this error when trying to add miscellaneous item of charge type for sales order in sage100c 2021 int TaskID = (int)oSS.InvokeMethod("nLookupTask", "CI_ItemCode_UI"); oSS.InvokeMethod("nSetProgram", TaskID); using (DispatchObject oCIItemCode…

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.…

Hello Team, I have an application and want to integrate it with Sage 100 cloud. I found the following specification: help-sage100.na.sage.com/.../index.htm As I understood, this API allows receiving all Account Receivables documents from Sage 100…

installed Sage100 and want to check tables models: does Sage100 allow to sync model of tables to retrieve Account Receivable docs? if the above is not possible, could you please share a link to documentation describing tables with this info?

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…

when use BOI to connect Sage 100 ERP cloud, Set user log on return 0, the sLastErrorMsg is: The user logon or password does not match. but the same user logon and password can log on to Sage without any problem. Here is the code I have Sub Main()…

I create this VB.Net application to test connect to Sage 100 ERP cloud, I add ProvideX reference , when run into oSS.nSetUser, get error message: Public member 'nSetUser' on type 'IPvxDispatch' not found. Can anyone figure it out? Sub Main(args…

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 Team, Could you please help me with the following questions? 1) Is it possible to integrate data from Sage 100 via web API? 2) Does Sage 100 have a cloud version? or it is just an On-Premise version?

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…

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…

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…