helpwith.salesorder.com
  • Read me first
  • Start!
    • How to move forward
  • Video Index
  • Live in 5
    • Step 4: Solution Plan
      • Workflow Guides
    • Must read: Data Migration
      • Read First: ASIC and presets
      • Transaction Migration Primer
      • Migrate transactions
      • Migrate from Quickbooks
        • How to categorize Quickbooks 'Open' Purchase Orders
    • Step 5: Launch Sequence
      • T -6: System Settings
      • T -5: Baseline preparation
      • T -4: 'Open' transactions
      • T -3: Trial balance
      • T -2: Set Stock levels
      • T -1: User testing / Dry run
  • Customer references?
  • Common Actions
  • Company
    • Workers and Users
      • Add new User login
      • Owners
  • Organizer
    • Memo
    • Contacts
    • Calendar
    • Email
    • Attachments and Linking
  • Expenses/Timesheets
    • Expense Claims
      • Mileage Claims
    • Timesheets
  • Sales Forecasting
  • Sales
    • Leads
    • Prospects
    • Customers
      • Credit Controls
    • Jobs
    • Sales Quote
    • Sales Orders
      • Common Sales Tasks
        • Pre-Authorization/Pre-Payment with BASYS
      • Ordered Item History
      • Stock Allocation
      • Pick-Pack-Ship Process
      • Sales Order List
      • Drop Ship
      • Special Orders (Just in Time)
      • Discounts
      • Prepayment/Deposit
    • Cash Sales
    • Sales Invoices
    • Payments from Customers
      • Processing digital Payments
      • Apply Credit Automatically on Payments
    • Customer Credit Notes
    • Customer Refunds
    • Delivery Notes (a.k.a Packing List)
    • Customer Statements
    • Shipments
      • Pick List
    • RMA
    • Commission automation?
  • Purchasing
    • Suppliers
    • Purchase Quotes
    • Purchase Orders
    • Cash Purchases
    • Item Receipts
    • Bills (Purchase Invoices)
    • Payments to Suppliers
    • Supplier Credit Notes
    • Supplier Refunds
    • PO Generator by Item
    • PO Generator by Order
  • Inventory Forecasting
    • Inventoro
  • Products/Services
    • Items - which ones?
      • Preferred Suppliers
      • Stock Items (SKUs)
      • Stock Assemblies
      • Kits
      • Non Stock Items
      • Group Item
      • 'Calculation' Items
      • Service Item
      • Matrix Item
    • Sites
    • Stock Adjustment
    • Stock Manager
    • Stock Locations
    • Categories, Tags and Attributes
      • Categories
      • Tags
      • Attributes
    • Images on Items
    • Item Extra Info
    • Price Levels
    • Price Lists
    • Advanced Price Lists
  • Banking
    • Cashflow Forecast
    • Checks
    • Bank Reconciliation
    • Petty Cash Accounts
    • Credit Cards
    • Money In and Out
  • Accounting
    • Accounting Periods
    • Payment Terms
    • Tax
      • Sales Tax
        • US Tax Codes
      • Tax Authorities
        • Working with HMRC (UK Specific)
      • Tax Codes
      • Tax Groups
      • Item Tax Options
      • VAT Returns
    • Currencies
    • General Journals
    • Memorized Transactions
    • Reverse Transactions
  • WMS: Warehouse Management
    • Stock View
    • Goods In
    • Goods Out
    • RMA
    • Shipping
    • Pallets
    • Kits and Assemblies
    • Stock Actions
    • Stock Count
    • Locations
    • History
    • Admin
    • Config
    • Barcode Scanner App â›­
    • Multipacks
    • Overship Tolerance
    • Expiry Date
  • WMS Setup
  • Third-party logistics (3PL)?
  • Shipping
    • FedEx Manager Integration
    • UPS WorldShip Integration
  • Reports
    • Classifications
    • Report Mailer
    • Email Reports on Schedule
    • Accounting Periods
  • Setup
    • Roles
    • Email templates
    • Payment Processors
      • Basys: low fees, VIP service
      • Authorize.net
      • Cybersource
      • PayPal
      • USAePAy
      • Paragon (PAYA)
    • Configuration
      • Company â›­
      • Memo â›­
      • Ref # â›­
      • Leads â›­
      • Prospects â›­
      • Customers â›­
      • Credit Controlsâ›­
      • Jobs â›­
      • Sales Quote â›­
      • Sales Order â›­
      • Sales Invoice â›­
      • Customer Credit Note â›­
      • Cash Sale â›­
      • Statements â›­
      • Shipment â›­
      • Customer Refund â›­
      • Delivery Notes â›­
      • RMA â›­
      • Pick List â›­
      • Supplier â›­
      • Purchase Quote â›­
      • Purchase Order â›­
      • Item Receipt â›­
      • Cash Purchase â›­
      • Bills â›­
      • Payment to Suppliers â›­
      • Supplier Credit Notes â›­
      • Supplier Refunds â›­
      • 1099 Categories â›­
      • Kit â›­
      • Accounts â›­
      • Accounting Periods â›­
      • VAT â›­
      • Email Accounts â›­
        • OAuth for Outlook 365 â›­
      • Company Security â›­
        • Two Factor Authentication
      • Classifications â›­
      • Document Templates â›­
      • Shipping Carriers
      • Sales Invoice â›­
      • Payments from Customers â›­
      • Sales Opportunities â›­
    • EasyPost â›­
    • Shipstation â›­
    • Web to Lead
    • Import data templates
    • Exporting Data
    • Your Account
  • Shopping Carts b2c
    • âš  Live Shopping Carts
    • Shopping Cart controls
    • Shopify â›­
    • BigCommerce â›­
    • Magento â›­
    • Woocommerce â›­
    • Prestashop â›­
  • Trade Acceleration Portal 2.0
    • TAP Users
      • Customers
      • Sales Reps
      • Sales Teams
      • Administrators
        • Configure barcode order entry
        • Get your Inventory List from QuickBooks
    • TAP UX
      • Global Brand Style
      • Themes
      • Pages
      • Blocks
        • Group Start
        • Plain Text
        • Image
        • Hyperlink
        • Menu Matrix
        • Title
        • Custom HTML
        • Block Configurations
          • Pixels and Percentages
          • Flex Box Settings
            • Flex Wrap
            • Justify Content
            • Align Items
            • Column/Row Gap
            • Align Content
          • Background
          • Dimensions
          • Border
          • Slider & Carousel
          • Margin Padding
          • Overflow Settings
      • Content Management System (CMS)
  • Trade Acceleration Portal 1.0
    • Configure barcode order entry
    • Get your Inventory List from QuickBooks
  • Customization
  • Volume Automation
  • EDI
    • EDI integration via XML
  • REST API
  • Schema Documents
