InventoryOnline

System Configuration

System configuration establishes the foundational settings that control how Inventory Pro processes transactions. Before using the system, administrators should configure these core elements to match organizational requirements.

Each configuration list follows the same interface pattern with record numbers, names, descriptions, and active status:

Category list showing system list interface with record numbers, names, descriptions, and active status columns

ConfigurationAccess PathPurpose
CarriersSystem → Lists → CarriersShipping carrier management
Payment TermsSystem → Lists → Payment TermsInvoice payment schedules
Sales TaxSystem → Configuration → Sales TaxTax rates and jurisdictions
Center CodesSystem → Lists → Center CodesCost center/department tracking
Units of MeasureSystem → Lists → Units of MeasureInventory counting units
Shipping MethodsSystem → Lists → Ship ViaDelivery methods
Reason CodesSystem → Lists → Adjustment CodesTransaction justifications

Carriers

Carriers define the shipping companies used for order fulfillment and inbound deliveries.

Access: System → Lists → Carriers

Security: Security ID 101 (View), Security ID 102 (Create/Modify)

Carrier Fields

FieldPurpose
Short IDUnique carrier code (e.g., MTRK, WSXI, PYLE)
NameFull carrier name
TypeCarrier classification
ContactsPrimary, secondary, and 24-hour contact names
AddressPhysical address for the carrier
Phone/Fax/EmailCommunication methods (primary and secondary)
Ship ViaLinks to shipping method
TermsDefault payment terms with carrier
DiscountNegotiated carrier discount percentage
LTLLess-Than-Truckload capability flag
Stop ChargePer-stop delivery charge amount
Authorized for ReturnsCan handle return shipments
Insurance CertInsurance certification details and date
ContractContract reference document
ActiveEnable/disable the carrier

How to Add a Carrier

  1. Navigate to System → Lists → Carriers
  2. Click Add New Carrier
  3. Enter the Short ID (unique code) and Name
  4. Complete contact information and address
  5. Configure service options (LTL, returns authorization)
  6. Set discount and charge information if applicable
  7. Check Active to enable
  8. Click Save

Carrier Integration

Carriers link to:

  • Shipping Orders: Select carrier for delivery
  • Purchase Orders: Specify inbound carrier
  • Vendor Records: Default carrier for supplier shipments

Payment Terms

Payment terms define invoice due dates and early payment discounts for customers and vendors.

Access: System → Lists → Payment Terms

Security: Security ID 103 (View), Security ID 119 (Create/Modify)

Payment Terms Fields

FieldPurpose
TermTerm code (e.g., Net30, Net60, Immediate)
DaysNumber of days until payment due
DiscountEarly payment discount percentage (0-100)
Days DiscountDays within which discount applies
UseEnable/disable the term
List TopDisplay priority ranking

Standard Payment Terms Examples

TermDaysDiscountDiscount DaysDescription
Net30300%0Payment due in 30 days
Net60600%0Payment due in 60 days
2/10 Net30302%102% discount if paid within 10 days
Immediate10%0Payment due immediately
COD00%0Collect on delivery

How to Add Payment Terms

  1. Navigate to System → Lists → Payment Terms
  2. Click Add New Payment Term
  3. Enter the Term code
  4. Set Days until payment due
  5. Configure discount if applicable:
    • Enter Discount percentage
    • Set Days Discount window
  6. Check Use to enable
  7. Click Save

Due Date Calculation

The system calculates due dates automatically:

Due Date = Order Date + Days

Discount Applied if payment received by: Order Date + Days Discount

Payment Terms Integration

Payment terms link to:

  • Vendor Records: Default terms for purchase orders
  • Customer Records: Default terms for shipping orders
  • Purchase Orders: Terms for specific orders
  • Shipping Orders: Terms for customer invoices

Sales Tax

Sales tax configuration establishes tax rates and jurisdictions for customer invoicing.

Access: System → Configuration → Sales Tax

Sales Tax Fields

FieldPurpose
DescriptionTax zone name (e.g., “Pennsylvania Sales Tax”)
StateState code for jurisdiction
CityCity-level tax specification
CountryCountry tax zone
Sales TaxTax rate as decimal (e.g., 0.06 = 6%)
FormulaComplex calculation for multi-step tax rules
UseEnable/disable the tax code

Tax Configuration Points

SettingLocationPurpose
Tax CodesSystem → Configuration → Sales TaxDefine tax rates by jurisdiction
Customer Tax IDCustomer → Tax ID fieldLink customer to tax jurisdiction
Customer Tax RateCustomer → Sales Tax fieldCustomer-specific tax override
Item Non-TaxItem Master → Non-Tax checkboxMark items as tax-exempt

How to Configure Sales Tax

  1. Navigate to System → Configuration → Sales Tax
  2. Click Add New Tax Code
  3. Enter Description for the tax zone
  4. Specify State, City, Country as applicable
  5. Enter the Sales Tax rate as a decimal
  6. Optionally enter a Formula for complex calculations
  7. Check Use to enable
  8. Click Save

Customer Tax Exemptions

For tax-exempt customers:

  1. Navigate to the customer record
  2. Set Tax ID to 0 or the exempt tax code
  3. Alternatively, set Sales Tax field to 0
  4. Document exemption certificate in customer notes

Center Codes

Center codes (cost centers) track inventory costs and transactions by department or business unit.

Access: System → Lists → Center Codes

Cost Center List showing center codes with department descriptions, list top priority, and active status

Center Code Fields

