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.
I am trying to apply the Sage 2020.1 update. During the update, when it scans for corruption it says that PL_JournalPDFLog.M4T has an ambiguous "file discrepancy" in it. The instructions say to simply Rebuild Key Files for any discrepancies, but alas…
Has anyone run into an issue with a general journal posting that occurred months earlier now showing a different result if you were to run the report today? In January we had one entry, and if we run the report today, it shows 3 of the same entry. For…
Hi All,
Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script.
I right clicked on the…
Version: Sage 100cloud Premium 2020 (Version 6.20.0.01)
Additional software: Scanco Operations Management & Multi-bin, Some custom DSD programming
Hello all! First post here. Looking for some assistance when it comes to replicating data for reporting…
Hello All,
We are using SAGE 100. Somehow On PO qty coming in Stock status report is not Open PO Qty.
SAGE is pulling a open PO qty from somewhere - SAGE ppl kindly share your thoughts
In the below example, in main I m seeing a open PO qty but in…
Hello,
We had something strange happen once last week, and now once again today.
We had an order which was not acceessible through Sales Order and Quote History, so accounting contacted me. After checking our database, I noticed that there was no…
Hello,
We have been trying to troubleshoot our slow performance with SAGE 100 PREMIUM 2018 and are running out of options. I have read all the articles here and on the knowledge-base, and nothing seems to be improving our performance. My last inquiry…
Hello,
Our company MAS system has been running very slowly and I would like to delete some records form our database. There does not seem to be information on certain tables inside of SAGE under File Layouts and Program Information. Specifically, I…
Hello,
I am trying to do a SQL query to see which users have had activity on a specific company ABC by doing a SQL query on the SY_ActivityLog table.
When I do a query where CompanyCode = 'ABC', I get MOST of the users that have had activity on ABC…
I recently found a discrepancy in values between the quantities tab and the cost detail tab within Item inquiry on a few items.
After researching in the Knowledge Base, I came across the following steps to clear out the issue:
Update all transactions…
Sage 100 Version 5.20
Crystal 2011 for Sage
Window server 2012 R2
Ok, here is an odd one. We had been having incorrect data running a Inventory List via Crystal. We have a total of 600 items. When I add a filter for Category 2 data I am getting…
Last night I was doing some maintenance on one of our warehouse (zeroing out product), and noticed a problem I'm not quite sure how to solve for.
I found that we have an item in our SQL database (Running Sage 2014 premium) that says we have .014400…
We're currently on Sage 100 2014 (Non SQL) and we're currently running into the issues where we are being sent names containing certain ranges of extended ascii characters.
For now, we are going to limit ourselves to the first 127 in the ascii table…
Have an issue with what I believe is a corrupted date value. It resides in purchase order detail required date and PO header PO date.
Running the open order report on "required expire date" for date greater than 12/30 will result in "Vendor Code 9"…
Once every 1-2 weeks I rebuild all sort files and am wondering if I should also be rebuilding the key files? Is there any risk/downside to rebuilding the key files? Also, when I am running the utility do I want Integrity Check and Optimize File checked…
