Personal tools

Difference between revisions of "Reports"

From TrueERP wiki

Jump to: navigation, search
(= D=)
(D)
Line 100: Line 100:
 
===D===
 
===D===
  
Deduction Report - Report of deductions paid to employees in pays for a given date range
+
*[[Deduction Report]] - Report of deductions paid to employees in pays for a given date range
Deductions<LinkId=163> - List of available deductions
+
*[[Deductions]] - List of available deductions
Departments List<LinkId=135> - List of all departments  
+
*[[Departments List]] - List of all departments  
Deposited List<LinkId=53> - List of Bank Deposits
+
*[[Deposited List]] - List of Bank Deposits
  
 
===E===
 
===E===

Revision as of 13:01, 12 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

Employee Analysis - Summary of chargable and non chargeable hours per employee by job Employee Fixed Assets - List of Fixed Assets in the possesion of an employee Employee List<LinkId=86> - List of all employees Employee Summary<LinkId=84> - Summary of invoiced amounts by employee Employee Summary by Period - Comparison of invoiced amounts by employee on a period by period End of Period Summary - End of Period is run at the end of a shift or more often and summarises all transactions by employee Equipment List<LinkId=1206>- List of "Generic" Equipment ie. General details of equipment without specific item or ownership details. ETP Report - Terminated Employees ETP details Expense Claims - List of payments linked to an employee expense

F

Feedback Report<LinkId=1124> - List of customers on Support List with Feedback notes Fixed Asset Types<LinkId=99> - List of the Assert Types as defined by you Fixed Asset Details Report - List of Fixed Assets with details of each depreciation transaction Fixed Assets List<LinkId=97> - List of Fixed Assets with details of warranties and insurances Foreign Exchange Rates List<LinkId=138> - List of Foreign Exchange Rates showing Active or Not Active Foreign Purchase Report - List of purchases in foreign currency Foreign Sales Report - List of sales transacted in a Foreign Currency

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

Invoice Backorders - List of backordered Invoices

J

Job Time Sheets<LinkId=1228> - List of job time sheet entries

L

Leads<LinkId=1236> - List of Leads Leave Accruals by Department - Leave accrued summarised by department Leave Accrued - Leave accrued summarised by employee and leave type Leave Accrued Details - List of transactions that make up current leave accruals Leave Taken - Leave taken by pay Location List<LinkId=550> - List of Cities and postcodes Loyalty Program List<LinkId=183>

M

Marketing_Action_List<LinkId=1231> - 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 Manufacture Product List<LinkId=1226> - List of Manufactured Products with Bills of Material Marketing Ratio Report<LinkId=1116> - List of calls with ratios of different resulting actions Memorised Transaction List<LinkId=131> - List of unposted memorised transactions

O

Orders From Stock<LinkId=1227> - List of orders for Manufactured products that can be taken from stock

P

Pay History<LinkId=153> - List of past pays Pay Rates<LinkId=159> - List of Pay Rates available PAYG Payment Summary<LinkId=325> - PAYG details by employee and financial year. Payroll Jobs - Employee pay details by job Payroll Reconciliation Report - Summary of Pays by month Phone Contact/Follow Up List 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 Product Commission List - List of products on which commission is paid including commission rate 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 Movement Report - Shows all movements (buy sell etc) for a selected product Product Report - Product Sales Projection based on past sales 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 Summary - List of sales by product with summary and detail filters Product Sales Summary (By Column) - Summary of sales by product showing margins Product Express List<LinkId=4> - List of all products Production Job List - List of all Production Jobs Production Job Status<LinkId=172> - List of Production Jobs by Status 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 Order details Products List (Reorder) - List of all products showing reorder points Prospect List<LinkId=1115> 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 Summary - Profit & Loss Totals only with comparison by various period selections from daily up to 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

Quote Details Report - List of quote line items Quote_List<LinkId=216> - List of Quotes with filters for Converted and Completed Quote Status Report - List of Quotes with filters for Converted and Completed

R

Raw Marketing Contact List - List of unfiltered Marketing Contacts Reconciliation List<LinkId=59> - List of completed and Held reconciliations 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 (Invoice)<LinkId=260> - List of repairs with drillable details of invoices issued Resource List<LinkId=66> - List of Production Resources with capacity details Resource Unavailability<LinkId=67> - List of scheduled unavailability of resources Return Authority List<LinkId=206> - List of return authorities 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 Roster List<LinkId=1149> - List of Clocked On and Clocked Off employees

S

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 Order Backorders - List of all backordered Sales Orders Sales_Order_List<LinkId=219> - 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 Ratios Report<LinkId=1117>- Report of sales ratios by employee Sales Report - List of all completed Sales Transactions (ie. excluding Sales Orders) Sales Reward Points - List of customers with reward points accrued Sales Summary Report - Summary of Sales by various periods (day, weekday, week, month,etc Serial Numbers<LinkId=122> - All Serial Number transactions within ERP Service Log List<LinkId=101> - List of service history for each Fixed asset Shipping Agent List - List of Shipping Agents Shipping List<LinkId=134> - List of available shipping methods Smart Order List<LinkId=202> - List of all smart orders SourceList<LinkId=74> - List of contact sources available Statements<LinkId=187> - Listing of Invoices and Payments that appear on statements for the selected date range. See Print Statements<LinkId=197> Stock Adjustment List<LinkId=1219> - List of all stock adjustment and stocktake transactions 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 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 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 receivables and Profit and Loss comparisons for prior periods of Last Week, Last Month, Last 3 Months and Last 12 Months Super by Fund Report - Superannuation Liabilities by fund/Emplyee/account Supplier List<LinkId=199> - List of all suppliers Supplier Payment List<LinkId=195> - List of all Supplier Payments Supplier Prepayment List<LinkId=192> - List of all Supplier Prepayments Supplier Product Report - List of purchases by supplier Supplier Report - Summary of amounts spent with each supplier Supplier Statement - List of transactions by suplier Support Log List - List of support calls showing issue and resolution

T

Tax Code List<LinkId=139> - List of tax codes for GST/VAT Tax Scales<LinkId=22> - 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<LinkId=1233> - List of all telemarketing calls made Terms List<LinkId=136> - 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<LinkId=83> - 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<LinkId=1277> - 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<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

UnAllocated Bins Report - 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. 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 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 Unpaid Bills - This is a simplified creditors report that has the advantage of being faster to produce than a full Accounts Payable Report

V

Vouchers List - List of vouchers issued with details

W

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