Sage 100

Hi, I want to read and write data in sage100 database, so after some research I found out this course for reference. But just need to validate that is this course really guides on how to read and write back data to Sage100 database or not? This…

Hi, I am new to Sage100 and customer is using Sage100 advanced which comes with ProvideX ODBC driver which only allows to read data from Sage100. I did some research on the functionality to write back the data in Sage100 but was not able to find any…

I am getting this error "Missing record to calculate taxes." while trying to import Sales order in Sage using BOI. Has anybody faced this issue before? OR anyone has some idea how to solve this. Appreciated your help

Hi, I've been wondering if there's a way to get the latest revision number from A Bill of Materials. I've tried to get the value by uising oProduction.nGetValue("Revision$", strRevisionNo) but im still getting the "000" revision number. Thanks…

Where I can find the work order header & material details in C# language?( help-sage100.na.sage.com/.../index.htm In which table I can find those? Eg: For purchase order I fetch the details from PO_PurchaseOrder_bus. Where I can find the details of…

I am currently attempting to sync product information from MSCRM online to Sage100 on prem... Is there anyway to manage the Inventory Items through the eBusiness Web Services? I am able to retrieve customers, sales orders, etc. but do not see any options…

Hello, We recently ran into a problem while importing AP invoices as a batch. Here is a summary of our code in C#: // Loop though AP invoices a batch foreach (var invoice in batch.NonInventoryInvoices) { try { service.Call("nCLEAR"); service…

Hello, A client of mine owns SAGE 100 i7 and I wonder whether it's possible or not to access his data from outside (from a webserver hosted in Azure) like the bank transactions... Any idea? Thanks in advance for any help. Best regards…

Hi All, I got the issue while trying to import the Invoice into Sage. I am using BOI Interface with the C# code. I am getting this "All lines have not been distributed." error while importing, Can anyone suggest me to solve this problem? Thanks…

Hello I am trying to read data from SO_SalesOrderDetial i tried setting key value to read data for a given sales order i am able to get data using GetResultSet but i am not able to read values like price , ordered etc and when i am trying to use…

Hello i am trying to read data for each line in sales order and i am getting a error , i am not sure why i am getting this error cause the same code is working for few lines but not for few this is my code ##################################################################################################…

I'm trying to create Sales Orders within Sage 100 via C#, but I've been having trouble including payment information. I wonder if anyone could please help get me on the right track. I've been able to set a Freight Amount, but I've not be able to set any…

Hello Everyone, I am trying to build a 3rd party C# application for my client on sage 100, i read several things but was not able to achieve this, i have been trying few sample codes to connect with sage using BOI but i am not able to read data from…

Is Company ID from ODBC login available?