2766 rfd

From UG

(Difference between revisions)
Jump to: navigation, search
m (Requirements and Solutions: re-write "What" wording)
(added Example of Estimation View Table as Figure 1)
 
(6 intermediate revisions not shown)
Line 9: Line 9:
* '''Task type:''' Change.
* '''Task type:''' Change.
* '''Where:''' [http://ct.jaguarfreight.com/wiki/Profit_Loss_for_Multiple_CTs Profit Loss for Multiple CTs] report.
* '''Where:''' [http://ct.jaguarfreight.com/wiki/Profit_Loss_for_Multiple_CTs Profit Loss for Multiple CTs] report.
-
* '''What:''' Add option that would enable to show estimated charges vs actual charges.
+
* '''What:''' Add option that would enable a special view '''"Estimation"''' to show estimated charges vs actual charges.
 +
 
 +
=== Summary ===
 +
 
 +
*When the estimation is to be included on this report the report should have the following additional columns.
 +
 
 +
:Estimated Sales
 +
:Estimated Purchase
 +
 
 +
* The estimation columns should be located '''next''' to the corresponding actual column ''(for example, Actual Sales > Estimated sales)''.
 +
* Any '''P/L''' (Profit/Loss) headings should be replaced with '''GM''' (Gross Margin) for this report.
 +
 
 +
=== Output Columns ===
 +
 
 +
*'''Office''' - Jaguar Office that issued given invoice.
 +
*[http://ct.jaguarfreight.com/wiki/CT_bo#Mode_Of_Transport '''Transport Mode'''] of CT.
 +
*[http://ct.jaguarfreight.com/wiki/CT_bo#E0_Client '''Client'''].
 +
*[http://ct.jaguarfreight.com/wiki/CT_bo#CT_Num '''CT #'''].
 +
*'''GRP #''' - this column shows group that CT belongs to or blank if none.
 +
*'''Actual Sales''' - USD total amount from Sale Invoices Table on Inv Tab ''(or USD Sales from P/L Tab)''.
 +
*'''Estimated Sales''' - USD total estimated sales from Estimated Charges Table on Est Tab.
 +
*'''Actual Purchase''' - USD total amount of Purchase Invoices that issued against given CT ''(or USD Purchase from P/L Tab)''.
 +
*'''Estimated Purchase''' - USD total estimated costs from Estimated Charges Table on Est Tab.
 +
*'''Actual Gross Margin''' (Act GM) - - calculated as USD (''Actual Sales'' minus ''Actual Purchase'').
 +
*'''Estimated Gross Margin''' (Est GM) - calculated as USD (''Estimated Sales'' minus ''Estimated Purchase'').
 +
*'''Actual Gross Margin %''' (Act GM %) - calculated by formula: ''(Actual Gross Margin / Actual Sales) x 100''.
 +
*'''Estimated Gross Margin %''' (Est GM %) - calculated by formula: ''(Estimated Gross Margin / Estimated Sales) x 100''.
 +
 
 +
NOTES:
 +
* Estimation should be showed in merged cells related to CT and in total line also.
 +
* Each line should show the CT number (CT#) next to it, not in a merged cell.
 +
* See example of output table in [[#Figures |Figures]] section.
== Architect Review ==
== Architect Review ==
Line 15: Line 46:
== QA Plan ==
== QA Plan ==
== History ==
== History ==
 +
== Figures ==
== Figures ==
 +
=== Figure 1: Example of Estimation View Table ===
 +
[[File:MultiplePL EstimationView.gif]]

Current revision as of 11:44, 29 March 2011


Contents

[edit] Info

  • mantis: 2766 ((Acc Report: Misc) Add a special view to accounting report to show estimation

[edit] Requirements and Solutions

  • Task type: Change.
  • Where: Profit Loss for Multiple CTs report.
  • What: Add option that would enable a special view "Estimation" to show estimated charges vs actual charges.

[edit] Summary

  • When the estimation is to be included on this report the report should have the following additional columns.
Estimated Sales
Estimated Purchase
  • The estimation columns should be located next to the corresponding actual column (for example, Actual Sales > Estimated sales).
  • Any P/L (Profit/Loss) headings should be replaced with GM (Gross Margin) for this report.

[edit] Output Columns

  • Office - Jaguar Office that issued given invoice.
  • Transport Mode of CT.
  • Client.
  • CT #.
  • GRP # - this column shows group that CT belongs to or blank if none.
  • Actual Sales - USD total amount from Sale Invoices Table on Inv Tab (or USD Sales from P/L Tab).
  • Estimated Sales - USD total estimated sales from Estimated Charges Table on Est Tab.
  • Actual Purchase - USD total amount of Purchase Invoices that issued against given CT (or USD Purchase from P/L Tab).
  • Estimated Purchase - USD total estimated costs from Estimated Charges Table on Est Tab.
  • Actual Gross Margin (Act GM) - - calculated as USD (Actual Sales minus Actual Purchase).
  • Estimated Gross Margin (Est GM) - calculated as USD (Estimated Sales minus Estimated Purchase).
  • Actual Gross Margin % (Act GM %) - calculated by formula: (Actual Gross Margin / Actual Sales) x 100.
  • Estimated Gross Margin % (Est GM %) - calculated by formula: (Estimated Gross Margin / Estimated Sales) x 100.

NOTES:

  • Estimation should be showed in merged cells related to CT and in total line also.
  • Each line should show the CT number (CT#) next to it, not in a merged cell.
  • See example of output table in Figures section.

[edit] Architect Review

[edit] Implementation Notes

[edit] QA Plan

[edit] History

[edit] Figures

[edit] Figure 1: Example of Estimation View Table

File:MultiplePL EstimationView.gif

Personal tools