Knowledge Base

AU: 1300 732 618

INT: +61 0011 7 3117 0530

Inventory - Fulfil Products from the Fulfilment Report

Find FAQs and related articles at the bottom of this page

The Fulfilment Report is designed to allow you to process and dispatch one or more orders to your customers when these orders were placed:

  • In-store - e.g. when having products delivered at home via courier or delivery service, or if being picked up from another location (warehouse, another store etc)
  • Online through an integrated web store

Each individual product within each Order is listed, allowing you to address your fulfilment at an individual Product level. i.e. you can choose to fulfil some items on an order and leave others for future Fulfilment. This can be especially beneficial if you offer home deliveries or you're a retailer that sends out several orders worth of products via large deliveries at pre-scheduled times.

Using the Fulfilment Report

To use the Fulfilment Report:

  1. Navigate to Inventory > Fulfilment Report
    Tip: You can also access the Fulfilment Report from the Quick Links drop-down
  2. Update the Search Fields as required (see below for detailed information)
  3. Click the Refine Search section to expand the detailed search filters e.g. specific Outlets, Order or Delivery status etc
  4. Click Search
  5. Any orders and products matching the filters will be displayed on the Results tab
  6. Use the Results tab to dispatch products (refer to the Results tab section below for detailed information)
  7. Use the Saved List to save the products that have been sent for dispatch without actually fulfilling the sale (where the fulfilment will be updated later - refer to the Saved Lists section below for more detail)

reports_fulfilmentreport_filters.png
Click to view full size

The Search Fields and Refine Search filters assist you in targeting the Customer Invoices and Products to be fulfilled. For example, if you receive stock from a supplier based on a Purchase Order, you can use the Purchase Order Number field to search for Invoices or Products specific to that Purchase Order.

reports_fulfilmentreport_searchfields.png
Click to view full size

Search field Detail
Invoice Number The Customer's Invoice Number in Retail Express 
Product PLU Code Product ID or Supplier SKU
Customer Name The Customer's name (can be either first, last or both)
Ordered From/Ordered To Used to select a particular date range the Invoice was created within e.g. the previous calendar day to see any new orders that need to be dispatched
External Order Reference

Used to search for an Invoice Number from another system e.g. if using the Shopify integration you can search for the Shopify Order Number

Tip: This number can also be entered via POS or any integration using the Webstore/eCommerce integration that sends this information from the external system

Only Show Stock Available for Picking When ticked, the results will only show the products available to dispatch to the customer
Delivery From and To

Returns only products that had a manual Fulfilment/Delivery Date entered when sold (at POS) AND whose Fulfilment Date is within the range.

Note: This will ignore all products that did not have a manual Fulfilment/Delivery date entered when sold.

Purchase Order Number

Enter the Purchase Order number created automatically by a sale at POS.

Note: This option will only display Purchase Orders that were automatically created by Retail Express using the "Auto Generate PO" settings for the products sold (not products from Purchase Orders that were manually created).

Purchase Order Options
  • Show orders with items contained in this PO - allows you to view only Products on the Purchase Order number entered in the above field. Untick to exclude the products on the Purchase Order number entered into the field above.
  • Show orders dependent on this PO for fulfilment - allows you to view all products on orders that contain products that are dependent on the delivery of the Purchase Order entered into the field above.

For example if an order contains Product A and Product B, and Product A was ordered on the Purchase Order listed in the Purchase Order Number, ticking this check box will show both Product A and Product B in the results, while un-ticking this check box will ONLY display Product A.

Sort By

The Default sorting is via Invoice Date. Select from the drop-down menu for any other preference.

Sales Person

The staff member who processed the original Invoice.

reports_fulfilmentreport_results.png
Click to view full size

The Results tab displays detail on each individual product to be dispatched to customers. Invoices with multiple products will be split with each product on a separate line (if there are multiples of the same product on the same invoice these will be combined on one line).

The results tab can be used to:

  • Dispatch products
  • Enter reference notes
  • Select a zone, time and driver to organise delivery efficiently
  • Printing - reports, pick lists, run sheets, labels, invoices etc.

The results are displayed with the oldest Invoices at the top to assist with actioning these outstanding invoices first.

When a sale is Fulfilled the stock will be removed from the Allocated status, and the order will be marked as Complete.

Fulfilling/dispatching products

You can use any of the following three methods to fulfil and dispatch products:

Use the Dispatch (Disp) column Manually enter the quantity of products being sent to the customer in the Dispatch (Disp) column
Scanning products using the PLU Scan field

Click into the PLU Scan field and begin scanning products using a barcode scanner. The system will search and match against either the Supplier SKU or Product ID, and increase the Dispatch (Disp) column for the first result in the list each time a match is found.

