Consigned Goods answers “what do my vendors have here on memo, and what do I owe them?” It lists every piece marked as on memo from a vendor that you have not yet paid for or returned. It covers jewelry, watches, diamonds, colored stones and pearls in one list.
It is the other side of Memo Liability, which lists goods you have out on memo to customers.
Open it from Reports → Consigned Goods, or from the All consigned goods button on the Vendor Memos page.
Columns
- Stock #: tap it to open the piece.
- Received, Days: the purchase date on the piece and how many days you have held it.
- Vendor: shown as a column only in Item detail view. When grouped, each vendor is a heading.
- Vendor Memo #: the vendor’s invoice or memo number from the piece.
- Type, Description
- Qty: pieces for jewelry, watches and pearls, carats for diamonds and colored stones.
- Where: see below.
- Invoice: for a sold piece, the invoice it sold on and who bought it. Tap to open the invoice.
- Cost: the vendor’s cost of the piece.
- Balance Due: for a sold piece, what you still owe the vendor after any payouts.
Cost and Balance Due only appear for users who can see cost.
Where
- In stock: the piece is in your store.
- Out on memo: you have sent the piece out on memo to a customer.
- In stock + on memo: some of the quantity is in each place.
- Sold, not paid: the piece sold and the vendor has not been paid in full. These are the same pieces the Vendor Memos page lists for payout, with the same balances.
- No stock, no sale: the piece shows no quantity in stock or on memo, but no invoice sold it either. Check these. It may have gone back to the vendor without being marked returned, or its quantity may be wrong.
Once you pay the vendor for a piece on the Vendor Memos page, or mark it returned, it leaves this report.
Filters
- Where: pick one location, or In stock or out on memo to hide sold pieces.
- Vendor: one vendor’s goods.
- Type: jewelry, watches, diamonds, colored stones or pearls.
- Days held: 0-30, 31-60, 61-90 or 91+ days.
- By vendor / Item detail: grouped with a subtotal per vendor, or one flat list.
- Store: when you have more than one store.
- Include photos: photos show on screen and in print. The Excel and CSV exports carry an Image URL column instead.
Totals
The footer shows how many pieces are in stock or out on memo and their cost, how many sold pieces are not yet paid and the balance you owe, any pieces with no stock and no sale, and the total cost of everything listed.