Sage 100

On a Sage 100 2014 Premium (SQL) the GL General Journal Crystal Report is displaying 1/1/1753 for the Reversing Date when there is no Reversing Date because that is the value SQL uses for a Null (no date). Does anyone know the formula for how to suppress that date from displaying for that filed when the Reversing date is blank / null / 1/1/1753 in SQL on the GL Journal?

Go to the Suppress if field, use this: isnull({AR_SalespersonCommission.PayDate}) or {AR_SalespersonCommission.PayDate} = #01/01/1753#

thanks Erin! I came up with a similar formula using a date function.

In the 'give him an inch and he'll ask for a mile' school of thought, does anyone know of how to make this 1/1/1753 date show up as a blank or something that won't upset the clients in Business Insights Explorer?

Did you find a solution to suppress the date in business insights explorer?

------------------------------
Shannon Stanley
Sage 100 Consultant
Ardent Consulting LLC
704-839-6697
------------------------------

Original Message:
Sent: 09-17-2014 13:29
From: Cullen Lowe
Subject: On a Sage 100 2014 Premium (SQL) the GL General Jo

In the 'give him an inch and he'll ask for a mile' school of thought, does anyone know of how to make this 1/1/1753 date show up as a blank or something that won't upset the clients in Business Insights Explorer?

I opened a case with Sage about this very issue last year with a 2013 SQL install. Support said they could not replicate, so I resorted to suppression formulas in Crystal as well...

The case I opened with Sage last week was just closed. They said it is a WAD, so at least they now know how to reproduce it. Just to make sure I'm not missing anything, when you are talking about a formula in Crystal this is not something you can port into Business Insights Explorer, is it?

I wonder what version of SQL theses clients are running and if that's why Sage can't replicate the issue? 1/1/1753 is a break point date between Julian and Gregorian calendar systems. Wad? @CullenLowe the next time they say that you can point them to this link and let them know about Philip Stanhope, 4th Earl of Chesterfield. http://stackoverflow.com/questions/3310569/what-is-the-significance-of-1-1-1753-in-sql-server

Thanks @MoiraGoggin, they actually sent me that same article.