Trucking Billing Manifest(User Guide)

From UG

(Difference between revisions)
Jump to: navigation, search
(Example and Typical Workflow)
 
(9 intermediate revisions not shown)
Line 1: Line 1:
-
== Related Documents ==
+
[[Category: xArc]]
-
 
+
-
See [[:Category: Trucking Billing Manifest (M) (xls)]]
+
-
 
+
-
== Purpose ==
+
-
 
+
-
This spreadsheet is used by some operators working with [[Master Trucking]]. It will be generated, edited and sent to the client or vendor.
+
-
 
+
-
== Location ==
+
-
 
+
-
* Doc Center Tab in [[Master Trucking]].
+
-
 
+
-
 
+
-
[[Category: Trucking Billing Manifest (M) (xls)]]
+
-
 
+
-
== Example and Typical Workflow ==
+
-
 
+
-
* User opens one of the [[Master Trucking]] records and navigates to [[Doc Center Tab]].
+
-
 
+
-
* User selects "Trucking Billing Manifest" from dropdown and clicks on "Show Template" button.
+
-
 
+
-
* System brings up modal window where user mays select any subset of CTs that belong to the Master. See example on [[#Figure 1.]]
+
-
 
+
-
* User selects some CTs and clicks "OK".
+
-
 
+
-
* System brings user back to Doc Center Tab where user is presented with a template (form). See example on [[#Figure 2.]]
+
-
** See additional information about template here: [[#Template]]
+
-
 
+
-
* Users completes the form and clicks "Generate Report" button.
+
-
 
+
-
* System generates spreadsheet and opens it to the user. See example on [[#Figure 3.]] and [[#Figure 4.]]
+
-
** See additional information about spreadsheet here: [[#Spreadsheet]]
+
-
 
+
-
=== Template ===
+
-
 
+
-
* '''Date''' - [[datebox]], default value is current date
+
-
 
+
-
* '''Client Company''' - [[textbox]], default value is blank
+
-
 
+
-
* '''Authorized By''' - [[textbox]], default value is blank
+
-
 
+
-
* '''Rate''' - [[textbox]], default value is 0.00
+
-
 
+
-
* '''Minimum Rate''' - [[textbox]], default value is 0.00
+
-
 
+
-
* '''Fuel''' - [[textbox]], default value is 0.00
+
-
 
+
-
* '''Extra columns''' - [[listbox]], default value is 0
+
-
 
+
-
=== Spreadsheet ===
+
-
 
+
-
There are 2 sections - see below.
+
-
 
+
-
=== Spreadsheet: Manifest Section ===
+
-
 
+
-
See Example on Figure 3.
+
-
 
+
-
*  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. See column definitions below.
+
-
 
+
-
* '''CT#'''
+
-
 
+
-
* '''Vendor''' -  [[CT#Shipper]]
+
-
 
+
-
* '''P.O.''' - [[Commodity#PO]]
+
-
 
+
-
* '''Item''' - [[Commodity#SKU]]
+
-
 
+
-
* '''Origin Port'''
+
-
::''City, State'' from [[CT#Export Pick Up]]
+
-
::Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet
+
-
 
+
-
* '''Dest. Port'''
+
-
::''COMPANY-CITY-NOTE'' from [[CT#Export Delivery To]]
+
-
::Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet
+
-
 
+
-
 
+
-
 
+
-
 
+
-
* 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
+
-
 
+
-
 
+
-
* Sorted by: CT#
+
-
 
+
-
=== Spreadsheet: Billing Section ===
+
-
 
+
-
See example on figure 4.
+
-
 
+
-
== Figures ==
+
-
 
+
-
=== Figure 1. ===
+
-
 
+
-
[[File:Select_CTs_from_Groups.JPG]]
+
-
 
+
-
=== Figure 2. ===
+
-
 
+
-
[[File:Trucking_Billing_Manifest_Template_ver_2.JPG]]
+
-
 
+
-
=== Figure 3. ===
+
-
 
+
-
[[File:Trucking_Billing_Manifest_Section_A.JPG]]
+
-
 
+
-
=== Figure 4. ===
+
-
 
+
-
[[File:Trucking Billing Manifest Section B.JPG]]
+

Current revision as of 06:41, 13 August 2011

Personal tools