Trucking Billing Manifest (Change Requests)

From UG

(Difference between revisions)
Jump to: navigation, search
(Change Request)
(Change Request)
Line 15: Line 15:
*** '''CT#'''  
*** '''CT#'''  
**** Mapping: [[Ct#CT_Num]]
**** Mapping: [[Ct#CT_Num]]
 +
*** '''From'''
 +
**** Mapping: Company name from [[Ct#Export_Pick_Up]] If there is no info on [[Ct#Export_Pick_Up]], Map [[Ct#Shipper]]
 +
*** '''Origin City'''
 +
**** Mapping: ''City'' from [[Ct#Export_Pick_Up]] If there is no info on [[Ct#Export_Pick_Up]], Map [[Ct#Shipper]]
 +
*** '''Origin State'''
 +
**** Mapping: ''State'' from [[Ct#Export_Pick_Up]] If there is no info on [[Ct#Export_Pick_Up]], Map [[Ct#Shipper]]
 +
*** '''To'''
 +
**** Mapping: [[Ct#Export_Delivery_To]] If there is no info on [[Ct#Export_Delivery_To]], Map [[Ct#Consignee]] ONLY '''the company name'''
 +
*** '''Destination City'''
 +
**** Mapping: ''City'' from [[Ct#Export_Delivery_To]] If there is no info on [[Ct#Export_Delivery_To]], Map [[Ct#Consignee]]
 +
*** '''Destination State'''
 +
**** Mapping: ''State'' from [[Ct#Export_Delivery_To]] If there is no info on [[Ct#Export_Delivery_To]], Map [[Ct#Consignee]]
 +
-
*** From // Gen Tab 2. Shipper T1
 
     * P.O. // ContTab
     * P.O. // ContTab
     * Item // SKU, ContTab
     * Item // SKU, ContTab

Revision as of 23:53, 9 March 2010


Change Request


   * P.O. // ContTab
   * Item // 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 


  • 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