Trucking Billing Manifest (Change Requests)

From UG

(Difference between revisions)
Jump to: navigation, search
(Change Request Dec 22, 2010)
Line 93: Line 93:
[[File:Tweak.JPG]]
[[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#

Revision as of 20:44, 28 July 2011


Contents

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

File:TruckingBillingManifestForMasterSection1.JPG


Figure 2. Trucking Billing Manifest Spreadsheet Section 2

File:TruckingBillingManifestForMasterSection2.JPG


Approval

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


Tweak Dec 22, 2010

from: Commodity#Grand_Total:_Gross_Kg

to: Commodity#Grand_Total:_Gross_Lb

Figure

File:Tweak.JPG

Change Request July 28, 2010

Personal tools