Billing for Virtual Group

From UG

Revision as of 00:34, 17 April 2010 (edit) Alex (Talk | contribs) (→Trucking Billing Manifest for NATP) ← Older edit		Revision as of 00:44, 17 April 2010 (edit) (undo) Alex (Talk | contribs) (→Generate For Choices) Newer edit →
Line 53:		Line 53:
	* All Pick Up Truckers		* All Pick Up Truckers
		+	** system must group all selected CTs per [[#Pick Up Trucker]] and display each group on a separate xls tab. Tab is to be named after given Trucker
	* All Delivery Truckers		* All Delivery Truckers
		+	** same idea as above
	* Selected Pick Up Trucker		* Selected Pick Up Trucker
		+	** on template system produces all unique truckers across selected CTs
		+	** xls has only CTs that have selected trucker
	* Selected Delivery Trucker		* Selected Delivery Trucker
		+	** same idea as above
	Validation		Validation

---

Revision as of 00:44, 17 April 2010

Contents 1 General 2 Business Requirements 3 Specs 3.1 Wizard Pop Up 3.2 Trucking Billing Manifest for NATP 3.2.1 Template 3.2.2 Xls 3.2.3 Generate For Choices 3.2.4 Rate Fuel Choices 4 Figures 4.1 Figure 1. Assign GRP and MASTER 4.2 Figure 2. Billing for Virtual Group 4.3 Figure 3. Rate fuel per trucker (one trucker per spreadsheet) 4.4 Figure 4. Rate fuel per unique origin and destination pair 5 History

General

• parent: http://mantis.jaguarfreight.com/mantis/view.php?id=1884

Business Requirements

See New Arden Trucking Project NATP (main)#Billing

Specs

To add this feature you need to add 2 components:

• #Wizard Pop Up
• #Trucking Billing Manifest for NATP

Wizard Pop Up

After user selects billing option on Virtual_Groups_for_NATP#General_Wizard_Step_3 system will:

• create a CT Group out of all CTs in Virtual Group
  • MOT = Truck Domestic
  • Client = Client from Virtual Grp classifiers
• Create Trucking Master
• Add CT Group above to the Master
• present pop up as on #Figure 1. Assign GRP and MASTER

Trucking Billing Manifest for NATP

Master Trucking needs additional tab: NATP.

See #Figure 2. Billing for Virtual Group

This tab has same purpose as Misc tab - to generate Trucking Billing Manifest. The difference is in how it is done and output design. Overall one is just a variation of another.

See what we have now on Misc tab here: Trucking Billing Manifest (Developer Guide)

Template

NATP template:

• has CT/GRP list as Misc does
• does not have any other field present on Misc except "Extra Columns". Reason: System will produce xls with default values (as defined for Misc) and user will edit on xls
• has additional (not present on Misc) controls/choices - see #Generate For Choices and #Rate Fuel Choices

Xls

It consists of same components as xls for Misc but there are some important differences:

• Section 1 and 2 are now located on same tab not 2 different tabs as for Misc
• user has some choices of layout - see #Generate For Choices and #Rate Fuel Choices

Generate For Choices

• All Pick Up Truckers
  • system must group all selected CTs per #Pick Up Trucker and display each group on a separate xls tab. Tab is to be named after given Trucker
• All Delivery Truckers
  • same idea as above
• Selected Pick Up Trucker
  • on template system produces all unique truckers across selected CTs
  • xls has only CTs that have selected trucker
• Selected Delivery Trucker
  • same idea as above

Validation
----------
Each CT must have Pick Up and Delivery Trucker set.
If not show error pop-up and block xls generation.

Rate Fuel Choices

Figures

Figure 1. Assign GRP and MASTER

Figure 2. Billing for Virtual Group

Figure 3. Rate fuel per trucker (one trucker per spreadsheet)

Figure 4. Rate fuel per unique origin and destination pair

History