Trucking Billing Manifest
From UG
(Difference between revisions)
(→Suggested Design) |
|||
| Line 1: | Line 1: | ||
[[Category:OpsPdfsTruck]] | [[Category:OpsPdfsTruck]] | ||
[[File:Select_CTs_from_Groups.JPG|thumb|400px|File:Select_CTs_from_Groups.JPG]] | [[File:Select_CTs_from_Groups.JPG|thumb|400px|File:Select_CTs_from_Groups.JPG]] | ||
| + | |||
== Business Requirements == | == Business Requirements == | ||
* Operators need xls spreadsheet for Trucking MOT that has: | * Operators need xls spreadsheet for Trucking MOT that has: | ||
| Line 14: | Line 15: | ||
[[File:Trucking_Billing_Manifest_Template.JPG|thumb|500px|Trucking_Billing_Manifest_Template.JPG]] | [[File:Trucking_Billing_Manifest_Template.JPG|thumb|500px|Trucking_Billing_Manifest_Template.JPG]] | ||
| - | === | + | |
| + | === Select Groups or CTs panel === | ||
* It is suggested to have this option available on Doc Center Tab in Master | * It is suggested to have this option available on Doc Center Tab in Master | ||
* On "generate template" system would present pop-up panel that gives a choice to the user of what CTs to include into the document - see Select_CTs_from_Groups.JPG | * On "generate template" system would present pop-up panel that gives a choice to the user of what CTs to include into the document - see Select_CTs_from_Groups.JPG | ||
| Line 30: | Line 32: | ||
=== xls Manifest Section === | === xls Manifest Section === | ||
| + | [[File:Trucking_Billing_Manifest_Section_A.JPG|thumb|500px|File:Trucking_Billing_Manifest_Section_A.JPG]] | ||
* This is a table. | * This is a table. | ||
| - | * See example here: . | + | * See example here: Trucking_Billing_Manifest_Section_A.JPG |
* Horizontally: | * Horizontally: | ||
** it consists of as many sections as there are CTs (originally selected by user) | ** it consists of as many sections as there are CTs (originally selected by user) | ||
Revision as of 23:56, 2 December 2009
Contents |
Business Requirements
- Operators need xls spreadsheet for Trucking MOT that has:
- Manifest section:
- commodity info (PO, SKU, etc)
- general CT info (Shipper, etc)
- Billing section:
- per CT
- has commodity totals (Gross weight, etc)
- has fields that contain formulas
- Manifest section:
Suggested Design
Select Groups or CTs panel
- It is suggested to have this option available on Doc Center Tab in Master
- On "generate template" system would present pop-up panel that gives a choice to the user of what CTs to include into the document - see Select_CTs_from_Groups.JPG
Template
- See File:Trucking_Billing_Manifest_Template.JPG
- Mapping:
- Date // today's date
- Client // GenTab.E0
- Author By // Gen Tab
- Rate // float; default=0.00
- Min Rate // float; default=0.00
- Fuel // float; default=0.000
xls Manifest Section
- This is a table.
- See example here: Trucking_Billing_Manifest_Section_A.JPG
- 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# //
- Vendor // 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
