x Want to participate? Join the group to interact

Sage 100

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.

Technical and Installation

Need help getting "Invoice History Printing" data in SQL database.

Surya IT

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…
- over 4 years ago
- Sage 100
- Technical and Installation
Datetime fields ALL no longer allow nulls

cjbuechler

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…
- Answered
- over 7 years ago
- Sage 100
- Technical and Installation
How to enter search criteria for Blank Fields

Lan Support

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?
- over 8 years ago
- Sage 100
- Technical and Installation