• Getting customer data from sage100

    I need to get customer data from sage100 using .Net code. I went through https://help-sage100.na.sage.com/2018/FLOR/index.htm but could not understand the functions as there was no clear instructions. I managed to get data from two columns using a sample…
  • Error while writing a Purchase Order Invoice using C# to Sage 100 US

    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…
  • Create PO Purchase Order in BOI c# on Sage 100

    Hello, getting an error: Invalid or missing header on the code below- can anyone provide a working example of creating a purchase order in BOI? using (var sySession = new MasSession(homePath)) { sySession.InitSession(sessionLogon); CI.ColumnNames…
  • BOI. Please, provide an example of a sample C# or VB code as a reference to write invoice using BOI which links to an Order

    Hi Team, Please, help me with this scenario. Scenario: Order is already created in the ERP Using BOI, write an Invoice to ERP that Integrates into an Order (The invoice will contain the Order document number(DO_Piece)). a) This invoice can also…
  • BOI not pushing web orders to Sage 100

    We are encountering an issue where CIM Cloud web orders are successfully pushing to the ERP Driver but is failing to create a BOI session. Any suggestions on what other pieces we can troubleshoot before reinstalling the ERP Driver? What we have tried…
  • Is the BOI going to stick around for awhile? Is there a better way to communicate with Sage 100

    I've been working with the Sage 100 BOI for some time now and have done a lot of C# applications that interact with the BOI for all sorts of Sage 100 integrations. As we all know the "API" is pretty clunky. I thought about creating a class Library that…
  • Where is Credit card information stored in Sage 100

    Can anyone please help me with the business object for Credit card information and the tables in which it is stored.
  • Looking for consultant to help in installation of Sage API into our sage 100 2020

    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-…
  • How to receive access to Account Receivables documents via API

    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…
  • What's the purpose of SetDate?

    I took the BOI class, but that seems to be intended as a high-level overview, not so much a function-by-function breakdown. I checked the documentation, but it just says "Set module date". Not exactly helpful. So, what's the effect of setting the module…
  • nLookupTask returns 0, sLastErrorMsg is empty

    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…
  • Scanco told me this morning that they have discontinued support on their 2016 products as of 9/30/19.

    Has anyone else been told this? Did anyone receive notice of this?
  • Integration of Sage 100 to my rails application

    Hello, I am a developer, and we have purchased Sage 100 partner account. We want to integrate it with our app. Where we will fetch products related data to our system. However, I am unable to see any help regarding the REST API or integration tool. I…
  • Error creating record in SO_SalesOrderPayment table, "you must enter payment information, Sage Exchange Vault Payment Identifier"

    FormerMember
    FormerMember
    Hello Everyone, I am trying to figure out how to know what is the cause of an error that will not let my software create a payment record for an incoming Sales Order. The error I got from the business object is: "Error Creating record from table…
  • BOI with PR : Cant figure out how to add detail lines to pr_payroll

    Hi all! I'm working with the new BOI capable PR module and having trouble sorting out how to add detail lines. I seem to have worked out creating a transaction, at least the batch I create does end up with an entry for the employee I am adding to…
  • Error produced in vbscript when trying to create GL_Account: The record is not in an editable state.

    I am just starting out on my Sage 100 journey to help our Sage admin automate a few processes. So, please bear with me as my knowledge is limited... We are on Sage 100c Premium 2018 (Version 6.00.3.0) I took the Intro to BOI class in SageU which was…
  • Syncing Sage 100 customers to Sage CRM without using Relationship Management Wizard

    We are looking to move customers from our Sage 100 system to Sage CRM. We have a 3rd-party application that generates customers and we feed them into Sage 100 using VI. That part works fine. However, it's not possible to trigger the creation of a…
  • Quotes from Sage 100 ERP integration as PDF (cross-posted)

    Hello! Can PDFs that we create through Crystal Reports in ERP be automatically loaded into CRM quotes/documents? We're working with a Sage CRM 7.3a & Sage 100 ERP integration, and therefore we are creating quotes and orders using the ERP Sales Order…
  • How to integrate with Sage Vault for associating CreditCardGUID with Sales Order?

    We are using Sage 100 Premium ERP 2014 (Version 5.10.1.0) with eBusinessWebServices (eBWS). We are setting up an ordering website that will process credit cards. The goal is to tie this all together for collecting new credit cards, converting them to…
  • Create new Batch / Get used Batch number

    Hello, I'm inserting invoices for a client and they have requested that they all go into the same batch. I can't figure out how to create a new batch and keep using it. The best I can come up with is creating a new batch for each invoice. I pull…
  • nProcessReport returns 0 and blank last error message

    Sage 100 ERP Version 5.00.8.0 The following code fails at the call to nProcessReport returning 0 and LastErrorMessage is blank. using (DispatchObject pvx = new DispatchObject("ProvideX.Script")) { pvx.InvokeMethod("Init", @"C:\Sage\Sage 100 Advanced…
  • MAS90 -EDI 846??

    Hi, Let me start by saying I am new to MAS90. The issue we have is trying to create an 846 doc (using Gentran Director). We have a report called Inventory Stock Status Report, that give's the information that I need for my 846 document. but when I try…