Inventory Management
This chapter covers the day-to-day tools for managing physical inventory: transferring goods between stores, adjusting quantities, counting inventory, checking stock status, and managing shelf locations.
Item Transfers
An Item Transfer moves inventory from one store to another. The transfer creates two linked transactions — a Transfer Out in the sending store and a Transfer In in the receiving store. When posted, the transfer:
- Decreases on-hand in the sending store
- Increases on-hand in the receiving store (once received)
- Posts through a transfer clearing account in the General Ledger
- Tracks serial numbers if the items are serial-tracked
| Screen | Access | Purpose |
|---|---|---|
| Item Transfer | Inventory → Item Transfers | Create or edit a transfer |
| Transfer List | Inventory → Transfer List | Browse and search transfers |
Key Fields
| Field | Purpose |
|---|---|
| Transfer No. | Auto-assigned document number |
| Transfer Type | Display only — shows Transfer Out or Transfer In depending on which side you are viewing |
| To/From Store | The other store in the transfer. For a Transfer Out, this is the destination store. For a Transfer In, this is the source store. |
| Transfer Account | The GL clearing account used to balance the inter-store transfer. Defaults from the store’s Transfer Account setting. |
| Memo | Free-text note for the transfer |
| Transfer Status | Shows In-transit until the receiving store posts the Transfer In, then shows Received |
| To Transfer No. | The linked transfer document number in the other store |
| Picked? | Checkbox indicating the transfer has been picked and is ready for shipment |
Item Grid
The item grid shows columns for Item Number, Description, Size, On Hand, Quantity, Amount, Deposit, Levy, and Total. Enter the items and quantities to transfer.
Toolbar Actions
| Button | Action |
|---|---|
| Item Search | Search for items by number or description |
| View Serials | View serial numbers on the transfer |
| Receive Transfer | Post the Transfer In to receive items into the destination store |
Transfer Workflow
- At the sending store, create a new Item Transfer and select the destination in the To Store field
- Add items and quantities to the grid
- Optionally check Picked? to indicate the items have been physically gathered
- Save and post — inventory leaves the sending store and the status shows In-transit
- At the receiving store, open the linked Transfer In and click Receive Transfer to accept the goods into inventory
Item Adjustments
An Item Adjustment changes on-hand quantities without a purchase or sale. Common uses include shrinkage, damage, write-offs, samples, and corrections. When posted, it:
- Increases or decreases inventory quantities
- Debits or credits the item’s asset account
- Posts the offset to a specified expense account
- Handles serial number entry and expiry tracking
| Screen | Access | Purpose |
|---|---|---|
| Item Adjustment | Inventory → Item Adjustments | Create or edit an adjustment |
| Adjustment List | Inventory → Adjustment List | Browse and search adjustments |
Key Fields
| Field | Purpose |
|---|---|
| Adjustment No. | Auto-assigned document number |
| Date / Time / Store | Standard transaction header fields |
Adjustment Tabs
| Tab | Contents |
|---|---|
| Accounts | Reason — the adjustment reason code
(auto-fills the expense account). Expense Account — the GL account that absorbs the cost of the adjustment. Expense Amount — the total cost of items being adjusted (read-only). |
| Expiry Info | Batch Number and Expiry Date for the selected item line — used for lot-tracked or perishable products. |
Item Grid
Columns: Item Number, Description, Size, On Hand, Quantity, Amount, Deposit, Levy, and Total. Enter a positive quantity to add inventory or a negative quantity to remove it. Quasar automatically calculates the cost based on the item’s current average cost.
Adjust Reason Codes
| Screen | Access | Purpose |
|---|---|---|
| Adjust Reason | Inventory → Adjust Reasons | Create or edit reason codes |
| Reason List | Inventory → Reason List | Browse reason codes |
Each reason code links to a GL expense account. When you select a reason on an adjustment, Quasar automatically fills in the expense account. Common reasons:
- Shrinkage — unaccounted-for loss
- Damage — broken or spoiled goods
- Samples — product given for demonstration
- Correction — fixing data entry errors
Toolbar Actions
| Button | Action |
|---|---|
| Item Search | Search for items by number or description |
| View Serials | View or edit serial numbers on the adjustment |
| Production Batches | Create a production batch from the adjustment items (see Production chapter) |
Physical Inventory Counts
A Physical Count records the actual quantities on hand for a set of items. After counting, Quasar compares the counted quantities to the system on-hand and generates adjustment transactions for the differences. This is the primary tool for periodic inventory audits.
| Screen | Access | Purpose |
|---|---|---|
| Count Items | Inventory → Count Inventory | Create or edit a physical count |
| Count List | Inventory → Count List | Browse and search count documents |
Key Fields
| Field | Purpose |
|---|---|
| Count No. | Auto-assigned document number |
| Description | A name for this count (e.g., “March 2026 Full Count”) |
| Date | The date the count is performed |
| Location | Optional — limit the count to a specific shelf or bin location |
| Employee | The employee performing the count |
| Store | The store being counted |
Item Grid
Columns: Item Number, Description, Size, On Hand, and Counted. The On Hand column shows the system’s current on-hand quantity (read-only). Enter the actual counted quantity in the Counted column.
Toolbar Actions
| Button | Action |
|---|---|
| Item Search | Search for an item already on the count sheet |
| Add Items | Bulk-load items to count by department, subdepartment, brand, vendor, group, or location |
| Clear Items | Remove all items from the count (with confirmation) |
| Not Counted | Find items that should have been counted (they have on-hand stock in this store) but are not on any active count sheet. Adds them to the current count so nothing is missed. |
How Counting Works: Count as You Find
Quasar’s counting model is additive. You count items as you find them, wherever you find them. Multiple employees can create separate count documents for the same items and the system automatically consolidates the totals.
For example: Employee A finds 3 units of item 101 on Aisle 2 and enters them on their count. Employee B finds 4 more units of item 101 in the back room and enters them on a different count. When you process counts, Quasar adds the two entries together (3 + 4 = 7) and compares the combined total against the system on-hand to calculate the adjustment.
Counting Workflow
- Create one or more Count documents for the store — you can split by location, employee, or area
- Use Add Items to pre-load items, or simply scan/enter items as you find them
- Optionally print count sheets for clipboard use
- Walk your assigned area and record quantities in the Counted column
- Save each count — multiple counts can exist simultaneously for the same store
- Use Not Counted to identify items with on-hand stock that do not appear on any active count sheet
- Process all counts — Quasar consolidates the counted quantities across all count documents and generates Item Adjustments for the differences
Count Reports and Audit
Quasar provides a suite of reports that support every phase of the counting process — from pre-count preparation through post-count verification and discrepancy analysis. Run these reports from Reports → Inventory.
| Report | Purpose |
|---|---|
| Count Sheet | A printable worksheet listing the items on a count document with a blank “Counted” column for hand-writing quantities. Print this before sending staff to the floor. |
| Count Verify | A verification worksheet showing each item and its counted quantity alongside a blank Verify column. Give this report to a supervisor or audit staff member who independently re-counts a sample of items. If the verify quantities disagree with the original counted quantities, the count should be investigated and corrected before processing. |
| Count Discrepancy | The most critical post-count report. It consolidates all active counts for a store, adds up the counted quantities per item, and compares each total against the system on-hand. The report shows three columns: Counted, On Hand, and Discrepancy (Counted − On Hand). An option to include zero-discrepancy items lets you confirm that matching items were actually verified, not just skipped. |
| Items Not Counted | Lists every item that has on-hand stock in the store but does not appear on any active count document. This is the report-based equivalent of the Not Counted button on the Count screen. It can be filtered by department, subdepartment, item group, or location to narrow the scope. Run this before processing counts to catch anything missed. |
| Count Items Not Found | Lists items that were entered on a count but could not be matched to a valid item in the database (the item_id is NULL). These are typically miskeyed item numbers or barcodes. Review and correct these entries before processing. |
Count Verify: Second-Count Audit
The Count Verify report is designed for audit control. After the counting team has finished entering their quantities, print the Count Verify report for a specific count document. It displays the count number, description, location, employee, and every item with its counted quantity — plus a blank line beside each item for a second count.
Give this report to a different employee (or auditor) who independently re-counts a sample or all of the items. Compare the verify column to the counted column:
- If they match, the count is reliable
- If they differ, investigate and recount the disputed items before processing
Stock Status
The Stock Status screen provides a real-time view of inventory levels across all stores. It is the primary tool for answering “how much do we have?”
| Screen | Access | Purpose |
|---|---|---|
| Stock Status | Inventory → Stock Status | View on-hand quantities across stores |
Single Item Mode
Enter an item number to see its stock position at every store. For each store, the display shows:
| Column | Meaning |
|---|---|
| On Hand | Current on-hand quantity |
| On Order | Quantity on open purchase orders |
| Dedicated | Quantity reserved by unfulfilled sales orders |
| In-Transit | Quantity on posted transfers not yet received |
| Price | Selling price at this store (with and without tax) |
Multiple Item Mode
Select a department, subdepartment, matrix, brand, color, vendor, item group, or location to see a summary of all matching items. Double-click an item to drill into its Single Item view.
Additional Features
| Feature | Description |
|---|---|
| Show Consignment | Toggle consignment columns: Consign In (received, to invoice), Consign Out (out, to invoice) |
| Serial Numbers | View serial numbers assigned to the selected item at each store |
| Mirror Status Screen | Opens a second Stock Status window that mirrors your item selection — useful on dual-monitor setups to compare items side by side |
| Sort By | Sort stores by Store Number, Store Name, or Business Number |
| Ignore Transits Before | Filter out old in-transit entries before a specified date |
| Ignore Dedicated Before | Filter out old sales order dedications before a specified date |
Locations (Shelf Management)
Locations define specific shelf positions, bins, or areas within a store. They are used to track where items are physically placed and to guide restocking.
| Screen | Access | Purpose |
|---|---|---|
| Location Master | Inventory → Locations | Create or edit location records |
| Location List | Inventory → Location List | Browse locations |
Locations are assigned to items on the item’s Stocking tab in the Item Master. Once assigned, locations appear in:
- Stock Status — as a column showing each item’s shelf position
- Physical Counts — as a filter for location-based counting
- QuasarReach — for mobile restocking and shelf management
Item History
The Item History screen shows day-by-day activity for a single item over a date range. It answers the question “what happened to this item?”
| Screen | Access | Purpose |
|---|---|---|
| Item History | Inventory → Item History | View daily inventory activity for an item |
Selection Criteria
| Field | Purpose |
|---|---|
| Item Number | The item to analyse |
| Store | Limit to a single store |
| Size | Filter by item size (or All Sizes) |
| Date Range | From/To dates — pre-set ranges like “Today”, “This Month”, etc. are available |
| Quantity Size | Display quantities in a specific unit (Each, Case, etc.) |
Display Columns
For each day in the range, the screen shows:
| Column | Meaning |
|---|---|
| Total Qty / Cost | Cumulative on-hand quantity and inventory cost |
| Sold Qty / Cost / Price | Units sold, cost of goods sold, and selling price for the day |
| Recv Qty / Cost | Units received (from vendor invoices) and their cost |
| Adj Qty / Cost | Units adjusted (from item adjustments and count adjustments) and their cost |
The first row shows Opening balances and the last row shows Closing balances. Double-click any date row to drill into the Inquiry screen showing the individual transactions for that day.
Sales History
The Sales History screen analyses an item’s selling performance over time, broken down by period. It is the primary tool for demand planning and reorder decisions.
| Screen | Access | Purpose |
|---|---|---|
| Sales History | Inventory → Sales History | View periodic sales analysis for an item |
Selection Criteria
| Field | Purpose |
|---|---|
| Item Number | The item to analyse |
| Store | Single store, store group, or all stores |
| Size | Filter by item size (or All Sizes) |
| Date | The “as of” date (periods count backwards from this date) |
| Period | Month, Week, or Day |
| Count | Number of periods to display (default: 12) |
Display Columns
| Column | Meaning |
|---|---|
| Period | Month name, week number, or day of week |
| Start Date | First date of the period |
| Quantity | Units sold in the period |
| Total Cost | Cost of goods sold |
| Total Price | Revenue from sales |
| Profit | Price minus Cost |
| Margin | Profit as a percentage of Price |
Below the grid, summary fields show the item’s Min/Max stocking levels, Last Purchased and Last Sold dates, and current On Hand and On Order quantities — providing a complete picture for reorder decisions.
Inventory Screens Summary
| Screen | Menu | Help |
|---|---|---|
| Item Transfer | Inventory → Item Transfers | Help |
| Item Adjustment | Inventory → Item Adjustments | Help |
| Adjust Reason | Inventory → Adjust Reasons | Help |
| Count Items | Inventory → Count Inventory | Help |
| Stock Status | Inventory → Stock Status | Help |
| Item History | Inventory → Item History | Help |
| Sales History | Inventory → Sales History | Help |
| Location | Inventory → Locations | Help |
- Chapter 17 — Production Batches and Lot Tracking