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.
Hi,
I want to read and write data in sage100 database, so after some research I found out this course for reference.
But just need to validate that is this course really guides on how to read and write back data to Sage100 database or not?
This…
Hi,
I am new to Sage100 and customer is using Sage100 advanced which comes with ProvideX ODBC driver which only allows to read data from Sage100.
I did some research on the functionality to write back the data in Sage100 but was not able to find any…
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,
I'm working on a project and I need to be able to pull the same information the "Invoice History Printing" report pulls for a date. For my selected date, in our database we have about 3,000 invoices. The report, however, only pulls about 140…
For some reporting purposes I need to normalize the bill of materials exactly how it shows in the BM_SummarizedReportWRK report into a SQL table. How do I do this? I've been attempting to backwards engineer from the regular and accessible Bill Of Materials…
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…
Merged over 3,300 items to code "Z_Discontinued" after months of working with staff to make sure all items on list were approved for merging.
Now they need 2 of the 3,300 items restored, historical data. I created the original item numbers and setup…
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?