Est Tab

From UG

(Difference between revisions)
Jump to: navigation, search
(→SOW 1 Re-design estimation module)
(→SOW 1 Add Populate ETOC from selected CT)
 
(109 intermediate revisions not shown)
Line 1: Line 1:
-
[[Category:2013]]
+
[[Category:Acc]]
== Info ==
== Info ==
-
*  0004050: [DR/KPI] Estimation of Sales and Cost
+
== Business Need ==
-
== SOWs ==
+
* To enter estimated charges (on sales side)
 +
* Ops instructed to enter by Arrival date
-
=== SOW 1 Re-design estimation module ===
+
== Component Description ==
-
'''mantis''':
+
To enter charges user have to navigate to Est Tab.
-
'''spec''': see below
+
User can add, remove, edit information in a table like format.
-
In a nutshell:
+
=== General controls ===
-
* create new way of submitting estimated sales and cost
+
* user have to save changes using "Save" button
-
* remove/rework existing code (that links to what we have on Est Tab)
+
* user can add and delete lines using '''Add''' and '''Remove''' buttons
-
* position Est Form on Est Tab (CT Editor)
+
-
* incorporate estimation form on Imp tab into a new module
+
-
* data collected will be used in various reports: CPU KPIs, etc
+
-
* also WE NEED A LINK BETWEEN "E0 CLIENT" AND "BILL TO PARTIES" ( ???)
+
-
At a user level:
+
=== Table of Estimated Charge Codes ===
-
* it has one form that consists of two TOCs:
+
==== Sales section ====
-
** sales
+
-
** cost
+
-
* these 2 tables are unrelated
+
-
* tables have same columns except 2nd column:
+
-
** CC
+
-
** Bill To (in Sell Charges table) vs Vendor (in Costs table)
+
-
** Description
+
-
** Qty
+
-
** Rate
+
-
** Amount
+
-
** currency
+
-
* See mock up below:
+
-
[[File:Estimation module.JPG | 700px]]
+
Columns related to Estimated Sales.
-
Questions:
+
* '''CC#'''
 +
** combobox with list of all [[Charge Code Admin |charge codes]] defined in the system
 +
** selected by user
 +
** required
-
* WE NEED A LINK BETWEEN "E0 CLIENT" AND "BILL TO PARTIES" Marc pls explain this again, how it will work and why we need this? Is it related to this spec?
+
* '''Unit'''
 +
** dropdown
 +
