Browse By Tags

  • User unable to promote company to Sage 300 Customer/Vendor

    Hi all, I am able to promote company as admin. However, my user unable to promote company to Sage 300 Customer/Vendor, stating that the Customer code already exists in Sage 300 Company, but the customer code does not exist yet. My user setting: …
  • Error while installing Workstation Setup

    Hi all, My customer is having error while installing the Workstation setup on Sage 300. Checking the log file, a lot of things cannot be found. how do I fix this? The following properties have been set: Property: [AdminUser] = true {boolean…
  • Session Initialization w/.NET API

    I have the following code to create a session. Session s = new Session(); s.Init("", "XY", "XY1000", "67A"); s.Open(User, Password, Company, DateTime.Today, 0); A client had been using ADMIN/ADMIN for the username and password (don't ask why they…
  • How to figure out errors ViewExceptions .NET API

    I'm trying to insert an order using the API - and I'm getting back an error that just says 6666 How can I find what this means, and in general, is there a way to get the COM exceptions and error codes? I know how to get session.Errors, but that is empty…
  • SAGE 300 PROJECTS AND JOB COSTING INTERGRATION WITH MICROSOFT PROJECTS

    Where can I find a document or a user guide on how to integrate Sage 300 2020 PJC and Microsoft Projects 2016. Please advice
  • 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 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 =…
  • Is it possible to Restrict certain Customers created within Sage 300 with specific group code from getting inserted or synced to CRM?

    Hello, Is there any method/setting, that can ‘Restrict’ certain Customers (with specific Group code) that are created within Sage 300 from getting into CRM as company record? I know that if we tick the suspend A/R integration to CRM checkbox from…
  • Sage300 Integration with C#. Error Occurred While Opening ODBC Connection on Sage 300 Application using C#.

    ERROR [08001] [Simba][SimbaEngine ODBC Driver][DRM File Library]Invalid account name.ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failedERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version…
  • SalesJournal SetShipDate The field you are trying to change or function you are calling is not accessible under current circumstance.

    Hello Friends, I am using SAGE 2019.1 SDK for importing invoice in my application. I am getting error at the time of SetShip date "The field you are trying to change or function you are calling is not accessible under current circumstance.". I am getting…
  • Unable to do multi select in all list box after installing sage 300 2019 CRM Integration Setup

    Dear All, I am unable to do multi select option in all the list box fields in sage crm, this is happened only after installting the sage 300 2019 integration setup. Sage CRM ver 2018 R3. Please refer to the bleow url which is from sage CRM Community…
  • Issue sending AP/AR Adjustments using SAGE300WebAPI calls ARReceiptAndAdjustmentBatches/APPaymentAndAdjustmentBatches

    I'm sending adjustments to Sage 300 ERP Server for 'posted' invoices and I know that the transaction are successful because the webapi call returns a reponse code is 201 and the response message contains the information I sent but when I open the adjustment…
  • There was a problem opening company.: (inner exception: FileNotFound)

    var companyId = GetCompany(); try { // Request authorization from Sage 50 for our third-party application. AuthorizationResult authorizationResult = Session.RequestAccess(companyId); This line Session.RequestAccess throws a PeachtreeException: FileNotFound…
  • #C and SDK issues

    FormerMember
    FormerMember
    Hi, A little background... We were asked by a client to create a.Net application to do a few things. The more effort we put in the less success we seem to be having. We are trying to create POs, Time records, and add Cost Codes to the DB. Reading…
  • update onhand on MasterStockItem

    Hi, Is there any way to update the onhand qyt in a MasterStockItem from the SDK?
  • SDK Performance is tooooo slow

    Hi, I have sage 50 accounting, the data are on a local server (within same network). We have no issue with the performance when using Sage 50 but when using the SDK it's really [:@]tooooooooooooo[:@] slow Listing companies takes 45 seconds! Finding…
  • 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…
  • 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…
  • How to capture the data returned wSDBSelectRecords in sage 50 2016 CA SDK with Visual Basic .NET?

    I´m using ConnectionManagerService.dll and I am using the function wSDBSelectRecords with this syntax: Call wSDBSelectRecords(iDBLink, iTBLink, "", 0, True) But I do not know how to capture the data you are going to select in a DataTable. I´m Working…
  • Custom button is missing once the CRM Integration with Sage 300 ERP 2014 is installed on CRM server

    I created a new button through Administration > Advanced Customization > Button Group for Company Summary screen with the System Act of "newemail". It was working until I installed the Sage CRM Integration for Sage 300 ERP 2014. Once it was installed…
  • Update Inventory Worksheet via SDK

    Hi Guys, I am having an issue while updating Inventory Counts in SAGE300. I have created the Macro but it actually does not update the Quantity Counted in I/C Physical Inventory Quantities. Has someone successfully updated /C Physical Inventory…
  • How do you keep from having to 'allow access' every time you run your app?

    I have an Application ID and I can start a new session and open our production company, but every time I (or anyone) runs this c# .net app it always says that I have to open Sage and allow access. I open Sage and select 'Always Allow' but we have to do…