FieldPurpose
Cost CenterCenter code (e.g., 4100, 1000, 1100)
DescriptionDepartment or business unit name
WarehouseAssociated warehouse/facility
UseEnable/disable the center
List TopDisplay priority ranking

Center Code Examples

CodeDescriptionUse Case
4100ManufacturingProduction materials
1000RetailRetail operations
1100Medical SuppliesMedical division
1200FragileSpecial handling items

Cost Center List sorted by name showing departments like Manufacturing, Retail, Medical Supplies, and Fragile

How to Add a Center Code

  1. Navigate to System → Lists → Center Codes
  2. Click Add New Center Code
  3. Enter the Cost Center code
  4. Enter a Description
  5. Select the associated Warehouse if applicable
  6. Check Use to enable
  7. Click Save

Center Code Integration

Center codes link to:

  • Item Master: Assign items to cost centers
  • Transaction Reports: Filter and group by cost center
  • Financial Reports: Cost allocation by department

Units of Measure

Units of measure (UOM) define how inventory is counted, stored, and ordered. Inventory Pro supports dual UOM for scenarios where you buy in one unit but sell in another.

Access: System → Lists → Units of Measure

UOM Fields

FieldPurpose
UOMUnit code (e.g., EACH, CASE-12, BOX)
ConversionSupports conversion calculations
Base Unit IDLinks to base unit for conversion
Base UnitsConversion factor to base unit
UseEnable/disable the unit

Standard UOM Examples

UOMBase UnitConversion FactorDescription
EACHEACH1Single item
CASE-12EACH12Case of 12 each
CASE-24EACH24Case of 24 each
CASE-48EACH48Case of 48 each
BOXEACHvariesBox quantity
PALLETCASEvariesPallet of cases

Dual UOM Implementation

Inventory Pro supports tracking inventory in one unit while ordering in another:

UOM edit screen for Box-4 showing base unit conversion to EACH with a contains value of 4

  • Inventory UOM: How items are stored and tracked (usually EACH)
  • Ordering UOM: How items are purchased (may be CASE, BOX, etc.)

Example:

  • Store soda as EACH (individual cans)
  • Order soda as CASE-24 (cases of 24 cans)
  • System converts: 1 CASE-24 = 24 EACH

How to Add a Unit of Measure

  1. Navigate to System → Lists → Units of Measure
  2. Click Add New UOM
  3. Enter the UOM code
  4. If this converts to a base unit:
    • Enable Conversion
    • Select the Base Unit ID
    • Enter Base Units (conversion factor)
  5. Check Use to enable
  6. Click Save

Shipping Methods

Shipping methods (Ship Via) define how orders are delivered to customers.

Access: System → Lists → Ship Via

Shipping Method Fields

FieldPurpose
Ship ViaMethod code (e.g., UPS, USPS, FedEx, Truck)
Carrier Picks UpCarrier picks up vs. deliver to carrier
Tracking LinkURL template for tracking numbers
Account NumberCarrier account for billing
UseEnable/disable the method

Configure tracking URLs with the {tracking} placeholder:

  • UPS: https://www.ups.com/track?tracknum={tracking}
  • FedEx: https://www.fedex.com/fedextrack/?trknbr={tracking}
  • USPS: https://tools.usps.com/go/TrackConfirmAction?tLabels={tracking}

How to Add a Shipping Method

  1. Navigate to System → Lists → Ship Via
  2. Click Add New Ship Via
  3. Enter the Ship Via code
  4. Configure Carrier Picks Up as applicable
  5. Enter the Tracking Link URL template
  6. Add Account Number if using carrier billing
  7. Check Use to enable
  8. Click Save

Reason Codes

Reason codes (Adjustment Codes) provide accountability for inventory transactions. Different codes control whether positive or negative adjustments are allowed.

Access: System → Lists → Adjustment Codes

Reason Code Fields

FieldPurpose
Type CodeNumeric code identifier
DescriptionReason description
PositiveAllows positive quantity adjustments
NegativeAllows negative quantity adjustments
PickSelectable in picking operations
HistoryTrack in transaction history
WarehouseRestrict to specific warehouse

Common Reason Code Categories

CategoryExamplesDirection
ReceiptsPO Receipt, Found Inventory, Transfer InPositive
IssuesWork Order Issue, Damaged, Transfer OutNegative
AdjustmentsPhysical Inventory, Cycle CountBoth
AssemblyAssembled, DisassembledBoth
RepairsUsed in Repairs, Repair ReturnBoth

How to Add a Reason Code

  1. Navigate to System → Lists → Adjustment Codes
  2. Click Add New Adjustment Code
  3. Enter the Description
  4. Configure direction flags:
    • Enable Positive for receiving adjustments
    • Enable Negative for issuing adjustments
  5. Optionally restrict to a Warehouse
  6. Click Save

Initial Setup Checklist

When first configuring Inventory Pro, complete these steps in order:

  • Payment Terms: Define Net30, Net60, and any custom terms
  • Units of Measure: Configure EACH plus any case/box units
  • Center Codes: Create department/cost center codes
  • Carriers: Add primary shipping carriers
  • Shipping Methods: Configure Ship Via options
  • Sales Tax: Set up tax jurisdictions
  • Reason Codes: Review and customize adjustment codes
  • Warehouses: Configure warehouse locations
  • Facilities: Set up company facilities

Key Reports

ReportReport IDPurpose
Carriers List202List all configured carriers
Center Codes271List all cost centers
Term Agreements276-278Vendor payment agreements

On this page