Hold stock you do not own
What this does
Consignment stock sits in your warehouse but belongs to the supplier until it is sold. You store it and sell it; you never buy it. Useful when a profile supplier wants a colour range on your floor without you funding it.
Before you start
- Enable Consignment under Inventory › Configuration › Settings, in the Traceability section.
- There is no purchase order: consigned goods are received by hand, because nothing was bought.
Steps
Most of the time, products stored in a company's warehouse are either purchased from suppliers, or are manufactured in-house. However, suppliers will sometimes let companies store and sell products in the company's warehouse, without having to buy those items up-front. This is called consignment.
Consignment is a useful method for suppliers to launch new products, and easily deliver to their customers. It's also a great way for the company storing the products (the consignee) to earn something back for their efforts. Consignees can even charge a fee for the convenience of storing products they don't actually own.
-
01
From the Inventory dashboard, open Receipts and click New.
-
02
Set Receive From to the supplier.
-
03
Set Assign Owner to the same supplier — this is what marks the goods as theirs.
-
04
Add the products and the quantities received.
-
05
Validate.
Enable the consignment setting
To receive, store, and sell consignment stock, the feature needs to be enabled in the settings. To do this, go to Inventory › Configuration › Settings, and under the Traceability section, check the box next to Consignment, and then click Save to finish.
Receive (and store) consignment stock
With the feature enabled in WindoorERP, consignment stock can now be received into a warehouse. From the main Inventory dashboard, click into the Receipts section. Then, click Create.
Note
Consignment stock is not actually purchased from the vendor; it is simply received and stored. Because of this, there are no quotations or purchase orders involved in receiving consignment stock. So, every receipt of consignment stock will start by creating manual receipts.
Choose a vendor to enter in the Receive From field, and then choose the same vendor to enter in the Assign Owner field.
Important
Since the products received from the vendor will be owned by the same vendor, the Receive From and Assign Owner fields must match.
Once the vendor-related fields are set, enter products into the Product lines, and set the quantities to be received into the warehouse under the Done column. If the Units of Measure feature is enabled, the UoM can be changed, as well. Once all the consignment stock has been received, Validate the receipt.
Sell and deliver consignment stock
Once consignment stock has been received into the warehouse, it can be sold the same as any other in-stock product that has the Can Be Sold option enabled on the product form.
To create a sales order, navigate to the Sales app, and from the Quotations overview, click Create. Next, choose a customer to enter into the Customer field.
Note
The Customer must be different from the Vendor that supplied the consignment stock received (and stored) in the warehouse.
Add the consignment product under the Product column in the order lines, set the Quantity, and fill out any other pertinent product details on the form. Once the quotation is complete, click Confirm.
Once the quotation has been confirmed, it becomes a sales order. From here, the products can be delivered by clicking on the Delivery smart button, and selecting Validate to validate the delivery.
Traceability and reporting of consignment stock
Although consignment stock is owned by the vendor who supplied it, and not by the company storing it in their warehouse, consignment products will still appear in certain inventory reports.
To find inventory reports, go to Inventory › Reporting, and choose a report to view.
Note
Since the consignee does not actually own consignment stock, these products are not reflected in the Stock Valuation report, and have no impact on the consignee's inventory valuation.
Product moves report
To view all information about on-hand stock moves, navigate to the Product Moves dashboard by going to Inventory › Reporting › Product Moves. For consignment products, the information in this report is the same as any other product: the history of its product moves can be reviewed; the Quantity Done and Reference document are available; and its Locations are available, as well. The consignment stock will originate from Partner Location/Vendors.
Tip
To view a consignment product's moves by ownership, select the Group By filter, choose the Add Custom Group parameter, and then select From Owner, and Apply to finish.
Tip
To see forecasted units of consignment stock, go to Inventory › Reporting › Forecasted Inventory.
Stock on hand report
View the Stock On Hand dashboard by navigating to Inventory › Reporting › Inventory Report. From this report, the Locations of all stock on-hand are displayed, in addition to the quantities per location. For consignment products, the Owner column will be populated with the owner of those products, or the original vendor who supplied the products in the first place.
Selling it
Sell it like any other product: quote, confirm, deliver. The only rule is that the customer must not be the supplier who owns the stock.
What the reports do
Consigned goods appear in the stock and moves reports, so you can see and trace them — but they are not in your inventory valuation, because they were never yours.
Common mistakes
- Leaving Assign Owner empty, which quietly turns the supplier's stock into yours on the balance sheet.
- Raising a purchase order for consigned goods.
- Counting consigned stock as available for a job without agreeing the terms with the supplier.
Was this article helpful?
Thanks — your feedback helps.
Running a window or door factory?
Ask for a demo