Trucking Billing Manifest (Change Requests)

From UG

(Difference between revisions)
Jump to: navigation, search
(Change Request)
(Change Request)
Line 19: Line 19:
*** '''From'''
*** '''From'''
**** Mapping: ''Company name'' from [[Ct#Export_Pick_Up]] If there is no info on [[Ct#Export_Pick_Up]], Map [[Ct#Shipper]]  
**** Mapping: ''Company name'' from [[Ct#Export_Pick_Up]] If there is no info on [[Ct#Export_Pick_Up]], Map [[Ct#Shipper]]  
 +
**** Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet
*** '''Origin City'''
*** '''Origin City'''
**** Mapping: ''City'' from [[Ct#Export_Pick_Up]] If there is no info on [[Ct#Export_Pick_Up]], Map [[Ct#Shipper]]  
**** Mapping: ''City'' from [[Ct#Export_Pick_Up]] If there is no info on [[Ct#Export_Pick_Up]], Map [[Ct#Shipper]]  
 +
**** Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet
*** '''Origin State'''
*** '''Origin State'''
**** Mapping: ''State'' from [[Ct#Export_Pick_Up]] If there is no info on [[Ct#Export_Pick_Up]], Map [[Ct#Shipper]]  
**** Mapping: ''State'' from [[Ct#Export_Pick_Up]] If there is no info on [[Ct#Export_Pick_Up]], Map [[Ct#Shipper]]  
 +
**** Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet
*** '''To'''
*** '''To'''
**** Mapping: ''Company name'' from[[Ct#Export_Delivery_To]] If there is no info on [[Ct#Export_Delivery_To]], Map [[Ct#Consignee]]
**** Mapping: ''Company name'' from[[Ct#Export_Delivery_To]] If there is no info on [[Ct#Export_Delivery_To]], Map [[Ct#Consignee]]
 +
**** Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet
*** '''Destination City'''
*** '''Destination City'''
**** Mapping: ''City'' from [[Ct#Export_Delivery_To]] If there is no info on [[Ct#Export_Delivery_To]], Map [[Ct#Consignee]]  
**** Mapping: ''City'' from [[Ct#Export_Delivery_To]] If there is no info on [[Ct#Export_Delivery_To]], Map [[Ct#Consignee]]  
 +
**** Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet
*** '''Destination State'''
*** '''Destination State'''
**** Mapping: ''State'' from [[Ct#Export_Delivery_To]] If there is no info on [[Ct#Export_Delivery_To]], Map [[Ct#Consignee]]  
**** Mapping: ''State'' from [[Ct#Export_Delivery_To]] If there is no info on [[Ct#Export_Delivery_To]], Map [[Ct#Consignee]]  
-
*** '''P.O.''' // ContTab
+
**** Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet
 +
*** '''P.O.'''  
 +
**** Mapping: [[Commodity#PO]]
 +
*** '''SKU'''
 +
**** Mapping: [[Commodity#SKU]]
 +
* '''Origin Port'''
 +
::''City, State'' from [[CT#Export Pick Up]]
 +
::
 +
* '''Dest. Port'''
 +
::''COMPANY-CITY-NOTE'' from [[CT#Export Delivery To]]
 +
::Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet
 +
 +
* '''Actual Pick Up Date'''
 +
:: [[CT#Actual Export Pick Up Date]]
 +
:: Note: for Truck-Ocean this date is on [[Container]]; and since each [[Commodity]] line is assigned to its own container - date would be shown for every spreadsheet line for such CT
 +
 +
* '''Actual Delivery Date'''
 +
:: [[CT#Actual Delivery Date]]
 +
:: Note: for Truck-Ocean this date is on [[Container]]; and since each [[Commodity]] line is assigned to its own container - date would be shown for every spreadsheet line for such CT
 +
 +
* Sorted by: CT#
-
*** '''SKU''' // SKU, ContTab
 
-
*** '''Origin Port''' // City, State from Gen Tab 5 Export Pick up T4 // print once per CT on the first line
 
-
*** Dest. Port // "COMPANY-CITY NOTE" - 6. Export Delivery to (T5) // print once per CT on the first line
 
-
    * Actual Pick Up Date // Actual Export Pick-Up Date (mode logic) // for FCL date is per commodity item
 
-
    * Actual Delivery Date // Actual Delivery Date (mode logic) // for FCL date is per commodity item
 

Revision as of 15:23, 10 March 2010


Change Request

  • Mantis 1844
  • Template section: Add Maximum Rate under Minimum Rate
    • Maximum Rate - text box, default is 0.00
    • Addition Information
      • Maximum Rate- datatype/format: Datatypes#decimal, max=100,000;2 digits after decimal, Required: N
  • Spreadsheet:Manifest Section (Section 1)
  • Origin Port
City, State from CT#Export Pick Up
  • Dest. Port
COMPANY-CITY-NOTE from CT#Export Delivery To
Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet
  • Actual Pick Up Date
CT#Actual Export Pick Up Date
Note: for Truck-Ocean this date is on Container; and since each Commodity line is assigned to its own container - date would be shown for every spreadsheet line for such CT
  • Actual Delivery Date
CT#Actual Delivery Date
Note: for Truck-Ocean this date is on Container; and since each Commodity line is assigned to its own container - date would be shown for every spreadsheet line for such CT
  • Sorted by: CT#



  • Spreadsheet:Billing Section (Section 2)
    • Insert Maximum Rate under Minimum Rate
    • Formula for Freight Total will be:
      • IF(gross weight/100*Rate < X) THEN X
      • ELSE IF (gross weight/100*Rate > Y) THEN Y
      • ELSE Gross Weight/100*Rate



  • Bug: Reset Form Button
    • Reset Form button should clear the data and uncheck the CTs from the Shipments table. Right now it deletes all the CTs in the shipment table. This is a bug!!! It must ONLY uncheck CTs, not DELETE CTs!
Personal tools