Personal tools

Difference between revisions of "Reports"

From TrueERP wiki

Jump to: navigation, search
(→‎H)
 
(16 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
<menu name=myMenu align=center>
 
<menu name=myMenu align=center>
−
Related Items=
+
More Details=
−
[[Accounts Payable Notes Report|Accounts Payable Notes Report]]
+
−
[[Action Authorisations|Action Authorisations]]
+
−
[[Allowances Report|Allowances Report]]
+
−
[[Appointment Report|Appointment Report]]
+
−
[[Approval Reminder List|Approval Reminder List]]
+
−
[[Barcode Picking Manifest|Barcode Picking Manifest]]
+
 
[[Drill Down Reports|Drill Down Reports]]
 
[[Drill Down Reports|Drill Down Reports]]
 
[[Exporting Reports|Exporting Reports]]
 
[[Exporting Reports|Exporting Reports]]
Line 12: Line 6:
 
[[Report Printing Options|Report Printing Options]]
 
[[Report Printing Options|Report Printing Options]]
 
</menu>
 
</menu>
−
 
−
 
 
== Overview ==
 
== Overview ==
 
Each tab on the left of the main menu has its own list of specialised reports.  Select the link below for help on  
 
Each tab on the left of the main menu has its own list of specialised reports.  Select the link below for help on  
 
the relative reports or see the full list of reports.
 
the relative reports or see the full list of reports.
−
 
 
*[[Accounts Reports]]
 
*[[Accounts Reports]]
 
*[[Appointments Reports]]
 
*[[Appointments Reports]]
Line 133: Line 124:
  
 
===H===
 
===H===
−
*[[Hourly Sales Report]] - Summarises sales for defined time blocks (hours by default) without the need for running
+
*[[Hourly Sales Report]] - Summarises sales for defined time blocks (hours by default) without the need for running an End Of Period.  Report is not limited to POS sales.
−
an End Of Period.  Report is not limited to POS sales.
+
  
 
===I===
 
===I===
−
Invoice Backorders - List of backordered Invoices
+
*[[Invoice Backorders]] - List of backordered Invoices
  
 
===J===
 
===J===
−
Job Time Sheets<LinkId=1228> - List of job time sheet entries
+
*[[Job Time Sheets]] - List of job time sheet entries
  
 
===L===
 
===L===
−
Leads<LinkId=1236> - List of Leads
+
*[[Leads]] - List of Leads
−
Leave Accruals by Department - Leave accrued summarised by department
+
*[[Leave Accruals by Department]] - Leave accrued summarised by department
−
Leave Accrued - Leave accrued summarised by employee and leave type
+
*[[Leave Accrued]] - Leave accrued summarised by employee and leave type
−
Leave Accrued Details - List of transactions that make up current leave accruals
+
*[[Leave Accrued Details]] - List of transactions that make up current leave accruals
−
Leave Taken - Leave taken by pay
+
*[[Leave Taken]] - Leave taken by pay
−
Location List<LinkId=550> - List of Cities and postcodes
+
*[[Location List]] - List of Cities and postcodes
−
Loyalty Program List<LinkId=183>
+
*[[Loyalty Program List]]
  
 
===M===
 
===M===
−
Marketing_Action_List<LinkId=1231> - The Marketing Action List is a list of all actions recorded against any Lead
+
*[[Marketing Action List]] - The Marketing Action List is a list of all actions recorded against any Lead
−
Marketing_Contact_List<LinkId=175> - Use this list to view all marketing contacts
+
*[[Marketing Contact List]] - Use this list to view all marketing contacts
−
Manufacture Product List<LinkId=1226> - List of Manufactured Products with Bills of Material
+
*[[Manufacture Product List]] - List of Manufactured Products with Bills of Material
−
Marketing Ratio Report<LinkId=1116> - List of calls with ratios of different resulting actions
+
*[[Marketing Ratio Report]] - List of calls with ratios of different resulting actions
−
Memorised Transaction List<LinkId=131> - List of unposted memorised transactions
+
*[[Memorised Transaction List]] - List of unposted memorised transactions
  
 
===O===
 
===O===
−
Orders From Stock<LinkId=1227> - List of orders for Manufactured products that can be taken from stock
+
*[[Orders From Stock]] - List of orders for Manufactured products that can be taken from stock
  
 
===P===
 
===P===
−
Pay History<LinkId=153> - List of past pays
+
*[[Pay History]] - List of past pays
−
Pay Rates<LinkId=159> - List of Pay Rates available
+
*[[Pay Rates]] - List of Pay Rates available
−
PAYG Payment Summary<LinkId=325> - PAYG details by employee and financial year.   
+
*[[PAYG Payment Summary]] - PAYG details by employee and financial year.   
−
Payroll Jobs - Employee pay details by job
+
*[[Payroll Jobs]] - Employee pay details by job
−
Payroll Reconciliation Report - Summary of Pays by month
+
*[[Payroll Reconciliation Report]] - Summary of Pays by month
−
Phone Contact/Follow Up List  
+
*[[Phone Contact/Follow Up List]]
−
POS End Of Period Report - Report summarising when End Of Period has been run for each Till
+
*[[POS End Of Period Report]] - Report summarising when End Of Period has been run for each Till
−
Price Scheme Best Price - This report lists all products in price schemes and displays the price and savings information
+
*[[Price Scheme Best Price]] - This report lists all products in price schemes and displays the price and savings information
−
Product Commission List - List of products on which commission is paid including commission rate
+
*[[Product Commission List]] - List of products on which commission is paid including commission rate
−
Product Formula List - List of formula available for products
+
*[[Product Formula List]] - List of formula available for products
−
Product List<LinkId=1202> - List of all Products. Can be viewed as Product Express List or full Product List
+
*[[Product List]] - List of all Products. Can be viewed as Product Express List or full Product List
−
Product Movement Report - Shows all movements (buy sell etc) for a selected product
+
*[[Product Movement Report]] - Shows all movements (buy sell etc) for a selected product
−
Product Report - Product Sales Projection based on past sales
+
*[[Product Report]] - Product Sales Projection based on past sales
−
Product Reward Points List - List showing details of products with reward points attached
+
*[[Product Reward Points List]] - List showing details of products with reward points attached
−
Product Sales Projection - Forward projection of sales based on past sales
+
*[[Product Sales Projection]] - Forward projection of sales based on past sales
−
Product Sales Summary - List of sales by product with summary and detail filters
+
*[[Product Sales Summary]] - List of sales by product with summary and detail filters
−
Product Sales Summary (By Column) - Summary of sales by product showing margins
+
*[[Product Sales Summary (By Column)]] - Summary of sales by product showing margins
−
Product Express List<LinkId=4> - List of all products
+
*[[Product Express List]] - List of all products
−
Production Job List - List of all Production Jobs
+
*[[Production Job List]] - List of all Production Jobs
−
Production Job Status<LinkId=172> - List of Production Jobs by Status
+
*[[Production Job Status]] - List of Production Jobs by Status
−
Production Parts List - List of all parts required for production jobs
+
*[[Production Parts List]] - List of all parts required for production jobs
−
Production Parts Status<LinkId=70> - List of parts required for production jobs with availability and Purchase  
+
*[[Production Parts Status]] - List of parts required for production jobs with availability and Purchase Order details
−
Order details
+
*[[Products List (Reorder)]] - List of all products showing reorder points
−
Products List (Reorder) - List of all products showing reorder points
+
*[[Prospect List]]
−
Prospect List<LinkId=1115>
+
*[[Profit & Loss]] - Full Profit & Loss report as described above
−
Profit & Loss<LinkId=17> - Full Profit & Loss report as described above
+
*[[Profit & Loss (By Period)]] - Full Profit & Loss report with comparison periods (Month, Quarter or Year).  eg. you can compare income in the Profit and Loss for the current month, with revenue from the previous month.
−
Profit & Loss (By Period) - Full Profit & Loss report with comparison periods (Month, Quarter or Year).  eg.
+
*[[Profit & loss Summary]] - Profit & Loss Totals only with comparison by various period selections from daily up to a full year.
−
you can compare income in the Profit and Loss for the current month, with revenue from the previous month.
+
*[[Purchase Order Backorders]] - List of back ordered purchase order line items
−
Profit & loss Summary - Profit & Loss Totals only with comparison by various period selections from daily up to
+
*[[Purchase Order List]] - List of all purchase orders
−
a full year.
+
−
Purchase Order Backorders<LinkId=1252> - List of back ordered purchase order line items
+
−
Purchase Order List<LinkId=1248> - List of all purchase orders
+
  
 
===Q===
 
===Q===
−
Quote Details Report - List of quote line items  
+
*[[Quote Details Report]] - List of quote line items  
−
Quote_List<LinkId=216> - List of Quotes with filters for Converted and Completed
+
*[[Quote_List]] - List of Quotes with filters for Converted and Completed
−
Quote Status Report - List of Quotes with filters for Converted and Completed
+
*[[Quote Status Report]] - List of Quotes with filters for Converted and Completed
  
 
===R===
 
===R===
−
Raw Marketing Contact List - List of unfiltered Marketing Contacts  
+
*[[Raw Marketing Contact List]] - List of unfiltered Marketing Contacts  
−
Reconciliation List<LinkId=59> - List of completed and Held reconciliations
+
*[[Reconciliation List]] - List of completed and Held reconciliations
−
Reconciliation List (Details) - List of reconciliations with transaction details
+
*[[Reconciliation List (Details)]] - List of reconciliations with transaction details
−
Repairs List<LinkId=1204> - List of all repairs with multiple filter options and date range
+
*[[Repairs List]] - List of all repairs with multiple filter options and date range
−
Repairs List (Invoice)<LinkId=260> - List of repairs with drillable details of invoices issued
+
*[[Repairs List (Invoice)]] - List of repairs with drillable details of invoices issued
−
Resource List<LinkId=66> - List of Production Resources with capacity details
+
*[[Resource List]] - List of Production Resources with capacity details
−
Resource Unavailability<LinkId=67> - List of scheduled unavailability of resources
+
*[[Resource Unavailability]] - List of scheduled unavailability of resources
−
Return Authority List<LinkId=206> - List of return authorities
+
*[[Return Authority List]] - List of return authorities
−
Rep Ability List - List of relative skill or ability levels for reps.  These are defined by you.
+
*[[Rep Ability List]] - List of relative skill or ability levels for reps.  These are defined by you.
−
Rep List<LinkId=81> - List of all Reps
+
*[[Rep List]] - List of all Reps
−
Roster List<LinkId=1149> - List of Clocked On and Clocked Off employees
+
*[[Roster List]] - List of Clocked On and Clocked Off employees
  
 
===S===
 
===S===
−
Sales Commission - List of individual transactions resulting in commissions for employees
+
*[[Sales Commission]] - List of individual transactions resulting in commissions for employees
−
Sales List - List of all sales transactions (Sales Order, Invoice, POS and Cash Sale)
+
*[[Sales List]] - List of all sales transactions (Sales Order, Invoice, POS and Cash Sale)
−
Sales Order Backorders - List of all backordered Sales Orders
+
*[[Sales Order Backorders]] - List of all backordered Sales Orders
−
Sales_Order_List<LinkId=219> - List of all Sales Orders
+
*[[Sales Order List]] - List of all Sales Orders
−
Sales_Pipeline_Report<LinkId=1240> - summary activity by the Quote/Lead Status<LinkId=1237> of each Lead or Quote.
+
*[[Sales Pipeline Report]] - summary activity by the [[Quote/Lead Status]] of each Lead or Quote.
−
Sales Ratios Report<LinkId=1117>- Report of sales ratios by employee
+
*[[Sales Ratios Report]]- Report of sales ratios by employee
−
Sales Report - List of all completed Sales Transactions (ie. excluding Sales Orders)
+
*[[Sales Report]] - List of all completed Sales Transactions (ie. excluding Sales Orders)
−
Sales Reward Points - List of customers with reward points accrued
+
*[[Sales Reward Points]] - List of customers with reward points accrued
−
Sales Summary Report - Summary of Sales by various periods (day, weekday, week, month,etc
+
*[[Sales Summary Report]] - Summary of Sales by various periods (day, weekday, week, month,etc
−
Serial Numbers<LinkId=122> - All Serial Number transactions within ERP
+
*[[Serial Numbers]] - All Serial Number transactions within ERP
−
Service Log List<LinkId=101> - List of service history for each Fixed asset
+
*[[Service Log List]] - List of service history for each Fixed asset
−
Shipping Agent List - List of Shipping Agents
+
*[[Shipping Agent List]] - List of Shipping Agents
−
Shipping List<LinkId=134> - List of available shipping methods
+
*[[Shipping List]] - List of available shipping methods
−
Smart Order List<LinkId=202> - List of all smart orders
+
*[[Smart Order List]] - List of all smart orders
−
SourceList<LinkId=74> - List of contact sources available
+
*[[SourceList]] - List of contact sources available
−
Statements<LinkId=187> - Listing of Invoices and Payments that appear on statements for the selected date range.  
+
*[[Statements]] - Listing of Invoices and Payments that appear on statements for the selected date range.  
−
See Print Statements<LinkId=197>
+
*[[See Print Statements]]
−
Stock Adjustment List<LinkId=1219> - List of all stock adjustment and stocktake transactions
+
*[[Stock Adjustment List]] - List of all stock adjustment and stocktake transactions
−
Stock Movement Status - Report showing current stock and stock movement for each product
+
*[[Stock Movement Status]] - Report showing current stock and stock movement for each product
−
Stock Quantities & Location Report - Product list showing stock by bins, batches and serial numbers
+
*[[Stock Quantities & Location Report]] - Product list showing stock by bins, batches and serial numbers
−
Stock Status Report - Stock movement by transaction type and filtered by periods (day, week, month etc)
+
*[[Stock Status Report]] - Stock movement by transaction type and filtered by periods (day, week, month etc)
−
Stock Transfer List<LinkId=1221> - List of all stock transfer transactions
+
*[[Stock Transfer List]] - List of all stock transfer transactions
−
Stock Turnover Report - Summary of turnover by product for a date range
+
*[[Stock Turnover Report]] - Summary of turnover by product for a date range
−
Summary Sheet<LinkId=16> - Summary of financial information including current Balance sheet total, aged payable and  
+
*[[Summary Sheet]] - Summary of financial information including current Balance sheet total, aged payable and receivables and Profit and Loss comparisons for prior periods of Last Week, Last Month, Last 3 Months and Last 12 Months
−
receivables and Profit and Loss comparisons for prior periods of Last Week, Last Month, Last 3 Months and Last
+
*[[Super by Fund Report]] - Superannuation Liabilities by fund/Emplyee/account
−
12 Months
+
*[[Supplier List]] - List of all suppliers
−
Super by Fund Report - Superannuation Liabilities by fund/Emplyee/account
+
*[[Supplier Payment List]] - List of all Supplier Payments
−
Supplier List<LinkId=199> - List of all suppliers
+
*[[Supplier Prepayment List]] - List of all Supplier Prepayments
−
Supplier Payment List<LinkId=195> - List of all Supplier Payments
+
*[[Supplier Product Report]] - List of purchases by supplier  
−
Supplier Prepayment List<LinkId=192> - List of all Supplier Prepayments
+
*[[Supplier Report]] - Summary of amounts spent with each supplier
−
Supplier Product Report - List of purchases by supplier  
+
*[[Supplier Statement]] - List of transactions by suplier
−
Supplier Report - Summary of amounts spent with each supplier
+
*[[Support Log List]] - List of support calls showing issue and resolution
−
Supplier Statement - List of transactions by suplier
+
−
Support Log List - List of support calls showing issue and resolution
+
  
 
===T===
 
===T===
−
Tax Code List<LinkId=139> - List of tax codes for GST/VAT
+
*[[Tax Code List]] - List of tax codes for GST/VAT
−
Tax Scales<LinkId=22> - Current PAYG Tax Scales
+
*[[Tax Scales]] - Current PAYG Tax Scales
−
Tax Summary - Listing of tax codes and corresponding amounts for a selected date range
+
*[[Tax Summary]] - Listing of tax codes and corresponding amounts for a selected date range
−
To Be Reconciled - List of unreconciled items
+
*[[To Be Reconciled]] - List of unreconciled items
−
Telemarketing_List<LinkId=1233> - List of all telemarketing calls made
+
*[[Telemarketing List]] - List of all telemarketing calls made
−
Terms List<LinkId=136> - List of payment terms available
+
*[[Terms List]] - List of payment terms available
−
Till Summary Report - Summary of transactions and payment types by Till
+
*[[Till Summary Report]] - Summary of transactions and payment types by Till
−
Timesheet Pays - List of timesheets filtered by Current or Converted to Pay
+
*[[Timesheet Pays]] - List of timesheets filtered by Current or Converted to Pay
−
To Do List<LinkId=83> - List of items on an employees To Do List
+
*[[To Do List]] - List of items on an employees To Do List
−
Traffic List - Traffic count per hour by branch (requires a traffic sensor to be connected to ERP)
+
*[[Traffic List]] - Traffic count per hour by branch (requires a traffic sensor to be connected to ERP)
−
Traffic Summary - Traffic Monitoring Summary shows traffic by branch for selected period (Day, Weeks etc)
+
*[[Traffic Summary]] - Traffic Monitoring Summary shows traffic by branch for selected period (Day, Weeks etc)
−
Transaction Journal<LinkId=1277> - Listing of all transactions for a selected period of time with detail of all associated  
+
*[[Transaction Journal]] - Listing of all transactions for a selected period of time with detail of all associated account postings
−
account postings
+
*[[Transactions with 0 Quantity]] - Report showing any saved transactions with a zero quantity in a line
−
Transactions with 0 Quantity - Report showing any saved transactions with a zero quantity in a line
+
*[[Trial Balance]] - Listing of accounts and their balances as well as a total of debits and credits for a period of time.  This is a snapshop of balances to demonstrate that all all account postings balance.
−
Trial Balance<LinkId=21> - Listing of accounts and their balances as well as a total of debits and credits for a period of  
+
−
time.  This is a snapshop of balances to demonstrate that all all account postings balance.
+
  
 
===U===
 
===U===
−
UnAllocated Bins Report -  
+
*[[UnAllocated Bins Report]] -  
−
Unassigned Tax Codes - Listing of any transactions that have been created without a tax code.  A tax code is  
+
*[[Unassigned Tax Codes]] - Listing of any transactions that have been created without a tax code.  A tax code is essential on all transactions to ensure BAS or VAT returns can include all necessary transactions.
−
essential on all transactions to ensure BAS or VAT returns can include all necessary transactions.
+
*[[Unbalanced Bin Quantities]] - List of products where the stock doesn't match the bin allocations
−
Unbalanced Bin Quantities - List of products where the stock doesn't match the bin allocations
+
*[[Units of Measure List]] - List of Units Of Measure created  
−
Units of Measure List - List of Units Of Measure created  
+
*[[Un-Invoiced Customer Purchased Items]] - List of purchase order lines with no invoice recorded
−
Un-Invoiced Customer Purchased Items - List of purchase order lines with no invoice recorded
+
*[[Un-Invoiced Purchase Orders]] - List of purchse orders with no invoice recorded
−
Un-Invoiced Purchase Orders - List of purchse orders with no invoice recorded
+
*[[Unpaid Bills]] - This is a simplified creditors report that has the advantage of being faster to produce than a full [[Accounts Payable Report]]
−
Unpaid Bills - This is a simplified creditors report that has the advantage of being faster to produce than a full
+
−
Accounts Payable Report
+
  
 
===V===
 
===V===
−
Vouchers List - List of vouchers issued with details
+
*[[Vouchers List]] - List of vouchers issued with details
  
 
===W===
 
===W===
−
Wages Journal - List of Journals posts created by Pays
+
*[[Wages Journal]] - List of Journals posts created by Pays
−
Warranty/Insurance Policy Report<LinkId=102> - List of Fixed assets with standard filters for No Insurance and No Warranty
+
*[[Warranty/Insurance Policy Report]] - List of Fixed assets with standard filters for No Insurance and No Warranty

Latest revision as of 11:28, 19 January 2011

Overview

Each tab on the left of the main menu has its own list of specialised reports. Select the link below for help on the relative reports or see the full list of reports.

Alphabetical List of Reports

A


B

C


D

E

F

G

  • General Ledger - Listing of all transactions by account for a selected period with options for:
    • Summary - Totals Only
    • Details - Subtotals by transaction type
    • Extra Details - Full transaction listing
  • Global List - List of all entities in ERP from Employees to customers and suppliers and marketing

H

  • Hourly Sales Report - Summarises sales for defined time blocks (hours by default) without the need for running an End Of Period. Report is not limited to POS sales.

I

J

L

M

O

  • Orders From Stock - List of orders for Manufactured products that can be taken from stock

P

Q

R

S

T

  • Tax Code List - List of tax codes for GST/VAT
  • Tax Scales - Current PAYG Tax Scales
  • Tax Summary - Listing of tax codes and corresponding amounts for a selected date range
  • To Be Reconciled - List of unreconciled items
  • Telemarketing List - List of all telemarketing calls made
  • Terms List - List of payment terms available
  • Till Summary Report - Summary of transactions and payment types by Till
  • Timesheet Pays - List of timesheets filtered by Current or Converted to Pay
  • To Do List - List of items on an employees To Do List
  • Traffic List - Traffic count per hour by branch (requires a traffic sensor to be connected to ERP)
  • Traffic Summary - Traffic Monitoring Summary shows traffic by branch for selected period (Day, Weeks etc)
  • Transaction Journal - Listing of all transactions for a selected period of time with detail of all associated account postings
  • Transactions with 0 Quantity - Report showing any saved transactions with a zero quantity in a line
  • Trial Balance - Listing of accounts and their balances as well as a total of debits and credits for a period of time. This is a snapshop of balances to demonstrate that all all account postings balance.

U

V

W