Inventory Field Mapping

This article displays a mapping of all Paradigm inventory fields and the corresponding Sage Evolution inventory fields which update them.

There are fields from the following 13 inventory tables, synced from Sage Evolution.

1. Inventory Items

Paradigm Display Name	Evolution Display Name
Code	Unique Code
Description 1	Description 1
Description 2	Description 2
Description 3	Description 3
Group	Group
Pack	Pack Code
Bin Location	Bin Location
Barcode	Barcode
Re-Order Level	Re-Order Level
Re-Order Quantity	Re-Order Quantity
Minimum Level	Minimum Level
Maximum Level	Maximum Level
Lead Days	Purchased Lead Time
Average Unit Cost	Average Unit Cost
Latest Unit Cost	Latest Unit Cost
Lowest Unit Cost	Lowest Cost
Highest Unit Cost	Highest Cost
Last GRV Cost	Last GRV Cost
Manual Cost	Manual Cost
Last GRV Cost	Last GRV Cost
Quantity on Hand	Qty on Hand
Inactive	Active
Service Item	Service Item
Serial Number Item	Serial Number Item
Allow Duplicate Serial Numbers	Allow Duplicate Serial Numbers
Strict Serial Number Tracking	Strict Serial Number Tracking
Warhouse Item	Warhouse Item
Commissionable Item	Commissionable Item
Lot Item	Lot Item
Lot Expiry Date Required	Expiry Date Required
Unit of Measure Item	Unit of Measure Item
Tax Types - Invoicing	Tax Types - Invoicing
Tax Types - Credit Notes	Tax Types - Credit Notes
Tax Types - Goods Received Notes	Tax Types - Goods Received Notes
Tax Types - Returns to Supplier	Tax Types - Returns to Supplier
Model	Model
Revision	Revision
Component	Component
Release Date	Release Date
Stocking Unit	Stocking Unit
Purchase/Manufacture Unit	Default Purchase Unit
Selling Unit	Default Sale Unit
Allow Negative Qty	Allow Negative Quantities
Linked To Warehouses	Add to Warehouse(s)...

2. Inventory Tax Types

Paradigm Display Name	Evolution Display Name
Code	Code
Name	Description
Tax %	Tax Rate

3. Inventory Groups

Paradigm Display Name	Evolution Display Name
Code	Group Code
Name	Description
Sales Account	Sales Account
Cost of Sales Account	Cost of Sales Account
Inventory Account	Inventory Account
Purchases Account	Purchases Account
Purchases Cost Variance Account	Purchases Cost Variance Account
Inventory Adjustment	Inventory Adjustment
Inventory Cost Variance Account	Inventory Cost Variance Account
Work In Progress Account	Work In Progress Account
Minimum GP %	Minimum GP %

4. Inventory Packs

Paradigm Display Name	Evolution Display Name
Code	Pack Code
Name	Description
Pack Size	Size

5. Inventory Bin Locations

Paradigm Display Name	Evolution Display Name
Name	Bin Location
Description	Description

6. Inventory Unit of Measure Categories

Paradigm Display Name	Evolution Display Name
Name	Description

7. Inventory Unit of Measure

Paradigm Display Name	Evolution Display Name
Code	Code
Name	Description
Category	Category

8. Inventory Warehouses

Paradigm Display Name	Evolution Display Name
Name	Name
Default	Master Warehouse
Default Inventory Group	Default Group
Allowed To Add New Inventory	Always Add New Warehouse Inventory Items to this Warehouse
Allow Negative Qty	Allow Negative Quantities
Allowed To Sell From	Allow Sales Transactions
Allowed To Buy Into	Allow Purchase Transactions
Telephone	Telephone
Email	Email
Fax	Fax

9. Inventory Lot Status

Paradigm Display Name	Evolution Display Name
Name	Status Description
Allow Purchases	Purchase Status
Allow Sales	Sales/Use Status

10. Inventory Lot Tracking

Paradigm Display Name	Evolution Display Name
Number	Lot Number
Inventory Item	Inventory Item
Status	Lot Status
Expiry Date	Expiry Date
Total Quantity	Quantity on Hand
Inactive	Is Active

11. Inventory Segment Groups

Paradigm Display Name	Evolution Display Name
Code	Segment Group
Name	Segment Group
Type	Segment Type

12. Inventory Segment Types

Paradigm Display Name	Evolution Display Name
Code	Segment Type
Name	Segment Type

13. Inventory Segment Values

Paradigm Display Name	Evolution Display Name
Name	Description
Code	Segment Value
Group	Segment Group