2157 rfsa

From UG

(Difference between revisions)
Jump to: navigation, search
 
(12 intermediate revisions not shown)
Line 1: Line 1:
-
[[Category: Acc RFD]]
+
[[Category:RFSA]]
 +
 
 +
<div style="background-color:lightSteelBlue">
== Info ==
== Info ==
-
* mantis: 2157
+
 
 +
* mantis: 0002157: (Reps) (CTs With No Inv) Add 2 report types: “CT with Unbilled Sales”, “CT with a Loss”
 +
 
 +
This is a tweak for the following Acc component: [[Acc Reports CTs With No Inv]]
 +
 
 +
We need to create a report that would allow accounting to monitor that shipments are being invoiced in a timely manner and have a profitable gross margin.
== Requirements ==
== Requirements ==
Line 11: Line 18:
Criteria: CT should appear on this report if:
Criteria: CT should appear on this report if:
-
"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.
+
CT record with no sales invoice issued.
 +
 
 +
AND
 +
 
 +
There is Purchase invoice issued against the CT record greater then $0.00.
 +
 
 +
*If no Purchase Invoice is issued against the CT record, the shipment should NOT show on the report.
   
   
-
*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.
+
Notes: 
-
For Group Shipments:
+
The system should not recognize internal invoices as a sales invoice for this report.
-
Note: The system should recognize the CT records, that are included in the sales invoice
+
For group shipments, the system should recognize the CT records group that are included in the sales invoice.
-
* Any CT records selected from the group, to be included on the invoice being issued, should NOT show on the report.
+
For shipments on the report. The report should show the Jaguar Office that has entered to largest Purchase invoice in an additional column on the report.
-
* Any CT records not selected from the group, to be included on the invoice being issued, SHOULD show on the report.
+
 +
=== Unbilled Sales Report Output===
-
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.
+
The report should list the following fields:
-
**PLEASE SEE ATTACHED EXAMPLES FOR FURTHER EXPLANATION**
+
Report Type
 +
Date Range from
 +
 +
Date Range to
 +
 +
CT Number
 +
 +
Client Company
 +
 +
Jaguar Office
 +
 +
 +
The report should be downloadable to excel 
 +
 +
[[File:CT with Unbilled Sales.JPG]]
=== “CT with a Loss” ===
=== “CT with a Loss” ===
-
Criteria: * If the Sales invoice exceeds the Purchase Invoice, the record should NOT show on the report.
+
Criteria: CT should appear on this report if:
 +
 
 +
The total purchase invoices is equal to
 +
 
 +
OR
 +
 
 +
Greater then the total sales invoices.
 +
 
 +
Notes:
 +
The report should list the Jaguar Office reflecting the loss.
 +
 
 +
If multiple offices show a loss or show purchase invoices without sales invoices – the office showing the largest loss should be the one reflected on the report.
 +
 
 +
=== CT with a loss Report Output===
 +
 
 +
The report should list the following fields:
-
* The shipment should not be considered "Billed complete", until the total Sales invoices is greater than the total Purchase invoices.
+
Report Type
-
* If a record contains a Sales Invoice that is equal to or less then the Purchase Invoice, the record SHOULD show on the report.
+
Date Range from
 +
Date Range to
-
**PLEASE SEE ATTACHED EXAMPLES FOR FURTHER EXPLANATION**
+
CT Number
-
Reports should include the Jaguar Office reflecting the loss.
+
Client Company
-
*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.
+
Jaguar Office
-
=== 2 Report types added ===
+
Total Gross Margin
-
[[File:0002157.JPG]]
 
-
=== Explanation of requirements FOR GROUPED SHIPMENTS case ===
+
The report should be downloadable to excel
-
[[File:0002157a.JPG]]
+
[[File:Cts with a loss revised.JPG]]
-
== SA Notes ==
+
</div>

Current revision as of 20:40, 17 December 2010


Contents

[edit] Info

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

This is a tweak for the following Acc component: Acc Reports CTs With No Inv

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

[edit] Requirements

Adding two additional report types.

[edit] “CT with Unbilled Sales”

Criteria: CT should appear on this report if:

CT record with no sales invoice issued.

AND

There is Purchase invoice issued against the CT record greater then $0.00.

  • If no Purchase Invoice is issued against the CT record, the shipment should NOT show on the report.

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.

For shipments on the report. The report should show the Jaguar Office that has entered to largest Purchase invoice in an additional column on the report.

[edit] Unbilled Sales Report Output

The report should list the following fields:

Report Type

Date Range from

Date Range to

CT Number

Client Company

Jaguar Office


The report should be downloadable to excel

File:CT with Unbilled Sales.JPG

[edit] “CT with a Loss”

Criteria: CT should appear on this report if:

The total purchase invoices is equal to

OR

Greater then the total sales invoices.

Notes: The report should list the Jaguar Office reflecting the loss.

If multiple offices show a loss or show purchase invoices without sales invoices – the office showing the largest loss should be the one reflected on the report.

[edit] CT with a loss Report Output

The report should list the following fields:

Report Type

Date Range from

Date Range to

CT Number

Client Company

Jaguar Office

Total Gross Margin


The report should be downloadable to excel

File:Cts with a loss revised.JPG

Personal tools