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
|