Trucking Billing Manifest
From UG
(Difference between revisions)
(→Home and Select Groups or CTs panel) |
(→Suggested Design) |
||
Line 13: | Line 13: | ||
== Suggested Design == | == Suggested Design == | ||
[[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]] | ||
+ | [[/File:Trucking_Billing_Manifest_Template.JPG|thumb|500px|Trucking_Billing_Manifest_Template.JPG]] | ||
=== Home and Select Groups or CTs panel === | === Home and 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 | ||
- | * | + | |
+ | === 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 | ||
+ | |||
+ | |||
+ | === Generated xls === |
Revision as of 23:36, 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
thumb|500px|Trucking_Billing_Manifest_Template.JPG
Home and 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