Trucking Billing Manifest (Change Requests)
From UG
(Difference between revisions)
(→Change Request) |
(→Change Request) |
||
| Line 6: | Line 6: | ||
* 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 | ||
| - | * Spreadsheet:Billing Section | + | * 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 // Gen Tab 2. Shipper T1 | ||
| + | * P.O. // ContTab | ||
| + | * Item // SKU, ContTab | ||
| + | * Origin Port // City, State from Gen Tab 5 Export Pick up T4 // print once per CT on the first line | ||
| + | * Dest. Port // "COMPANY-CITY NOTE" - 6. Export Delivery to (T5) // print once per CT on the first line | ||
| + | * Actual Pick Up Date // Actual Export Pick-Up Date (mode logic) // for FCL date is per commodity item | ||
| + | * Actual Delivery Date // Actual Delivery Date (mode logic) // for FCL date is per commodity item | ||
| + | |||
| + | |||
| + | * Spreadsheet:Billing Section (Section 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 17: | Line 37: | ||
* 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 | + | ** 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! |
Revision as of 23:20, 9 March 2010
Change Request
- Mantis 1844
- Template section: Add Maximum Rate under Minimum Rate
- Maximum Rate - text box, default is 0.00
- 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
- CT#
- From // Gen Tab 2. Shipper T1
* P.O. // ContTab * Item // SKU, ContTab * Origin Port // City, State from Gen Tab 5 Export Pick up T4 // print once per CT on the first line * Dest. Port // "COMPANY-CITY NOTE" - 6. Export Delivery to (T5) // print once per CT on the first line * Actual Pick Up Date // Actual Export Pick-Up Date (mode logic) // for FCL date is per commodity item * Actual Delivery Date // Actual Delivery Date (mode logic) // for FCL date is per commodity item
- Spreadsheet:Billing Section (Section 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
- 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!
