Back Office reports

To access Reports:

  • Open Rx 365
  • Click the Reports Module

reports

  • The Reports Module will open the 1. Daily Reports section by default

reports

- Common Report Functions

While many reports may contain different information when compared to each other, there are a number of common functions that can be carried out on Reports.

Located at the top of every report there are additional features:

  • Print
  • Favourite
  • Excel
  • CSV
  • Show Filters
  • Save Parameters as..
  • Show Parameters

reports

Description

  • Every Report In Rx 365 has a blue information icon 'i' located next to the report
  • Hovering the mouse over the Icon will give a brief description of what the report is used for

reports

Choosing Parameters

Before you run a report, you may have to enter some parameters to tell the report what kind of information you are looking e.g. what Store do you want to report on, what date range are you looking at or what Level of Stock Category do you want to report on etc...

When selecting a report, you will first be brought to the parameters and asked to choose a number of them before running the report.

The Run Report option will be greyed out until all required fields have been filled out

reports

Filtering

  • Clicking Show Filters allows to further refine the search criteria to be more specific.

reports

Exporting

  • Clicking Excel will export the report to excel
  • Clicking CSV will export the report to CSV

reports

Printing

  • Clicking Print will print out the report

reports

Favouriting

Clicking Favourite will save the report to the Favourite section of the Orders Module located at the bottom of the reports tab.

This can be saved for quick access to reports that are run daily

reports

Saving Parameters

  • Clicking Save parameters as.. will give the option to save a specific set of parameters applied to the report for quick access.
  • Click Save Parameters and enter in the name of the report to save.

reports

  • This saved Parameters report can be now quickly accessed on the home page of the Todays Dispenses Report.

reports

- Daily Reports

Todays Dispenses

This report shows a linst of all dispenses that were carried out today.

The report displays the following for each store selected:

  • Date
  • Store
  • Product
  • Pack Size
  • Manufacturer
  • Qty Dispensed
  • Pask Dispensed]
  • Pack Owed

- Ordering Reports

To access the reports:

  • Open Rx 365
  • Click the Reports Module
  • Click Orders from the reports menu.

reports

The following reports will appear in Orders:

  • Orders by Supplier
  • Returns by Supplier
  • Stock Transfer Summery
  • Transfers by Store
  • Under-delivered Orders Report

reports

Orders by Supplier

This report lists all purchase orders given in a specified date range, to specified (suppliers) and in a specified store(s).

reports

The report displays the following for each order:

  • Date and Time
  • Store
  • Supplier
  • Order Number
  • Order Status
  • Number of items in the order
  • Order Value

The report can be filtered by applying ranges to the data in each column

reports

Returns by Supplier

This report lists all returns to suppliers in a specified date range, to specified (suppliers) and in specified store(s)

reports

This report displays the following for each supplier:

  • Date and time
  • Store
  • Supplier
  • Return number
  • Return Status
  • Number of items in the return
  • Return Value
  • Retail Value

The report can be filtered by applying ranges to the data in each column

reports

Stock Transfers Summary

For specified date range and specific stores, this report displays the total of transfers in and the total of transfers out for each store specified

reports

This report displays the following for each store:

  • Store name
  • Stock transfers in
  • Stock transfers out

reports

Transfers By Store

For a specified date range and specific stores, this report displays each stock transfers in and each stock transfer out for each store listed.

reports

The details listed for each transfer are as follows:

  • Transfer date
  • The Sending Store
  • The Receiving Store
  • The Transfer store
  • The Transfer Number
  • The Transfer Status
  • Number Of Items in the transfer
  • Transfer Value

reports

Under delivered Orders Report

This report is run for a specific date range(s), specific supplier(s), and the specific store(s).

It displays all purchase orders where the quantity delivered for a product or products in the order is less than the quantity ordered.

reports

The details listed in the report are as follows:

  • The date
  • The Store
  • Supplier
  • Order Number
  • Quantity Ordered
  • Quantity Delivered
  • Quantity Difference
  • Cost Ordered
  • Cost Delivered
  • Cost Difference

By clicking on the order number, the details of the undelivered products are displayed in a separate tab on the browser.

reports

- Stock Reports

The following reports are reports that can be run in order to generate information about Stock Levels of products on the system.

Stock Adjustments Summary Report

This report details the net value of stock adjustments done in stock takes and on the product screen, for each product category in each store.

The following parameters can be specified

  • Date range
  • Sales group(s) level 1
  • Store(s)

For each category, the variance value, the sales in the defined period and the variance value as a percentage of sales are detailed.

There is the option to group this report by store or category by toggling the "Group By Store/Group by Category" button.

reports

reports

Stock Cover Report

This is a report which measures the level of stock versus the dispenses.

The number of week’s stock is the measure used.

The following parameters can be specified,

  • Product
  • Current stock quantity dispensed in the period specified when running the report
  • Last dispense date
  • Average weekly dispenses over the last 12 weeks.

The last column is the stock cover based on the current stock level and the average dispense quantity over the last twelve weeks.

reports

Stock Movements Report

This report details the stock movements for a specified range of products.

The scope of the report can also be set by the date range, the category or categories, the supplier(s), the manufacturer(s), the product name or barcode, the adjustment type(s), adjustment value, adjustment quantity and the store(s).

For each product listed the date, the original stock quantity, the adjustment quantity and value, the adjustment reason and the staff member are also detailed.

reports

reports

Stocktake Variance Report

This report details the stock variances in stock takes in a specified period.

The scope of the report can also be set by the category, supplier(s), a manufacturer(s), variance value and quantity, and store(s).

It details each product in each stock take, the date, the opening stock quantity and value, the variance quantity and value, the additional adjustments due to dispenses during the stock and finally the closing stock quantity and value.

The report can also be filtered by each of the report columns.

reports

reports

Stock Value ( By Category )

This report is designed with the stock in each category grouped together as a subheading in the report.

The stock values of each product in the category are totalled as a subtotal, thus giving you the value of the stock for each product category.

The price, list average cost of each product is shown.

Then the stock value at list cost and average cost are all shown.

The report can be run for specific sections of the store by specifying suppliers and categories.

reports

reports

Stock Value On Date ( Summary )

This report gives you the stock totals per group as they were on the selected date

reports

reports

- Listing Reports

The following are reports that can be run in order to list various things such as Suppliers etc..

Supplier Listing

This report lists each supplier for the specified store(s) together with supplier code.

reports

reports