Sage 100 Contractor 9-2 Parts
Overview:
Import Parts directly into Sage 100 Contractor. Simply download your parts into Excel, review and apply part information and import directly into Sage 100 Contractor 9-2 Parts.
Are you tired of manually keying in Parts one by one into Sage 100 Contractor? Would you rather download your parts, fill in the blanks in Excel and import the details directly into Sage 100 Contractor? The following integration template allows you to do just that. It mimics every feature and function of the 9-2 Parts data entry form.
Key Features:
- Download Parts into Excel
- Edit key part information in Excel
- Bulk import parts directly into Sage 100 Contractor
- Supports all native features and functions of the 9-2 Parts Entry Form
Import Template Download:
Import File Layout:
| Header | Reference | Data Type | Tab | Example | Description |
| filetype | Required | ESPART | ESPART | ESPART | |
| recnum | Required | Numeric | Header | Part No | |
| prtnme | Required(I) | String (75) | Header | Part Description | |
| prtunt | Required(I) | String (10) | Header | i.e. ea, sf, lf, lb | Unit Type |
| alpnum | String (50) | Header | Alpha Part No | ||
| prtcls | ** | Numeric | Header | Part Class | |
| cstcde | ** | Numeric (12,3) | Header | Cost Code | |
| csttyp | ** | Numeric | Header | 1-Mat,2-Lab,3-equip,4-sub,5-oth,6-udf,7-udf,8-udf,9-udf | Cost Type |
| prttsk | ** | Numeric (11,3) | Header | Task No | |
| mannme | String (50) | Header | Manufacturer | ||
| mannum | String (30) | Header | Manufacturer Part No | ||
| msdsnm | String (30) | Header | MSDS No | ||
| usrdf1 | String (50) | Header | User Def1 | ||
| usrdf2 | String (50) | Header | User Def2 | ||
| prtcst | Numeric (9,6) | Cost Bill Order | Default Cost | ||
| lstupd | Date | Cost Bill Order | yyyy-mm-dd | Last Updated | |
| mrkupr | Numeric (4,2) | Cost Bill Order | Markup Pct | ||
| prtbil | Numeric (9,6) | Cost Bill Order | Billing Amount | ||
| minord | Numeric (10,2) | Cost Bill Order | Min Order Qty | ||
| pkgqty | Numeric (10,2) | Cost Bill Order | Package Qty | ||
| prtwgt | Numeric (10,2) | Cost Bill Order | Unit Weight | ||
| labnum | ** | Numeric | Labor | Labor Part No | |
| labunt | Numeric (9,6) | Labor | Labor Qty | ||
| stkitm | Numeric | Inventory | 1=Yes;0=No | Stock Item | |
| serinv | Numeric | Inventory | 1=Yes;0=No | Serialized Item | |
| reqivt | Numeric | Inventory | 1=Yes;0=No | Required From Inv. | |
| dftloc | ** | Numeric | Inventory | Default Location No | |
| binnum | String (10) | Inventory | Bin No | ||
| reordr | Numeric (10,2) | Inventory | Reorder Qty | ||
| srvprt | Numeric | Service Equip | 1=Yes;0=No | Service Equip Item | |
| oemdur | Numeric | Service Equip | OEM Warranty Duration | ||
| ntetxt | Text | Header | Notes |
Required(I) - required for Inserts only
** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor
File Example:
filetype,recnum,prtnme,prtunt,alpnum,prtcls,cstcde,csttyp,prttsk
PART,19101,"Part #1","ea","",1,2120.000,,
PART,19102,"Part #2","ea","",1,2120.000,,
PART,19103,"Part #3","ea","",1,2120.000,,