2157 rfsa
From UG
(12 intermediate revisions not shown) | |||
Line 1: | Line 1: | ||
- | [[Category: | + | [[Category:RFSA]] |
+ | |||
+ | <div style="background-color:lightSteelBlue"> | ||
== Info == | == Info == | ||
- | * mantis: | + | |
+ | * 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 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. | |
- | + | ||
+ | === 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]] | ||
=== “CT with a Loss” === | === “CT with a Loss” === | ||
- | Criteria: | + | 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: | ||
- | + | 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: | + | [[File:Cts with a loss revised.JPG]] |
- | + | </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
[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