Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  1. In the navigation panel, go to Reports then Form Reports.
  2. Type the name of the report your are looking for in the search bar. A list of will appear. 

    Expand
    titleShow me

  3. Select the report you wish to run.
  4. In the Parameters tab, click Show Report Using Parameters. The Parameters window will display. The parameters you need to enter depend on the report you have chosen.

  5. All reports have different filters and can be filtered as required. Below is an example of how to run a report.
    For the Statement of accounts (category cards> Statement of Account) enter the "statement date" to view the correct report, enter customers name in the start and end customer or alternatively leave it blank to see all customers.

    Expand
    titleShow me

  6. Enter the desired parameters, then click OK. The selected report displays in the Preview window.

  7. You can print, email or save the report.

 

To run form reports select the form report option from the Readysell 8 navigation bar. Form 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: 
Report Type: Form 
Data Type: GST Item 
Filter By:???
Group By:???
Sort By:Date (Ascending)
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
Detail:Form of Open Items under each Card
Group By:Age
Sort By:Date
Columns:Transaction Type,Transaction Number,Description (Customer Purchase Order Number),Value Inc
Notes: Total for all customers at the bottom 

Report Name: Supplier Trial Balance (Summary) Report

Notes: Same as Customer 


Report Name: Supplier Trial Balance (Detail) Report 
Notes: Same as Customer 


Report Name: General Ledger Chart of Accounts

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

User: 
Report Type: Form 
Sort By:Date
Columns:Date,Invoice Number,Description (Customer Purchase Order Number),     
Notes: 
?     HOC (Credits) are showing as debits 
?     Need to align customer address details for window envelope (All printable forms!) 
?     Payment terms are not filling in 
?     Heading for Bank Account details showing in wrong place 
?     If payments for the period is empty, show it as 0.00 


Report Name: Sales Order

User: 
Report Type: Form 
Notes:Copy Tax Invoice and remove payment details
      

Report Name: Picking Slip 
User: 
Report Type: Form 
Notes:Copy Tax Invoice and remove payment details

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: Erlinda 
Report Type: Form 


Report Name: Supplier Remittance

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: