Acc Reports CTs With No Inv
From UG
Contents |
Info
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
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