Trucking Billing Manifest (Change Requests)

From UG

(Difference between revisions)
Jump to: navigation, search
(Change Request July 28, 2011)
(Change Request Aug 22, 2011)
Line 151: Line 151:
** Dest Zip
** Dest Zip
** Destination Country
** 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

Revision as of 18:23, 13 September 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, 2011

  • Mantis 3110
  • Spreadsheet:Manifest Section (Section 1)
  • 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
Personal tools