Acc Reports CTs With No Inv

From UG

Revision as of 21:43, 17 October 2011 (edit) Alex (Talk | contribs) (→Ver 3) ← Older edit		Revision as of 15:58, 18 October 2011 (edit) (undo) Alex (Talk | contribs) (→Hard Coded conditions) Newer edit →
Line 23:		Line 23:
	== Hard Coded conditions ==		== Hard Coded conditions ==
		+
		+	Todo (Tracie):
		+
		+	* review all conditions to make sure they are up to date
		+	** see http://ct.jaguarfreight.com/wiki/2157_rfd#.E2.80.9CCT_with_a_Loss.E2.80.9D and
	=== CTs with Unbilled Sales ===		=== CTs with Unbilled Sales ===

---

Revision as of 15:58, 18 October 2011

Contents 1 Info 2 Biz Req 3 Summary 4 Report Types 5 Hard Coded conditions 5.1 CTs with Unbilled Sales 5.2 CTs with a Loss 5.3 CTs without Purchase Invoices 5.4 CTs without Sales Invoices 6 Filters 7 Action Controls 8 Output 9 Excel format 10 Solution ver 1 10.1 CTs With No Invoices 10.2 CTs with a loss 11 Solution ver 2 11.1 Level 1 11.2 Level 2 11.3 Level 3 12 Ver 3 13 History 13.1 m1894 13.2 0002157: (Reps) (CTs With No Inv) Add "Unbilled Sales" report type. Rename some labels 13.3 0003192: (Acc Report: CTs With No Inv) (CTs with a Loss option) Create a dashboard version of this report

Info

• http://ct.jaguarfreight.com/mantis/view.php?id=2303

See User Guide here: CTs With No Invoices

Biz Req

This report helps to "catch" invoices that for some reson never being billed or never being mapped into any purchase amounts.

Summary

• CTs With No Invoices report is accounting report.
• It is a list of shipments (CTs) which can be selected from DB by the #Hard Coded conditions.
• These sets of conditions correspond to their #Report Types.

Report Types

• CTs with Unbilled Sales
• CTs with a Loss
• CTs without Purchase Invoices
• CTs without Sales Invoices

Hard Coded conditions

Todo (Tracie):

• review all conditions to make sure they are up to date
  • see http://ct.jaguarfreight.com/wiki/2157_rfd#.E2.80.9CCT_with_a_Loss.E2.80.9D and

CTs with Unbilled Sales

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

NOTES:

• 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.
• 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.

CTs with a Loss

• If the Sales invoice exceeds the Purchase Invoice, the record should NOT show on the report.
• The shipment should not be considered "Billed complete", until the total Sales invoices is greater than the total Purchase invoices.
• If a record contains a Sales Invoice that is equal to or less then the Purchase Invoice, the record SHOULD show on the report.

CTs without Purchase Invoices

CT should appear on this report if at least one condition is satisfied:

• CT is billed - see Billed CT Status

OR

• 0 lines posted against CT in any PI in the system

CTs without Sales Invoices

• No sales invoice was issued against CT

Filters

• Report Types: group of radio buttons that correspond to the Report Types
• CT Created on Date: from / to date calendar
• NOTE: CT Created on Date: = GenTab.17. Notification Date:
• NOTE: if both dates empty it means do not apply any date filter (no restriction on dates)

Action Controls

• Reset Form > clear all filter
• Generate Result > HTML result(s) with CT#links and paging
  • Go back > go back to the previous page
  • Download to Excel > Excel report with CT# links

Output

3 columns:

• CT (link)
• Client Company
• Jaguar Office
  • CTs with Unbilled Sales: The report should show the Jaguar Office that has entered to largest PI in an additional column on the report.
  • CTs with a Loss: The report should include 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 included on the report.
  • CTs without Purchase/Sales Invoices: Jaguar Office where was issued CT.

With paging.

With download to xls.

Excel format

Same as HTML (ZUL)

Solution ver 1

CTs With No Invoices

HTML output:

XLS output:

CTs with a loss

Solution ver 2

Create a dashboard version of this report (just for "CTs with a Loss option").

"CTs with a Loss option" should appear as option in Report scheduler.

Option to be DR or email.

Make "created from/to" required filter.

Level 1

Counter: number of CTs that satisfy criteria (with hyperlink to next level)

Level 2

TBD in the next ver. None in this.

Level 3

HTML, with xls download option. Columns:

CT#
Client company
MaxPI
USD profit/loss
Date CT created
Origin country
Dest country
MOT

Ver 3

Add Lev 2 as defined for all AR reports.

Option to "clear" CT from above list

History

m1894

• Report conditions has been clarified. Verify that report satisfy #Hard Coded conditions. If not fix it.
• spec updated? Yes

0002157: (Reps) (CTs With No Inv) Add "Unbilled Sales" report type. Rename some labels

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

0003192: (Acc Report: CTs With No Inv) (CTs with a Loss option) Create a dashboard version of this report