Versions Compared

Old Version 12

changes.mady.by.user John Nairn

Saved on

compared with

New Version 13

changes.mady.by.user Monica Chand

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Excerpt

Key Features

  • Reports can be exported to excel, scheduled to email to you or scheduled to run and save an export in a specified folder on your computer on a regular bases.
  • Readysell is deployed with built in reports. You can copy those reports and adjust the copies to suit your requirements
  • List reports work a lot like excel spreadsheets. They can have columns subtotalled and can be designed by dragging and dropping columns. Excellent for management review of detailed data
  • Analysis report allow drag and drop design summary cross tabulated reports. Comparing one criteria down the screen and another across the screen. Reports like customer sales by period. With all the periods across the top of the screen and customers down the left.
  • Form reports are used for nicely formatted output to customers and suppliers.
  • The standard list view in Readysell can be used as a quick reporting tool. By dragging columns onto the screen, totalling the data then saving the list view as a default view. You can make many reports without having to even use the reporting system
  • Dashboards show graphs and charts of popular reports grouped by functional area
  • Key performance indicators show shorthand summaries of how your business is tracking

 

Running List Reports

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: Cash Flow Forecast (STAGE 2)

Report Type: Form
Data Type: Account
Fields: Account ID, Account Name, Forecasted Balance (for each month to the end of the FY)
Notes: Calculate forward based on budget to determine future balance for accounts on a given date

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: