Accounts Receivable

Menu Options

---

1. Dashboard [1]
2. Customers [100]
3. Aged Debtors [200]
4. Invoices [300]
5. Reports [400]
6. Applications [500]
7. Interfaces [600]
8. Timetable [700]
9. Forms[800]
10. [Audit] [900]
11. [Administration] [1000]
12. [Reserved] [Pages 10,000 - 11,000]

Customer Audit New Customers Customer Statement

Accounts Receivable Module

Report Module	Shortcut / Static-Id
Customers	ar-customers
Aged Debtors	ar-aged-debtors
Invoice Enquiry	ar-invoice-enquiry
Timetable	ar-timetable
Interfaces	ar-interfaces
Forms	ar-forms
Administration	ar-admin

Dashboard

---

• Aged debtors total (badge)
• Aged debtors by sub ledger (badge)
• Outstanding Invoices (badge)
• Number of disputed invoices (badge)

Customers

---

Classic report of all customers in eFinancials. Users have the ability to filter using the faceted search functionality.

The

• New Customer
• Customer List
• Customer Statement

Filters

The following filters are available on the Customers reports.

• Financial Year (LOV)
• Financial Period (tick-box)
• Customer (incl all)
• Marked for deletion (yes/no)
• On Stop (yes/no)

Aged Debtors

---

• [x] Aged Debtors page

  view/accounts-receivable/aged-debtors)

  sql

• Aged Debtors by sub ledger
• Aged Debtors by GL
• Aged Debtors by customer
• Aged Debtors by credit controller

Invoices

---

• Transactions
• Transactions by sub ledger
• Transacions by customer
• Transactions by financial year & period

Reports

---

The Reports section

Transactional Reports

• Debtor analysis by credit controller incl ageing buckets
• Debtor analysis by category incl ageing buckets
• Debtor analysis by business type incl ageing buckets
• Debtor analysis by payment status
• Debtor analysis by payment status

KPI Reports

• Invoices raised by financial year (compared to prior year)
• Invoices raised by period (based on current fin year)
• Invoices raised by customer qty (top 5,10 or user defined)
• Invoices raised by customer value (top 5,10 or user defined)
• Invoices raised by user (top 5,10 or user defined)
• Sales Invoices created by month
• Sales Invoices by customer
• Sales Invoices by division
• Sales Invoices by cost centre

Additional Reports

• Invoices past due date by reason for dispute, by month & year (user defined buckets)
• Overdue invoices by category type (user defined) into user defined buckets - up to 361+ days detail +summary
• Creditors grouped into categories e.g. NHS / Non-NHS / LA - grouping for AOB
• Invoice data extract by status type / value / aged bucket / comments field populated in eFin.
• Team KPIs - count & sum invoices processed/ query resolved by team member - rolling average & variance
• For user defined buckets up to 361+ days, invoice original value vs current for user defined date range
• Overseas debt by month & receipts as a % (calc)
• For a user defined date range movements and receipts
• By week / Month invoiced totals / value rec’d & rolling overseas debt plotted on a bar / line chart
• For a user defined date range OS invoices - cash received & write off values

Applications

Interfaces

Timetable

Forms

Audit

Administration

Core Reporting Fields

---

fields in reports (validate this against excel addin)

• transaction ref (comp ref)
• year
• period
• transaction type (SI etc)
• transaction sub type
• sub ledger
• customer code
• customer name (lookup to names table)
• customer receipt stop
• customer deleted yn
• customer job code (from customer setup screen) (lookup to name_for_sub_ledgers table)
• customer business type (ns_business_type) L=large S=small
• batch reference
• our ref (hyperlink to invoice image)
• invoice image link (document imaging - uses jboss)
• invoice image link (dbwebq - uses efin cgibin)
• their ref
• payment batch reference
• description
• region
• region name
• division
• division name
• category
• category name
• location
• location name
• receipted ??? (received on AC208S)
• payment terms
• payment term description
• dispute code
• dispute description
• credit controller
• credit controller name
• entry date
• trans date (invoice date)
• due date
• date paid
• days outstanding (calculated field) 30/4 10/5 sysdate - due date
• letter severity
• letter date
• originator
• orginator name
• division (maybe link in all hierarchies)
• division name
• chart of accounts - cc
• chart of accounts - ccc
• chart of accounts - act
• chart of accounts - job
• cc - Hierarchy based
• ccnHierarchy based
• ac Hierarchy based
• ac name Hierarchy based
• act Hierarchy based
• act name Hierarchy based
• job Hierarchy based
• job name Hierarchy based
• status
• vat code
• analysed amount (detail table)
• analysed vat (detail table)
• gross amount (calculated analysed amount+analysed vat)
• outstanding amount (sub_ledger_trans ????)
• write-off amount ??????? check slt table

customer notes -powerpad-notes customer files files

questions

do we need two reports. one by invoice number and total amount, the other including analsysis like cc/acc and analysed amounts. what does excel addin show????? no credit controller setup