Previous Day Collection

From UG

Current revision as of 03:11, 12 April 2010

[edit] Mantis

1589

[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:
  • CT#Export Pick Up Trucker
  • Delivery Trucker
  • CT#Export Pick Up Address
  • CT#Export Delivery To Address
  • CT#PT Number

• spec updated? No