Trucking Billing Manifest (Change Requests)

From UG

Revision as of 23:20, 9 March 2010 (edit) Montira (Talk | contribs) (→Change Request) ← Older edit		Revision as of 23:53, 9 March 2010 (edit) (undo) Montira (Talk | contribs) (→Change Request) Newer edit →
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

• Mantis 1844
• Template section: Add Maximum Rate under Minimum Rate
  • Maximum Rate - text box, default is 0.00
• Spreadsheet:Manifest Section (Section 1)
  • See Example on Figure 1.
  • This is a table
  • Horizontally:
    • It consists of as many sections as there are CTs (originally selected by user)
    • Each CT section has as many lines as there are in commod table for this CT
  • Vertically it has a number of columns:
    • CT#
      • 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

   * 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!