Find entries and reports

Every movement of vendor stock is a Consignment Ledger entry: receipts, adjustments, transfers, counts, sales, customer returns, returns to the vendor and ownership changes. You can reach these entries from wherever you start, as you would reach item ledger entries.

Consignment Ledger Entries

Search for Consignment Ledger Entries, or choose Consignment Ledger Entries on any of these pages:

Page	Shows the entries of
Item card, item list	The item
Vendor card, vendor list	The vendor's consignment stock
Sales order	The stock that the order's consignment lines sold
Purchase order	The stock that the purchase order bought, by a sale or an ownership change
Posted sales shipment, posted purchase receipt	The stock that the shipment sold or the receipt bought
Posted sales invoice, posted purchase invoice	The stock that the invoice billed to the customer or settled with the vendor
Posted consignment document lines	The entries the line posted
Consignment Journal lines	The item on the line

Each entry shows the Posting Date, Entry Type, Document Type, Document No., vendor, item, variant, serial, lot and package number, then Quantity and Remaining Quantity, the location, bin, Open and Received Date. More columns, such as Description, Expiration Date, Customer No., Sales Order No., Purchase Order No., Applies-to Entry, Correction, Unit Cost (LCY) and Cost Amount (LCY), can be shown with Personalize.

Find entries

Choose Find entries on a posted sales shipment, posted purchase receipt, posted sales invoice, posted purchase invoice or posted consignment document. The result lists Consignment Ledger Entry and, for consignment documents, Posted Consignment Document, next to the native entries. Choose the line to open them.

Invoices are linked to consignment entries through their value entries, so a sales invoice finds the units it billed and a purchase invoice finds the units it settled.

Serial and lot search

In Find entries, search by serial number, lot number or package number. Consignment entries with that number are listed with the native item tracking results, so you can trace a serial from the vendor's receipt to the customer's shipment.

For a recall, the Consignment Lot and Serial Trace report lists the consignment and item ledger entries of a number on one sheet, with the customers. See Analysis reports.

Posting preview

Preview Posting on a sales order, a purchase order, a consignment document or the Consignment Journal lists the Consignment Ledger Entry rows that posting will create.

Posted consignment documents

Search for Posted Consignment Documents. The list shows every posted receipt, adjustment, transfer, count, return and ownership change, and the posted usage reports and site counts of customers. Open a document to see its lines, then:

• Print prints it again with the report of its type: the Consignment Receipt Note for receipts, adjustments and ownership changes, the Consignment Return Note for returns to the vendor, the Consignment Transfer Note for transfers, the Consignment Count Result for physical counts and site counts, and the Consignment Usage Confirmation for usage reports.
• Send emails the return note to the vendor, or the usage confirmation or site count result to the customer, with their document sending profile.
• Find entries finds everything posted with the same document number and date.
• Line > Consignment Ledger Entries shows the entries of one line.

Posted physical counts keep the expected and counted quantity of every line, including lines without a difference.

Reports

Report	How to run it	What it shows
Consignment Receipt Note	Print on a posted receipt, adjustment or ownership change	One page per posted document with its lines, the variant, serial, lot and expiry on a detail line under each line, and signature fields
Consignment Return Note	Print or Send on a return to vendor, open or posted	The goods returned to the vendor, with the vendor and ship-from addresses and signature blocks. See Returns
Consignment Transfer Note	Print on a transfer, open or posted	The vendor stock moved between locations and bins
Consignment Count Result	Print on a physical count or site count, open or posted	Expected, counted and difference per line and what posting did with it; with Show Values, also the value of each difference
Consignment Usage Confirmation	Print Usage Confirmation on a usage report; Print or Send on the posted one	What the customer used from the site, for the customer to sign; once posted, with Show Prices, also the prices of the usage invoice
Consignment Site Delivery Note	Site Delivery Note on a posted transfer shipment to a site; Print Site Delivery Note on the transfer order	The delivery to a customer site, with lots, serials, expiry and the ownership clause
Consignment Settlement Summary	Settlement Summary on a consignment purchase invoice, posted or not, the settlement page and the vendor card	Every unit or lot a settlement invoice pays the vendor for. See Settle with vendors
Consignment Stock Confirmation	Consignment Stock Confirmation on the vendor or customer card and list	The year-end letter asking a vendor (their stock you hold) or a customer (your stock at their sites) to confirm the stock at a date
Consignment Physical Count Sheet	Print Count Sheet on a physical count or a site count	The lines to count, with a column for the counted quantity. It prints as the Consignment Physical Count Sheet with the vendor and location, or as the Consignment Site Count Sheet with the customer and site. Switch off Show Expected Quantities for a blind count
Consignment Stock Report	Search for it, or Consignment Stock Report on the role center or the Consignment Stock page	Vendor stock at a date (As of Date) by vendor, location, item and bin, with the variant, lot, serial and expiry on a detail line, the committed and available quantity, whether the location is in Warehouse Mode, and the informational value. Filter the stock lines on Vendor No., Location Code, Item No., Variant Code, Bin Code, Lot No. and Serial No., and add any other field with + Filter. Choose the Excel layout to analyze it
Consignment Aging and Expiry	Search for it, or from the role center or the Consignment Stock page	Open vendor stock in four age buckets since receipt, with expired stock, stock that expires soon, and stock older than the vendor's own aging period. Filter the entries on Vendor No., Location Code, Item No., Variant Code, Lot No. and Serial No.. Choose the Excel layout to analyze it
Consignment Customer Statement	Consignment Statement on the customer card	Stock at the customer's sites per item for a period. The Word layout is the statement to send; the Excel layout is the same data for analysis
Consignment Vendor Statement	See Settle with vendors	What happened to the vendor's stock in a period

