Browse By Tags

  • C# Create Sales Invoice From Sales Order; nSetKey() fails, sLastErrorMsg = "The [InvoiceNo] is invalid"

    I am on Sage 100c Standard 2016 (Version 5.30.5.0) (yes, I know it is very old, and have plans to upgrade to a supported version). I am attempting to create a program in C# that creates a sales invoice from a sales order. When my program executes the…
  • Cleanup() returns null

    I have a C# code that integrates with Sage 100 2021 Standard. After performing some action I want to clean and close the session I opened. for this I'm using: session.nCleanup(); session.DropObject(); for some reason the nCleanup() returns null…
  • Looping a table while batches enabled

    Hi, I want to loop through all my not-registered invoices. What I do (in general) is: dynamic obj = pvx.NewObject("AP_ManualCheck_bus", oSession); obj.nMoveFirst(); //To get to the first record //Rest of code The problem is that I have…
  • Access PO_ReceiptReturnMatRqByPO

    How can I access the table object PO_ReceiptReturnMatRqByPO? I need to delete a record from this table which refers to a ghost receipt and locks my PO. There isn't a file with _bus or _svc, so using NewObject returns "NewObject Error 90". When I…
  • AP_OpenInvoice with balance 0

    Hi, I'm trying to write a code that gets all the invoices which were fully paid. My idea was to take all the invoice and remove all the open invoices from "AP_OpenInvoice". But, I see invoices in that tables that have 0 balance. So probsbly it doesn…
  • 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…
  • Address Validation with Avalara

    Hello, We have encountered an issue when validating addresses where the FOB and ship method are automatically changed after validation is complete. Is there a way to prevent the FOB & Ship Method from being restored to default? Thank you for your…
  • sage .NET libraries for c#

    I see some older threads discussing some in-progress ideas people were working with, as well as some libraries on the nuget packages out there - but there is no documentation on them that I can see. Does anyone have a recommended usage for them? Have…
  • Has anyone used an external requisition software?

    Has anyone used a software package that integrated with Sage 500 ERP for creating Requisitions outside of Sage and then generating Purchase Orders in Sage? What software did you use? How did that process go? Any recommendations or precautions?
  • Sage500 API Documentation

    I am new to Sage and we are looking for Sage500 API documentation because we need to pull data from Sage into a different receivables application. I have been looking around on the website and cannot find anything and I have made 10 calls to 10 different…
  • How do I get the order lines to populate an Invoice/Shipment using BOI with C# when I set the order number?

    I am working with an integration that was previously working (nothing was changed in the code). An order is created in Sage 100, and I then go to set the SalesOrderNo as part of a new Invoice/Shipment in code, and this should load in the line items…
  • Is there a tool that will allow Sage 500 to retrieve a file from FTP for automated processing?

    Trying to integrate Sage 500 A/P with a third party application that drips a batch file into FTP. Sage 500 processing is already automated to process the batch, but it needs something to allow it to automatically retrieve the file from the FTP server…
  • how to download sdk

    i am trying to integrate sage 500 with my application , but i am unable to find from where i can download sage 500 sdk ....can any one help me out ? thank you
  • Programming Sage 300

    I need to start programming in sage 300. Typically programs that import etc. What software do I need and where can I get a good tutorial on this? I have no starting point.
  • Online Portal and/or Ecommerce Integration with Sage 300

    Hi, Does anyone have any recommendations for Online Portal and/or Ecommerce Integration with Sage 300? Requirements: 1. It must integrate with Sage 300. 2. Integrate with Ariba and Ariett 3. Be able to take Credit Card Payments 4. Be able…
  • Creating customer through API aka stored procedures

    I have been trying to create a customer in Sage 500 by means of sage provided stored procedures. To start with, I have my own stored procedure which creates a record in staging table, ie. stgCustomer. Thereafter, I invoke a stored procedure(api by Sage…
  • Importing customer payment for existing invoice

    We have an existing payment engine that processes credit card and checking. I have created the ability to lookup invoices with a balance, "grab" all the details and offer customer payment through other means. Now I need to bring the payment information…
  • Are there any stored procedure to create/update customer and customer contact?

    I recently started working with sage 500 api which is really a set of stored procedures. At this stage, I want to create/update a customer as well as the corresponding contact. Does anyone have any idea of what stored procedures to use for this purpose…
  • Looking for WMS to integrate with Sage 100

    Hello, We are a distribution company that is looking to implement a WMS that can integrate with Sage 100. Preferably one that can stand alone as well. We are going through some growing pains and may also be looking to a new ERP in years to come. May…
  • JobOps with Sage 100 ERP using barcoding with JOScan

    Community, We are a mid-west manufacturing company and are looking to implement the JobOps product with barcoding using JOScan. We are hoping to find another company presently using JobOps with Sage 100 ERP that might be willing to share their experience…