Quasar Docs
Chapter 16

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
ScreenAccessPurpose
Item Transfer Inventory → Item Transfers Create or edit a transfer
Transfer List Inventory → Transfer List Browse and search transfers

Key Fields

FieldPurpose
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

ButtonAction
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

  1. At the sending store, create a new Item Transfer and select the destination in the To Store field
  2. Add items and quantities to the grid
  3. Optionally check Picked? to indicate the items have been physically gathered
  4. Save and post — inventory leaves the sending store and the status shows In-transit
  5. At the receiving store, open the linked Transfer In and click Receive Transfer to accept the goods into inventory
Transfer Pricing The transfer amount is normally based on cost. If the sending store’s Price Level is set to something other than “Cost” (e.g., a retail price level), Quasar uses the selling price as the transfer value instead. This is configured on the Store Master.
📱 QuasarReach Pick pending transfers from a mobile device via Inventory → Pick Inventory Transfer in QuasarReach. Load the transfer, scan items to confirm picked quantities, and mark the transfer ready for shipment.

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
ScreenAccessPurpose
Item Adjustment Inventory → Item Adjustments Create or edit an adjustment
Adjustment List Inventory → Adjustment List Browse and search adjustments

Key Fields

FieldPurpose
Adjustment No. Auto-assigned document number
Date / Time / Store Standard transaction header fields

Adjustment Tabs

TabContents
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.

Cost Security The Amount and Total columns are only editable if the current user has the CHANGE_ITEM_COST security permission. Otherwise, cost is calculated automatically and the fields are read-only.

Adjust Reason Codes

ScreenAccessPurpose
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

ButtonAction
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)
📱 QuasarReach Adjust on-hand quantities from the field via Inventory → Item Adjustment in QuasarReach. Select reason codes, scan barcodes, and enter quantities from a phone or tablet.

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.

ScreenAccessPurpose
Count Items Inventory → Count Inventory Create or edit a physical count
Count List Inventory → Count List Browse and search count documents

Key Fields

FieldPurpose
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

ButtonAction
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

  1. Create one or more Count documents for the store — you can split by location, employee, or area
  2. Use Add Items to pre-load items, or simply scan/enter items as you find them
  3. Optionally print count sheets for clipboard use
  4. Walk your assigned area and record quantities in the Counted column
  5. Save each count — multiple counts can exist simultaneously for the same store
  6. Use Not Counted to identify items with on-hand stock that do not appear on any active count sheet
  7. Process all counts — Quasar consolidates the counted quantities across all count documents and generates Item Adjustments for the differences
Freeze Activity During Counts For the most accurate results, avoid selling, receiving, or adjusting inventory while a count is in progress. If this is not practical, schedule counts during off-hours or use location-based partial counts to minimize disruption.
📱 QuasarReach Count inventory from a phone or tablet via Inventory → Count Inventory in QuasarReach. Scan barcodes and enter quantities on the device. Counts sync to the server when reconnected.

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.

ReportPurpose
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
Review Reports Before Processing Always run the Items Not Counted and Count Items Not Found reports before processing counts. Items Not Counted identifies stock that was never counted (and would otherwise be adjusted to zero). Count Items Not Found catches data entry errors that would silently be ignored during 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?”

ScreenAccessPurpose
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:

ColumnMeaning
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

FeatureDescription
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.

ScreenAccessPurpose
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
📱 QuasarReach Create locations (Shelf Management → Create Locations), assign items to locations (Set Locations), and view restocking needs (Restock Shelves) — all from a mobile device.

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?”

ScreenAccessPurpose
Item History Inventory → Item History View daily inventory activity for an item

Selection Criteria

FieldPurpose
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:

ColumnMeaning
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.

ScreenAccessPurpose
Sales History Inventory → Sales History View periodic sales analysis for an item

Selection Criteria

FieldPurpose
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

ColumnMeaning
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

ScreenMenuHelp
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
What’s Next?
  • Chapter 17 — Production Batches and Lot Tracking