The ATP (Available to Promise) report in Delivrd is a great way to forecast any possible shortages of stock and take appropriate action.
The ATP report relies on a demand forecast, on future purchase order, and on stock on hand. It is useful both as a tool to prevent future stock shortage, as well as future spend analysis tool.
Here’s how ATP works:
For each product, the system shows the next 12 months starting from the current month.
Delivrd fetches the number of open future receipts for the month. Please note that to display receipts in the ATP report, you need to specify the delivery date either in the purchase order header or lines. The date in the lines is more important, so if both header and line date exist, the system considers only the line date. Except specifying the dates, you also need to release the order.
You enter the demand that you expect for this month.
The system calculates the ATP automatically according to this formula: last month ATP + current month receipts – current month demand.
It is possible to update the sales forecast either in a product, in which case the demand will be the same for every month, or by uploading demand data by month, with forecast data for each month.
Currently in Delivrd, when order processing is completed (issue of product in sales order or receiving of products in purchase order), status of order is marked as Completed.
Once processing is done, the next step in the order life cycle is payment – either paying a supplier or getting paid by your customer.
We have just released a new feature that allows you to track the status of payment for your purchase order or sales orders:
In the relevant order list page, if an order is in status Completed, you can now mark that order as Paid.
When you click the Paid button, you can record any comment you like (for example, vendor invoice number), and also track the payment date. An order marked as paid changes its status to (you guessed right) – Paid.
Sometimes it’s hard to calculate the total value of your stock because of intensive inventory transactions. Delivrd inventory management software and its Stock Valuation Report feature give you an insight into your total inventory value with just a couple of clicks. Here’s how it works:
In the navigation bar, click Products & Inventory > Inventory List.
In the upper-right corner of the Inventory List page, hover over the … button and choose Stock Valuation Report.
And that’s it! The stock valuation report will show you the product category, available quantity, location, unit value, and total value of the product, which is unit value multiplied by quantity. Besides, Delivrd will calculate the total stock value, which is displayed in the upper-right corner of the report.
It is also possible to filter the report by specific SKU number, location, or category.
Finally, it is possible to export the stock valuation report.
Whenever you create an inventory transaction (e.g. inventory count, receive or issue) in Delivrd, you can enter a remark. Documenting transaction details in remarks is very useful, in particular when working in multi-user environment.
With Delivrd latest release, you can now search through remarks entered in transactions. You can search by entering search text in the ‘Search By Remark’ box:
When you carry out inventory transactions – stock count, receiving products to stock or issuing products to a sales order, we strongly recommend to add remarks. It makes it easier for everyone to understand why these transactions happened.
You can view these remarks in inventory transaction history, one of Delivrd’s coolest features. And now, you can update existing remarks!
If you forget to add a remark or made a mistake while inputting one, you can just visit the inventory transaction history of the relevant inventory record, click on the remark to update it, or add a new remark if one doesn’t exists.
And here’s a short clip explaining how to update remarks of any inventory transaction:
Barcode scanning is easy to implement, provides clear return on investment, will make your inventory much more accurate and will help prevent costly pick/pack/ship mistakes. Imagine standing in line in a supermarket and having to wait for the person at the counter to enter the name of all products. How slow, inefficient and error prone would that be?
In Delivrd, every process can (and should) be implemented using barcode scanning.
Barcode Scanning Process
To get started with barcode scanning, you will need:
A barcode scanner
Labels with barcodes which include the relevant data – it can be a product’s SKU number (or part number), EAN/UPC code, or a label of a package with its tracking number.
There are many types of barcode scanners, but they all work the same: you connect them to your desktop computer or tablet, and they start acting as a keyboard. When you scan a barcode label, the data from the label is read by the barcode scanner, and is passed to your desktop or tablet, as if you types the data on the barcode label.
Barcode scanners do not require any software or driver. They are similar to keyboards, so you just plug them to your computer and start using without having to install anything.
Barcode scanners can be connected to a desktop/tablet either with a wire or wireless (again, similar to keyboard).
Wired barcode scanners – These scanners have a cable running from their USB connector to the scanner itself. Here’s an example:
Wired Barcode Scanner
Wireless Barcode Scanners – These scanners are not connected with a cable to desktop/tablet, but use either bluetooth connectivity or have a small USB dongle connect wirelessly to the scanner.
Wireless Barcode Scanner
The big adventage of wireless scanners is that you are not limited by the length of the cable and you will not have to worry about the cable.
Choose a wired scanner when you are stationary, standing or sitting next to a stationary (usually desktop) completer. Use a wireless scanner when you need to move around, but keep in mind that you will still need to be able to see what you scan, so you can’t go too far from your desktop / tablet.
Recommended combinations are: wired scanner + desktop if you are stationary, wireless scanner + tablet, for mobility.
If you are using an iPad tablet, make sure your scanner is compatible. Android/Windows tablet have a much wider range of supported scanners, since the iPad does not have a USB port.
Once a scanner is connected to your computer, you can start scanning barcode labels. You can find barcode label on many products in your inventory. Some products have EAN/UPC labels, which are being scanned in supermarkets, while others would have serial numbers, which identify each product uniquely, such as computer monitors or TV screens. Many mobile phones have IMEI barcode labels attached to their backs. Here are some examples:
2D barcodes/ QR codes (middle of bottom row in image above) are not commonly used in inventory management & order fulfillment applications. If you do plan to use 2D barcodes, make sure your barcode scanner supports reading them.
Many products have barcode labels applied by the product’s manufacturers. If you manage inventory and/or sell products which are not labeled, we strongly suggest you label them or ask your supplier to label them. You can buy a label printer and print the barcodes yourself and apply them to your products, or buy pre-printed labels.
Barcode Scanning in Delivrd
Barcode scanning is key to accurate, efficient inventory management & order fulfillment.
In this tutorial, we will focus on barcode scanning in inventory management processes in Delivrd. In later tutorials, we will explain how barcode scanning is used in receiving products from purchase orders, issuing products for a sales order, and scanning barcodes in pick/pack/ship processes.
Barcode scanning in inventory management
In order for you to use barcode scanning in inventory management in Delivrd, you first have to make sure barcode labels are applied to your products.
The barcode label should include a unique number to identify each product. In Delivrd, that unique identifier is called SKU (stock keeping unit). The number on the barcode label which identifies the product should be entered in the relevant Delivrd product as SKU.
Product SKU in Delivrd
Once the SKU number in Delivrd is the same as the number on the barcode label applied to the product, you can scan the product in the search box in Delivrd’s inventory list page. Once scanned, Delivrd will find the relevant product, and then, you can perfromd any inventory transaction: inventory count, issue, receive, or transfer to another location.
Delivrd inventory management software now has a feature of sending emails with inventory alerts. To set up this feature, go to Settings and make one of the following choices in the Inventory Alert drop-down list:
Don’t send any alerts: This is a default option that does not allow to send the inventory alerts.
Send only low inventory alerts: Choose this option to send the alerts when the inventory quantity is below the reorder point or safety stock.
Send list of all inventory: Choose this option to send inventory reports for all products, regardless if the inventory quantity is below the reorder point or safety stock.
If you assigned any products to suppliers, then it is also possible to send the inventory alerts to those suppliers. To do so, just specify the email address when creating or editing a supplier record. It is possible to add multiple email addresses for a single supplier, by separating each email with a comma (,)
To send the inventory alerts, to your own email and to your suppliers, go to the Inventory List page, and from the Actions menu, select ‘Send Inventory Alerts’:
In the navigation bar on the left, click either Products & Inventory > Products or Partners > Suppliers.
In the upper-right corner of the Products List or Suppliers page, click Actions > Products – Supplier Assignment.
In the upper-right corner of the Product-Supplier Assignment page that opens, click New Product-Supplier.
In the form that opens, select the product and supplier that you are going to connect. You can also optionally add the price you buy this product from the specified supplier, and select the status of assignment – either Active or Inactive.
When ready, click Save.
The system will reflect the product-supplier assignment in the inventory list by adding the Supplier column to the page where the product record is located.
The product price will be copied to replenishment order lines that you will create with this supplier and product combination, and the system will send inventory alerts to the supplier regarding their own products – more on inventory alerts coming soon.
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
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:
In the navigation pane on the left, click Products & Inventory > Serial Numbers.
In the upper-right corner of the serial number list, click New Serial.
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:
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
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.
After scanning the serial’s barcode label into the inventory location list search box, click Issue Serial.
2. 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: