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

From UG

Revision as of 00:04, 1 December 2011 (edit) Alex (Talk | contribs) (→SOW 1) ← Older edit		Current revision as of 19:34, 15 February 2012 (edit) (undo) Alex (Talk | contribs) m (moved Estimated Gross Margin (P/L) Module MAIN WIKI to Estimated Gross Margin (P/L) Module. Operators driven)
(6 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] .......	+	* '''Wiki category:''' Estimated P&L / Accruals
	=== Scope of this wiki ===		=== Scope of this wiki ===
Line 22:		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.
-	[[File:Inv and Est tabs merged.JPG]]	+	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 ===

---

Current revision as of 19:34, 15 February 2012

Contents 1 Info 1.1 Scope of this wiki 2 SOW 0 3 SOW 1 3.1 Impact on DB performance and speed 4 SOW 2 4.1 Impact on DB performance and speed 5 History 5.1 Old history 5.2 0003217: [Estim P&L/Etc] Add an accrual check box 5.3 0003279 [Estim P&L/Etc] Estimation report - Report # 2 including both actuals and estimation 5.4 0003216: (Acc Report: Acc Milestones) Create estimation report 6 User Guide 6.1 SOW covered 6.2 Executive Summary 6.2.1 Est Tab 6.2.2 P and L report with point of rev recognition option

[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:

• 2565_rfd
• 2565_dev

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

#SOW 0

[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