To run list reports select the form report option from the Readysell 8 navigation bar. List reports require selection of both a report and a query filter. Find the report category and report name in the last as specified for each report below. Highlight the required report. Then highlight the required Query Filter then click on the 'Show Report Using Filter' button to run the report. When the report is complete a list will show on the screen including all details from the report. Click on the Export button to send the report to Excel if required.
You can copy list reports and change their contents. You can also copy and modify the saved query filters for list reports.
List reports also allow you to add columns to the generated report and change the headings and subtotals in away similar to an excel pivot table.
How to run each report is described below as follows :-
User: [PrimaryUser],
Run In Place: [Yes/No]
Report Type: [Form/List]
Data Type: [The file from which the data is extracted. For example Suppliers],
Filter By: [Parameters that can be used to limit the data printed on the report]
Group By: [Field used for subheadings and subtotals]
Sort By: [Sorting by fields]
Columns: [Data printed on the report]
Notes: [Notes about report usage]
Report Name: General Ledger Extract for Bank Reconciliations
User: Regina,
Run In Place: No
Report Type: List,
Data Type: Dissection,
Filter By: Date Range (User Entered), AccountSite, Supplier
Group By: None
Sort By: Date (Ascending)
Columns: Date,Transaction Type,Transaction Number,Description,AccountSite,Debit Amount,Credit Amount
Notes: Used with “Monthly Sales Reconciliation Report” - make sure that all the relevant fields from that report are on this report.
Report Name: Monthly Sales Reconciliation Report
User: Regina
Report Type: Form
Data Type: Purchase Invoice
Filter By: Date Range (User Entered) Card (User Entered)
Group By: None
Sort By: Date (Ascending)
Columns: Date,Transaction Number,SaleInvoice.Transaction Number,SaleInvoice.CardID,SaleInvoice.CustomerName,Supplier Invoice,ValueExTax,ValueIncTax, Dissection.Account
Notes: :D
Report Name: Bank Reconciliation Report
User: Regina
Report Type: Form
Data Type: Banking
Filter By:Date Range (User Entered)
Group By:Transaction Type
Sort By:Date (Ascending)
Columns:Date,Card ID,Card Name,Description,Transaction Type,Transaction Number,Value
Notes: Spreadsheet in John’s Email wpacbankrec31may2010v2
Report Name: Purchase Receipt Liability Reconciliation Report (AKA Purchase order accrual)
User: Erlinda
Report Type: Form
Data Type: Purchase Receipts
Filter By: IsFullyInvoiced = False
Group By:None
Sort By:Date (Ascending)
Columns:Transaction Number,Supplier,???
Notes: Make sure that the filters on the Purchase Order/Purchase Receipt screens are working correctly. Create something similar for sales orders that have not been shipped.
Report Name: GST Report
User: Erlinda
Report Type: Form
Data Type: GST Item
Filter By: ???
Group By:???
Sort By:Date (Ascending),
Columns:???
Notes: Create a report that replicates the GST Items “Group by BAS Code” view
Report Name: Customer Trial Balance (Summary) Report - Debtors Aging Report
User:
Report Type: Form
Data Type: Card
Filter By:None,Optional Filter: “With Credit Balances” (if any of the balances are negative)
Group By:???
Sort By:Card ID
Columns:Card ID,Customer Balance Current,Customer Balance 30 Days,Customer Balance 60 Days,Customer Balance 90 Days,Customer Balance 120 Days, Customer Balance Total,Customer Balance Forward
Notes: Total for all customers at the bottom
Report Name: Customer Trial Balance (Detail) Report - Debtors Aging Report
...
User: Erlinda
Report Type: Form View
Notes:To be Exported/Printed from Form View. Need to implement the “Expand All Nodes” button to make this easier though. Export of Tree Form not showing in correct order.
Report Name: General Ledger Trial Balance
User: Erlinda
Report Type: Form
Data Type: Account
Filter By:None
Group By:None
Sort By:Account ID
Columns:Account ID,Account Name,Opening Balance,Closing Balance,Movement
Notes:
Report Name: Customer Statement
...
Report Name: Sales Invoice
User:
Report Type: Form
Notes:
? “TI Number” should be “Invoice Number”
? “Bill To” and “Deliver To” should be shown in relevant boxes
? Don’t show “Tax Rate” and “Tax Value” for each column. Only show total GST Value for the whole sale down the bottom.
? Indicator on the line for GST inclusive items
? “Invoice Total” should be Subtotal
? Total values at the bottom need to have a $ sign
? Change “Shipping Instructions” to “Notes” and make it a box with set bounds (globally)
? Make sure the supplier invoice number is on here
Report Name: Purchase Order (Head Office Purchase)
User:
Report Type: Form
Notes: Same as Head Office sale except remove the bits only relevant to Sale Orders
Report Name: Purchase Order (Head Office Sale)
User: Trudi
Report Type: Form
Notes:
? Header Page: Put logo on a line on its own and put text underneath
? Shuffle supplier details to the windowed area
? Move the customer details to the top right and leave “Deliver To” in the bottom right
? Fix column widths
? $ sign for total
? “Total of Order Ex Tax” can be “Total Ex Tax”
Report Name: General Journal
...
User:
Report Type: Form
Notes:Remove interal invoice number, irrelevant to supplier
Report Name: Bank Deposit Report
User:
Report Type: Form
Data Type: Customer Payment
Filter:Date Range (User Entered), Tender is Cheque
Fields:Date, Transaction Number, Card ID, Description, Value
Notes:There is a jira for “Additional Cheque Details” which should also be included on this report
Report Name: Debtor Interest Charges
User:
Report Type: Form
Data Type: Sales Invoice
Filter:Customers with Outstanding Invoices that are 10 days overdue
Fields: Date, Transaction Number, Due Date, Days Overdue, Customer.ID, Customer.Customer Name, Total Invoice Value, Outstanding Invoice Value, Interest Value (2.6% per month overdue on outstanding value)
Notes: To determine how much interest has to be charged
Report Name: Customer Back Order Report
User:
Report Type: Form
Data Type: Sale Order Lines
Filter: Quantity Backordered > 0
Fields:SaleOrder.TransactionNumber, SaleOrder.CustomerID, SaleOrder.Customer Name, SaleOrder.PurchaseOrder.SupplierID,SaleOrder.PurchaseOrder.Supplier Name,Product, Product Name, Quantity Ordered,Value Ordered, Quantity Backordered, Value Backordered
Notes:
Report Name: Customer Open Items Due in Date Range
User:
Report Type: Form
Data Type: Open Item
Filter: Due Date Range, Balance <> 0
Fields: Date, Transaction Number, Due Date, Customer.ID, Customer.Customer Name, Value Inc, Balance
Notes:
Report Name: Supplier Open Items Due in Date Range
Notes: Same as Customer
Report Name: Stock Report
Report Type: Form
Data Type: Product Site
Filter: None, Obsolete Products Only (Optional), Never Sold (Optional)
Group: Site, Category
Fields: Product ID, Product Name, Date Last Received, Date Last Sold, Quantity on Hand, Cost P1, Value of Stock, Quantity Issued (This FY),Quantity Received (This FY)
Notes:
Report Name: Product Movement Report
Report Type: Form
Data Type: Product Movement
Filter: Date Range
Group: Category, Product
Fields: Product ID, Product Name, Date,Transaction Type, Transaction Number, Card ID, Movement Qty, New Stock on Hand, Movement Value
Notes:
Report Name: Profit and Loss / Balance Sheet
Report Type: Form
Data Type: Account
Fields: Account ID, Account Name, Period Balance (Ex GST), YTD Balance (Ex GST)
Notes:
Report Name: Budget Report
Report Type: Form
Data Type: Account
Fields: Account ID, Account Name, Period Budget (all periods July to June), Total Budget
Notes:
Report Name: Variance Report
Report Type: Form
Data Type: Account
Fields: Account ID, Account Name, Period Budget, Period Actual, Period Variance, YTD Budge, YTD Actual, YTD Variance
Notes:From the navigation panel. select reports then list reports
| Expand | ||
|---|---|---|
| ||
|
Note:
- that all the list reports that come standard with Readysell have a code in the "Report ID" column. Each code starts with "L" which indicates a list report, then "-[nnn]" which indicates the built in report number
- any report with no report id is a custom report for your site that is not included as one of Readysell's standard reports
Find the list report you want to run by either:
- Viewing the list of reports displayed on the list report menu
- Looking for a report the may suit your requirements in the user guide, see Key List Reports Overview
For this example, I will use list report L-018 Stock report
- Highlight the report you wish to run
- Highlight one of the available parameters on the "Parameters" tab
- Then click on the "Show Report Using Parameters" button
| Expand |
|---|
|
Fill in any options on the parameters popup window, then click on the "OK" button
| Expand | ||
|---|---|---|
| ||
|
There will be a delay while the report runs.
When the report has finished running, a new tab will display showing the output from the report
Click on Export, Excel or Export PDF if you want to keep the report output
Make sure you click on the arrow pointing down below the export button, otherwise it will export using a default format, you want to select the format of the output
Export on server is not normally used. This is only for special cases where the report output is truly huge. Don't use this button, use the standard export
| Expand |
|---|
|
See also:
Customising Readysell lists and detail view user interface then saving and sharing the results
Changing the formatting on lists using appearance rules