Previous Day Delivery

From UG

(Difference between revisions)
Jump to: navigation, search
(Created page with 'Category:OpsReps == Business needs and Requirements == This report is generated shipment(s) that is confirmed for delivery date since the last report created. == Introducti…')
(History)
 
(8 intermediate revisions not shown)
Line 1: Line 1:
 +
[[Category:OpsReps]]
[[Category:OpsReps]]
 +
 +
== Mantis ==
 +
[http://mantis.jaguarfreight.com/mantis/view.php?id=1588 1588]
== Business needs and Requirements ==
== Business needs and Requirements ==
Line 35: Line 39:
** Origin Countries (GenTab 11. Origin country) -> ''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''
** Destination Countries (GenTab 12. Destination country) -> ''defaulted on the combo box''
-
** Estimated Picked Up Date -> ''defaulted on the combo box''
+
** Estimated Picked Up Date
-
** Actual Picked Up Date -> ''defaulted on the combo box''
+
** Actual Picked Up Date
-
** Estimated Delivery Date
+
** Estimated Delivery Date -> ''defaulted on the combo box''  
-
** Actual Delivery Date
+
** Actual Delivery Date -> ''defaulted on the combo box''
** P.O (ContTab Table A.)->''defaulted on the combo box''
** P.O (ContTab Table A.)->''defaulted on the combo box''
** SKU (ContTab Table A.)
** SKU (ContTab Table A.)
Line 50: Line 54:
** Total CBM (ContTab Table B.)
** Total CBM (ContTab Table B.)
** Last Comment entry (ComTab>most recent comment) ->''defaulted on the combo box''
** Last Comment entry (ComTab>most recent comment) ->''defaulted on the combo box''
 +
[[Media:Example.ogg]]
 +
 +
== History ==
 +
 +
=== m1913 ===
 +
 +
* 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#DT Number]]

Current revision as of 03:05, 12 April 2010


Contents

[edit] Mantis

1588

[edit] Business needs and Requirements

This report is generated shipment(s) that is confirmed for delivery 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 DELIVERY DATE(S) were set or not empty.
  • Report is a re-occurring 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
    • Actual Picked Up Date
    • Estimated Delivery Date -> defaulted on the combo box
    • Actual Delivery Date -> defaulted on the combo box
    • 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

Media:Example.ogg

[edit] History

[edit] m1913

Personal tools