Acc Reports CTs With No Inv

From UG

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 12 History 12.1 m1894 12.2 0002157: (Reps) (CTs With No Inv) Add "Unbilled Sales" report type. Rename some labels

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

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

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