Browse By Tags

  • Have you ever had performance issues with Starship due to your UDFs? What is your UDF count?

    Hi all, We've been using Starship for years but in the last week have experienced major delays and performance problems EXCLUSIVELY with their integration (meaning other 3rd parties like ScanForce, Avalara, Paya, TrueCommerce, Insynch, etc.... are performing…
  • Expanded Price Levels (DSD IMXL)

    I have an end user that is considering DSD's Expanded Price Levels enhancement. I am a little nervous adding an enhancement that will have such a large impact on Sage 100. Just wondering if anyone has any experience with this enhancement. If so, are you…
  • Sale order zipcode import issue after upgrading from Sage 2018 to 2021

    Hello, We just recently upgraded to Sage 2018 to 2021 and our third-party web service(Deposco) sale order imports are now having issues after migration. Error response: FAILED : Exception: Error trying to set property BillToZipCode$ with value 46550…
  • Duplicate SO (PO's) being imported via True Commerce EDI in Citrix environment

    Upgraded from Sage 100c Advanced v2019.2 to v2022.1 on new Win2022 ERP server and separate Win2019 Citrix server. When we import EDI PO's from True Commerce Transaction Manager v2 integration into Sage 100 which become SO, of course, we get duplicate…
  • How do I split incoming EDI sales orders into appropriate warehouses while also considering stock status?

    I am currently using Sage 100 and Trucommerce Transaction Manager. Our current setup is incomplete. Transaction Manager sees what state the sales order is shipping to and then assigns the appropriate warehouse code so that the order will ship from the…
  • How to enter Purchase order and create Sales Order using API

    My team has been using desktop Sage 100 (2021) to enter purchase orders to generate sales orders, but we would like to do this via API. https://help-sage100.na.sage.com/2021/FLOR/index.htm#Program_Listings/Program_Listings_Overview.htm?TocPath=Program…
  • 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…
  • Setting shipping/mailing addresses in Sales Orders and Purchase Orders

    I feel like there's something I'm missing. I can successfully create a Sales Order and a Purchase Order with line items in Sage50 using the .NET API (not ODBC). The issue I'm having is that while the correct vendor/customer are set, the address for…
  • Missing record to calculate taxes, Sales Order Invoice.

    I'm getting this error if I leave off the sales order number. I want to be able to enter the sales order invoice without a preexisting sales order. All the code seems to work and the data is being input into Sage, however the tax fields never populate…
  • 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…
  • 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?
  • Order creation with authorized credit card details from 3rd party system

    I am trying to import a sales order with payment details. The credit card is already authorized in 3rd party system (eCommerce), i want to save the Authorization code and Transaction Id in Sage so that while invocing we can capture the amount. But payment…
  • 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 to overwrite the sales tax using sdk

    We want to be able to write the Sales tax of a document back to sage using a third party application. From the .net dll, we have understood that the sales tax can only be calculated but not written to. But we want to know if there is any way we can edit…
  • 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.
  • Signature Pads for Sales Order Module

    Hello Everyone, I've read the previous posts referencing signature pads; however, they are all outdated. The company I work for is looking to implement the use of signature pads with our sales order module to streamline our processes. Currently, we…
  • 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…
  • Sales Order Entry via BOI

    Please forgive me as I have been scouring the internet and other Sage sites to find the answer to this question with no avail. I am trying to insert a sales order from c#. The order gets created, yet it doesn't have an assigned customer or any lines…