Fast Inventory Transactions in Delivrd

With Delivrd inventory management software, you can quickly update inventory for a specific product. To do it, open the Inventory List page under Products & Inventory and scan the barcode of the product on this page. If you don’t have a barcode scanner, you can manually enter the SKU, EAN, or UPC of the product in the field above the inventory list, and then click Search.

If the system finds a result, you can directly receive or issue 1 piece from inventory, or choose to receive or issue any quantity you want. You can do this with the four buttons in the Inventory Transactions column: +1, -1, Receive, or Issue.

Click the corresponding button to open a window where you can enter the transaction details. For the Receive and Issue transactions, you can enter any value in the quantity field, whereas for the +1 and -1 transactions, this field is not available for editing, as quantity of transaction is 1.

 

As always, any inventory transaction you enter into Delivrd will be displayed in the Inventory Transaction History

twitteryoutube

Managing Inventory of Serial Numbers in Delivrd

In this user guide, we’ll describe how to manage the inventory of serial numbers in multiple locations, specifically, how to create, transfer, and issue serial numbers in Delivrd. Read on!

Creating a Serial Number
To start managing the inventory of serial numbers in Delivrd, you first need to create them. You can do it in several simple steps:

    1. In the navigation pane on the left, click Products & Inventory > Serial Numbers.

    1. In the upper-right corner of the serial number list, click New Serial.

  1. In the window that appears, choose the product for which you are creating the serial, and an inventory location for this serial.

After you choose a location, two things will happen:

    • The serial will be created in this inventory location.

  • A quantity of 1 piece will be added to inventory in this inventory location (there is no need to update the inventory separately).

Note: You can scan the barcode of your serial number into the serial number field instead of typing it.

Transferring a serial number to another location

To transfer a serial to another inventory location:

    1. On the inventory list page, scan the barcode of the serial. The inventory record of the product with the inventory location of the serial will appear. You can then either issue the serial or transfer the serial to another location. To choose the destination inventory location, click Transfer Serial

  1. In the window that appears, choose the location and add remarks, if necessary. When ready, click Save.

After you click Save, two things will happen:

  • Serial number location in serial inventory list will change to the new inventory location.
  • 1 piece will be deducted from the previous inventory location of the serial number (North inventory location in this example), and 1 piece will be added to the destination inventory location.

Issuing serial numbers

If the serial number no longer remains in any inventory location that is managed in Delivrd (for example, the serial is issued to sales order, returned to vendor, or scrapped), you can issue the serial number.

    1. After scanning the serial’s barcode label into the inventory location list search box, click Issue Serial.

  1. In the window that appears, you can add a remark to record the reason for the issue. When ready, click Save.

After you click Save, two things will happen:

  • The inventory will be deducted in 1 piece.

  • The serial will be marked as out of stock, but it will still appear in the serial numbers list.

If you try to search the inventory list for a serial that was already issued, you will get an error message:

That’s how you handle the inventory of serial numbers in Delivrd inventory management software.twitteryoutube

Beginners User Guide for Importing Product Data into Delivrd

Beginners User Guide for Importing Product Data into Delivrd

After signing up to use Delivrd inventory management software you will need to import your products into the system. This can be done by importing a CSV type file into the product database.

In order to import items into the Delivrd system you need to prepare a CSV file with your products information. If you are not sure of the format the file should be in you can download a sample file as shown below

Sample file

Please note the following two (2) limitations when importing source files:

  • Maximum file size for uploads is 100 KB.
  • You can upload only CSV files.

Click here for an explanation of the fields. 

Starting the importing process.

Click on the Import Products from CSV file button as shown below. After doing so you will be taken to a different screen where the actual import action will be implemented.

Adding an import file

Click on the +Add File button in order to browse to your source file’s destination and select it.

Starting the upload

In order to start the uploading process once the file has been uploaded you can click on either the Start Upload or Start buttons as shown below.

Creating the products

After the file has been successfully uploaded it is now ready to be imported into the Delivrd system by clicking on the Create Products button as shown below.

After importing the file

After the file has been imported successfully you are taken directly to the Products List page so you can view the imported products directly.

Downloading a sample file

You can download a sample source file and insert your data into the relevant fields which can then be imported as explained previously.

Explanation of the fields that can be imported.

Managing inventory across multiple warehouse locations

If you keep your product inventory in multiple locations in your warehouse you can manage their quantity and distribution in fulfilling customers’ orders with Delivrd’s Locations. This can be done by the accessing the Manage Locations option via Products & Inventory → Inventory List → Actions → Manager Locations as shown below.

After clicking on the Manage Locations option you will be taken to the Locations management screen where you can add a new location as shown below.

When clicking + New Location, a new window opens in which you will add the locations details.

There are two available fields, Name and Description. Name is used for naming the location of the products and Description to describe in short detail any relevant information as shown in the example below. This says the items that the customer ordered can be found on the second shelf in the north east side of the warehouse and that each order is fulfilled by one box of product.

