• 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…
  • 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…
  • CustomerNo$ not on file

    We have no issues creating AR invoices in the ProvideX library with Sage 100 Advanced. We have several clients using our integration (all with Advanced). We were told our code would not need to change to support Premium (SQL). After setting up Premium…
  • Refresh Sales Order lines after they are imported

    Hi Forum, I have a script that imports Sales orders from a SQL server, but because some of the lines are kits the components display at the end of the order. Is there a way in BOI to refresh the Sales Order lines after is imported into Sage ? …
  • 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…
  • 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…
  • How to create a shipment for a sales order with BOI

    We are attempting to create a shipment for a sales order in Sage100 4.5 using the business object interface, however the "shipping_bus" object does not seem to have any meaningful methods associated with it. There are no articles in the knowledgebase…
  • BOI - Unable to edit QuantityBackOrdered in salesorder lines

    Hello, I am using Sage ERP 100 Version 2015 and using BOI to update QuantityBackOrdered on an existing sales order line item. The QuantityBackOrdered is not getting updated in MAS. I am able to change it from the UI. liStatus = gpSalesOrderHeader…
  • Sage BOI Class not offered anymore

    I'm new to the sage BOI and trying to learn it - I've found the file layouts and object reference in the help. However everyone in these blog posts indicates that it is extremely useful to take the BOI class at Sage University. However the BOI class…
  • How to fix "RPC server is unavailable" error when calling NewObject("AR_Customer_bus")?

    We have a client who recently upgraded from Sage 100 2013 to Sage 100 2016 on the same server. When we call a NewObject using software that we had written in VB.NET on the server, we will get an RPC error at random times throughout the day. I've also…
  • BOI Receipt of Goods Error #88 on nWrite

    I just spent a few hours troubleshooting something and figured that someone else might benefit from my experience. We have a receipt of goods integration that runs from AP invoices in our ECM system and creates a receipt of goods entry in Sage 100 ERP…
  • Get records from system tables

    There is a system table named "CM_UDF". I want to get records from this table. The corresponding data file for this table lies in folder named "MAS_SYSTEM" which is outside the folder structure belonging to any company. Moreover, there are no business…