Sunday, June 23, 2019

Saved Search to Show Orders Shipped on a Specific Day

1. Navigate to Reports > Saved Searches > All Saved Searches > New


2. Select Transaction link


3. Set the following under Criteria tab > Standard subtab:

         Type = Sales Order

         Formula (Numeric) || Click on formula and type the following formula;

     CASE WHEN to_char({shipdate},'DAY') like '%MONDAY%' THEN 1 ELSE (CASE WHEN to_char({shipdate},'DAY') like '%WEDNESDAY%' THEN 1 ELSE 0 end) end

     Under Formula Numeric column choose equal to 1

 

4. Under Results tab > Columns subtab, add following fields(choose other based on your preference:

         Formula (Text) || Click on formula and type the following formula

           to_char({shipdate},'DAY')

  5. Enter a Search Title

   6. Click Save & Run

 

No comments:

Post a Comment