Supplier Returns

Supplier Returns can be used to return stock to a supplier.

It is important to be able to return goods to a supplier without it being counted as goods being issued to a customer. If you just issue goods to your supplier through an Outbound Shipment, then those goods will be counted as part of your store's 'issuance' (consumption). A Supplier Return is the right way to return goods to a supplier.

If you have used mSupply in the past, you may be familiar with the term Supplier Credit instead of Supplier Return.

Viewing Supplier Returns🔗

Open the Supplier Returns Menu🔗

Choose Replenishment > Supplier Returns in the navigation panel.

gotooor

You will be presented with a list of Supplier Returns (if you don't see any, you are probably just starting!).

From this screen you can:

  • View a list of Supplier Returns
  • Create a new Supplier Return
  • Export Supplier Returns to a .csv file

Supplier Return list🔗

  1. The list of Supplier Returns is divided into 6 columns:
ColumnDescription
NameName of the Supplier
StatusCurrent Status of the return
NumberReference Number of the return
CreatedCreation date of the return
ReferenceSupplier reference
CommentComment for the return
  1. The list can display a fixed number of returns per page. On the bottom left corner, you can see how many returns are currently displayed on your screen.

Page

  1. If you have more returns than the current limit, you can navigate to the other pages by tapping on the page number or using the right of left arrows (bottom right corner).

Page

  1. You can also select a different number of rows to show per page using the option at the bottom right of the page.

Rows per page

Search by Supplier Name🔗

You can filter the list of returns by supplier name or by status. This can be useful if you're looking for one particular return! Select the Name filter from the list to filter by the supplier name:

Supplier Return filter

Type the name of a supplier in the Name field. All the returns for this supplier will appear in the list.

Exporting Supplier Returns🔗

The list of Supplier Returns can be exported to a comma separated file (csv). Simply click the export button (on the right, at the top of the page)

Export button

and the file will be downloaded. The export function will download all Supplier Returns, not just the current page, if you have more than 20 of them.

Delete a Supplier Return🔗

You can delete a return from the Supplier Return list.

  1. Select the return that you want to delete by checking the box on the left end of the list. You can select more than one return to be deleted. You can even select them all using the master checkbox in the list headers.

  2. Open the Select dropdown (top right corner, above the list) and select Delete selected lines.

  3. A notification confirms how many returns were deleted (bottom left corner).

You can only delete Supplier Returns if they have not been SHIPPED.

Outbound list: delete

Creating a Supplier Return🔗

Create from Inbound Shipment🔗

Often, you will be returning goods that you received via an Inbound Shipment. In this case, you can create a Supplier Return from the Inbound Shipment itself.

Create manually🔗

  1. Go to Replenishment > Supplier Return.

  2. Press the New Return button, in the top right corner

New Return

  1. A new window Suppliers opens, inviting you to select a supplier.

Select a Supplier🔗

  1. In the Suppliers window, you will be presented with a list of available suppliers. You can select your supplier from the list or you can type as much of a supplier name as you want.
In the below example, we are wanting to return stock to Kamo Regional Warehouse.

Search supplier list

You can tell if a supplier is also using Open mSupply in their store. If they do, you will see icon like this Store next to the supplier code.
  1. Once you tap or press Enter, or click on a supplier, your Supplier Return is automatically created
If everything went well, you should see the name of your supplier in the top left corner and the status should be NEW

Supplier Return: created

Enter a Supplier Reference🔗

Once your Supplier Return has been created, you can enter a supplier reference in the Reference field, if they have one (eg. PO#1234567)

View or edit the Supplier Return Information Panel🔗

The Information Panel allows you to see or edit information about the Supplier Return. It is divided into multiple sections:

  • Additional Info
  • Related Documents
  • Transport Details

We are planning to add more sections in the future as Open mSupply grows.

How to open and close the Information Panel?🔗

If you are using a large screen, the information panel will be automatically opened for you. However, on an average sized screen, the information panel will be closed by default.

To open the Information Panel, you can tap on the More button, located in the top right corner of the Supplier Return view.

You can close by tapping on the X Close button, on the top right corner of the information panel.

Open and close the Information Panel

Additional Info🔗

In the Additional Info section, you can:

  • See who created the Supplier Return (name of the user)
  • View and edit the Supplier Return color. To edit the color, tap on the coloured circle and select a color from the pop-up
  • Write or edit a comment

In the Related Documents section, you can see other related transaction documents for the Supplier Return.

If your Supplier Return was created from an Inbound Shipment, the reference number of the Inbound Shipment would appear in this section.

In the future, we would also include other documents such as transportation documents or pick slips.

Transport Details🔗

In this section, you can see or edit a transport reference number (eg. a booking or a tracking reference number).

Actions🔗

  1. Delete: You can tap on the Delete button to delete the return. You can only delete Supplier Returns if they have not been SHIPPED.
  2. Copy to Clipboard: You can tap on the Copy to Clipboard button to copy the invoice details to the clipboard.

Supplier Return Status Sequence🔗

The status sequence is located at the bottom left corner of the Supplier Return screen.

Passed statuses are hightlighted in blue, next statuses appear in grey.

Supplier Return Status Sequence (New)
Status Sequence: current status is NEW.
Supplier Return Status Sequence (Shipped)
Status Sequence: current status is SHIPPED.

There are 5 status for the Supplier Return:

StatusDescription
NewThis is the first status when you create a return. Goods are reserved (no longer available for other shipments) but are still part of your inventory.
PickedReturn is picked and is now ready to ship. Goods are no longer part of your inventory.
ShippedReturn has been shipped
DeliveredYour supplier has received the return
VerifiedYour supplier has verified the quantity of the return. Goods are now part of their inventory.

If you hover over the status sequence, a return history window appears. You can see the date when a return was updated from one status to another.

This return has been created on 03/03/2022, picked on 04/03/2022 and shipped on 07/03/2022

Outbound status: hover

Hold checkbox🔗

Located on the bottom left corner, on the left of the status sequence.

Checking the Hold checkbox prevents the Supplier Return from being updated to the next status.

Outbound checkbox

Close and Confirm button🔗

Close Button🔗

Tap on the Close button to quit the Supplier Return view and return to the Supplier Returns list.

Confirm Button🔗

The Confirm button updates the status of a return. The status which you can confirm depends on the current status of the return and follows the sequence shown below.

When managing a Supplier Return, you can only confirm the Picked and Shipped statuses.

Confirm...Current StatusNext Status
Confirm PickedNewPicked
Confirm ShippedPickedShipped

You don't have to update a return to the next status in the sequence. You can choose to skip Picked to go directly to Shipped for example.

As demonstrated below, tap on the down arrow of the Confirm button and select the status you want the return to be updated to.

Skip Status

Adding lines to a Supplier Return🔗

Tap on the Add Item button (top right corner).

A new Add Item window opens.

Add Item button

Select an Item🔗

In the Add Item window, you can look up an item by:

  • Reading through the list of available items
  • or by typing some or all of the item name
  • or by typing some or all of an item code

Once your item is highlighted, tap on the name or press Enter.

Select an item

List of available batches:🔗

This is a list of batch numbers that you have in store for this item:

  • Code: Item code
  • Name: Item name
  • Batch: Batch number. It is a designation given to products made in the same manufacturing run.
  • Expiry: Expiry date of the batch (format: MM/YYYY)
  • Pack: Number of units per pack
  • Quantity Available for Return: Number of packs available (not already allocated to other shipments or returns)
  • Quantity to Return: Number of packs to be returned

List of available batch numbers

Return a quantity of packs🔗

As you can see above, initially the quantity of packs to return from each batch will be 0. You can adjust this to return some or all of the available stock in that batch.

In the example below, we are returning all 17 packs of the first batch in the list, and just 5 packs from the second batch.

Set quantities to return

Warnings🔗

You may see one or more warning messages on this screen:

return quantity warning!

If you forget to enter a quantity to return for any batch and click Next step, you will see this warning message. You'll need to add a quantity to return from at least one batch. You can click Cancel if you no longer want to return any of this stock.

Provide Reasons🔗

Return reasons are configured on the mSupply central server via options

When you are happy with the quantities, you can press the Next step button. The list of batches will be filtered to only include the batches you set a return quantity for. In this view, you can provide a reason for returning each batch, and an additional comment.

Provide return reasons

Confirm🔗

When you are happy with the quantities and reasons, you can press on:

  • the OK button. Your item will be added to the Supplier Return. The quantities for each batch will be reserved for this return.
  • the OK & Next button to add another item right away
  • the Back button, to go back to the Select quantity step

Editing a Supplier Return Line🔗

To edit a return line, tap on it. You will be presented with the Edit Item window, which is identical to the Add Item window, except that the item is already chosen.

Edit a Return Line🔗

You can edit a return line if the return has a status lower than SHIPPED.
  1. Open the Supplier Return you want to edit.

  2. Tap on the line you want to edit. An identical window to Add Item appears. At this stage you can:

    • Edit quantity to return for each batch
    • Click Next step to view/adjust the reasons and comments

If you set the Quantity to Return to 0, that line will be removed from the return.

If you set all return quantities to 0, and click Next step you will see this warning message. It is informing you that no return quantities were provided; from here you can click OK again to confirm, in which case the window will close and all lines for that item will be removed.

no quantities warning!

When editing a return line, you cannot change the item. You would need to delete the return line and create a new one.

Delete a Return Line🔗

  1. Open the Supplier Return you want to edit.
  2. Select the line(s) you want to delete by checking the box(es) on the right of the list.
  3. Go to the Actions dropdown menu (top right corner, above the list)
  4. Select the action Delete selected lines

Supplier Return actions dropdown

In the below example, we are deleting 2 items, with the item codes 030453 and 201116

Alt Text

You can delete multiple lines at once. Be sure to review what is selected before performing the Delete action.

Processing a Supplier Return🔗

Confirming Supplier Return picking🔗

Picking refers to the process where individual items are picked from a fulfilment facility (usually a warehouse or a pharmacy store).

Once a return has been created, the next step is to go get the items to prepare the actual return. To help with that, you are able to generate a pick slip document. A pick slip indicates:

  • The items to be picked
  • The quantity and batch numbers for each item
  • If you manage your inventory with storage locations, where the items are located

Once all items are picked and packed. You can then confirm the picking of the return to indicate that it is ready to be dispatched.

To confirm that a return has been picked, tap on the Confirm Picked button.

Alt Text

Once picking is confirmed:

  • Return status is now PICKED
  • Goods are no longer part of your inventory
  • You are now invited to confirm the shipping via the Confirm Shipped button
  • If your supplier is also using mSupply, then an Customer Return has been generated and is now visible to your supplier

At this stage, you are still able to edit return lines, to add items or to delete existing lines. However, if picking has been confirmed, you need to make sure to inform your fulfilment facility of any change so they can make sure that the return is still correct.

Confirming the Supplier Return shipping🔗

The last step to return stock with a Supplier Return is to confirm that stock has been shipped.

To confirm that a Supplier Return has been shipped, tap on the Confirm Shipped button.

Once shipping has been confirmed:

  • Return status is now SHIPPED
  • You can no longer edit return lines
  • You can no longer delete the return
  • Your supplier is able to mark the return as DELIVERED once they receive the return

Tracking Progress of Supplier Returns🔗

If your supplier is also using mSupply, you will be able to see when they receive your returns:

  • status will become DELIVERED when goods are received: your supplier confirmed that they received your return
  • status will become VERIFIED when the return has been verified by your supplier. Goods are now a part of their inventory.

Viewing a Supplier Return🔗

When viewing a specific return, you can view the batches on that return grouped by item or with each batch listed separately. To change the view mode, click the Group by item switch.

When grouped by item, you can expand the item to see individual batches, or use the expand in the table header to expand all grouped rows. If you click on an item you will also see all selected batches, as shown in this example:

Group by Item

If you do not have enough room on your screen, or simply aren't interested in some of the columns shown, you have the option of hiding which columns are shown in this view.

Click on the Show / hide columns button which is at the top right of the table. This gives a list of the columns available - you can check the columns you want to see. The options chosen are stored for the current browser, so next time you view a Supplier Return, you will see the selected columns only. If you have chosen which columns to show, then the button is shown in blue to remind you that there are more columns available.

In the below example, we are hiding the pricing columns

Hide columns