NStock.us

Contents

inventory

Issue Stock

Issuing inventory is a negative adjustment that decreases your on-hand quantities. Inventory Pro supports multiple workflows for different issuing scenarios:

Issuing MethodAccess PathPurpose
Direct AdjustmentsInventory → Stock → Issue Stock (this page)Manual issues for damaged goods, samples, or items without formal documentation
Shipping OrdersOrders → Shipping → Shipping Orders → [Select SO] → Line Items → IssueCustomer shipments with order status updates, packing workflows, and invoice generation
Work OrdersOrders → Other → Work Orders → [Select WO] → Line Items → IssueConsume materials for jobs, build assemblies, and track manufacturing costs
Purchase Order ReturnsOrders → Purchasing → Purchase Orders → [Select PO] → Line Items → ReturnsSupplier returns and credit processing with proper PO line status updates
Cycle CountingInventory → Inventory → Cycle CountsSystematic physical inventory verification with variance analysis and optional approval workflows
Mobile IssuingInventory Pro Mobile → Inventory → Issue Stock (direct) or Shipping → Order Picking (order-based)Mobile device issuing with barcode scanning and immediate issue submission
Bulk ImportUtilities → General → Import and Export → Issue Stock row (Stock Transactions section)Large data sets from CSV/Excel for bulk consumption or data migration
ReportingReports → Issuing StockAnalyze issue history, patterns, and audit trails by date, user, item, or reason code

All issues are tracked in the audit trail and material logs with full transaction details for accountability and reporting.

Access: Inventory → Stock → Issue Stock

Understanding the Issue Screen

The issue screen uses a temporary staging area where you can add items, make corrections, and review before finalizing. This two-step process (Save → Issue) prevents accidental inventory changes.

Issue screen showing the grid layout with warehouse selector, reason code, supplier filter, and action buttons

Screen Components:

  • Warehouse: Select the source warehouse (required)
  • Reason: Choose the negative adjustment code explaining why inventory is decreasing
  • Supplier (optional): Filter items by supplier
  • Ship To (optional): Assign the issue to a customer for tracking
  • Job (optional): Link to a job for cost allocation

Key Operations:

  • Save: Stores items in temporary staging area without updating inventory. Allows review, modifications, and building up issues over time. Items remain until finalized or reset
  • Load FIFO: Auto-populates grid using FIFO/FEFO intelligent stock allocation (Admin Option 21)
  • Issue: Finalizes all transactions, immediately updates warehouse inventory, and creates permanent audit trail. Cannot be undone
  • Pick List: Generates warehouse picking instructions for direct issues and shipping order issues
  • Reset: Clears all temporary items and starts fresh
  • Trashcan Icon: Marks a line to be removed when you save

Issuing Methods

Direct Issuing (Manual Adjustments)

Direct issuing creates negative inventory adjustments without linking to orders-used for damaged goods, samples, or corrections.

Required: Valid reason code explaining why inventory is decreasing

When to Use Direct Issuing:

  • Small adjustments (1-20 items)
  • Damaged or defective inventory write-offs
  • Sample distribution or promotional items
  • Items issued without formal documentation
  • Internal consumption or testing

When NOT to Use Direct Issuing:

  • Customer shipments (use Shipping Orders for proper invoicing and tracking)
  • Manufacturing consumption (use Work Orders for cost tracking)
  • Large-scale corrections (use Cycle Counting for variance analysis)

Workflow:

  1. Select warehouse
  2. Choose a Reason code (e.g., Direct Issue, Physical Inventory - codes are configurable)
  3. Optionally filter by Supplier to limit item selection
  4. Assign Ship To or Job if tracking consumption
  5. Add line items manually:
    • Enter or search for Item ID
    • Enter quantity to issue
    • Select location or use Load FIFO for automatic allocation
    • Add lot or serial numbers for tracked items
  6. Save to stage multiple items
  7. Issue when ready to remove from inventory

Tips:

  • Use AutoFill option to copy the previous line’s location for faster entry
  • The system auto-generates a reference number on save for tracking
  • Load FIFO uses FIFO/FEFO logic to automatically select oldest stock

Line Item Fields

