Hi,

I would like to use a method on a report to get total (sum) of qty ordered
and invoice amount from CustInvoiceTrans based on ItemNumber.
I can get this to work YTD based on Day-Month- of Current Year to Report
date.

The problem is I need to base this on June 1 to June 1 calendar not from
beginning of the year. I need the method to look at the SystemDate
and if the SystemDate is before June 1 to base the YTD total on June 1 from
previous year to report date. If the SystemDate is after June 1
I need to base YTD on June 1 of current year to report date.

Any tips would be greatly appreciated.

Thanks,

David




Yahoo! Groups Sponsor
ADVERTISEMENT
click here


Yahoo! Groups Links

Reply via email to