This imports Feed Mill Manager purchases and creates Purchase Receipts within Agvance. For more information on this import, see the Purchases Import here.
iv_recpt.DAT – Purchase Import File
File Layout – Standard - Version 3
Output
An import log file will be created and displayed when the import is complete. This file can be printed. For each Purchase Receipt created, the following will be displayed in the import log:
- Vendor Name
- Agvance Purchase Receipt Number/Date
- Product Description/Quantity
Data Mapping
The following is data mapping for the different Record Types.
100
| Field | Type | Width | Position | Format |
| Record Type 100 | Numeric | 3 | 1-3 | 100 |
| Document Type | Numeric | 1 | 4 | 1 – Receipt
2 – Return |
| Receiving Document Number | Alphanumeric | 20 | 5-24 | Upper Case
Left-justified, blank-filled |
| PO Number | Alphanumeric | 20 | 25-44 | Upper Case
Left-justified, blank-filled |
| Vendor Document Number | Alphanumeric | 20 | 45-64 | Upper Case
Left-justified, blank-filled |
| Date Received | Date | 8 | 65-72 | YYYYMMDD |
| Vendor ID | Alphanumeric | 15 | 73-87 | Upper Case
Left-justified, blank-filled |
| Item Number | Alphanumeric | 30 | 88-117 | Upper Case
Left-justified, blank-filled |
| Item Description | Alpha | 50 | 118-167 | Left-justified, blank-filled |
| Site ID | Alphanumeric | 10 | 168-177 | Upper Case
Left-justified, blank-filled |
| Line Item Sequence | Numeric | 10 | 178-187 | Integer
Left-justified, blank-filled |
| Quantity Received | Numeric | 12 | 188-199 | 999999.99999
Right-justified, zero-filled *If receiving transaction is an Invoice, this value contains quantity invoiced. Otherwise, it contains quantity shipped. |
| Quantity in Base | Numeric | 12 | 200-211 | 999999.99999
Right-justified, zero-filled |
| Freight Cost | Numeric/Currency | 12 | 212-223 | 999999.99999
Right-justified, zero-filled |
| Unit Cost | Numeric/Currency | 12 | 224-235 | 999999.99999
Right-justified, zero-filled |
| Extended Cost | Numeric/Currency | 12 | 236-247 | 999999.99999
Right-justified, zero-filled |
| PO Line Number | Numeric | 2 | 248-249 | 99
Right-justified, zero-filled |
200
| Field | Type | Width | Position | Format |
| Record Type 200 | Numeric | 3 | 1-3 | 200 |
| Document Type | Numeric | 1 | 4 | 1 – Receipt
2 – Return |
| Receiving Document Number | Alphanumeric | 20 | 5-24 | Upper Case
Left-justified, blank-filled |
| PO Number | Alphanumeric | 20 | 25-44 | Upper Case
Left-justified, blank-filled |
| Vendor Document Number | Alphanumeric | 20 | 45-64 | Upper Case
Left-justified, blank-filled |
| Vendor ID | Alphanumeric | 15 | 65-79 | Upper Case
Left-justified, blank-filled |
| Vendor Name | Alphanumeric | 64 | 80-143 |
|
| Landed Cost ID | Alphanumeric | 15 | 144-158 | Upper Case
Left-justified, blank-filled |
| Landed Cost Description | Alphanumeric | 50 | 159-208 |
|
| Total Landed Cost | Numeric | 17 | 209-225 | 99999999999.99999
Right-justified, zero-filled |
