2157 dev

From UG

Revision as of 19:37, 10 December 2010 (edit) Alex (Talk | contribs) (→Info) ← Older edit		Current revision as of 03:46, 16 December 2010 (edit) (undo) Alex (Talk | contribs)
(34 intermediate revisions not shown)
Line 1:		Line 1:
-	[[Category:Acc Tweaks]]	+	[[Category:RFD]]
	== Info ==		== Info ==
		+	* Mantis: 0002157: (Reps) (CTs With No Inv) Add 2 report types: “CT with Unbilled Sales”, “CT with a Loss”
		+	* Support Guide: [[CTs With No Invoices]]
-	This is a tweak for the following Acc component: [[Acc Reports CTs With No Inv]]	+	This is a change.
-	We need to create a report that would allow accounting to monitor that shipments are being invoiced in a timely manner with a profitable gross margin.	+	== Business Analysis ==
-	== Requirements ==	+	=== Business Need ===
-	Adding two additional report types.	+	We need to create additional reports that would allow accounting to monitor that shipments are being invoiced in a timely manner and have a profitable gross margin.
-	=== “CT with Unbilled Sales” ===	+	=== Business Solution ===
-	Criteria: CT should appear on this report if:	+	Adding two additional report types:
-	"CT is NOT billed – (If at least one Sales Invoice does not exist (No sales invoice was issued against CT)) AND there is "PI" amount > 0 posted against CT"	+
-	*If a CT record does not reflect a purchase invoice against it, it is not required to have a sales invoice against it. If no Purchase Invoice is issued against the CT record, the shipment should NOT show on the report.	+	* [[#CTs with Unbilled Sales]]
-		+	* [[#CT with a Loss]]
-	*The system should not recognize internal invoices as a sales invoice for this report. If a CT records only has an internal invoice and no sales invoice the shipment SHOULD show on this report.	+
-	For Group Shipments:	+	==== CTs with Unbilled Sales ====
-	Note: The system should recognize the CT records, that are included in the sales invoice	+	CT should appear on this report if:
-	* Any CT records selected from the group, to be included on the invoice being issued, should NOT show on the report.	+	CT record has no sales invoice issued.
-	* Any CT records not selected from the group, to be included on the invoice being issued, SHOULD show on the report.	+	AND
		+	There is one or more Purchase invoice posted against this CT.
		+	Notes: The system should not recognize internal invoices as a sales invoice for this report.
-	Note: For shipments on the report. The report should show the Jaguar Office that has entered to largest PI in an additional column on the report.	+	For group shipments, the system should recognize the CT records group that are included in the sales invoice.
-	**PLEASE SEE ATTACHED EXAMPLES FOR FURTHER EXPLANATION**	+	'''Output:'''
		+	Header:
-	=== “CT with a Loss” ===	+	* Report Type
		+	* Date Range from
		+	* Date Range to
-	Criteria: * If the Sales invoice exceeds the Purchase Invoice, the record should NOT show on the report.	+	Columns:
-	* The shipment should not be considered "Billed complete", until the total Sales invoices is greater than the total Purchase invoices.	+	* CT Number
		+	* Client Company
		+	* Jaguar Office that has posted largest Purchase invoice against this CT.
-	* If a record contains a Sales Invoice that is equal to or less then the Purchase Invoice, the record SHOULD show on the report.	+	The report should be downloadable to excel.
		+	Example:
-	**PLEASE SEE ATTACHED EXAMPLES FOR FURTHER EXPLANATION**	+	[[File:CT with Unbilled Sales.JPG]]
-	Reports should include the Jaguar Office reflecting the loss.	+	==== CT with a Loss ====
-	*If multiple offices show a loss or show purchase invoices without sales invoices – the office showing the largest loss should be the one included on the report.	+	CT should appear on this report if:
-	=== 2 Report types added ===	+	The total purchase number is equal to or greater then the total sales number for this CT.
-	[[File:0002157.JPG]]	+	'''Output:'''
-	=== Explanation of requirements FOR GROUPED SHIPMENTS case ===	+	Header:
-	[[File:0002157a.JPG]]	+	* Report Type
		+	* Date Range from
		+	* Date Range to
-	== SA Notes ==	+	Columns:
		+
		+	* CT Number
		+	* Client Company
		+	* Jaguar Office that has posted largest Purchase invoice against this CT
		+	* Total Gross Margin
		+
		+
		+	The report should be downloadable to excel
		+
		+	Example:
		+	[[File:Cts with a loss revised.JPG]]
		+	== Systems Analysis ==
		+	No additional SA info required.
		+
		+	== Architect Review ==
		+	Not required
		+
		+	== Implementation Summary ==
		+	== QA Plan ==
		+	== History ==

---

Current revision as of 03:46, 16 December 2010

Contents 1 Info 2 Business Analysis 2.1 Business Need 2.2 Business Solution 2.2.1 CTs with Unbilled Sales 2.2.2 CT with a Loss 3 Systems Analysis 4 Architect Review 5 Implementation Summary 6 QA Plan 7 History

[edit] Info

• Mantis: 0002157: (Reps) (CTs With No Inv) Add 2 report types: “CT with Unbilled Sales”, “CT with a Loss”
• Support Guide: CTs With No Invoices

This is a change.

[edit] Business Analysis

[edit] Business Need

We need to create additional reports that would allow accounting to monitor that shipments are being invoiced in a timely manner and have a profitable gross margin.

[edit] Business Solution

Adding two additional report types:

• #CTs with Unbilled Sales
• #CT with a Loss

[edit] CTs with Unbilled Sales

CT should appear on this report if:

CT record has no sales invoice issued. 
AND 
There is one or more Purchase invoice posted against this CT.

Notes: The system should not recognize internal invoices as a sales invoice for this report.

For group shipments, the system should recognize the CT records group that are included in the sales invoice.

Output:

Header:

• Report Type
• Date Range from
• Date Range to

Columns:

• CT Number
• Client Company
• Jaguar Office that has posted largest Purchase invoice against this CT.

The report should be downloadable to excel.

Example:

[edit] CT with a Loss

CT should appear on this report if:

The total purchase number is equal to or greater then the total sales number for this CT.

Output:

Header:

• Report Type
• Date Range from
• Date Range to

Columns:

• CT Number
• Client Company
• Jaguar Office that has posted largest Purchase invoice against this CT
• Total Gross Margin

The report should be downloadable to excel

Example:

[edit] Systems Analysis

No additional SA info required.

[edit] Architect Review

Not required

[edit] Implementation Summary

[edit] QA Plan

[edit] History