Browse By Tags

  • 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…
  • Sage CRM 2020 R2- Connection to REST API

    Hi everyone. I am relatively new to SageCRM(2020 R2) & I have to use REST API for getting and posting cases. I am stuck on: =>To access a Sage CRM record data via the RESTful API, use the following URL format for your HTTP request: http://{server}/sdata…
  • Get All customers, vendors details using .Net SDK

    Hello, How can i get data of all customers and vendors using .NET SDK ? In Development Guide I can see there is a method "Load by name", which can only return 1 Customer/Vendor. But I want to retrieve all the Customers/Vendors. Is it possible…
  • Customer integration issue after update to 2020

    We have a customer that just upgraded their Sage 100 product to the 2020 version and are seeing some issues with integrating to our product. They migrating from Sage 2016. Below is a code snippet of where the issue is coming from. The error is “CI_NOF…
  • Read Inventory from Sage in C# .net

    FormerMember
    FormerMember
    Hello Everyone I am New to the sage and looking for the C# integration with sage to read inventory data for the client. Our client have the SAGE 100 ERP software . Can anyone help me this and provide the some links for the same.
  • Get a list of codes required for customers such as Terms, Salespersons, and Tax Schedules

    I am new to BOI. I have figured out how to pull customer data using AR_Customer_svc. Where do I find a list of services for other tables such as Terms, Salespersons, and Tax Schedules? Thanks in advance!
  • Is there a version of the Sage 50 SDK that can be installed for .NET Core on Linux?

    I would like to create a web service that can run on a Linux host. Is there any way to do this?
  • CRM & Sage 300 integration stops working for no reason (reboot to get it to work again)

    cCRM V7.3 / S300 V2014 / SQL 2008 R2 / Win 2008 R2 A couple of times a month the integration between CRM & Sage 300 stops working. We get the message (session could not be opened) with number (2147221230) I have checked the services and IIS and…
  • How to get assembly component list using .net api ?

    How do I get the component list for an Assembly item using the SDK ? I can get the list of Assembly items using the AssemblyItemFactory, but it does not have a Bill of Materials or Components collection for each item. The only way I've found so far…
  • Sage 100 2017. Cannot communicate with Sage Exchange Desktop 2.0 when initializing AR_CustomerCreditCard_Bus

    I get an error that says "Cannot communicate with Sage Exchange Desktop 2.0" when initializing AR_CustomerCreditCard_Bus in VB.Net as a Windows Service. I have the sample code attached and the credentials to Sage are hard coded in the Sage100Connection…
  • The Records is not in editable state

    Hi, I got this "The Records is not in editable state" Error while delete contact from Ar_CustomerContact_bus object. Please anyone give hint to solve this issue. Thanks.
  • Payroll Link

    Can anyone point me in the right direction. Client is using Sage HRMS 2014 and 300 ERP 2014. I am setting up Payroll Link and everything is working fine except for the Accruals Tab. I can't see the Accpac Accrual Code/Description fields or the HRMS…
  • How do I know if the connection to the database is open ?

    I´m working with sage 50 CA 2016 SDK, and i have a problem with database connection. When I run this code in a console application successfully opens the connection, but when I run the same code in a Winform application , does not open the connection…
  • Where payment terms are stored for the customer in Sage 50 CA Edition?

    I'm working on extracting data from the database sage 50 CA, but in the documentation containing the data definition , I have not found the relationship of the payment terms with customers, or where it is stored ( table). Here is the information that…
  • Exist the price levels in Sage 50 CA?

    I'm working on the integration of Sage 50 CA with a third party application with .NET. And price levels are within the required information extracted from the database Sage 50 CA, but so far I have not found any information to verify the existence of…
  • Looking for Peachtree 2012 SDK

    Where can I find the Peachtree 2012 SDK? I need to update some custom integration that a contractor built a few years ago. Thank you!
  • Where stored the data returned by the function wSDBFetchRecord ?

    I'm trying to extract data from tables in the database Sage 50 CA 2016, with a Visual Basic application that uses the SDK Sage 50 CA (Simply.ConnectionManagerService.dll). I'm using the function "wSDBSelectRecords" to extract the data And then I 'm…
  • Updating Credit Card Expiration Dates

    We are on 100 Advanced 2013, and have some automated processes that import sales orders through the BOI. We have a number of repeat customers who have been customers for years, and occasionally they use a card that they have been using for several years…
  • Get SalesOrder

    Hello I am using businss object to get SalesOrder for sage MAS90.I am using GetResultSets option to get.In it i am getting array of two columns.Is there way to get mutiple coulumns for this?
  • Sage 50 2015 SDK Migration Issue

    I wrote a sales order entry program on the back of the 2014 SDK's .NET "BasicSDKApp". I recently switched over to use the 2015 Sage.Peachtree.API file (version 2015.2.0.196) and everything work as it did, however now when you save the sales order it does…