• 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…
  • I have used Sage for 30 years and need to utilize purchase order and inventory modules.

    Where do I start? We are a manufacturer and I purchase raw materials and sell the finished product. I currently use the sales order module for sales orders & invoicing. I need direction and recommendations.
  • 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 a Microsoft Power App expert

    Looking for a Microsoft Power App expert who can develop a power app application that will fetch data from the SQL database in bulk and then send that data to Sage 100 ERP via Sage 100 API connector which is already installed. Data to be picked and sent…
  • Best option for extracting data out of Sage 100 into Third-Party software

    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…
  • 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…
  • Is there any way by which we can achieve integration between ACT! and Sage 100?

    is there any way by which we can achieve integration between ACT! and Sage 100?
  • Invalid or missing posting date encountered on Bill of Materials transaction update

    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…
  • BM Production register Error "The register must be printed prior to posting"

    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…
  • BM ProductionRegister - New object error:200

    Hi, i've been constantly getting the error "System.Exception: <NewObject Error: 200>" when I register the BM production entries. here's what I have coded: oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI")) objTransactionRegister =…
  • 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?
  • Anybody else having issues with JobOps/Scanco integrating with other ISV's?

    We have been using Sage 100 along with the Scanco and JobOps modules for quite some time. We recently purchased a module from another ISV which requires some integration work to be completed to ensure they operate together without conflicts. We’ve tried…
  • Ar Cash Receipts using BOI

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