I have a booking report that currently compares YTD booking with Prior YTD Booking. The complete selection formula is as follows and is working without problems.
{oeel1.custno} <> 100052.00 and
({oeel1.enterdt} in LastYearYTD or
{oeel1.enterdt} in YearToDate) and
{oeeh1.transtype} in ["CR", "DO", "RM", "SO"] and
{oeeh1.cono} = 1 and
({oeeh1.stagecd} in [1,9] or ({oeeh1.stagecd} in [ 2, 3, 4, 5] and {oeel1.qtyship} > 0)) and
{sasta1.codeiden} in ["c"]
So this selection grabs all records from 01/01/last year to today's date and
from 01/01/Current year. This of course is obvious to all of you but it will help me explain the next selection.
I have been asked to make an adjustment to include orders entered prior to 01/01/last year but were invoiced last year. So I created this selection independent of the the first selection.
{sasta1.codeiden} in ["c"] and
{oeel1.custno} <> 100052.00 and
{oeel1.enterdt} > (Date(Year(CurrentDate)-2, 1, 1)) and
{oeel1.enterdt} < (Date(Year(CurrentDate)-2, 12, 31)) and
{oeeh1.transtype} in ["CR", "DO", "RM", "SO"] and
{oeeh1.cono} = 1 and
({oeeh1.stagecd} in [1,9] or ({oeeh1.stagecd} in [ 2, 3, 4, 5] and {oeel1.qtyship} > 0)) and
{oeel1.invoicedt} > (Date(Year(CurrentDate)-1, 1, 1))
This seems to work on its own as well. My problem is when I try to combine the formulas it bombs out.
Sorry this probably is a simple solution but i am just learning.
{oeel1.custno} <> 100052.00 and
({oeel1.enterdt} in LastYearYTD or
{oeel1.enterdt} in YearToDate) and
{oeeh1.transtype} in ["CR", "DO", "RM", "SO"] and
{oeeh1.cono} = 1 and
({oeeh1.stagecd} in [1,9] or ({oeeh1.stagecd} in [ 2, 3, 4, 5] and {oeel1.qtyship} > 0)) and
{sasta1.codeiden} in ["c"]
So this selection grabs all records from 01/01/last year to today's date and
from 01/01/Current year. This of course is obvious to all of you but it will help me explain the next selection.
I have been asked to make an adjustment to include orders entered prior to 01/01/last year but were invoiced last year. So I created this selection independent of the the first selection.
{sasta1.codeiden} in ["c"] and
{oeel1.custno} <> 100052.00 and
{oeel1.enterdt} > (Date(Year(CurrentDate)-2, 1, 1)) and
{oeel1.enterdt} < (Date(Year(CurrentDate)-2, 12, 31)) and
{oeeh1.transtype} in ["CR", "DO", "RM", "SO"] and
{oeeh1.cono} = 1 and
({oeeh1.stagecd} in [1,9] or ({oeeh1.stagecd} in [ 2, 3, 4, 5] and {oeel1.qtyship} > 0)) and
{oeel1.invoicedt} > (Date(Year(CurrentDate)-1, 1, 1))
This seems to work on its own as well. My problem is when I try to combine the formulas it bombs out.
Sorry this probably is a simple solution but i am just learning.