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

From UG

Contents 1 Info 1.1 Parent Mantis 1.2 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

Info

Parent Mantis

• 0002515: [Estim P&L/Etc] .......

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

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)

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:

Impact on DB performance and speed

SOW 2

Impact on DB performance and speed

History

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]

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

WU? No

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

Under construction!

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

P and L report with point of rev recognition option