Sage 100 Contractor 6-6-1 Purchase Orders
Overview:
Import Purchase Orders directly into Sage 100 Contractor. Simply download your purchase orders into Excel, review and apply purchase order information and import directly into Sage 100 Contractor 6-6-1 Purchase Orders.
Are you tired of manually keying in Purchase Orders one by one into Sage 100 Contractor? Would you rather download your purchase orders, 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 6-6-1 Purchase Orders data entry form.
Key Features:
- Download Purchase Orders into Excel
- Edit key purchase order information in Excel
- Bulk import purchase orders directly into Sage 100 Contractor
- Supports all native features and functions of the 6-6-1 Purchase Orders Entry Form
Import Template Download:
Import File Layout:
Header| Field | Reference | Data Type | Tab | Example | Description |
| filetype | Required | String (4) | PJPO | (File Type Code) | |
| linetype | Required | String (1) | H | Header Record | |
| ordnum | Required [*] | String (20) | Header | PO Number | |
| vndnum | Required [*] ** | Numeric | Header | Vendor No | |
| orddte | Required (I) | Date | Header | yyyy-mm-dd | PO Date |
| dscrpt | Required (I) | String (50) | Header | Description | |
| status | Required (I) ** | Numeric | Header | 1-Open, 2-Review, 3-Dispute, 4-Closed, 5-Void, 6-Master | Status |
| ordtyp | ** (1) | Numeric | Header | PO Type | |
| attion | String (50) | Header | Attention | ||
| wrkord | ** (2) | String (20) | Header | Work Order No | |
| jobnum | ** (2) | Numeric | Header | Job No | |
| phsnum | ** | Numeric | Header | Phase No | |
| eqpmnt | ** | Numeric | Header | Equipment No | |
| tsknum | Numeric (11,3) | Header | Task No | ||
| taxdst | Numeric | Header | Tax District | ||
| appdte | Date | Header | yyyy-mm-dd | Approved Date | |
| schdte | Date | Header | yyyy-mm-dd | Scheduled Date | |
| deldte | Date | Header | yyyy-mm-dd | Delivery Date | |
| delvia | String (60) | Header | Via | ||
| ordtrm | String (6) | Header | ##DY,##TH or ##MO | Terms | |
| odrdby | ** | Numeric | Header | Ordered By | |
| addrs1 | String (50) | Header | Address 1 | ||
| addrs2 | String (50) | Header | Address 2 | ||
| ctynme | String (50) | Header | City | ||
| state_ | String (2) | Header | State | ||
| zipcde | String (10) | Header | Zip Code | ||
| usrdf1 | String (50) | Header | User Def 1 | ||
| usrdf2 | String (50) | Header | User Def 2 | ||
| hotlst | Numeric | Header | Hot List | ||
| lckedt | Numeric | Header | Lock Edit | ||
| ntetxt | Text | Header | Notes |
Required (I) - required for Inserts only [*] Key Fields - the combination of theses fields must be unique ** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor (1) Leave blank for '0 - None' (2) If a Work Order No is specified, Job No should be left blank as it will be derived from the Work Order
Details
| filetype | Required | String (4) | PJPO | PJPO | |
| linetype | Required | String (1) | D | Detail Record | |
| ordnum | Required [*] | String (20) | Header | PO Number | |
| vndnum | Required [*] ** | Numeric | Header | Vendor No | |
| linnum | [*] (1) | Numeric | Detail | 1 | Line No |
| prtnum | ** | Numeric | Detail | 0 | Part No |
| prtdsc | Required (I) | String (75) | Detail | Line Description | |
| untdsc | String (10) | Detail | Unit of Measure | ||
| linqty | Numeric (8,4) | Detail | Quantity | ||
| linprc | (2) | Numeric (9,6) | Detail | Price | |
| currnt | Numeric (8,4) | Detail | Current | ||
| cancel | Numeric (8,4) | Detail | Canceled | ||
| cstcde | ** | Numeric (12,3) | Detail | Cost Code | |
| csttyp | ** | Numeric | Detail | Cost Type | |
| invloc | ** | Numeric | Detail | Inventory Location | |
| lgract | ** | Numeric | Detail | Account | |
| subact | ** | Numeric | Detail | Subaccount | |
| usrdf1 | String (50) | Detail | User Defined | ||
| ntetxt | Text | Detail | Notes | ||
| taxabl | String (1) | Detail | Y-Yes, N-No or blank | Taxable |
Required (I) - required for Inserts only [*] Key Fields - the combination of theses fields must be unique ** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor (1) Null/Empty = line no will be automatically derived; Specified line no must be unique based on the Key pair (2) Price may not be a negative value. If the line amount is negative you must make the "Quantity" negative
File Example:
!PJPO,H,ordnum,vndnum,orddte,dscrpt,status,ordtyp,attion,wrkord,jobnum,phsnum,eqpmnt,tsknum,taxdst,appdte,schdte,deldte,delvia,ordtrm,odrdby,addrs1,addrs2,ctynme,state_,zipcde,usrdf1,usrdf2,hotlst,lckedt,ntetxt !PJPO,D,ordnum,vndnum,linnum,prtnum,prtdsc,untdsc,linqty,linprc,currnt,cancel,cstcde,csttyp,invloc,lgract,subact,usrdf1,ntetxt,taxabl PJPO,H,"PO 2",231,"2019-07-13","PO Test 2",1,,"","",2017008,,,,,"","","","","",,"","","","","","","",,,"" PJPO,D,"PO 2",231,,,"poline 1","",10,50,75,1,2120.000,1,,1211,,"","","Y" PJPO,D,"PO 2",231,,,"poline 2","",10,75,20,,,,,,,"","","N"