Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Sage MAS Partner
BirdDog
Posts: 41
Registered: 01-05-2009
0

Modifying selection formula on standard MAS 90 report

Is it possible to modify the selection formula on a standard MAS 90 report?  For example, my client ran the Customer Sales Analysis out of the Accounts Receivable module with the following criteria:  YTD Sales > $1.00, PYTD Sales > $1.00.  The report returned only those customers for which both of these criteria were true.  What my client really wanted was YTD Sales > $1.00 OR PYTD Sales > $1.00.  Can that be done with the standard Customer Sales Analysis report?  If so, how?

 

BTW, my client is using MAS 90 4.4 so the report is written in Crystal Reports.

 

Brad Prather, CPA
DWD Technology Group
"You've got to stand for something or you'll fall for anything."
Regular Contributor
Gator
Posts: 272
Registered: 12-05-2008
0

Re: Modifying selection formula on standard MAS 90 report

Instead of using the main screen to select the greater than $1, edit the crystal report and make the record selection criteria be:

 

{AR_CustomerSalesAnalysisWrk.DollarsSoldYTD}>1 or {AR_CustomerSalesAnalysisWrk.DollarsSoldPY}>1

 

If the dollar amount needs to be variable, then make parameters for the amounts for the user to input.