Consignment Aging and Expiry options

Option	Meaning
Aging Date	The date at which age and days to expiry are measured
Period Length	The size of each age bucket as a date formula, as on Aged Accounts Payable: 30D gives 0-30, 31-60, 61-90 and over 90 days; 1M gives calendar months back from the aging date
Expires Within (Days)	How many days after the aging date stock counts as expiring soon. Expired stock is marked too
Only Expiring Stock	Include only stock that has expired or expires within that number of days

The Beyond Vendor Aging Period column marks stock older than the vendor's Aging Period, with the vendor's Aging Action next to it.

Values on the stock reports are informational: consignment stock belongs to the vendor and is not part of your inventory value.

Analysis reports

These reports open in Excel, one row per entry or line, so you can filter, total and pivot them. Search for them, or find them in the Settlement & Reports group of the Consignment menu on the role centers.

Report	Also on	What it shows
Consignment Unsettled Liability	Vendor card (Report > Consignment), Consignment Settlement page, vendor FactBox	At an As of Date, for example the month end, the units sold or bought out that the vendor has not invoiced yet and the customer returns not credited yet, at the expected settlement price, with the days outstanding and the unposted invoice that already holds the line. Invoices posted after the date count as not posted yet, so the report gives the accrual of a past month end too
Consignment Sales and Margin	Vendor, customer and item cards	Consignment sales and customer returns of a period: quantity, sales amount, the vendor's cost (the settlement price), margin and margin %, and whether the vendor has invoiced it. Filter on vendor, item, customer and location
Consignment Turnover Analysis	Vendor and item cards, Consignment Stock page	Per vendor, item and location for a period: stock at the start and the end, average stock, units sold, turnover, days on hand, days since the last sale, the stock older than the vendor's aging period, and Slow Mover when stock has not sold within No Sale Within (Days)
Consignment Lot and Serial Trace	Consignment Ledger Entries (Lot and Serial Trace), item card, lot and serial number information cards	Every consignment ledger entry and item ledger entry of a lot, serial or package number: receipt, moves, sales with the customer, customer returns, ownership change, drop shipments and customer sites, and where the remaining units are now (Held Now: vendor stock, customer site or own stock). With Show Customers Only it is the contact list of a recall
Consignment Site Stock	Customer card (Report > Consignment), Consignment Sites FactBox	Your stock at customer sites at an As of Date by customer, site, item, lot and serial number, with its value at cost, the last date stock came to the site, the expiry, and the last usage report and site count of the site. Expires Within (Days) keeps only stock that expires soon

Your own report layouts

The document reports have report selection usages, so you can choose your own report or Word layout and email them with document sending profiles:

• Report Selection - Purchase: Consignment Receipt Note, Consignment Vendor Statement, Consignment Settlement Summary, Consignment Return Note, Consignment Count Result, Consignment Vendor Stock Confirmation, Consignment Transfer Note.
• Report Selection - Sales: Consignment Customer Statement, Consignment Site Count Result, Consignment Usage Confirmation, Consignment Site Delivery Note, Consignment Customer Stock Confirmation.

A usage that has no report yet gets the standard consignment report the first time you print or send it. The document reports come with a Word layout that you can copy and edit in Report Layouts, for example to add your logo or change the ownership clause.

FactBoxes and cues

• Item card: the Consignment Stock FactBox shows the stock of each vendor per location. Choose a quantity to see the entries.
• Vendor card: the Consignment FactBox shows the vendor's stock on hand, its value, what was received and sold this month, the units On Sales Orders, the units Sold, Not Invoiced and their amount, the Aged Stock and the stock Expiring Within 30 Days.
• Customer card: the Consignment Sites FactBox shows, per site, your stock and its value, the Last Usage Report and Last Site Count, and the Open Usage Reports. Choose the value to open the Consignment Site Stock report of the site.
• Purchase invoice, posted purchase invoice: the Consignment Settlement FactBox shows what the consignment lines settle (units sold, bought out and returned, Warehouse Mode units, their sales amount and the amount), the vendor's settlement terms, and what of the vendor is still to settle: receipt lines on no invoice, returns not credited and the vendor stock left.
• Order Processor: the Lines to Ship and Open Usage Reports cues in the Consignment group.
• Purchasing Agent: the Open Documents and Receipts to Settle cues in the Consignment group, and Aged Consignment Stock.

The Consignment menu on the Order Processor, Purchasing Agent and Business Manager role centers has four groups:

Group	Pages
Documents	Consignment Documents, Consignment Receipts, Consignment Adjustments, Consignment Transfers, Consignment Physical Counts, Consignment Returns to Vendor, Consignment Ownership Changes, Consignment Usage Reports, Consignment Site Counts, Consignment Journal, Posted Consignment Documents
Stock	Consignment Stock, Consignment Bin Contents, Aged Consignment Stock, Consignment Ledger Entries
Settlement & Reports	Consignment Settlement, Consignment Stock Report, Consignment Aging and Expiry, Consignment Pick List, Consignment Bin Count Sheet, Consignment Unsettled Liability, Consignment Sales and Margin, Consignment Turnover Analysis, Consignment Lot and Serial Trace, Consignment Site Stock
Setup	Consignment Setup, Set Up Bitta Consignment, Set Up Consignment Warehouse Mode

What's next

Something not working? See Troubleshooting and FAQ.