Consignment Stock

Track consignment stock ownership and movements across locations and transactions.

The consignment process in Bevica is a structured method for handling stock that is held on consignment—meaning items are received into inventory but not owned or invoiced until they are sold. The page explains how this process separates consignment stock from normal inventory by using dedicated GL accounts, posting groups, and a specific consignment location, ensuring accurate financial and stock tracking.

It outlines how consignment goods are received at no initial cost, sold through standard sales orders, and later matched to supplier purchase invoices based on actual sales, with each stage creating the appropriate accounting entries.

Overall, the process ensures businesses can sell goods they do not yet own while maintaining clear visibility of liabilities, stock values, and profit impact.

Prerequisites

Knowledge of inventory processes within Bevica.

Knowledge of purchase and sales processes within Bevica.

Consignment Stock Overview

1

Create two new GL accounts

Consignment Stock and Consignment GRNI/Liability

2

Create a new location for Consignment stock

3

Complete Inventory Posting Setup

Create records for the Consignment location/Inventory Posting Group combinations.

Set the Inventory Account (Interim) to be the new Consignment Stock GL account.

Set the Inventory Account to be either your normal stock account (2120) or the new Consignment Stock GL account

4

Consider Dimensions

Create any relevant dimensions to default against items, customers or vendors.

5

General Product Posting Group

Create a new General Product Posting Group for Consignment stock. Allocate this to items you will be purchasing as consignment stock

6

Complete General Posting Setup

Create new General Posting Setup records for the relevant combinations of General Business Posting Groups and the new Consignment General Product Posting Group.

Set the Invt. Account Account (Interim) to be the new Consignment GRNI/Liability G/L Account.

Set the other GL Accounts as per Gen. Bus. Posting Group/STOCK combination

Allocating the Consignment General Product Posting Group to item records assumes you will not be purchasing items as both consignment and normal stock.

It is the General Product Posting Group on the purchase line which determines the GRNI account posted to when the purchase receipt is posted.

If an item can be bought as normal and consignment stock and you would like a Consignment GRNI/Liability account, users will need to switch the General Product Posting Group on the purchase line manually.

Create and Receive a Purchase Order for Consignment Stock

Create a purchase order as normal, ensuring that:

• The location used on the purchase order is the consignment location
• The item(s) entered onto the purchase line(s) have the General Product Posting Group of consignment
• The relevant dimensions have been entered

When the purchase order is received, it will:

• DR the new Consignment Stock GL account
• CR the new Consignment GRNI/Liability account

Create and Post a Sales Order for Consignment Stock

Create a sales order as normal, ensuring that:

• The location used on the sales order is consignment location
• The relevant dimensions have been entered

When the sales order is posted (shipped & invoiced), it will:

• CR stock - this will either be your consignment stock account or your normal stock account depending on the Inventory Account set up in the inventory posting group for the Consignment location
• DR cost of sales
• CR sales
• DR sales ledger control account

Create and Post a Purchase Invoice for Consignment Stock sold

At the relevant point in time, you can report on Posted Sales Invoices Lines, filtered by Posting Date and the Consignment Location Code, and any relevant dimensions. This will give you a list of the consignment stock sold for that period. You can create a purchase invoice for each vendor for these items and quantities. Run Get Receipt Lines to link to the original PO/receipted stock and amend the quantities and costs if relevant.

When the PI is posted it will:

• CR Consignment Stock
• DR Consignment GRNI/Liability
• DR Stock (this will either be consignment stock or normal stock depending on the Inventory Account in the Inventory Posting Setup against the consignment location)
• CR purchase ledger control

You will still have a value in your Consignment Stock and Consignment GRNI/Liability accounts for the consignment stock you have received but not yet invoiced the supplier for.

Learn more about adjusting inventory