FieldBehaviorNotes
Item IDRequiredMust be enabled in current warehouse and not discontinued
UnitsRequired, >0Quantity to issue from stock
At LocationDisplayShows current stock location
LocationAuto-assigned if blankDefaults to FIFO/FEFO selection when using Load FIFO
Serial/LotRequired for serialized/lot itemsCombined column; enter serial number, lot number, or RFID in this field
Alt.SerialOptional secondary serialAvailable in View 2 only; used for dual serial tracking
Date OutHeader field (default view)Global date applied to all lines; per-line in View 2. Can be adjusted within limits (Admin Option 525)
RemarkOptionalFree-text note per line
WarehouseHidden fieldPartsActive RecNo for specific stock allocation

Header fields (apply to all lines on the issue, not per-grid-row): Ship To, Job, Date Out (default view).

Shipping Order Issues

Shipping orders drive customer fulfillment with automated stock allocation and order status tracking.

Workflow:

  1. Navigate to Orders → Shipping → Shipping Orders
  2. Select the shipping order and click the Line Items tab
  3. Click Issue - a confirmation dialog appears: “Start issue process for this shipping order?” Click OK
  4. The issue screen opens pre-populated with:
    • Warehouse from the SO
    • Shipping order reference link (SO number)
    • Line items with committed stock
    • Reason auto-set to “SO Issue” (not user-editable)
  5. Review items and locations (use Load FIFO for automatic FIFO/FEFO allocation)
  6. Adjust quantities if doing partial shipments
  7. Check Show Packing Slip if a packing slip is needed
  8. Save to review, then Issue (or Pack if packing workflow enabled)
  9. Print packing slips and shipping labels from the SO record if needed

Features:

  • Partial shipments automatically update SO line status
  • Packing workflow moves items to packed status requiring Ship or Return action (Admin Option 153)
  • Auto-create backorders for remaining quantities (Admin Option 71)
  • Pick List button available to help warehouse staff locate items
  • Restriction: Cannot add new line items - only items from the original order are accepted (backend-enforced)

See the detailed Shipping Orders guide for creating and managing shipping order records.

Work Order Issues

Work orders consume materials for jobs or build assemblies with cost tracking and manufacturing integration.

Workflow (Standard WO - default):

  1. Navigate to Orders → Other → Work Orders
  2. Select the work order and click the Line Items tab
  3. Click Issue - a confirmation dialog appears: “Issue inventory for current work order?” Click OK
  4. The system executes the issue immediately and returns to the Line Items page. No staging screen is shown.

When Admin Option 195 is enabled, the system also preloads the WO line items into the Issue screen staging area on this default path for post-issue review.

Workflow (Standard WO - Admin Option 122 enabled):

When Admin Option 122 is on, clicking Issue redirects to the full Issue screen with the WO’s items listed. You then use the standard Save → Issue staging workflow rather than the immediate confirm path.

Workflow (Assembly WO):

  1. Navigate to Orders → Other → Work Orders
  2. Select the assembly work order and click the Line Items tab
  3. Click Assemble (replaces the Issue button for assembly WOs) - confirm the dialog
  4. The system issues component materials and automatically receives the assembled finished goods

Features:

  • Tracks material consumption against job budgets
  • For assembly WOs, issuing components simultaneously receives the assembled stock
  • Auto-create backorders for remaining quantities (Admin Option 121)
  • Pick List button available from the WO Line Items tab for warehouse staff

See the detailed Work Orders guide for creating and managing work order records.

Purchase Order Returns

Return defective, incorrect, or unwanted items to suppliers using the dedicated return functionality.

Use the Purchase Order module’s return functionality at Orders → Purchasing → Purchase Orders → [Select PO] → Line Items → Returns for proper supplier credit tracking, return authorization management, and PO line status updates. Click Apply to commit the return; click Back to cancel and return to the PO.

Note: If stock has been moved from its original receive location, those lines will not appear in the Returns grid. Use a manual correction in that case.

See the detailed Purchasing guide for complete return workflow and features.

Cycle Counting

Cycle counts verify physical inventory against system records and automatically adjust stock levels for discrepancies. When shortages are identified, the system issues inventory to correct the variance.

