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.
Occasionally we get an Invoice that is missing the Batch No. from when it was created via Shipping Data Entry. We have multiple batches a day, usually separated out between EDI and Non-EDI orders and/or AM vs. PM shipments; totally anywhere between 2…
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…
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?
