This imports Feed Mill Manager invoices and creates Delivery Tickets within Agvance. For more information on this import, see the Purchases Import here.
INVCEXP.DAT – Invoice Import File
Output
An import log file will be created and displayed when the import is complete. This file can be printed. For each Delivery Ticket created, the following will be displayed in the import log:
- Feed Management Systems order number
- Agvance Delivery Ticket Number/Date/Location
- Customer ID
Data Mapping
The following is data mapping for the different Record Types.
100
This is the invoice header. One Agvance Delivery Ticket will be created for each order header record.
Record Total: 322 (V1, V2) or 323 (V3)
| Field | Type | Max Length | Format | Description | Columns |
| Record Type 100 | Numeric | 3 | 100 | Header | 1-3 |
| Invoice Number | Alphanumeric | 20 | Upper Case Only |
|
4-23 |
| Invoice Type | Numeric | 1 | 1 – Order
2 – Return |
|
24 |
| Order Number | Alphanumeric | 20 | Upper Case Only |
|
25-44 |
| Customer ID | Alphanumeric | 15 | Upper Case Only |
|
45-59 |
| Customer Name | Alpha | 30 |
|
|
60-89 |
| Sales Territory | Alphanumeric | 15 | Upper Case Only |
|
90-104 |
| Salesperson ID | Alphanumeric | 15 | Upper Case Only |
|
105-119 |
| Invoice Date | Date | 8 | YYYYMMDD |
|
120-127 |
| Order Date | Date | 8 | YYYYMMDD |
|
128-135 |
| Transfer Date | Date | 8 | YYYYMMDD |
|
136-143 |
| Invoice Total | Numeric | 17 | 99999999999.99999 |
|
144-160 |
| Total Tax | Numeric | 17 | 99999999999.99999 |
|
161-177 |
| On Account Amount | Numeric | 17 | 99999999999.99999 |
|
178-194 |
| Freight Amount | Numeric | 17 | 99999999999.99999 |
|
195-211 |
| Misc Amount | Numeric | 17 | 99999999999.99999 |
|
212-228 |
| Trade Discount Amount | Numeric | 17 | 99999999999.99999 |
|
229-245 |
| Discount Taken Amount | Numeric | 17 | 99999999999.99999 |
|
246-262 |
| Payment Terms ID | Alphanumeric | 20 |
|
|
263-282 |
| Location/Division | Alphanumeric | 25 |
|
(from FMM Setup) | 283-307 |
| Department | Alphanumeric | 15 |
|
(from FMM Setup) | 308-322 |
| Shipping Method | Numeric | 1 | 0 – Pickup
1 – Delivery |
Only if Dex.ini setting is EZStandardVersion = 3 | 323 |
110
Invoice Header Comments
Record Total: 104
| Field | Type | Max Length | Format | Description | Columns |
| Record Type 110 | Numeric | 3 | 110 | Comments associated with Header | 1-3 |
| Invoice Number | Alphanumeric | 20 | Upper Case Only |
|
4-23 |
| Invoice Type | Numeric | 1 | 1 – Order
2 – Return |
|
24 |
| Comments | Alphanumeric | 80 |
|
Comment text field | 25-104 |
200
Invoice Line Items
Record Total: 505
| Field | Type | Max Length | Format | Description | Columns |
| Record Type 200 | Numeric | 3 | 200 | Order lines | 1-3 |
| Invoice Number | Alphanumeric | 20 | Upper Case Only |
|
4-23 |
| Line Item Sequence | Numeric | 10 |
|
|
24-33 |
| Customer ID | Alphanumeric | 15 | Upper Case Only | Primary, Split or Grain Bank or Contracts from Customer ID
Depends on system setup setting |
34-48 |
| Price Level | Alphanumeric | 15 |
|
|
49-63 |
| Record Type | Integer | 1 | 1 – Formula
2 – Stock 3 – Ingredient, Adv. Pricing |
|
64 |
| Item Number | Alphanumeric | 30 | Upper Case Only |
|
65-94 |
| Item Description | Alpha | 50 |
|
|
95-144 |
| User Defined | Alphanumeric | 10 |
|
|
145-154 |
| Unit of Measure | Alpha | 8 |
|
|
155-162 |
| Qty In Base U of M | Numeric | 17 | 99999999999.99999 |
|
163-179 |
| Quantity Type | Numeric | 1 | 0 – Regular Inventory
1 – Grain Bank 2 – Contract 3 – Non Inventory |
|
180 |
| Ticket/Contract Number | Alphanumeric | 20 | Upper Case | Ticket Number – If Grain Bank
Contract Number – If Contract |
181-200 |
| Contract Sequence Number | Numeric | 10 | Long Integer | Contract Sequence Number or blanks (right-justified blank-filled) | 201-210 |
| Quantity | Numeric | 17 | 99999999999.99999 |
|
211-227 |
| Unit Price | Numeric | 17 | 99999999999.99999 |
|
228-244 |
| Extended Price | Numeric | 17 | 99999999999.99999 |
|
245-261 |
| Extended Cost | Numeric | 17 | 99999999999.99999 |
|
262-278 |
| Tax Amount | Numeric | 17 | 99999999999.99999 |
|
279-295 |
| Delivery Date | Date | 8 | YYYYMMDD |
|
296-303 |
| Site ID | Alphanumeric | 10 | Upper Case Only |
|
304-313 |
| Item Class Code | Alphanumeric | 10 | Upper Case Only |
|
314-323 |
| Formula Modified | Boolean | 1 | 1 – True
0 – False |
|
324 |
| Group Code | Alphanumeric | 15 | Upper Case Only |
|
325-339 |
| Farm Location Code | Alphanumeric | 15 | Upper Case Only |
|
340-354 |
| Barn Code | Alphanumeric | 15 | Upper Case Only |
|
355-369 |
| Room Code | Alphanumeric | 15 | Upper Case Only |
|
370-384 |
| Pen Code | Alphanumeric | 15 | Upper Case Only |
|
385-399 |
| Participating | Alpha | 1 |
|
Y or N (User Category) | 400 |
| Line Department | Alphanumeric | 15 |
|
(User Category) | 401-415 |
| Sub Account | Alphanumeric | 10 |
|
(User Category) | 416-425 |
| Primary Formula Code | Alphanumeric | 30 | Upper Case Only | Blank unless 200 line is an ingredient or advanced pricing in a non-guaranteed formula | 426-455 |
| Formula Description | Alphanumeric | 50 |
|
Same as Primary Formula Code | 456-505 |
210
Invoice Line Item Lot Numbers
Record Total: 103
| Field | Type | Max Length | Format | Description | Columns |
| Record Type 210 | Numeric | 3 | 210 | Lots | 1-3 |
| Invoice Number | Alphanumeric | 20 | Upper Case Only |
|
4-23 |
| Line Item Sequence Number | Numeric | 10 |
|
|
24-33 |
| Item Number | Alphanumeric | 30 | Upper Case Only |
|
34-63 |
| Lot Number | Alphanumeric | 15 | Upper Case Only |
|
64-78 |
| Lot Quantity | Numeric | 17 | 99999999999.99999 |
|
79-95 |
| Lot Received Date | Date | 8 | YYYYMMDD |
|
96-103 |
300
Ingredients used in formula - not imported by Agvance
Record Total: 228
| Field | Type | Max Length | Format | Description | Columns |
| Record Type 300 | Numeric | 3 | 300 | Guaranteed Feed, Ingredients in Guaranteed Feed and Advanced Costing | 1-3 |
| Invoice Number | Alphanumeric | 20 | Upper Case Only |
|
4-23 |
| Lien Item Sequence Number | Numeric | 10 |
|
|
24-33 |
| Formula Seq Number | Numeric | 10 |
|
|
34-43 |
| Item Number | Alphanumeric | 30 | Upper Case Only |
|
44-73 |
| Item Description | Alphanumeric | 50 |
|
|
74-123 |
| U of M | Alphanumeric | 8 |
|
|
124-131 |
| Quantity | Numeric | 17 | 99999999999.99999 | Guaranteed Feed:
Order: + Return: (-) Ingredients and Advanced Costing: Order: (-) Return + |
132-148 |
| Quantity Type | Numeric | 1 | 0 – Regular Inventory
1 – Grain Bank 3 – Non Inventory |
No longer send contract – 2
If there is a ticket number and the type is 0, it is a contract |
149 |
| Ticket Number | Alphanumeric | 20 | Upper Case | Ticket Number – If Grain Bank | 150-169 |
| Contract Sequence Number | Numeric | 10 | Long Integer
RIght-justified, blank-filled |
|
170-179 |
| Unit Cost | Numeric | 17 | 99999999999.99999 |
|
180-196 |
| Extended Cost | Numeric | 17 | 99999999999.99999 | Guaranteed Feed:
Order: + Return: (-) Ingredients and Advanced Costing: Order: (-) Return: + |
197-213 |
| Grain Bank From Customer | Alphanumeric | 15 | Upper Case Only |
|
214-228 |
310
Lots for ingredients used in formula - not imported by Agvance
Record Total: 113
| Field | Type | Max Length | Format | Description | Columns |
| Record Type 310 | Numeric | 3 | 310 | Lots | 1-3 |
| Invoice Number | Alphanumeric | 20 | Upper Case Only |
|
4-23 |
| Invoice Seq Number | Numeric | 10 |
|
|
24-33 |
| Formula Seq Number | Numeric | 10 |
|
|
34-43 |
| Item Number | Alphanumeric | 30 | Upper Case Only |
|
44-73 |
| Lot Number | Alphanumeric | 15 | Upper Case Only |
|
74-88 |
| Lot Quantity | Numeric | 17 | 99999999999.99999 |
|
89-105 |
| Lot Received Date | Date | 8 | YYYYMMDD |
|
106-113 |
500
Order Footer - not imported by Agvance
Record Total: 52
| Field | Type | Max Length | Format | Description | Columns |
| Record Type 500 | Numeric | 3 | 500 | Footer | 1-3 |
| Order Number | Alphanumeric | 20 | Upper Case Only |
|
4-23 |
| Process Date | Date | 8 | YYYYMMDD |
|
24-31 |
| Process Time | Time | 6 | HHMMSS |
|
32-37 |
| User ID | Alphanumeric | 15 | Upper Case Only |
|
38-52 |
