2157 dev

From UG

(Difference between revisions)
Jump to: navigation, search
(Figure 1)
 
(37 intermediate revisions not shown)
Line 1: Line 1:
-
[[Category:Acc Tweaks]]
+
[[Category:RFD]]
 +
== 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]]
-
== Requirements ==
+
This is a change.
-
Adding two additional report types.
+
== Business Analysis ==
-
=== “CT with Unbilled Sales” ===
+
=== Business Need ===
-
Criteria: CT should appear on this report if:
+
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 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.
+
=== Business Solution ===
-
+
-
*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:
+
Adding two additional report types:
-
Note: The system should recognize the CT records, that are included in the sales invoice
+
* [[#CTs with Unbilled Sales]]
 +
* [[#CT with a Loss]]
-
* Any CT records selected from the group, to be included on the invoice being issued, should NOT show on the report.
+
==== CTs with Unbilled Sales ====
-
* Any CT records not selected from the group, to be included on the invoice being issued, SHOULD show on the report.
+
 +
CT should appear on this report if:
-
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.
+
CT record has no sales invoice issued.
 +
AND
 +
There is one or more Purchase invoice posted against this CT.
-
**PLEASE SEE ATTACHED EXAMPLES FOR FURTHER EXPLANATION**
+
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.
-
=== “CT with a Loss” ===
+
'''Output:'''
-
Criteria: * If the Sales invoice exceeds the Purchase Invoice, the record should NOT show on the report.
+
Header:
-
* The shipment should not be considered "Billed complete", until the total Sales invoices is greater than the total Purchase invoices.
+
* Report Type
 +
* Date Range from
 +
* Date Range to
-
* If a record contains a Sales Invoice that is equal to or less then the Purchase Invoice, the record SHOULD show on the report.
+
Columns:
 +
* CT Number
 +
* Client Company
 +
* Jaguar Office that has posted largest Purchase invoice against this CT.
-
**PLEASE SEE ATTACHED EXAMPLES FOR FURTHER EXPLANATION**
+
The report should be downloadable to excel.
-
Reports should include the Jaguar Office reflecting the loss.
+
Example:
-
*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.
+
[[File:CT with Unbilled Sales.JPG]]
-
=== 2 Report types added ===
+
==== CT with a Loss ====
-
[[File:0002157.JPG]]
+
CT should appear on this report if:
-
=== Explanation of requirements FOR GROUPED SHIPMENTS case ===
+
The total purchase number is equal to or greater then the total sales number for this CT.
-
[[File:0002157a.JPG]]
+
'''Output:'''
-
== SA Notes ==
+
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:
 +
[[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

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

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

File:CT with Unbilled Sales.JPG

[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: File:Cts with a loss revised.JPG

[edit] Systems Analysis

No additional SA info required.

[edit] Architect Review

Not required

[edit] Implementation Summary

[edit] QA Plan

[edit] History

Personal tools