Stock Import
In Agility there are features that enable the importing of new stock codes, updating current stock codes and changing prices.
Here is a list of ALL items which can be imported but not ALL are required. Items highlighted are not required unless you use these functions.
Import Field | Description of Field | Field Length |
Stock Code | Must be unique | 25 |
Des1 | Stock Description | 50 |
Des2 | Leave Blank | 6 |
Dept | Stock Grouping - Accounting | 6 |
Cat | Stock Grouping - Category | 6 |
Grp | Stock Grouping - Group | 6 |
Type | Stock Grouping - Type | 6 |
Supplier | Supplier Code | 12 |
SuppCode | Supplier Stock Code - Code used by your supplier | 40 |
Base units | Leave Blank |
|
Def Buy Ctype | Case Type used to buy stock | 15 |
Def Sale CType | Case Type used | 15 |
Comparitive Muliplier | Leave Blank |
|
VAT Rates | R0 = 0 |
|
Barcode | Unique |
|
Location | Bin Location |
|
PRF | Producers Recycling Fund or EMC |
|
Matrix X | If not Fashion Leave Blank |
|
Matrix X Value | If not Fashion Leave Blank |
|
Matrix Y | If not Fashion Leave Blank |
|
Matrix Y Value | If not Fashion Leave Blank |
|
Matrix Z | If not Fashion Leave Blank |
|
Matrix Z Value | If not Fashion Leave Blank |
|
Season | If not Fashion Leave Blank |
|
Buy Price | Buy price by Default CaseType |
|
Sale Price inc Vat |
|
|
Sale Price exc VAT |
|
|
Stk Qty | If importing stock qty |
|
Description Local | Different Lang used with Agility Touch | 50 |
Manufactured M/c/p | Used if company produces manufactured items |
|
Man Component | Used if company produces manufactured items |
|
Comp Ctype | Used if company produces manufactured items |
|
Comp Qty | Used if company produces manufactured items |
|
Batched Tracked Y/N | If you have batched tracked items Seed etc |
|
No Discount Y/N | Prevents Code being discounted |
|
Min Margins | If you want a code to make a minimum margin |
|
Weight | Used on delivery |
|
Import Cost Nominal | If you have import costs a nominal would need setting up. |
|
Import Cost Method %/P | % or Price |
|
Import Cost Value | If Import cost method |
|
Commodity Code | Have suppliers outside of Europe |
|
Commodity Country | Have suppliers outside of Europe |
|
Recommended Qty to Buy | ||
Tools>Tools Menu>Import>Stock Records