Purpose

The Inventory module is designed to handle complex inventory tracking, while maintaining a full integration with all other features of TRUE. 


Inventory Filters

Advanced  
Job / Contract Allows the ability to filter Inventory data by a Cost Center.
Vendor Allows the ability to filter Inventory data by associated Vendor.
Purchase Order Allow the ability to filter Inventory data by active Purchase Orders.
Product Allows the ability to filter Inventory data by products.
Stock Allows the ability to filter Inventory data by In Stock.
Problem Allows the ability to filter Inventory data labeled as “Problem”.
Location Allow the ability to filter Inventory data by stored Location.

Inventory Module

Perform a search or filter your inventory results to make inventory adjustments directly within the Inventory module.

Sorts & Filter Options

Sort Use this to sort the current set of data based on 6 available criteria. An initial search is required to utilize this sort feature.
Clear Use this to clear the existing sort.
Problem Use this to display Inventory labeled as a “Problem”.
Stock Use this to display Inventory in “Stock”.
Select Choose specific inventory records.
Advanced Filter Use this to perform an advanced search for non-standard Inventory related fields.

Additional Features

View Products/Items Toggle displaying all found Inventory by Product, or by each individual item.
Scan Perform an Inventory Scan to perform a variety of Inventory related functions.
Plus icon Create a new manual Inventory item. (Note: This will be un-related to any product data).
"↻" icon Refresh inventory data display.
Export icon Export the current set of Inventory data to an Excel spreadsheet.
Report icon Generate related Inventory reports.
“⚙️" icon - Inventory Counts Used to manually update entire inventory counts and report on missing or extra items.

Column Headers

PRODUCT Displays the related Product/Service record.
JOB / CONTRACT Displays any associated Job or Contract records.
PURCHASE ORDER Displays any associated Purchase Order records.
LOCATION Current storage location.
STATUS Current inventory status.

Advanced Filter

Product Item or good tracked in inventory
Cost Amount paid to acquire/manufacture product
Notes Additional product details
Vendor Product supplier/provider
Type Vendor category/classification
Job / Contract Associated project/agreement
Used Job / Contract Product used for job/contract
Location Product's physical storage location
Purchase Order Document authorizing product purchase
Status Product's current state (Shrinkage, Problem, Unapproved, Reserve)
Product (Category) Product grouping/taxonomy
Unique Material Distinct product variant/lot identifier
Inventoried Date Date added to inventory records
Sold Date Date sold/removed from inventory
Billed Date Date customer invoiced for product
Shrinkage Date Date of product quantity loss/reduction
Vendor No Unique vendor identifier

Selected Inventory

Select an Inventory record to access the “Edit Inventory” feature.

Product Assign this Inventory item to an existing Product/Service record.
Material Specify material type.
Vendor Associated supplier.
Job / Contract Linked project or contract.
Stock Indicate if item is stocked.
Purchase Order Associated PO reference.
Location Storage location.
Notes Additional item information.
Inventory Account Associated GL account for inventory value.
COGS Account Cost of Goods Sold account.
Cost Unit cost of inventory item.
Shrinkage Record inventory loss.
Delete Remove inventory record.
Scan Barcode scanning function.
Close Exit inventory record.

Inventory Reports

Inventory Shrinkage Lost or damaged inventory analysis.
Inventory by Location Stock levels by storage location.
Inventory by Category Items grouped by category.
Inventory by Job / Contract Items allocated to projects.
Location by Product Storage location analysis by product.
Inventory As Of Point-in-time inventory snapshot.
Done Inventory Completed inventory items.
Problem Inventory Items with identified issues.
Shelf-Life Expiration tracking report.

Inventory Counts Feature

Used to manually update entire inventory counts and report on missing or extra items.