Estimated Gross Margin (P/L) Module. Operators driven

From UG

(Difference between revisions)
Jump to: navigation, search
(→History)
 
(12 intermediate revisions not shown)
Line 1: Line 1:
-
[[Category:AccCore]]
+
[[Category:Estimated P and L]]
== Info ==
== Info ==
-
=== Parent Mantis ===
+
* '''Parent Mantis''': 0002515: [Estim P&L/Etc] .......
-
* 0002515: [Estim P&L/Etc] .......<proj>
+
* '''Wiki category:''' Estimated P&L / Accruals
-
 
+
-
NOTE: this needs to be confirmed
+
=== Scope of this wiki ===
=== Scope of this wiki ===
Line 24: Line 22:
* [[2565_dev]]
* [[2565_dev]]
-
Some SOW were just posted into Mantis. See [[#History]].
+
Some tasks were just posted into Mantis. See [[#History]].
 +
 
 +
This SOW covers:
 +
 
 +
* creation of simple Est Tab (implemented)
 +
* creation of advanced Est Tab (not implemented)
 +
* suggests other features and stories under this module (not implemented)
== SOW 1 ==
== SOW 1 ==
-
Add a check box so operators can enter any charges that they know are going to be applied in the future, but are not part of the actual invoice yet.
+
This SOW covers creation of "quick and dirty" way of:
 +
* posting accrual charges
 +
* gradually marking them as non-accrual (as actual invoices are generated)
 +
* reports that pull accrual and actuals
-
This check box needs to be part of the line items, so each line can be checked individually.
+
Design by Tracie:
 +
------------------
 +
Add a check box so operators can enter any charges that they know are going to be applied in the
 +
future, but are not part of the actual invoice yet.
-
This check box will be checked to advise actual charges are not yet applied to this file and will be manually unchecked by the operator once the actual charges are entered.
+
This check box needs to be part of the line items, so each line can be checked individually.
-
This check box will be used for reporting purposes (currently creating 2 accounting reports that will need this information)
+
This check box will be checked to advise actual charges are not yet applied to this file and will be
 +
manually unchecked by the operator once the actual charges are entered.
 +
 
 +
This check box will be used for reporting purposes (currently creating 2 accounting reports that
 +
will need this information)
 +
 
 +
'''Design by Alex:'''
 +
 
 +
[[File:Inv and Est tabs merged.JPG]]
=== Impact on DB performance and speed ===
=== Impact on DB performance and speed ===
Line 46: Line 64:
{| {{table}}
{| {{table}}
-
| align="center" style="background:#f0f0f0;"|'''2565'''
+
| 2565||* Archived / Released ||[Estim P&L] Implement phase 1 [Delete]  
-
| align="center" style="background:#f0f0f0;"|'''* Archived / Released'''
+
-
| align="center" style="background:#f0f0f0;"|'''[Estim P&L] Implement phase 1 [Delete]'''
+
|-
|-
| 2800||* Archived / Released ||[Estim P&L] bug does not allow 0.00 in cost or sell [Delete]  
| 2800||* Archived / Released ||[Estim P&L] bug does not allow 0.00 in cost or sell [Delete]  
Line 66: Line 82:
|  
|  
|}
|}
-
 
=== 0003217: [Estim P&L/Etc] Add an accrual check box ===
=== 0003217: [Estim P&L/Etc] Add an accrual check box ===
Line 72: Line 87:
=== 0003279 [Estim P&L/Etc] Estimation report - Report # 2 including both actuals and estimation ===
=== 0003279 [Estim P&L/Etc] Estimation report - Report # 2 including both actuals and estimation ===
 +
WU? No
 +
 +
=== 0003216: (Acc Report: Acc Milestones) Create estimation report ===
 +
WU? No
== User Guide ==
== User Guide ==
-
=== SOW covered  ===
 
-
==== Sec 1 ====
+
'''Under construction!'''
-
==== Sec 2 ====
+
 
-
==== Sec 3 ====
+
=== SOW covered  ===
=== SOW covered  ===
 +
[[#SOW 0]]
 +
 +
=== Executive Summary ===
 +
 +
Main use cases:
 +
 +
* Operator enters estimated charges on [#Est Tab]]
 +
* CFO runs [[#P and L report with point of rev recognition option]] that pulls charges above
 +
 +
'''??? What happens in case of grouped CTs?'''
 +
 +
==== Est Tab ====
 +
 +
[[File:Est Tab as of Nov 30.JPG]]
 +
 +
 +
==== P and L report with point of rev recognition option ====
 +
 +
[[File:P and L with point of rev recognition option.JPG]]

Current revision as of 19:34, 15 February 2012


Contents

[edit] Info

  • Parent Mantis: 0002515: [Estim P&L/Etc] .......
  • Wiki category: Estimated P&L / Accruals

[edit] Scope of this wiki

It covers Estimated Gross Margin (P/L) Feature. Components affected:

  • CT profile > Est Tab
  • CT profile > Inv Tab
  • CT profile > P/L tab
  • Acc > Reps > P/L report

[edit] SOW 0

Previous SOWs are in these wikis:

Some tasks were just posted into Mantis. See #History.

This SOW covers:

  • creation of simple Est Tab (implemented)
  • creation of advanced Est Tab (not implemented)
  • suggests other features and stories under this module (not implemented)

[edit] SOW 1

This SOW covers creation of "quick and dirty" way of:

  • posting accrual charges
  • gradually marking them as non-accrual (as actual invoices are generated)
  • reports that pull accrual and actuals 
Design by Tracie:
------------------
Add a check box so operators can enter any charges that they know are going to be applied in the 
future, but are not part of the actual invoice yet.

This check box needs to be part of the line items, so each line can be checked individually.

This check box will be checked to advise actual charges are not yet applied to this file and will be 
manually unchecked by the operator once the actual charges are entered.

This check box will be used for reporting purposes (currently creating 2 accounting reports that  
will need this information)

Design by Alex:

File:Inv and Est tabs merged.JPG

[edit] Impact on DB performance and speed

[edit] SOW 2

[edit] Impact on DB performance and speed

[edit] History

[edit] Old history

2565* Archived / Released [Estim P&L] Implement phase 1 [Delete]
2800* Archived / Released [Estim P&L] bug does not allow 0.00 in cost or sell [Delete]
2848* Archived / Released [Estim P&L/Etc] Replace column heading \"A\" with something more descriptive [Delete]
2857* Archived / Released [Estim P&L/Etc] Add gross margin percent for total charges [Delete]
2863** BA Backlog [Estim P&L/Etc] Add \"Q\" & \"R\" to estimation tab [Delete]
2864** BA Backlog [Estim P&L/Etc] Auto generate actual invoices (sales and purchases) based on info on estimation tab [Delete]
2866* Archived / Released [Estim P&L/Etc] bug when changing from margin to amount total does not change and allows save [Delete]
2869** BA Backlog [Estim P&L/Etc] Add ability for operators to apply estimation across single or multiple CT\'s [Delete]

[edit] 0003217: [Estim P&L/Etc] Add an accrual check box

WU? No

[edit] 0003279 [Estim P&L/Etc] Estimation report - Report # 2 including both actuals and estimation

WU? No

[edit] 0003216: (Acc Report: Acc Milestones) Create estimation report

WU? No

[edit] User Guide

Under construction!

[edit] SOW covered

#SOW 0

[edit] Executive Summary

Main use cases:

??? What happens in case of grouped CTs?

[edit] Est Tab

File:Est Tab as of Nov 30.JPG


[edit] P and L report with point of rev recognition option

File:P and L with point of rev recognition option.JPG

Retrieved from "https://wiki.jaguarfreight.com/Estimated_Gross_Margin_(P/L)_Module._Operators_driven"
Personal tools