Powered by GitBook
On this page

Was this helpful?

Reports

PreviousUPS WorldShip IntegrationNextClassifications

Last updated 10 months ago

Was this helpful?

Media

Salesorder.com comes with a set of 'Standard Reports' that allow you to display and analyse data entered into your system. The reports are divided into a number of distinct categories, reflecting different areas of your business.

Reports can be customized to use a particular date range, show only certain columns, and filter by specified criteria. You can also memorize these custom reports so that you can build a complete set of reports specific to your business.

For convenience all reports can be exported to Microsoft Excel.

Generic Report Functionality

All standard reports allow the following:

  • Run the standard 'default' Report

  • Customize the Report by using filters

  • Memorize the Report, along with its associated settings.

  • Set the date range and column format where appropriate

  • Export the Report to Excel

  • Print the Report

Running a Standard Report

Reports > Standard Reports

To run a Standard Report, such as a Profit and Loss or Balance Sheet, go to 'Standard Reports' under the Reports folder on the Explorer. This displays the Standard Reports page, click on the plus icon next to 'Accounting' to expand the list of Standard Reports in the accounting category.

To run the report, you can either click on the name of the report which is a link or click 'Run'.

Please note that if you have a lot of data in your system, some Reports may take a while to run.

In most cases there is a summary Report, which displays a summary of the figures accumulated from multiple transactions, together with a detailed Report showing the constituent transactions.

This is a Standard Profit and Loss report. From the action bar, you can customize, memorize and export this report.

If required, you can use the Date Range option to select an alternative time period for your report. Once selected, click 'Run;.

To view the detailed report, click on the assocaited summary number which are in blue.

From the Ref # and Name columns, you can click on the blue text to pop up the assocaiated Document.

Customizing a Report

A Report can be customized by simply clicking 'Customise' on the Report's Action bar; this displays the Report's customization page.

You can specify which columns you wish to see on the Report from the 'Columns' tab. The 'Filters' tab can be used to filter the results as required. You can filter using a variety of categories including by account and by suppliers.

In addition to Columns and Filters, on most reports you can also specify a custom date range.

To run the customized report, click 'Run Report' on the action bar.

You can access the list of Customized Reports from the Explorer. Click Reports > Customized Reports to view.

Memorizing a Report

Often it is useful to be able to save or memorize a Report along with its customized settings. To do this simply click on 'Memorise' on the Report's Action Bar or from the Report's customization page. This will allow you to assign a name to the new Report, and save it.

Once the Report has been memorized, it can be accessed from the Explorer. Click Reports > Memorized Reports to display the List of Memorized Reports.

Exporting a Report to Microsoft Excel

It is sometimes useful to export a Report to Microsoft Excel. You can then manipulate figures, and formulae etc. To export a Report simply click the 'to Excel' icon on the Report's action bar or from the Report's customization page. This will popup a dialog asking you to save the exported Excel file to a suitable location on your computer.

Custom Reports

Want a Report that is not in the set of 'Standard' Reports supplied in your system? Or maybe you want a 'Dashboard' that gives specific real-time information about your business. We can build you virtually any type of Report/Dashboard with exports to PDF, Word and Excel.

For more information, and to discuss your reporting requirements please contact Customer Support at support@salesorder.com.

Standard Reports
Memorized Reports
Classifications
Customize Reports Using Filters
Find and Create Standard Reports
Memorize Reports