MyWork24 Knowledge Base
Article

Consignment Stock (overview)

Edit

Consignment Stock lets you hold and bill for stock that belongs to a customer - third-party or "3PL" goods that sit in your warehouse but are not your stock to sell. Each arrangement is a consignment agreement that records who owns the goods, where they are stored, and what you charge to store and handle them.

The module has two sides that work together:

  • Logistics - bring the customer's stock in, keep it segregated, and return it to them.
  • Finance - accrue storage rent and fees, bill the customer, and record what they pay.
How consignment stock fits together: an agreement holds receipts and segregated stock on the logistics side, and charges, bills and payments on the finance side.

Where to find it

Procurement & Logistics -> Consignment Stock:

  • Agreements - the list of all consignment agreements; open one to manage its stock and billing.
  • Rent & occupancy report - a read-only overview of every agreement: stock on hand, locations used, and the billing picture (billed / paid / outstanding).

The key ideas

  • Agreement (CONS-...) - one storage arrangement with a customer: the owner, storage bay, storage-rent terms, fees and billing cycle. Everything else hangs off it.
  • Segregated stock - consignment stock is tagged so it can never be confused with your own: it carries the inventory category CONSIGNMENT and a lot reference equal to the agreement (CONS-ref). Because of this it is excluded from your sellable availability and never syncs to the ERP as yours - but it is still tracked by building, floor and location.
  • Receipts and return shipments - stock comes in on a Local Receipt and goes back to the owner on a Local Shipment, both bound to the agreement. Existing receipts can be imported into an agreement.
  • Charges - storage rent (accrued each billing cycle) plus receipt / handling / shipment / setup fees, written to the agreement's ledger.
  • Bills and payments - charges are grouped into a bill (CBILL-...) that you issue and record payment against (full or partial).

Xero is the finance system of record. Until the Xero integration is live, myWork tracks billing and payments itself; when Xero is connected, issuing a bill will post it to Xero and payments will sync back - nothing you do here is wasted.

Who can do what

Finance and logistics duties are separate permissions, so a procurement person can move stock without touching money and a finance person can bill without touching stock:

  • Consignment User - view agreements, stock on hand, receipts / shipments and the charge ledger (read only).
  • Consignment Admin - the logistics / procurement side: create / edit agreements, activate / suspend / close, receive stock, import receipts, and return stock to the owner (create the LR / LS). Does not include billing.
  • Consignment Billing - the finance side: generate, issue, record payment against and void bills, and run rent accrual.
  • Consignment Report - view the rent / occupancy report only (a read-only analyst / auditor role).

These are usually bundled into two roles - a Consignment Logistics role (User + Admin) and a Consignment Finance role (User + Billing + Report). A system administrator can do everything.

Related articles