Browse By Tags

  • Creating a Parameter and Filter to Only return last 5 years out of 20 years of data in the report - This is a Consolidation Financial Report and has a Standard Report named Fiscal Year

    I Have a Consolidation Report with last 20 years financial data and I want to create a filter so that the report only returns last 5 years of data, I tried including system parameters to the standard report 'Fiscal Year' First but whenever I run that…
  • Multi-Line Invoice Import through Visual Integrator

    While importing a job through VI for AP Invoices - if there are multiple lines on the same invoice, the job will not work correctly. Is there an easy fix to this. The invoice will either not show up in Invoice Data Entry or Sage will need to be prompted…
  • Payroll Entry Unbalanced

    We posted a payroll entry that wasn't balanced. From looking at it, it appears that we used an earnings code that wasn't liked to a GL account and now the trial balance is unbalanced. I wanted to see if anyone else has experienced this and see how they…
  • How to filter in nGetResultSets or GetResultSets

    I am working on getting data from sage100 2016. I need to know how can I apply filter to data that I am getting using nGetResultSets. The documentation Sage100-2018 has shown what the function needs: FUNCTION GetResultSets(descColumn$, keyColumn$, dropBoxLoad…
  • Pop-Up message when starting SAGE 100

    I get the following pop-up message when clicking on the windows 10 desktop icon for SAGE 100 2023 advanced: "User Account Control Do you want to allow this app to make changes to your device PvxBootstrap" Is there a way to prevent this message from…
  • Email SO Invoices with Attachments

    I know how to add attachments to emailed invoices, but I understand all recipients get the same attachment. How do I email invoices, each with it's own unique attachments?
  • Accounts Payable Check Printing

    We had 2 checks stick together during check printing. I did not notice we were off by a check number until I had printed and posted the batch. about 40 of our 78 checks printed are off by 1 number. How do I fix this? Do I have to void them all and reprint…
  • Will Sage 2023 work with Starship 23.1.2

    Will Sage 2023 work with Starship 23.1.2?
  • Downloading/exporting General Ledger Detail Reports - so slow

    It takes longer than I consider normal to run the GLDR, print to PDF, and export to .xls. Does everyone have a slow export? I miss my last job's accounting software that had instant GL downloads (smart lists in Great Plains). Is there a way to speed it…
  • Sage 100 in Azure

    I am in the process of migrating Sage 100 on prem to Azure. I see this a a multi step process... In Azure: Will upgrade my on-prem Sage instance to latest version. Install Sage 100 on Azure Server (latest version) Overlay the new installation…
  • Days to pay report or query?

    I'm looking for which tables to use for creating a report or query to calculate the average days to pay per client. Any feedback is appreciated.
  • User is unable to print from Sage 2022

    A user of ours has recently been set up on a newly refurbished device. Device is on Windows 11 While logged into Sage 2022 they can drill down to specific location but when trying to print or preview the get the following alert "The database login…
  • Zip Code Removal on US Country

    Hi, I'm having an EDI PO import error that says zip code "33966" for Fort Myers FL is used in more than one country. I exported the SY_ZipCode table and found it listed for both US and USA. Would someone be willing to suggest a method for removal…
  • Electronic Payment paid twice as much as invoice

    We have a vendor that we entered in our AP data entry. The amount entered into the data entry batch matches that amount of the auto draft from our bank account. When we go into Invoice Payment Selection, the amount is correct and matches back to the AP…
  • Drilling down

    In most accounting software programs, when you create a document, you are able to click on any line to drill down. I do not see such an ability with Sage 100. What am I missing?
  • Formações Sage 100 - Março - Sage University

    Explore as nossas formações de março e garanta a sua participação nos cursos que o ajudarão a aumentar a sua eficiência na execução das tarefas do dia a dia. Para qualquer esclarecimento adicional, poderá entrar…
  • Sage 100 2023 SQL queries not running in custom web app

    Hello folks, We are starting the process of upgrading from an older version of MAS 90 which ran on Providex to 2023 Premium. There are a number of custom apps that we've developed over the years to run with our MAS data and they all used the MAS ODBC…
  • Sage 100 Cloud Advanced 2019 version 6.10.4.0 Consolidated Financials for 4 Sage companies

    I am using the above-mentioned version of Sage 100. I am also told it is called Sage 100 Construction although I do not see that information on the application. I have four different companies on Sage, and I want to create consolidated financials without…
  • Unable to perform Period End Processing while AP Invoice Data Entry is in progress

    When trying to close AP for the month in Sage 100 we are receiving this error "Unable to perform Period End Processing while AP Invoice Data Entry is in progress". However, there is nothing to post. I can see in the tables that there is data that has…
  • input/output error SY_Session.pvc

    We are getting multiple occurrences of this error (multiple lines and multiple processes) on Windows 11 machines (like the Windows 10 posted linked below). I have research a lot of things but this keeps happening. Any assistance or ideas? Did the…
  • Server-mounted PowerBI Gateway

    Having trouble with a server-mounted, On-Premises Gateway communicating with my silent ODBC for Sage 100 access. On-Premises Gateway successfully installed on my server (also the Sage server), and my published Power BI semantic model recognizes it.…
  • Vendor Terms Set Not Updating in PO Module

    Hello everyone, I had updated a vendor's terms in Vendor Maintenance. Since updating I have received a handful of invoices in the PO module and it still keeps having it as due upon receipt instead of populating the terms I set it to in the vendor card…
  • Sage 100: Dropping in Employee Maintenance Data using a CSV or Excel file

    Anyone have any experience with using an excel or csv data base spreadsheet to import employee maintenance info into Sage 100? Looking to save some time for a large client. Name, Address, SSN.. Thanks!
  • exporting invoice detail lines

    is there a way to export the line details on current open AR invoices. When I use Business insights the current open AR invoices just give the balance of the invoice not the line detail for those invoices. If I use invoice history I get more then open…
  • sage100 cambio de servidores

    Buenos dias, Soy consultor informático y administrador de Sistemas. Tengo un cliente que hace más de 10 años le administraba los sistemas que tenia en Windows 2003 server y MS Sql 2008. Sobre eso está montado Sage Linea 100 contabilidad (y servidor…