Previous Day Collection
From UG
(Difference between revisions)
(Created page with 'Category:OpsReps == Business needs and Requirements == == Introduction == ==') |
(→m1009) |
||
(12 intermediate revisions not shown) | |||
Line 1: | Line 1: | ||
+ | |||
[[Category:OpsReps]] | [[Category:OpsReps]] | ||
+ | |||
+ | == Mantis == | ||
+ | [http://mantis.jaguarfreight.com/mantis/view.php?id=1589 1589] | ||
== Business needs and Requirements == | == Business needs and Requirements == | ||
+ | This report is generated shipment(s) that is confirmed for picked-up date since the last report created. | ||
== Introduction == | == Introduction == | ||
+ | * This report is a report that is searched for the shipment(s) since the last created(previous) report that the ACTUAL PICKED UP DATE(S) were set or not empty. | ||
+ | * Report is a re-occuring report depend upon admin user set for when and time and days to create and send report (since the previous report (meaning, same CT number will only show on 1 report (unless a change is made)) | ||
+ | * Report is based on Client Company (E0.Client) | ||
+ | * This report can be managed through the saved and Scheduled report for class report dropdown and set the satisfied filters | ||
+ | * Report show date time stamp and how many records are found (number) and Mode of transportation | ||
+ | |||
+ | == Filters == | ||
+ | * Client Companies (E0 Client) | ||
+ | * Shippers: | ||
+ | * Consignees: | ||
+ | * Origin Countries: | ||
+ | * Destination Countries: | ||
+ | * Origin Regions: | ||
+ | * Destination Regions: | ||
+ | * Transport Mode: | ||
+ | * Client Mode:(GenTab 13. Client Mode) | ||
+ | * Export Pick Up Trucker (GenTab 8. Export Pick-up Trucker (V3)) | ||
+ | * Delivery Trucker:(V3) (ImpTab b. Delivery Trucker:(V3)) | ||
+ | |||
+ | == Output == | ||
+ | * Create output tab with list of output headings | ||
+ | * Some headings should be defaulted on the combo box and the rest of headings are in the dropdown filter output list | ||
+ | * List of headings | ||
+ | ** CT# with link ->''defaulted on the combo box'' | ||
+ | ** Customer References# (GenTab C.Customer Ref) | ||
+ | ** Transport Modes (GenTab F. Mode of Transport:) | ||
+ | ** Shippers (GenTab 2.Shipper) ->''defaulted on the combo box'' | ||
+ | ** Consignees (GenTab 3.Consignee) ->''defaulted on the combo box'' | ||
+ | ** Origin Countries (GenTab 11. Origin country) -> ''defaulted on the combo box'' | ||
+ | ** Destination Countries (GenTab 12. Destination country) -> ''defaulted on the combo box'' | ||
+ | ** Estimated Picked Up Date -> ''defaulted on the combo box'' | ||
+ | ** Actual Picked Up Date -> ''defaulted on the combo box'' | ||
+ | ** Estimated Delivery Date | ||
+ | ** Actual Delivery Date | ||
+ | ** P.O (ContTab Table A.)->''defaulted on the combo box'' | ||
+ | ** SKU (ContTab Table A.) | ||
+ | ** Quantity (ContTab Table A.) | ||
+ | ** Item Description (ContTab Table A.) | ||
+ | ** Ttl # of plts (ContTab Table A.) | ||
+ | ** Ttl pkgs on pkgs (ContTab Table A.) | ||
+ | ** Loose pkgs (ContTab Table A.) | ||
+ | ** Ttl G kg (ContTab Table A.) | ||
+ | ** ''Custom fields'' (if E0 client has "custom fields" that is/are set in admin mode, these should be available list as well) | ||
+ | ** Total CBM (ContTab Table B.) | ||
+ | ** Last Comment entry (ComTab>most recent comment) ->''defaulted on the combo box'' | ||
+ | |||
+ | == History == | ||
+ | |||
+ | === m1009 === | ||
+ | |||
+ | * Add Virtual_Group_Classifiers as filters | ||
+ | ** see [[Virtual_Groups_for_NATP#Complete_List_of_Virtual_Group_Classifiers]] | ||
+ | ** pls note that some classifiers might be already on the filter list for this report | ||
+ | ** highlight in some way Virtual_Group_Classifiers (make lables bold or different color and pre-fix label with '''(VG)''' ) | ||
+ | |||
+ | * add output: | ||
+ | ** [[CT#Export Pick Up Trucker]] | ||
+ | ** Delivery Trucker | ||
+ | ** [[CT#Export Pick Up Address]] | ||
+ | ** [[CT#Export Delivery To Address]] | ||
+ | ** [[CT#PT Number]] | ||
+ | |||
- | + | * spec updated? No |
Current revision as of 03:11, 12 April 2010
Contents |
[edit] Mantis
[edit] Business needs and Requirements
This report is generated shipment(s) that is confirmed for picked-up date since the last report created.
[edit] Introduction
- This report is a report that is searched for the shipment(s) since the last created(previous) report that the ACTUAL PICKED UP DATE(S) were set or not empty.
- Report is a re-occuring report depend upon admin user set for when and time and days to create and send report (since the previous report (meaning, same CT number will only show on 1 report (unless a change is made))
- Report is based on Client Company (E0.Client)
- This report can be managed through the saved and Scheduled report for class report dropdown and set the satisfied filters
- Report show date time stamp and how many records are found (number) and Mode of transportation
[edit] Filters
- Client Companies (E0 Client)
- Shippers:
- Consignees:
- Origin Countries:
- Destination Countries:
- Origin Regions:
- Destination Regions:
- Transport Mode:
- Client Mode:(GenTab 13. Client Mode)
- Export Pick Up Trucker (GenTab 8. Export Pick-up Trucker (V3))
- Delivery Trucker:(V3) (ImpTab b. Delivery Trucker:(V3))
[edit] Output
- Create output tab with list of output headings
- Some headings should be defaulted on the combo box and the rest of headings are in the dropdown filter output list
- List of headings
- CT# with link ->defaulted on the combo box
- Customer References# (GenTab C.Customer Ref)
- Transport Modes (GenTab F. Mode of Transport:)
- Shippers (GenTab 2.Shipper) ->defaulted on the combo box
- Consignees (GenTab 3.Consignee) ->defaulted on the combo box
- Origin Countries (GenTab 11. Origin country) -> defaulted on the combo box
- Destination Countries (GenTab 12. Destination country) -> defaulted on the combo box
- Estimated Picked Up Date -> defaulted on the combo box
- Actual Picked Up Date -> defaulted on the combo box
- Estimated Delivery Date
- Actual Delivery Date
- P.O (ContTab Table A.)->defaulted on the combo box
- SKU (ContTab Table A.)
- Quantity (ContTab Table A.)
- Item Description (ContTab Table A.)
- Ttl # of plts (ContTab Table A.)
- Ttl pkgs on pkgs (ContTab Table A.)
- Loose pkgs (ContTab Table A.)
- Ttl G kg (ContTab Table A.)
- Custom fields (if E0 client has "custom fields" that is/are set in admin mode, these should be available list as well)
- Total CBM (ContTab Table B.)
- Last Comment entry (ComTab>most recent comment) ->defaulted on the combo box
[edit] History
[edit] m1009
- Add Virtual_Group_Classifiers as filters
- see Virtual_Groups_for_NATP#Complete_List_of_Virtual_Group_Classifiers
- pls note that some classifiers might be already on the filter list for this report
- highlight in some way Virtual_Group_Classifiers (make lables bold or different color and pre-fix label with (VG) )
- add output:
- spec updated? No