Trucking Billing Manifest (Change Requests)

From UG

(Difference between revisions)
Jump to: navigation, search
(→Change Request Sept 9, 2011)
 
(36 intermediate revisions not shown)
Line 1: Line 1:
[[Category: Trucking Billing Manifest (M) (xls)]]
[[Category: Trucking Billing Manifest (M) (xls)]]
-
== Change Request ==
+
== Change Request March 8, 2010 ==
-
*
+
* Mantis [http://mantis.jaguarfreight.com/mantis/view.php?id=1844 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'' 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 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'''
 +
 
 +
[[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 ==
 +
 
 +
*Mantis [http://ct.jaguarfreight.com/mantis/view.php?id=2650 2650]
 +
 
 +
*change Mapping on [[Trucking_Billing_Manifest_(Developer_Guide)]]
 +
 
 +
from: [[Commodity#Grand_Total:_Gross_Kg]]
 +
 
 +
to: [[Commodity#Grand_Total:_Gross_Lb]]
 +
 
 +
=== Figure ===
 +
 
 +
[[File:Tweak.JPG]]
 +
 
 +
== Change Request July 28, 2011 ==
 +
 
 +
* 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 '''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
 +
== Change Request Sept 9, 2011 ==
 +
* Create Group Tree in order for operator to select it by group or shipment individually:
 +
[v]GRP82
 +
    [ ] 300824
 +
    [ ] 300825
 +
    .......
 +
[ ] GRP83
 +
    [v] 300876
 +
...
 +
[ ]GRPNNN
 +
* Additional output can be configurable. This can be added if needed. List of additional outputs:
 +
:* PO
 +
:* SKU
 +
:* Act Pickup
 +
:* Act Delivery
 +
* Check box to show output (visible) on the report for additional column.
 +
* Default for checkboxes: Uncheck

Current revision as of 18:50, 13 September 2011


Contents

[edit] 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!


[edit] 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

[edit] Tweak Dec 22, 2010

from: Commodity#Grand_Total:_Gross_Kg

to: Commodity#Grand_Total:_Gross_Lb

[edit] Figure

File:Tweak.JPG

[edit] Change Request July 28, 2011

  • Mantis 3110
  • Spreadsheet:Manifest Section (Section 1)
  • Spreadsheet:Manifest Section (Section 1)
    • Nothing changes

[edit] 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

[edit] Change Request Sept 9, 2011

  • Create Group Tree in order for operator to select it by group or shipment individually: 
[v]GRP82
    [ ] 300824
    [ ] 300825
    .......
[ ] GRP83
    [v] 300876
...
[ ]GRPNNN
  • Additional output can be configurable. This can be added if needed. List of additional outputs:
  • PO
  • SKU
  • Act Pickup
  • Act Delivery
  • Check box to show output (visible) on the report for additional column.
  • Default for checkboxes: Uncheck
Retrieved from "https://wiki.jaguarfreight.com/Trucking_Billing_Manifest_(Change_Requests)"