9 Zoom In - Revision history

Angelica at 18:39, 17 December 2014

2014-12-17T18:39:22Z

BethD: Replaced content with "Can you drill into transactions? Yes, The ability to drill down to view each transaction, all the way down to the original transaction, within ERP Reports is a valuable t..."

2014-12-10T13:59:17Z

Replaced content with "Can you drill into transactions? Yes, The ability to drill down to view each transaction, all the way down to the original transaction, within ERP Reports is a valuable t..."

Simon Clive: Created page with "Zoom In Can you drill into the transactions? Summary - This displays Outstanding Balances Details - This displays Outstanding Balances by Transaction type, e.g...."

2011-06-28T22:59:01Z

Created page with "Zoom In Can you drill into the transactions? Summary - This displays Outstanding Balances Details - This displays Outstanding Balances by Transaction type, e.g...."

New page

Zoom In

Can you drill into the transactions?

Summary - This displays Outstanding Balances
Details - This displays Outstanding Balances by Transaction type, e.g. Invoice
Extra Details - This displays Outstanding Balances by Invoice etc. including all information regarding the transaction
such as Invoice numbers.

In extra details you can 'drill down' to view the source transactions, by simply double clicking on the line.

Drillable Reports

The ability to drill down to view each transaction, all the way down to the original transaction, within ERP Reports
is a valuable tool. The time saved in identifying what an amount in one of your key reports is made up of
is invaluable to any growing, efficiency-conscious business.

How to Drill Down into Reports

Reports should be studied by each User in an effort to work out what reports relate best to your needs. This applies
to all Reports within the ERP database.

There are a few basic rules that apply to ERP Reports. These are as follows:

Filtering; Searching; Exporting; Customising; Printing; are all standard features of ERP reports.

Reports are either Real Time, As At a particular point in time, e.g. Balance Sheet and Trial Balance Reports
(this can be both). OR they are Date Range / Custom Range specific, meaning data can be viewed for a
particular time frame.

Some reports can be viewed in Summary, Detail or Extra Detail modes.

Report figures are drillable, i.e. you can drill into the transaction

The Accounts Receivable Report will load in Summary mode.

As stated above, Reports that can be viewed in Summary, Details and Extra Details mode are only drillable in
Extra Details mode.

Select the Extra Details radio button to load the transactions that make up the total figures for each Customer.
The figures in bold are the total (header) amounts due per Customer, you cannot drill into these.

The amounts of each individual transaction detailed per Customer can be drilled into.
Double-click on an amount
What makes up this amount will then be displayed on screen, eg an invoice

From within the Details on a report you can continue to drill-down until you get to the original transaction that makes
up the amount
Double-click to open the Reconciliation of this Deposit.
The Reconciliation that this Deposit was reconciled in will load.

Can you customise the appearance of drillable reports generated from the lists. Sales Order List, Invoice List,
Purchase Orders List, etc?

Open the report
You can click onto the Column header which will sort up or down, the hand indicates which way
You can left mouse click and hold the mouse on a column header, then drag the column and place it where you want it.
Select Customise tab at the bottom
Untick what you do not want to see on the report, and tick what you would like to see
Select the Custom Report Tab
Enter a Report Name
Then select Create Custom Report
This will then save the report into My Reports, Now when you go into the Report selector a radio button called My Reports
Will be available that will hold all custom reports saved.
Note: if you choose a Report Selector Tab (optional) this will mean the custom report will open in the tab you choose, eg Appointments
Leave this blank to save the reports to My Reports.

← Older revision		Revision as of 18:39, 17 December 2014
Line 1:		Line 1:
−	~~Can you drill into transactions?~~	+	'''Zoom In'''

−	Yes, ~~The~~ ability to drill down to view each transaction, all the way down to the original transaction, within ERP Reports is a valuable tool. The time saved in identifying what an amount in one of your key reports is made up of is invaluable to any growing, efficiency-conscious business.	+	'''Can you drill into transactions?'''
		+
		+	Yes, the ability to '''drill down''' to view each transaction, all the way down to the original transaction, within ERP Reports is a valuable tool. The time saved in identifying what an amount in one of your key reports is made up of is invaluable to any growing, efficiency-conscious business.

@@ Line 1: / Line 1: @@
-Zoom In
+Can you drill into transactions?
-Can you drill into the transactions?
+Yes, The ability to drill down to view each transaction, all the way down to the original transaction, within ERP Reports is a valuable tool. The time saved in identifying what an amount in one of your key reports is made up of is invaluable to any growing, efficiency-conscious business.
-−
-Summary       - This displays Outstanding Balances
-Details           - This displays Outstanding Balances by Transaction type, e.g. Invoice
-Extra Details  - This displays Outstanding Balances by Invoice etc. including all information regarding the transaction
-	                       such as Invoice numbers.
-−
-In extra details you can 'drill down' to view the source transactions, by simply double clicking on the line.
-−
-Drillable Reports
-−
 The ability to drill down to view each transaction, all the way down to the original transaction, within ERP Reports
 is a valuable tool. The time saved in identifying what an amount in one of your key reports is made up of
-is invaluable to any growing, efficiency-conscious business.
-−
-How to Drill Down into Reports
-−
-Reports should be studied by each User in an effort to work out what reports relate best to your needs. This applies
-to all Reports within the ERP database.
-−
-There are a few basic rules that apply to ERP Reports. These are as follows:
-−
-Filtering; Searching; Exporting; Customising; Printing; are all standard features of ERP reports.
-−
-Reports are either Real Time, As At a particular point in time, e.g. Balance Sheet and Trial Balance Reports
-	(this can be both). OR they are Date Range / Custom Range specific, meaning data can be viewed for a
-	particular time frame.
-−
-Some reports can be viewed in Summary, Detail or Extra Detail modes.
-−
-Report figures are drillable, i.e. you can drill into the transaction
-−
-The Accounts Receivable Report will load in Summary mode.
-−
-As stated above, Reports that can be viewed in Summary, Details and Extra Details mode are only drillable in
-Extra Details mode.
-−
-Select the Extra Details radio button to load the transactions that make up the total figures for each Customer.
-The figures in bold are the total (header) amounts due per Customer, you cannot drill into these.
-−
-The amounts of each individual transaction detailed per Customer can be drilled into.
-Double-click on an amount
-What makes up this amount will then be displayed on screen, eg an invoice
-−
-From within the Details on a report you can continue to drill-down until you get to the original transaction that makes
-	up the amount
-Double-click to open the Reconciliation of this Deposit.
-The Reconciliation that this Deposit was reconciled in will load.
-−
-−
-Can you customise the appearance of drillable reports generated from the lists. Sales Order List, Invoice List,
-Purchase Orders List, etc?
-−
-Open the report
-You can click onto the Column header which will sort up or down, the hand indicates which way
-You can left mouse click and hold the mouse on a column header, then drag the column and place it where you want it.
-Select Customise tab at the bottom
-Untick what you do not want to see on the report, and tick what you would like to see
-Select the Custom Report Tab
-Enter a Report Name
-Then select Create Custom Report
-This will then save the report into My Reports, Now when you go into the Report selector a radio button called My Reports
-	Will be available that will hold all custom reports saved.
-Note: if you choose a Report Selector Tab (optional) this will mean the custom report will open in the tab you choose, eg Appointments
-Leave this blank to save the reports to My Reports.