Estimated Gross Margin (P/L) Module. Operators driven
From UG
(Difference between revisions)
(→User Guide) |
m (moved Estimated Gross Margin (P/L) Module MAIN WIKI to Estimated Gross Margin (P/L) Module. Operators driven) |
||
| (8 intermediate revisions not shown) | |||
| Line 1: | Line 1: | ||
| - | [[Category: | + | [[Category:Estimated P and L]] |
== Info == | == Info == | ||
| - | + | * '''Parent Mantis''': 0002515: [Estim P&L/Etc] ....... | |
| - | + | * '''Wiki category:''' Estimated P&L / Accruals | |
=== Scope of this wiki === | === Scope of this wiki === | ||
| Line 22: | Line 22: | ||
* [[2565_dev]] | * [[2565_dev]] | ||
| - | Some | + | 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 | ||
| + | |||
| + | 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 | + | 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 79: | Line 99: | ||
[[#SOW 0]] | [[#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:
[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
[edit] 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?
[edit] Est Tab
[edit] P and L report with point of rev recognition option
