Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
We've recently moved from Sage 100 providex to SQL. Upon looking at our tables in SQL it appears that every field of type datetime now has been set to not allow null values. As a result all of those fields now automatically populate with 1753-01-01 (SQL…
Hello!
I am building a php eCommerce system for a client, and they would like to have inventory and product data synced from Sage 100 ERP 2016 to the eCommerce store.
They were previously using MAS90 when we had first looked into it, but between that…
Hello
I Need to upload my customer price list, someone can help me to do that.
I did pull the file and change already price on it. but now I need to put it back, appreciate your help.(excel file)
I am using sage 100 advance ERP V 5.008.00.
Joe…
Hello,
I do have sage 100 advance 5.008.00, one of the user gets disconnect from the server that's what I assume because of the message.
host:[tcp]server1.companyname.local;49383;NODELAY;STREAM
she needs to log off and then log in in order to…
I'm looking to pull the current balance of the GL for each account, basically exactly what is in the History Tab of account inquiry. Whats the best way to accomplish this? I've looked around the GL tables for any sort of summary. Will I have to sum the…
Hello everyone,
We have been using Sage 100 and it's earlier incarnations for over 20 years. Our data sets are quite large, especially sales and invoice history and inventory. What is the best practice, or what do you all do to maintain your data sets…
Utilizing Visual Integrator, I am attempting to create an export query where I only export the AR Customers records with blank comment fields. Anyone know of a way to do this?
Our Sage 100 version 4.40 server had a few files fail the integrity test with either read or write errors. I selected OK to rebuild them but now all the records are gone. The log file shows all the records were recovered.
Is this normal?
I can import…
Once every 1-2 weeks or so I have to get in after hours to rebuild sort files, in our old business system a similar process was scheduled to run each night. Does anyone out there have a script or other method that would allow for scheduling a rebuild…
I was trying to change a customer number, but when I went to Utilities and tried to use Delete/Change, I got the message that I was unable to proceed with unposted data in A/R Invoice Entry.
When I looked at the A/R invoices, I was unable to select…
We are having an issue with non-existent inventory items in our Sales Orders occasionally showing up as a "-1" item, but they do exist. Our software support company looked into this a while back but was not able to resolve the issue.
I am wondering…
Hello,
Everyone has been so helpful in the past, I thought I would ask about another issue I am having.
While trying to delete some items through the "Delete and Change Items" Module I receive the following Error Message for each of the items…
We use FIFO and item costs can vary depending on when we buy them, I need to be able to calculate the cost of an item based on the cost tier. I looked on ARINVOICEHISTORYDETAIL and it appears this table pulls the cost from Std. Cost and not the tier it…
Hello,
I am still having an issue with imported product item numbers being skipped. I do not know what could be causing this as I have successfully imported 250,000+ items with the same number scenarios. Has anyone else had this issue and if so, how…
