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…
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…
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?
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…
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…
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…
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…
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…
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…
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?
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…
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…
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…
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…
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…
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.…
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…
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!
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…
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…
I thought I read a post about this, but now I cannot locate one.
When we have Vendors with SSNs, like in this ABC Vendor below, we expect the First Name and Last Name fields to be filled out, but they are not:
Of course we get this message, which…