Trucking Billing Manifest (Change Requests)

From UG

(Difference between revisions)

Jump to: navigation, search

Revision as of 20:44, 28 July 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, 2010

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 removed:
  - 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#

@@ Line 93: / Line 93: @@
 [[File:Tweak.JPG]]
+== Change Request July 28, 2010 ==
+* Mantis [http://ct.jaguarfreight.com/mantis/view.php?id=3110 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 '''removed''':
+*** '''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#

Trucking Billing Manifest (Change Requests)

From UG

Revision as of 20:44, 28 July 2011

Contents

Change Request March 8, 2010

Figures

Tweak Dec 22, 2010

Figure

Change Request July 28, 2010

Views

Personal tools

Navigation

Toolbox

Search