Trucking Billing Manifest (Change Requests)
From UG
(Difference between revisions)
(→Change Request) |
(→Change Request Sept 9, 2011) |
||
(33 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] | * Mantis [http://mantis.jaguarfreight.com/mantis/view.php?id=1844 1844] | ||
* Template section: Add Maximum Rate under Minimum Rate | * Template section: Add Maximum Rate under Minimum Rate | ||
** '''Maximum Rate''' - text box, default is 0.00 | ** '''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:Manifest Section (Section 1) | ||
** See Example on Figure 1. | ** See Example on Figure 1. | ||
Line 15: | Line 18: | ||
*** '''CT#''' | *** '''CT#''' | ||
**** Mapping: [[Ct#CT_Num]] | **** Mapping: [[Ct#CT_Num]] | ||
- | + | *** '''From''' | |
- | + | **** Mapping: ''Company name'' from [[Ct#Export_Pick_Up]] If [[Ct#Export_Pick_Up]] is empty THEN Map [[Ct#Shipper]] | |
- | *** From | + | **** 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) | * Spreadsheet:Billing Section (Section 2) | ||
+ | ** See Example on Figure 2. | ||
** Insert Maximum Rate under Minimum Rate | ** Insert Maximum Rate under Minimum Rate | ||
** Formula for Freight Total will be: | ** Formula for Freight Total will be: | ||
Line 33: | Line 56: | ||
*** ELSE ''Gross Weight''/100*Rate | *** 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 | * 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! | ** 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)
- 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#
- 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!
[edit] 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
[edit] 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
[edit] Figure
[edit] 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
- Load Number
- 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#
- P.O.
- Vertically - Columns to be added:
- 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