Trucking Billing Manifest (Change Requests)

From UG

Revision as of 15:03, 6 September 2011

Change Request March 8, 2010

• 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
  • Fuel- textbox,update: default value is 0.0000 (4 decimal places)
• 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 Ct#Export_Pick_Up is empty THEN Map Ct#Shipper
      • Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet
    • Origin City
      • Mapping: City from Ct#Export_Pick_Up If Ct#Export_Pick_Up is empty THEN Map Ct#Shipper
      • Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet
    • Origin State
      • Mapping: State from Ct#Export_Pick_Up If Ct#Export_Pick_Up is empty THEN Map Ct#Shipper
      • Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet
    • To
      • Mapping: Company name fromCt#Export_Delivery_To If Ct#Export_Delivery_To is empty THEN Map Ct#Consignee
      • Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet
    • Destination City
      • Mapping: City from Ct#Export_Delivery_To If Ct#Export_Delivery_To is empty THEN Map Ct#Consignee
      • Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet
    • Destination State
      • Mapping: State from Ct#Export_Delivery_To If Ct#Export_Delivery_To is empty THEN Map Ct#Consignee
      • 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
    • Actual Pick Up Date
      • Mapping: 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
      • Mapping: 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)
  • See Example on Figure 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

• ! Please note that generated spreadsheet must contain formulas so that if number is changed by user it will re-calculate!

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

Figures

Figure 1. Trucking Billing Manifest Spreadsheet Section 1

Figure 2. Trucking Billing Manifest Spreadsheet Section 2

Approval

• By: Marc
• Update the change to the original Spec: No

Tweak Dec 22, 2010

• Mantis 2650

• change Mapping on Trucking_Billing_Manifest_(Developer_Guide)

from: Commodity#Grand_Total:_Gross_Kg

to: Commodity#Grand_Total:_Gross_Lb

Figure

Change Request July 28, 2011

• Mantis 3110
• Spreadsheet:Manifest Section (Section 1)
  • Vertically - Columns to be added:
    • Load Number
      • Mapping: CT_bo#Load_Number
    • Origin Zip
      • Mapping: Zip from Ct#Export_Pick_Up If Ct#Export_Pick_Up is empty THEN Map Ct#Shipper
      • Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet
    • Origin Country
      • Mapping: Country from Ct#Export_Pick_Up If Ct#Export_Pick_Up is empty THEN Map Ct#Shipper
      • Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet
    • Destination Zip
      • Mapping: Zip from Ct#Export_Delivery_To If Ct#Export_Delivery_To is empty THEN Map Ct#Consignee
      • Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet
    • Destination Country
      • Mapping: Country from Ct#Export_Delivery_To If Ct#Export_Delivery_To is empty THEN Map Ct#Consignee
      • Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet
  • Vertically - Columns to be check box options, default value = unchecked: Change Made by Denise 10-Aug
    • P.O.
      • Mapping: Commodity#PO
    • SKU
      • Mapping: Commodity#SKU
    • Actual Pick Up Date
      • Mapping: 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
      • Mapping: 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
    • Group by: Load Number
    • Sorted by: CT#
• Spreadsheet:Manifest Section (Section 1)
  • Nothing changes

Change Request Aug 22, 2011

• Location of columns
  • CT#
  • Load#
  • From
  • Ttl Plts
  • Ttl Pkgs
  • Ttl Loose
  • Gross Weight with sum up
  • Rate
  • Freight Total with sum up
  • Fuel
  • Fuel Total with sum up
  • Total with sum up
  • Origin City
  • Origin State
  • Origin Zip
  • Origin Country
  • To
  • Dest City
  • Dest State
  • Dest Zip
  • Destination Country