Workflow:

  1. Navigate to Inventory → Inventory → Cycle Counts
  2. Select a warehouse; click the Run New Cycle Count link to create a new count
  3. Optionally filter by location, supplier, or category
  4. The system generates count lines showing expected quantities
  5. Enter actual counted quantities and locations
  6. Use the View dropdown to filter to discrepancies, shortages, or overages
  7. Click Review Count to enter Review Mode (distinct from the Review report action)
  8. In Review Mode, check the per-line Post checkboxes and click Post Count to finalize
  9. Posting automatically issues shortages, receives overages, and moves location discrepancies

Capabilities:

  • Variance analysis with view filters: All Items, Counted Discrepancies, Counted Shortages, Counted Overages, Not Posted Items, and more
  • Auto-save during counting to prevent data loss (Admin Option 526)
  • Approval workflows for accountability (Admin Option 170) [NEEDS VERIFICATION]
  • Posting is per-line - individual rows can be selected before running Post Count
  • Variance reports for accuracy tracking
  • Shortages are automatically issued using the Cycle Count reason code

Issue Processing: When posting cycle count shortages:

  • System automatically creates issue transactions for missing inventory
  • Uses cycle count-specific reason code for audit trail
  • Removes stock from the system to match physical count
  • Tracks variance amounts for reporting and analysis
  • No manual issue screen required - posting handles everything

See Cycle Counting for complete documentation on creating counts, managing variances, and approval processes.

Mobile Issuing

Complete issuing operations on mobile devices for increased flexibility and warehouse efficiency.

Direct Issuing (no order):

  1. Login to Inventory Pro Mobile
  2. Confirm or change the active warehouse using the warehouse selector in the header
  3. Navigate to Inventory → Issue Stock
  4. Select a Reason code, then add items with quantities and locations
  5. Tap Issue to finalize

Order-Based Picking:

  1. Navigate to Shipping → Order Picking
  2. Select or scan the shipping order
  3. Pick items using the Next Pick hint or the Review tab
  4. Tap Save to finalize (or Issue if bulk picking is disabled - the button label is mode-dependent)

Scanner Issue Page: For dedicated barcode scanning workflows, navigate to Inventory → Scanner Issue. This page provides Scan and Review tabs for a streamlined scan-driven issue process.

Features:

  • Barcode scanning for faster item entry (Scan button in footer)
  • Immediate issue submission from the mobile workflow
  • Location selection on the warehouse floor
  • Serial/Lot and Alt Serial fields
  • More Options section for Customer, RFID, Reference, and Remarks
  • Pick list integration for order picking (Next Pick hint + Review tab)

Bulk Import

For large-scale issue operations or data migration, Inventory Pro supports bulk import of issue transactions.

Access: Utilities → General → Import and Export → locate the Issue Stock row under the Stock Transactions section. A downloadable Issue Stock Template (InventoryPro_DirectIssue.xlsx) is available in the Template column.

Supported Formats: CSV, XLS, XLSX

Available Fields:

FieldRequiredDescription
WarehouseYesDestination warehouse ID or name
Item IDYesItem number being issued
UnitsYesQuantity to issue (must be positive number)
Net WeightNoNet weight of items
Gross WeightNoGross weight including packaging
SerialNoSerial number for tracked items
Serial 2NoSecondary serial identifier
RFID TagNoRFID tag identifier
ReferenceNoTransaction reference number
RemarkNoNotes or comments
LocationNoWarehouse bin location
CustomerNoCustomer ID or name
Unit CostNoCost per unit
JobNoJob ID or name
SpareString1/2NoCustom field data

Process:

  1. Prepare CSV/Excel file with required columns (or download the Issue Stock Template)
  2. Navigate to Utilities → General → Import and Export
  3. Locate the Issue Stock row under Stock Transactions and upload the file
  4. System validates and stages records in temporary table
  5. Redirects to issue module for review
  6. Review staged items and click Issue to finalize

Important: All imports are validated before finalizing. Errors prevent the entire batch from processing until corrected.

FIFO & FEFO Stock Allocation

