Sage MAS 90/200 Quick Tip from Zip: Crystal, blank date
If you ever need the ability to enable criteria on a Crystal Report, for dates that equal ‘blank’, a simple formula like this will do the trick: {date field} = Date (0000, 00, 00)
Posted by Brett Zimmerman.
© 2010, Brett Zimmerman. All rights reserved. Formed in 2005. the 90 Minds Consulting Group is a collaboration of 100 Sage partners who independently join together online in a 24 x 7 private communication network to solve difficult issues for their customers. The group is not affiliated with Sage and our collaboration provides for unparalleled member access to early warnings of bugs and other issues which members in turn are encouraged to use to provide an exceptional customer experience.
Brett is an ERP and Business Management Systems professional (15+ years), based in Norfolk, MA (Metro Boston), 5 minutes from Gillette Stadium - home of the New England Patriots.
Brett is a client-focused, experienced and polished hands-on professional with a versatile blend of accounting, systems and business expertise, along with a good amount of creativity and common sense. Expert level understanding of the Sage MAS 90/200 product line and related applications, including solid comprehension of integrated business management systems and accounting, as well as effectively managing and sustaining cross-functional and inter-departmental relationships with clients and prospects. Excels at performing ERP implementations, consulting, project management, report writing, import development, upgrades, training, addressing business challenges, problem-solving, needs-analyses, and proposing business solutions - while consistently maintaining client/staff retention and internal/external team moral. Impeccable organizational skills and attention to detail; exceptional presentation, verbal articulation and written proficiency standards; superb client service experience; and an absolute team player with goal-oriented personality.
Brett Zimmerman
« Sage’s MAS 90 & MAS 200 FRX Replacement is From Alchemex: To Be Branded Business Insights Intelligence | Home | MAS90 and MAS200 Product Update 4.4.01 – What’s New with Pics »
February 11, 2012
by: Wayne Schulz • 90minds, ERP
February 7, 2012
by: Wayne Schulz • 90minds
January 30, 2012
by: Wayne Schulz • Uncategorized
January 23, 2012
by: Wayne Schulz • Sage MAS 200, Sage MAS 90
January 21, 2012
by: Wayne Schulz • Giving Tree Consulting, Sage MAS 200, Sage MAS 90
January 21, 2012
by: Wayne Schulz • Sage, Sage MAS 200, Sage MAS 90
January 23, 2012
by: Wayne Schulz • Sage MAS 200, Sage MAS 90
January 21, 2012
by: Wayne Schulz • Giving Tree Consulting, Sage MAS 200, Sage MAS 90
January 21, 2012
by: Wayne Schulz • Sage, Sage MAS 200, Sage MAS 90
January 5, 2012
by: Wayne Schulz • Sage MAS 200, Sage MAS 90
December 30, 2011
by: Wayne Schulz • 90minds, Bottom Line Software, Sage MAS 200, Sage MAS 90, Schulz Consulting
December 27, 2011
by: Wayne Schulz • Quantera Systems, Sage, Sage MAS 200, Sage MAS 90
January 23, 2012
by: Wayne Schulz • Sage MAS 200, Sage MAS 90
January 21, 2012
by: Wayne Schulz • Giving Tree Consulting, Sage MAS 200, Sage MAS 90
January 21, 2012
by: Wayne Schulz • Sage, Sage MAS 200, Sage MAS 90
January 5, 2012
by: Wayne Schulz • Sage MAS 200, Sage MAS 90
December 30, 2011
by: Wayne Schulz • 90minds, Bottom Line Software, Sage MAS 200, Sage MAS 90, Schulz Consulting
December 27, 2011
by: Wayne Schulz • Quantera Systems, Sage, Sage MAS 200, Sage MAS 90
Comments
Thank Brett. Nice tip.
What uses would a formula like this have with MAS90/200 version 4.4?
Not necessarily specific to any one version of MAS 90, but let's say you're creating a Crystal Report against the IM3 Item Costing file, and you don't want to see any of the 0 costing tiers which all have a blank date. This formula would allow you to enable Selection criteria for dates not equal to blank.
Trackbacks
Leave a Comment
You must be logged in to post a comment.