After filling in the fields with the correct data you can save the information by clicking the green Save button.

In a few simple steps you can start managing you products inventory in the Delivrd system.twitteryoutube

Releasing Multiple Sales Orders in Delivrd

Releasing Multiple Sales Orders at the Same Time

You can now release multiple sales orders, from your inventory,  at one time via the green Actions button in the top right corner of the Sales Order page.

In order to use this feature you need to select the orders you want to release by ticking the boxes next to all the orders you want to release in the pound sign column (#).

After selecting the items you want to release go to the green Actions button in the top right corner.

Then select Release All Orders option.

After the orders are released only the orders that were not selected will remain.

twitteryoutube

Delivrd Dashboard Layout

There is now a new Dashboard look which gives you more important information in one glance so you can manager you inventory better and more efficiently.

Sales Orders to Fulfill – These are orders that have been set to a Released status but still needs to be fulfilled for the customer.

Shipments Awaiting Pick-Up: The Pick and Pack step has been finished and the orders status has been set to Completed and is awaiting pickup by the delivery company for shipment to the customer.

Overdue Purchase Orders: These are orders that have not had their status changed to Released or the processing of the order has not been completed in the last 30 days and is overdue.

Inventory Alerts: Items that have reached their Reorder or Safety Stock levels and need to be replenished as soon as possible in order to continue conducting business in a timely and efficient manner without losing customers.twitteryoutube

Warehouse Bin Management

With Delivrd you can now manage Bins. Bins are the location in which your products are stored so that can be picked by your fulfillment individuals and control your inventory location.

This option can be found be going to: Partners –> Bins

The Bins page looks like this:

Adding a new Bin

To add a new Bin simply select the “+ New Bin” button.

The below page will appear.

Explanation of the fields.

Title: The name of the Bin itself.

Sort Sequence: The order is which the picker would select the items when fulfilling an order with multiple items.

Location: The physical location of the bin in the warehouse, store, etc.

Status: Active or Inactive. Is this Bin being used currently or not? For example, the Bin might not have any products in it now and is not in use, so the Inactive status would be set until it’s been resupplied with items to fulfill an order. Please note: If no status is selected the default status of Active will be chosen automatically. This can be changed later if you so choose.

It is also possible to load the Bin data via a CSV file.

 twitteryoutube

Delivrd: Inventory Management

Inventory Alerts and Stock Monitor

Knowing when your product stock is running low is an key part of inventory management.

In Delivrd is now possible to view only the items that are below their Reorder or Safety Stock levels.

In the Dashboard page you can see the Inventory Alerts box. The number shown there represents the items that have reached their Reorder or Safety Stock levels and needs to be replenished or reordered as soon as possible.

For example, shown below are all the items that are in the system currently.

Note that there are four items showing that their stock is running low; highlighted in yellow and red.

This is reflected in the Dashboard under the Inventory Alerts box.

After clicking on the Inventory Alerts box you are taken to a new page showing the exact items that require your immediate attention.

You can now view all of your products that are running low or need to be reordered soon at a single glance!!!twitteryoutube

Fast Inventory Count

In Delivrd, the inventory management software, it is possible to manually update the inventory count directly from the Inventory List screen now, instead of going through the Actions button.

To update the quantity of a product after a manual count was carried out just click or tap (if you are using a mobile device) on the Quantity field for the said product.

After clicking or tapping you will be able to manual enter a value as shown below. A empty dialog box will appear awaiting your input.

After the correct value has been entered you need to press the “Enter” key on the keyboard either on the computer or mobile device. This is the only was the value will be saved. Clicking or tapping anywhere else on the screen will revert the value to its original value.

twitteryoutube

Delivrd: Reorder Point vs. Safety Stock

Reorder Point vs. Safety Stock: What’s the Difference?

The concepts of reorder point and safety stock may be confused in Delivrd, so we’d like to explain the difference in this article.

Reorder Point vs. Safety Stock

Imagine that you work for a company that prints on T-shirts, and you have a supplier from which you regularly order “blank” T-shirts of different colors. Black and white medium-sized T-shirts are high sellers, as most people prefer their corporate logos, rock band names, or just funny pictures to be printed on black or white tees.
Let’s take a white medium-sized T-shirt as an example. Let’s suppose that you have 10 boxes of white medium-sized T-shirts in stock, with 100 tees per box, and would like to reorder them from your supplier when you have 5 boxes (500 tees) left. So, how to achieve this during inventory management in Delivrd?

  1. Click Products & Inventory > Products to view a list of your products. To learn how to create and import new product records, see Delivrd User Documentation.
  2. To the left of the needed product name, click Actions > Edit.
  3. On the General tab, in the UOM (Unit of Measure) drop-down list, select Box.
  4. In the Reorder Point field, enter 5.
  5. Click Save.

blog_01_reorderpoint

As a result, you will get low inventory warnings when your inventory of white medium-sized T-shirts reaches 5 boxes. You can still take the T-shirts from the warehouse, but it’s a bad practice, which may result in reaching the safety stock limit.
Safety stock acts as a safety belt for your inventory. Issuing stock when it goes below safety stock levels is a poor inventory management practice and should be avoided whenever possible.
So, let’s suppose that you want to be alerted when their number reaches 2 boxes (200 T-shirts). In Delivrd, do the following:

  1. Click Products & Inventory > Products to view a list of your products. To learn how to create new products, see Delivrd User Documentation.
  2. To the left of the needed product name, click Actions > Edit.
  3. Click the Logistics tab.
  4. In the Safety Stock field, enter 2.
  5. Click Save.

blog_01_reorderpoint

As a result, the inventory of white medium-sized T-shirts will no longer be issued when it reaches 2 boxes, and the inventory amounts will be marked with red for all transactions until you make a replenishment order. And, when you reach the reorder point, the inventory amounts will be marked with yellow. Here’s how it looks in Delivrd:

inventory-list-rp

And here’s how it’s reflected in transaction history:

transaction-history-rp

However, it’s up to you decide what to do when you reach the safety stock level. In case of reaching the reorder point, it’s clear that you need to reorder inventory by using the replenishment (purchase) order in Delivrd.

But in case of reaching the safety stock, you can either stop all issues or fulfill customer orders until the stock level is zero. You can use the safety stock only as a measure of accurate inventory management, as the stock should never get below the safety stock level.

An accurate reorder point means that you never get lower than your safety stock level, but a good safety stock level means that your quantity never hits zero while people are still willing to purchase the product.
Note: The figures in the example above are very approximate. Of course, you should make thorough calculations, estimations, and forecasts to determine the exact figures for reorder point and safety stock.

Calculating the Reorder Point

And now let’s involve some math and see how to calculate the reorder point. Please note that it’s possible to make such calculations only when you have a stable sales/purchase cycle. As for the reorder point, it’s calculated for each product individually. So, here’s the reorder point formula:

(Average Daily Unit Issues x Delivery Lead Time) + Safety Stock

where average daily unit sales means the average number of product units that are sold per day, and the average delivery lead time is a time period that is typically required for a specific product to arrive.

 twitteryoutube

Multi Location Inventory Management in Delivrd, Part 5

Note: For up-to-date guides on using Delivrd, please refer to official Delivrd documentation.

This is the last part of our multi location inventory management series. We’ve covered initial setup , locations setup and carrying out inventory transactions: with orders or without orders.

This last part will explain Delivrd’s transaction history – a powerful tool to analyze historic inventory transactions for each inventory location.

Inventory Transaction History

Here’s an example of our kitchen buzzer timer’s inventory transactions:

Product Inventory Transactions

Main data fields displayed in the transaction history:

(Transaction) Type – type of inventory transactions. Possible values are: Initial Inventory Count, Inventory Count, Replenishment Order, Customer Order. Each transaction type has a different effect on inventory quantities (explained later)

Order Number – if the transaction was related to an order – either a replenishment (purchase) order or a customer order – the relevant order number is displayed, with a link to the order details.

Location – the inventory location where the transaction was carried out.

Quantity – the transaction’s quantity. for example, the number of pieces that were received from a supplier through an order or were issued from stock.

In an inventory count transaction, the quantity displays the actual quantity that was counted.

Inv. Change – the effect in terms of inventory quantity the transaction had. When inventory is issued (for example, for customer order) inventory is reduced, so the Inv. Change field has a – (minus) sign next to it. When inventory is received, quantity increases.

 In an inventory count transaction, the inventory change displays the difference between the quantity before the count and the quantity after the count. So if inventory quantity was 5 before an inventory count, and it is 8 after the count (because there were physically 8 pieces counted), the inventory change would be 8 – 5 = 3.

Cum Qty (cumulative quantity) – This is the inventory quantity once the transaction has been completed. It describes the actual quantity progress over time.

In the example above, after the product has been created in Delivrd, inventory count was carried out in 3 inventory locations: ‘Default’, ‘North’ and ‘South’. The cumulative quantity (Cum Qty) once the inventory counts were completed is 20, which is the sum of all previous transactions.

Then, various inventory transactions (both issue and receive) were carried out. The cumulative quantity is adjusted according to each transaction type and quantity.

Let’s examine the following transactions (marked with a red rectangle)

Stock Transfer

3 pieces were transferred from ‘North’ inventory location to ‘South’, so two transaction were created – one of them has a negative (marked with a minus) inventory change from North, and a complement positive transaction in the ‘South’ location. The total inventory after this two transactions remained the same (26) because the same quantity was issued and received.

You can also view a chart of a product’s inventory quantity over time (plotted based on the ‘Cum Qty’ field)

Inventory Charttwitteryoutube