** see [[Sales Invoice#Unit]]
 +
 
 +
* '''DC''' - option to turn on/off the distribution by containers (for OCEAN CTs only)
 +
** checkbox
 +
** when checked Quantity/Rate/Amount will accomodate container entry
 +
 
 +
* '''Bill To Party'''
 +
 
 +
* '''Sale Quantity'''
 +
** required
 +
** pre-filled by system as defined in CC Admin > Quantity Field default to
 +
 
 +
* '''Sale Rate'''
 +
** required
 +
** entered by user
 +
 
 +
* '''Sale Amount'''
 +
** required
 +
** not editable
 +
** calculated by system: Sale Quantity X Sale Rate
 +
 
 +
* '''Curr'''
 +
** required
 +
** entered by user
 +
 
 +
* '''M/I'''
 +
 
 +
* '''CBV'''
 +
 
 +
* '''CT#'''
 +
 
 +
* '''VAT'''
 +
 
 +
==== Cost section ====
 +
 
 +
Columns related to Estimated Cost.
 +
 
 +
* '''Vendor'''
 +
** required
 +
** entered by user
 +
** combobox
 +
 
 +
* '''Cost Quantity'''
 +
** required
 +
** pre-filled by system as defined in CC Admin > Quantity Field default to
 +
 
 +
* '''Cost Rate'''
 +
** required
 +
** entered by user
 +
 
 +
* '''Cost Amount'''
 +
** required
 +
** not editable
 +
** calculated by system: Cost Quantity X Cost Rate
 +
 
 +
* '''Curr'''
 +
** required
 +
** entered by user
 +
 
 +
* '''M/I'''
 +
 
 +
* '''CBV'''
 +
 
 +
* '''CT#'''
 +
 
 +
* '''Office'''
 +
 
 +
* '''Description'''
 +
 
 +
=== Use cases ===
 +
 
 +
==== Main case ====
 +
 
 +
Create several lines. Click save
 +
 
 +
==== Updates to relevant fields on other tabs ====
 +
 
 +
Any values that are used on Est Tab and updated on other tabs of CT Editor (such as gross weight) should be updated on Est Tab and relevant amounts automatically re-calculated.
 +
 
 +
==== Multi editing ====
 +
 
 +
To change value for the same attribute (for example: Cost Curr) on multiple lines user can:
 +
 
 +
* select desired lines
 +
* change value on one line
 +
 
 +
System will update this attribute for lines selected.
 +
 
 +
==== Validation ====
 +
 
 +
* Each line should have info for:
 +
** General + Sales Charges OR
 +
** General + Costs OR
 +
** General + Sales Charges + Costs
 +
 
 +
===== Misc =====
 +
 
 +
* this is for all MOTs
 +
 
 +
== SOWs ==
-
=== SOW 2 charges should populate Est tab automatically ===
+
=== SOW 1 Add Populate ETOC from selected CT ===
-
mant: 4062
+
mantis: '''0004375'''
-
TBD
+
spec: see below
-
Every time we get XML with charges from Desc TMS we store them in DB. Same time we should display them on Est Tab.
+
'''Requirements''':
 +
* Ability to fill in ETOC quickly for CT#1 if it is similar to ETOC of existing known CT#2
 +
* Sales part only
-
'''Questions''':
+
'''Details''' (per Marc):
-
* what cc code it will populate? I assume one of 15XX codes
+
Add button "Select ETOC from CT#" + textbox
-
* do we distribute charges across CTs in the load? Based on what CBV type? Gross Weight?
+
Once user enters CT# and clicks button system should populate data from ETOC from CT#2. See details below.
-
* charges that come from TMS are not editable in CT2 internal by operator? Or editable? Can they add lines too?
+
-
=== SOW 3 ===
+
* Populate Sale section only
 +
* Populate all columns except Q
 +
* Pre-fill Q as usual for current record
 +
* Populate only lines created by current user office
 +
* Only allow copy from same E0 and same MOT
 +
* In case of Containers: pull rates for cont size/type that match; if no mach then leave rate as 0.

Current revision as of 03:00, 21 November 2013


Contents

[edit] Info

[edit] Business Need

  • To enter estimated charges (on sales side)
  • Ops instructed to enter by Arrival date

[edit] Component Description

To enter charges user have to navigate to Est Tab.

User can add, remove, edit information in a table like format.

[edit] General controls

  • user have to save changes using "Save" button
  • user can add and delete lines using Add and Remove buttons

[edit] Table of Estimated Charge Codes

[edit] Sales section

Columns related to Estimated Sales.

  • CC#
    • combobox with list of all charge codes defined in the system
    • selected by user
    • required
  • DC - option to turn on/off the distribution by containers (for OCEAN CTs only)
    • checkbox
    • when checked Quantity/Rate/Amount will accomodate container entry
  • Bill To Party
  • Sale Quantity
    • required
    • pre-filled by system as defined in CC Admin > Quantity Field default to
  • Sale Rate
    • required
    • entered by user
  • Sale Amount
    • required
    • not editable
    • calculated by system: Sale Quantity X Sale Rate
  • Curr
    • required
    • entered by user
  • M/I
  • CBV
  • CT#
  • VAT

[edit] Cost section

Columns related to Estimated Cost.

  • Vendor
    • required
    • entered by user
    • combobox
  • Cost Quantity
    • required
    • pre-filled by system as defined in CC Admin > Quantity Field default to
  • Cost Rate
    • required
    • entered by user
  • Cost Amount
    • required
    • not editable
    • calculated by system: Cost Quantity X Cost Rate
  • Curr
    • required
    • entered by user
  • M/I
  • CBV
  • CT#
  • Office
  • Description

[edit] Use cases

[edit] Main case

Create several lines. Click save

[edit] Updates to relevant fields on other tabs

Any values that are used on Est Tab and updated on other tabs of CT Editor (such as gross weight) should be updated on Est Tab and relevant amounts automatically re-calculated.

[edit] Multi editing

To change value for the same attribute (for example: Cost Curr) on multiple lines user can:

  • select desired lines
  • change value on one line

System will update this attribute for lines selected.

[edit] Validation

  • Each line should have info for:
    • General + Sales Charges OR
    • General + Costs OR
    • General + Sales Charges + Costs
[edit] Misc
  • this is for all MOTs

[edit] SOWs

[edit] SOW 1 Add Populate ETOC from selected CT

mantis: 0004375

spec: see below

Requirements:

  • Ability to fill in ETOC quickly for CT#1 if it is similar to ETOC of existing known CT#2
  • Sales part only

Details (per Marc):

Add button "Select ETOC from CT#" + textbox Once user enters CT# and clicks button system should populate data from ETOC from CT#2. See details below.

  • Populate Sale section only
  • Populate all columns except Q
  • Pre-fill Q as usual for current record
  • Populate only lines created by current user office
  • Only allow copy from same E0 and same MOT
  • In case of Containers: pull rates for cont size/type that match; if no mach then leave rate as 0.
Retrieved from "https://wiki.jaguarfreight.com/Est_Tab"
Personal tools