Sage 100

Trying to create a Crystal formula field using the email address from sy_company table in MAS_System folder. As a point of reference, I am copied the CompanyURL formula which is formula = """". The name of my formula field is CompanyEmailAddress. However, this bit of creative genius is not providing the results I hoped for. Is it possible to create a formula field for the company e-mail address>

Jeff , never done it but I'm sure it is. leaving your formula blank won't work though. Make it formula = {CompanyEmailAddress}

Oh, and you'll have to add the company file, I assume the other fields that Sage provides are automatically filled at runtime.

So you saying that I can't reverse engineer the Sage secret sauce?? So much for consistency....

I gotta say, that was a great try though!

thanks, unfortunately not a value priced action.

@JeffSchwenk -- Having worked intimately under the covers with these crystal reports & formulas, I can tell you firsthand that the formulas we see as formula="""" are always intended to be defined at runtime, part of the code in the selection screen fills these in and voila' we actually have something useful at runtime

A list of a lot of those values passed over automatically are here: http://community.90minds.com/2011/05/27/add-user-name-to-mas90-custom-report/ Those only work when you run it from inside Sage 100.