Note: where you have multiple line orders for the same Product (ie: multiple invoices for differing customers awaiting the same Product) the PLU Scan will increase the Disp column for the first result in the list. Once the first matching Product in the list has the full Order quantity entered into the Disp column, the search will move to the next matching Product, and so on until the last barcode is scanned.

Using the "Copy Across" button (bottom of the screen)

Clicking the Copy Across button automatically populates the Dispatch (Disp) column with the full ordered quantity.

Note: please exercise caution in using the Copy Across function. Bulk Fulfilment of orders processed in this way cannot be reversed.

To dispatch products:

  1. Update the Disp quantity using one of the methods described above
  2. Click Save to save the dispatched quantities but not update the inventory yet (i.e. the sales will not be fulfilled and the stock will not be removed from the Allocated status, however the sale will not show on the Fulfilment Report for subsequent searches)
    Tip: This method is beneficial when you prefer to update the inventory only after delivery has been confirmed e.g. at the end of the day when the courier returns to the warehouse. Refer to the Saved Lists tab below for more information on this process
  3. Click Submit to fulfil the products immediately, complete the Invoice and update the inventory

 

Other fields and actions

There are many other benefits to the Fulfilment Report beyond just updating the dispatch quantities. For example, you can coordinate delivery drivers by allocating a Zone or Driver, and your Warehouse staff by printing out Pick Lists ready to use for packing your stock. See below for detailed information on each option.

mceclip0.png

Feature Details
Item reference 

Used to enter a note for the Delivery Driver when using the a Runsheet

Note: This will only work if using the Save List function

Zone, Time and Driver

Select Zone, Time and Driver (previously configured options) from he drop-down options to better organise the delivery and manage Fulfilment.

For example if you run the Fulfilment Report and sort by Suburb, you could assign all deliveries within the suburbs to a Zone. The nearest suburbs could be assigned earliest time and the farthest with the latest time. These could all still be assigned to a single driver, and assists the driver with planning a route for deliveries.

XLS Picklist

Generates a Pick List in Microsoft Excel format to assist staff with picking the products for fulfilment.

Print
  • Report - print the report to your A4 printer
  • Labels - Print packing labels from your A4 Printer. These are basic Pre-Formatted labels that contain Delivery Address, Delivery Name, Return Address and Return Name, to be attached to the box the goods are packaged in.
  • Invoices - print a POS A4 Invoice for each Invoice included in the results

Note: Invoices are consolidated, where multiple Products exist on the same Invoice number within the Results, a single Invoice is generated. This can be used if you'd like to include a copy of the A4 Invoice with the goods being delivered to the customer.

XLS Runsheet

There are three different Run Sheets available, each providing different information. These are to be provided to your Delivery Drivers.

Each Run Sheet has a different combination of:

  • Customer information
  • Delivery Address (Run Sheet B omits the delivery address but has space for a map reference number to be entered)
  • Product information
  • Notes/Comments
  • Customer Signature

You should review each Run Sheet to determine which is the most suitable to your specific business requirements.

The Saved Lists feature of the Fulfilment Report is designed to enter a suggested dispatch quantity without actually updating the order or the inventory.

Example scenario:

If you have in-house delivery drivers you may find that at the end of the day you frequently have stock that was unable to be delivered to the customer. When the courier returns to your Warehouse with the product you would have to process a Refund within POS to show you still had the stock in your Outlet, ensuring accurate inventory levels.

By saving the list, you can remove the products from Fulfilment Report searches so you don't accidentally send the same product out for delivery more than once. At the end of the day when the courier arrives back at the Warehouse you can update the quantities for the ones that weren't delivered and then submit the Dispatch quantities. The stock that was delivered will be marked as Fulfilled and the sale marked as Complete. The products that weren't delivered won't be updated, and will be available again in subsequent searches using the Fulfilment Report.

Key Notes:

  • Products within Saved Lists have NOT had the Products Submitted for Fulfilment yet
  • Products added to Saved Lists will NOT appear in the Fulfilment Report for other users (unless a search is performed for a specific customer)

 

Using Saved Lists

To use Saved Lists:

  1. Perform a search for products/orders using the Fulfilment Report Search Fields and Filters
  2. Update the Disp quantity using the Results tab
    Important: Do not click Submit
  3. Enter a name in the Save As field
  4. Click Save
    reports_fulfilmentreport_save.png
  5. To access the saved list at the end of the day navigate to Inventory > Fulfilment Report > Saved Lists
  6. Click the Pencil icon to rename the list
  7. Click the Magnifying Glass icon to open the list in the Results tab
  8. Update the Disp quantities for your stock
  9. Click Submit to finalise the Fulfilment and update the Inventory levels

Want more information? Find related articles here:

Was this article helpful?
0 out of 0 found this helpful

Didn't find what you're after? Submit a request or call: 07 3117 0530