Orders at Store Report

Orders at Store Report

This report will list all items you have on orders and what order they are on for a specific date range.

Generating the Report

From the main screen of Retailer, click on Reports -> Stock Reports -> Orders at Store report.

Order status:
These let you select orders that have a specific status. More than one status can be checked by the report at a time.

Date Range:
The date range of of orders you wish to look at.

Supplier options:
Click All Suppliers for all or click Selected and choose one from the drop down list to filter the report by.

Select Departments/Category:
Allows you to select one or more Department or Category. Click Select All to include all Departments or Categories in the report. Click Selected, and choose the Departments and Categories to filter the report by.

Report options:
  1. Show summary report - Ticking this box will remove the order details (order number, status, etc.) for the items to produce a smaller report.
  2. Show Cost Prices - Adds a column for Cost prices in the report.
  3. Show Retail Prices - Adds a column for Retail prices in the report.
  4. Highlight Special Customer Orders - Ticking this box will highlight any items with Special Customer Orders linked in the report.
For more information on how to use Special Customer Orders, click HERE.
  1. Sort Order by - Allows you to sort the report by description, barcode or supplier stock code.

Reading the Report

The following information will be shown in the report, depending on options selected:
  1. Stock Description - Long name of the product
  2. Barcode - Barcode number for the product
  3. PLU - Lookup code for the product
  4. Supplier Stock Code - Supplier's code for the product
  5. Cost Price - Cost price of product, including GST
  6. Retail Price - Retail price of product

  1. Qty Pending - number of this item on pending orders
  2. Qty Sent - number of this item on orders already sent to suppliers
  3. Qty Received - number of this item arrived from supplier orders
  4. Qty Outstanding - 
This next section will list all orders containing this item, with each order on a separate line.
  1. Order Num - order number where the supplier order contains this item
  2. Status - status of this supplier order, whether pending, sent or arrived
  3. Date - date of the supplier order
  4. Qty - quantity ordered for the item on this supplier order
  5. Qty Received - quantity received for the item on this supplier order

    • Related Articles

    • Settings for Multi Store

      The settings for Multi Store setups (all Cloud hosted sites are Multi Store) can be managed in this screen. It is grouped broadly into three parts: Stores, Utilities, and MS Outpost. Beneath them, there are options relating to how stock is generally ...

    • Inter-Store Transfer Report

      The Inter-Store Transfer Report can be used to view the inter-store transfers that have been leaving or arriving at a location. It can be used to view the items in a specific transfer, or you can view totals across a selected date range. To run the ...

    • Multi-Store Order Details

      The Multi-Store Order Details tool will allow you to see what has happened with multistore orders and interstore transfer between a specific date range or by the order number. From the main screen of Retailer, click the Stock Maintenance tab and then ...

    • Store Locale

      Retailer allows you to more efficiently manage your stock in a warehouse situation by allowing you to assign your inventory a locale. This allows you to quickly and easily find and manage what stock you have on hand and assists in ordering the stock ...

    • Setting up Inter-Store Transfer for Multi-Store

      Setup conditions for inter store transfer From the Main screen in Retailer – Setup -> Multi-Store. Click on Store Rules. In Calculate Transfer Price Method select one of the following options to set transfer price on stock from another store. Note: ...