Where Is Report

From UG

(Difference between revisions)

Jump to: navigation, search

Revision as of 14:53, 6 July 2010

Info

Parent Mantis - 1587

BR: Business Requirements

Need to add text box for Steamship Lines Booking #
For Container #, need option to search the last digit by typing * instead of typing any number between 0-9
Need search feature to ignore upper/lower case letters when searching by a PO # of Item Code (aka SKU #)

SD: Systems Design

Summary

Where Is Report is one of core reports of CT2. It provides the ability to search and display shipments, which comply to user-defined conditions.

All needed User Defined Conditions (these are also called filters) could be set in the Filters section on the template of the Report.
Where Is Report NOT uses any Hard Coded Conditions.

Interface

Report is available right from the Main Menu of CT2. See Figure 0.

In order to generate report user have to:

configure User Defined Conditions in the Filters section on the template (see Figure 1) and
click appropriate button for needed action

Filters

Result of the Report that will be showed to user depends of the values of the following Filters (in that order of locating on the template):

P.O. contains:. Mapping to ...
SKU contains:. Mapping to ...
Export Ref # contains:. Mapping to ...
Import Ref # contains:. Mapping to ...
Customer Ref # contains:. Mapping to ...
Jaguar 3rd Ref # contains:. Mapping to ...
Shippers:. Mapping to ...
Consignees:. Mapping to ...
Container #s:. Mapping to ...
Master Airway Bills:. Mapping to ...
Departure Date: A pair of "from" and "to" databoxes. Mapping to ...
Arrival Date: A pair of "from" and "to" databoxes. Mapping to ...
From Countries:. Mapping to ...
To Countries:. Mapping to ...

NOTES:

At least one Filter should be not empty. Otherwise, System shows the error message "You have not set any filter" and doesn't generate the Report.
Every filter connected by AND and selections inside filter are connected by OR.
- Example: ...
All Filters (except Date Filters) are multiselect. It means ...
Empty Filters don't affect on the result of the Report. It means ...

Action controls

Generate Result button:

to generate report

Reset Form button:

to clear form

Output

Columns

Figures

Figure 0: Main Menu item

Figure 1: Where Is Report Filters

History

m2045

2045

BA

Need to add text box for the Steamship Lines Booking # which is found on the export tab under field # 6
current revision

SA

Add a filter: Steamship Lines Booking #

Steamship Lines Booking #

Label: Steamship Lines Booking # contains:
Widget: textbox , can be multiple selected
Location: After Master Airway Bills:
This field can be found on the ocean > export tab under field # 6

NOTE: this field is applied to Ocean shipments ONLY

m1875

1875

BA

We need the option to search the last digit of the container # by typing * instead of typing any number between 0-9
- See Example on how to search by using * symbol

See Results from the search by using the * symbol

SA

Add logic for * symbol in order to search the all digit from 0-9 possibilities
current revision

m2068

2068

BA

When searching for a PO # of Item Code (aka SKU #) we need the search feature to ignore upper/lower case letters

Closed m2068; cannot replicate. Please ignore this request.

Final version: http://mantis.jaguarfreight.com/mediawiki-1.15.0/index.php?title=Where_Is_Report&oldid=10773

SA

#SD: Systems Design

@@ Line 19: / Line 19: @@
 In order to generate report user have to:
-* configure User Defined Conditions in the Filters section on the template and
+* configure User Defined Conditions in the Filters section on the template (see [[#Figure 1: Where Is Report Filters | Figure 1]]) and
 * click appropriate button for needed action