• VI Cash Receipt with only Invoice #

    Client is running Sage 100 v2018 and have asked for a VI import of cash receipts. They scan in information and save it as a csv. However, the information does not include Customer Number...only Invoice Number. Within the Sage 100 Company where the data…
  • Azure migration from MSP hosted 2019 VM

    Currently we have an MSP host a Server2019 VM where anywhere from 15-20 people log in to access Sage 100. I am looking to migrate it over to an Azure Instance. Are there any recommended instance types or configuration resources I can read into? Thanks…
  • migrate from Sage 100 to Sage 300

    Hi All Can someone please advise if possible to migrate from Sage 100 to Sage 300? what are the steps or need a partner to do it? thank you
  • Cannot open attachments in memo fields

    Currently unable to open attachments. When I try nothing happens. This is happening for file types. File path look to be correct. I have uninstalled and reinstalled Sage. This is happening on Sage 100 2019 premium.
  • Import AR credit memo detail lines from history?

    I am hoping to streamline my VI script designed to import AR credit memos. If entered manually I only enter CM <Next Invoice>, Customer Number, Apply To Invoice. I am then asked "Do you want to copy invoice information from history?" Clicking Yes allows…
  • Does Sage 100 2020 require MSXML 4.0?

    MSXML 4.0 had been installed on the server at some point during installation of Sage 100 2017. Does it still need to be installed after upgrading to Sage 100 2020? The issue is that the version is no longer supported and is a security risk.
  • What CRM User to use during Sage Premium setup?

    During the Sage Premium setup, it asked for a SageCRM user and I have always used the sa user with no issues. Can I set up a different user and what rights does that new user need to have to work properly? Are there written instructions to do this?
  • SAGE 100 2020 closes on login

    Hello everyone, We are running into an issue where at random 2-3 users a day are not able to login to SAGE. They enter their passwords and the screen flashes and the closes. I've noticed that the module date is somewhere in 2015 when I catch a glimpse…
  • "[ProvideX][ODBC Driver] Internal Error"

    This is happening with a single table MS Query in Excel 64-Bit when accessing large individual I/M and P/R files and continues after rebuilding them (Ex. IM_ItemTransactionHistory) . I reviewed the other thread on this error, but nothing applies other…
  • VI import into payroll doesn't stop, have to click "cancel". All records are imported, though.

    PR header and detail are chained. Same problem with each.
  • Connection to Sage Data with postgresql fails

    Any help is greatly appreciated. Using Sage 100cloud Standard. My company uses Access to query Sage data. This works well, but I'd like to run more advanced and rapid queries. My system administrator has allowed me to install Postgresql on my computer…
  • Moving from Century Business Solutions to Paya Connect

    We are transitioning from Century Business Solutions to Paya Connect Merchant services Objective: to see if there's a way to move the credit card tokens from CBS to Paya so we can continue to have access to the credit cards. I understand that I need…
  • Payroll conversion on upgrade gets to Filing Status mapping screen and I can't go further.

    I installed Sage 100 2018 Standard. Then installed product update 10 and Payroll 2.21. I migrated the data from the 2017 version and began to convert companies. When I get to the filing status mapping screen, there is a single line there, with none of…
  • Sage Migrations (MAS 200 / Sage 100)

    Fairly new to most of Sage. From what I've heard it's not possible to migrate MAS 200 into Sage 100 because of different tax structure setups. We run MAS 200 v4.40 (listed in install as C:\M200cs\V44\MAS90), Sage CRM 200, and Sage 100 2017 v5.40.0…
  • Unable print _Manual check and payment register_databace connector error

    Hello, There is error message on the Sage100 as shown below. How to fix the error? Thank you in advance for your help!
  • No A/P Month End Reports Found

    We're running the A/P month end process for the first time. However, there are no period end reports listed in the Period End Report Selection. These are the reports I expect to see listed How do I get the A/P period end reports to list in the…
  • Importing Main Account, etc

    Is there a way that I can use to import my Main Account, MA Description, Account Category, Main Account Group, MAG Description, Account Type & cash Flow Type? I'm not copying this from another company. It's a brand new chart of accounts with over 1000…
  • List of Tables and Fields for Sage 100 v2017

    Hi, I need to write a query to get the customized AP Open invoice report. In order to do so, I need to find out the reference documents of Sage 100 v2017 that provides a list of Tables and Fields. I searched the Sage City. There was an old thread…
  • Auto pop up UDFs after selection

    Hello, In Sage 100, I've added a UDT with a list of items, and a UDF onto Sales Order Header which enables user to select an item from the UDT. After selection, I also want to pop up other fields (also UDF) based on the selected item. Basically, pop…
  • Error code 30 PDF Terminal Server

    We continue to get "error code 30 printer not activated" on a terminal server 2018, WIN 10. We have manually installed the PDF converter with all boxes checked, and ran Regedit on HKEY_CURRENT_CONFIG\Software. We've turned off UAC and all users have read…
  • Pass TEMP0001 to next VI Job in chain?

    On Sage 100 Advanced 2018, 6.00.5.0. Most of my experience with VI has been rather basic, updating or adding customer accounts, but I also have written scripts to import to Repetitive Invoicing Entry and Cash Receipts. However that is using data that…
  • Update Order Class Picklsit under Purchase Order

    Hello, i am now the default the admin for Sage for my company (I am a Salesforce Analyst by Profession), and I am just learning Sage Admin as issues or requests come up. I am not sure if this is the right group to ask, but overall in Sage if I want to…
  • Sage 100 2020 install is an upgrade from 2017 issue

    Issue is randomly cannot click on a tab key in data entry windows. Have to use Alt key. Any assistance will be appreciated.
  • Adobe Flash

    As companies are looking to move away from Adobe Flash due to vulnerabilities I have a question regarding Visual Process Flows. Most of my clients do not use the Visual Process Flows even if they once used competing products. If a client's security…
  • Sage 100 Workstation Synchronization

    It appears that the process that is used to synchronize the workstation synchronization is no longer an app that can be run to update components after product updates are installed. Instead a vb script is run from a temporary folder. The problem is…