x Want to participate? Join the group to interact

  • robust commission calculations

    Has anybody encountered with success a tool for robust motivational commission calculations. The standard Sage 100 is quite inadequate. We have identified a solution called QCommission who claim to be Sage compatible but not validated. We need a tool…

  • VI job error in VI_ImportAssignValues.pvc

    Hi there, I'm testing out the first of many imports in our parallel upgrade test environment. We are going from 4.5 to 2023 100 Premium. I'm getting an error when running an import of an order that is downloaded from TrueCommerce's EDI TransactionManager…

  • Visual Integrator - Big Commerce

    Has anyone tried to get a proper export from Big Commerce for a VI into Sage 100c 2021?

  • excel is running into problems with 'report designer add-in 1.2.0'

    Why does this continue to happen on reports running through the microsoft scheduler when the report does not use the report designer? excel desigmer error.docx

  • Sage alerts w/crystal reports error

    I am trying to attach a crystal report to a Sage Alert. I have crystal reports installed on the Sage Alerts server and Sage 100 workstation installed as well. I have the SAP Crystal runtime engine for .NET framework 64 bit installed as well. The alert…

  • How to change VI job export column heading

    I'm exporting column names in my Visual Integrator export. I need to rename one of the column headings, but I can't seem to find a way to do that. Anyone have any suggestions? Thanks!

  • Payment Services- Click to Pay

    I am using Sage 100 2022 and looking for feedback on various payment services that offer integration with Sage 100 Sales order. Repay formerly American Payment Solutions is anyone using this service that can offer feedback vs Paya? Feel free to contact…

  • Starship (shipping solution) alternatives?

    Hi, Just wondering if you guys can share experience with shipping integration/solutions for Sage 100. We currently have Starship on Sage 100 SQL but considering a different software for varieties of reasons. Thank you! Ken

  • Loyalty Cards

    Greetings, we want to create Loyalty Programme at our workspace. We want to have Reward Cards including allowing people save money and buy or use their funds later. We will add a magnetic machine to use when reading the card and also scan the card. The…

  • Sage Alerts DateDiff excluding weekends calculation

    I need to edit the date diff formula to be in workdays and exclude weekends. Does anyone know how to accomplish this in Sage Alerts? I found this formula example online, but does it have to be this complex? Having trouble replicating it. This is Sage…

  • Import Orders with Visual Integrator

    I'm wanting to get orders imported started with a J and have them increment for every new order that comes in. I managed to get the J in there, but with using the "NEXT" order number. Is there a way to have the vi job check for the last order, then…

  • Sage Alerts calculated column for length of a field

    Trying to do a simple calculated column in Sage Alerts and Workflow query that is linked to Sage 100 providex. The calculation is to return the length of a string field. I've tried LEN and LENGTH eg: LENGTH("AR_Division"."ARDivisionNo") and cannot get…

  • Error 503 Service Unavailable when trying to login to KnowledgeSync v10 Portal

    Client reports the following: "I have been in the middle of writing a report and was kicked out 4 times by saying the portal has timed out. Now I get this error when I try to log in. " Error is: "KnowledgeSync Alert <!DOCTYPE HTML PUBLIC "-//W3C//DTD…

  • Access to employee data via ODBC

    I have a customer who would like to connect a third party timekeeping program to Sage 100 (v 2021.2 Advanced). With the PII Encryption in place on the employee/payroll data, is that still possible or are there extra steps required to make that happen…

  • Sage 100 2021: Exporting List Boxes To Excel Results In Wrong Cell Formatting Applied

    On a 2021.0 and 2021.2 system, exporting to Excel from a list box results in the cell formatting applied being off by one column whereas on a 2020.1 system, the cells have the correct formatting applied. On the 2021 systems, this was observed when exporting…

  • Does anyone know any way to link Sage with Artifical intelligence or Articial Intelligence Audit

    Does anyone know any third party that links with Sage 100 and Artificial Intelligence and/or Artificial Intelligence Audit capability? Please share any feedback. thanks.

  • Sage 100 button link - pass variable to vbscript for shell call

    From Main Item Maint Panel I added a button link to run a vbscript, which runs a shell command. How can I pass the ItemCode to the vbscript. ' init vars Dim itemcode Dim oShell itemcode = "S-209220" 'hardcoded here works, but needs to change…

  • SendGrid Setup

    Does anyone have any documentation on how to setup the emailing of invoices through SendGrid? We were using "appriver" but all of a sudden it stopped working and everyone is blaming someone else. We have not updated to the newest version so, we can not…

  • CRM Integration to Sage 100

    We are looking for a good CRM and Quoting software that integrates with Sage 100. We would like the products and pricing to sync to the quoting software so we don't have to add and update in two places. When a quote is approved, we would like them to…

  • 3rd Party Accounts Payable app

    Hello! We are very interested in upgrading our accounts payable functionality to include paperless invoice processing, invoice approval and to have a access to alternative payment processing options. Has anyone had success with the using a 3rd party accounts…

  • Sage 100 2020 integration with Amazon Seller Central for Amazon Payment and inventory reconciliation

    Hi, We Needed help to integrate Sage 100 2020 with Amazon Seller Central for Amazon Payment and inventory reconciliation. Following is my requirement : - 1) Sync Amazon sales with sage 2) Sync Amazon returns with Sage 3) Sync Amazon Payments…

  • Sage100 Visual Integrator: Where to put ship to informaton?

    OK. This has me flustered. I have figured out how to use Temp fields in Vi for Sage 100 2019 to create a single SO that has multiple items on it. The data source I'm using has a separate row for each item purchased, and my current VI job creates one…

  • Phone Number Field in Sales Order Entry Table?

    Hi everyone, I have a phone number field in the Sales Order Entry task, which appears to be a customization someone added at some point. It’s not a default field, right? The text label looks a bit different than the other fields and sometimes it seems…

  • Sage 100cloud integration with Okta

    For a lot of different Sage products/solutions there "how to" manuals for integrations with Okta and setting up SSO etc. Is this anywhere available for Sage 100cloud or is there no connection with Okta yet?

  • Sage 100 2020 integration with Amazon Seller Central for Amazon Payment and inventory reconciliation

    Hi, Needed Sage 100 2020 integration with Amazon Seller Central for Amazon Payment and inventory reconciliation. Following is my requirement : - 1) Sync Amazon sales with sage 2) Sync Amazon returns with Sage 3) Sync Amazon Payments with sage…

*Community Hub is the new name for Sage City