When using Load FIFO or letting the system auto-select locations, intelligent stock allocation optimizes inventory turnover:

FIFO (First In, First Out): Prioritizes oldest stock by receive date to prevent obsolescence. Selection order:

  1. Items committed to current order (for SO/WO issues)
  2. Items assigned to the specific job
  3. Items with no job assignment (general stock)
  4. Oldest receive date first

FEFO (First Expired, First Out): Prioritizes stock approaching expiration dates for perishable inventory:

  1. Items with nearest expiration dates
  2. Configurable expiration warnings
  3. Automatic alerts for expired stock

Multiple Location Splits: When insufficient stock exists at a single location, the system automatically splits the request across multiple locations to fulfill the total quantity.

Validation Rules

The system enforces strict validation to prevent errors:

Item Validation:

  • Item must exist and not be discontinued
  • Item must be enabled in the selected warehouse (Admin Option 504)
  • Non-stock items bypass availability checks

Quantity Validation:

  • Sufficient units must be available at specified locations
  • Stock must not be on hold (unless using Hold Release reason code -7)
  • Committed stock validated for SO/WO issues

Location Validation:

  • Location must exist in the warehouse
  • Location cannot be on hold for issuing (except with reason code -7)
  • Serial number must match location if specified

Shipping Order Restrictions:

  • Cannot add new line items - must issue items from original order
  • Quantities cannot exceed order line quantities (warnings issued for over-shipments)
  • Stock must be committed to the specific shipping order

Work Order Restrictions:

  • By default, issue runs from the WO Line Items tab without a staging screen; Admin Option 122 redirects to the Issue screen instead
  • Stock committed to work order validated
  • Assembly WOs validate component requirements

Date Limiting:

  • Date Out cannot exceed configured range (Admin Option 525)
  • Prevents excessive forward or back-dating of transactions

Admin Options

Key configuration options affecting issue operations:

OptionDescription
21Enable Load FIFO button for automatic FIFO/FEFO stock allocation
71Auto-create backorders for unissued shipping order quantities
121Auto-create backorders for unissued work order quantities
122Route WO issuing through the Issue screen instead of immediate confirm-and-issue
153Enable packing workflow for shipping orders (Pack → Ship process)
195Preload WO line items into the Issue screen staging area (works with the default AO 122-off path)
219Enable job tracking and assignment
504Enforce warehouse-specific item assignments
525Date Out limit (days) - restricts how far forward/back issues can be dated

Permissions

Access to each issuing method is controlled by separate permissions assigned under System → Security.

MethodRequired Permission
Direct IssuesNegative Adjustment (Issues)
Shipping Order IssuesPreview SO
Work Order IssuesMaintain WO Lines
Work Order Issues (AO 122 path)Maintain WO Lines + Negative Adjustment (Issues)
PO ReturnsPO Returns
Cycle CountCycle Count
Bulk ImportImport / Export
Pick List (Direct / SO)Order Fulfillment
Pick List (WO)Maintain WO Lines

Negative Adjustment Codes

Negative adjustment codes document the business reason for inventory removals and enable reporting by issue type.

Standard Codes:

Negative adjustment codes are configurable per site. Common examples include codes for direct issues, physical inventory corrections, and asset consumption. The following codes are system-reserved (cannot be deleted):

  • SO Issue (-4): Automatically assigned for shipping order issues
  • WO Consumption (-3): Automatically assigned for work order issues
  • PO Correction (-8): Returns and corrections to purchase orders
  • Hold Release (-7): Issues from held locations (bypasses hold restrictions)

Why They Matter:

  • Variance Tracking: Identify patterns in shrinkage, damage, or waste
  • Regulatory Compliance: Document reasons for inventory decreases
  • Cost Analysis: Track consumption by type for budgeting
  • Reporting: Filter and analyze issue history by reason code

Creating Custom Codes:

  1. Navigate to System → Definitions → Negative Adj. Codes
  2. Click Add New Negative Adjustment Code
  3. Enter code description
  4. Set active status
  5. Assign to specific warehouses if needed
  6. Save the new code

For comprehensive guidance on adjustment codes, see the dedicated Adjustment Codes documentation.

