• Non-existent items

    We're currently using the Sage100 C# NuGet package noted below. We've run into a situation whereby a miscellaneous item (CI_Item) is visible in the UI and via OBDC connection however, we're unable to find the item using the MASRecordset utilities…
  • 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…
  • 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-…
  • 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?
  • Documented needed to help create new modules

    My apologies if I'm not in the correct forum for this. (It seemed to match the best from the list I was presented with.) I'm looking for documentation on building modules to run from the Sage 100 desktop. I've taken a number of the courses (including…
  • Hubspot

    Is anyone out there utilizing HubSpot? And if so, are you transferring data both to and from Sage 100? Or just transferring data from HubSpot to Sage? Any problems with the integration?
  • 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 =…
  • 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…
  • SSIS (SQL Server Integration Services) Connector to Sage Business Object Interface (API)

    Does anyone have any suggestions on the best way to use Microsoft SSIS (SQL Server Integration Services) to connect to SAGE 100 Business Objects API? We came across this product, but were curious to know what recommendations the community had. https:…
  • 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 in SY_SDataServer.pvc when trying to create sales order with SData

    I am getting the following exception while creating the sales order with SData. Same is working in Dev environment but not working in Stage environment. What could be the issue? Error in E:\Sage\Sage 100 Advanced ERP\MAS90\SY\SY_SDataServer.pvc at line…
  • Error while transfer a stock from one warehouse to other warehouse using BOI

    Hi All, I am working on a task where I need to transfer stock from one warehouse to other warehouse using BOI interface script but I am getting the error "ŠA valid warehouse must be entered at the Transfer To Warehouse field". Is anybody has any idea…
  • Creating GL account with BOI

    Hi, I'm trying to create GL account in Sage 100 ERP with BOI. Here is my code: // omitted initialize and login steps GlAccountBus.nSetKeyValue("Account$","235-04-00") GlAccountBus.nSetKey() // Error is on this line GlAccountBus.sLastErrorMsg //…
  • Issue in RMAs insert using BOI

    Hi ALL, I have an issue to import RMAs few field, All the information get inserted but just EmailAddress and Fax Number not get inserted using BOIs, I am using COM APIs with the C#.Net Can anyone please help me to resolve this issue? Or Can give me…
  • 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…
  • System.Runtime.InteropServices.COMException: <NewObject Error: 90>

    Hi All, I am getting this exception "System.Runtime.InteropServices.COMException: <NewObject Error: 90>" on the below code line, It is working fine in 2016. but on client machine it giving me an exception. oSS = pvx.GetType().InvokeMember("NewObject…