Pick Lists

Pick lists streamline warehouse operations by providing organized picking instructions for direct issues, shipping orders, and work orders.

Access: Available via the Pick List button on the direct issue screen, the SO issue screen, and the WO Line Items tab

Features:

  • Groups items by warehouse location for efficient routing
  • Shows quantities needed and available
  • Includes serial number tracking requirements
  • Can be printed or emailed to warehouse staff

Workflow:

  1. Save your issue (don’t finalize yet)
  2. Click Pick List button
  3. Review picking instructions
  4. Print or email to warehouse staff
  5. Return to issue screen and finalize when picked

Key Reports

Access issue reports via Reports → [Search] or direct access from the issuing screen.

Issue History (Report 60): Complete transaction log showing all issues by date range, item, user, warehouse, or reason code. Displays quantities issued, costs, locations, and reference numbers. Primary report for tracking inventory consumption and investigating discrepancies.

Issue Slip (Report 64): Printable transaction document for physical records and signature verification. Includes item details, quantities, locations, and user information. Used for warehouse documentation and audit compliance.

Audit Trail (Issues) (Report 124): Detailed audit log with user timestamps, reference tracking, and full transaction history. Shows who issued what items, when, and why with complete traceability for accountability and compliance.

Hot Movers (Issues/Customer Issues): Identify frequently issued items for demand forecasting and stocking optimization. Filter by customer (Report 155) to analyze customer-specific consumption patterns or view all issues (Report 150) for overall trending.

Audit Trail (Active Parts Issued) (Report 95): Track issues from specific inventory lots by serial number, lot number, or location. Essential for serialized item tracking and investigating lot-specific quality issues.

All reports support filtering by date range, warehouse, customer, job, and reason code. Export to Excel for further analysis.

Troubleshooting

“Not enough inventory at this location”

  • Problem: Insufficient stock at specified location
  • Solution: Verify physical inventory matches system records, check if stock is on hold, or use Load FIFO to find available stock
  • Prevention: Maintain accurate inventory records and use FIFO/FEFO allocation

“Cannot add line(s) to the issue derived from shipping/work order”

  • Problem: Attempting to add items not on original order
  • Solution: Return to the order and add line items there first
  • Prevention: Expected behavior for SO/WO issues - can only issue items from original order

“Warehouse Location does not exist”

  • Problem: Location not defined in warehouse Maps table
  • Solution: Verify location exists in selected warehouse and check for typos or extra spaces
  • Prevention: Set up all warehouse locations in Maps table before issuing

“Item has been discontinued”

  • Problem: Cannot issue discontinued items
  • Solution: Contact system administrator to reactivate item if needed
  • Prevention: Maintain current item master with accurate status

“Serial number does not exist in inventory”

  • Problem: Serial number not found at specified location
  • Solution: Verify serial number is typed correctly and exists at specified location
  • Prevention: Implement serial number validation and barcode scanning

Permission Errors

  • Problem: User lacks required permissions
  • Solution: Verify “Negative Adjustment (Issues)” permission is assigned and check warehouse-specific access
  • Prevention: Establish proper user permission levels

Incomplete Issues

If you saved an issue without completing it:

  1. Navigate to Inventory → Stock → Issue Stock
  2. Select the appropriate Warehouse
  3. Staged items appear automatically
  4. Review and click Issue to finalize
  5. Or click Reset to clear and start over

Note: Saved issues are user-specific and warehouse-specific. Items are not visible to other users and don’t affect inventory until finalized.

Best Practices

  1. Use Appropriate Reason Codes: Select codes that accurately reflect why inventory is being removed for better reporting
  2. Verify Locations: Confirm physical location matches system records before issuing, especially for serialized items
  3. Partial Shipments: Use shipping order partial shipments rather than direct adjustments for customer orders
  4. Regular Reconciliation: Review issue reports regularly to identify patterns and discrepancies
  5. Serial Number Accuracy: Double-check serial numbers for tracked items to prevent picking errors
  6. Job Tracking: Assign jobs when applicable for accurate cost allocation and project tracking
  7. Timely Processing: Complete staged issues promptly to maintain accurate inventory levels

On this page