AgriMine

TABLE OF CONTENTS

1 A. Background Information
2 B. FAQs - Frequently Asked Questions
3 C. Setup Information
- 3.1 C.1. Verify that the Extended Option is set to “Y” / On.
- 3.2 C.2. Configure the File Translations.

A. Background Information

AgriMine is a system provided by Winfield Solutions, LLC that seeks to “turn your customer sales data into valuable business intelligence…to help you maximize every business opportunity.” Click HERE to learn more about AgriMine or call 866-212-6578.

The AGRIS system has a Customer File Translation (CFT) that extracts and transforms certain AGRIS sales transactions from the standard defined AGRIS System export file format into the AgriMine file format.

The AGRIS Extended Option for integrating with AgriMine is available at no extra charge for customers on any of the AGRIS Agribusiness or Retail Package Editions (i.e., Standard, Advanced, Elite).

The AGRIS File Translation for AgriMine saves time by electronically translating data into the import format that AgriMine reporting requires.

B. FAQs - Frequently Asked Questions

1. What file formats are available to send from AGRIS to send to AgriMine?

Answer: AGRIS populates 3 files:
- IMPT.DAT for Invoices and voids
- WNCUST.DAT for Customers
- WNPROD.DAT for supplemental item record details.
The .DAT files created are transferred by the retailer employee manually to Agrimine’s FTP
NOTE: Agrimine requires all three files every time you submit. If you only submit one, or two of the files, AgriMine is unable to load anything until you provide all 3 files.
Formats listed below follow the guidelines required for the WILNETT 2001 format.
Within AGRIS the Retailer starts the process by exporting the following data to begin the transformation.
- 1.a) Print A/R Invoice Report: INVOICE EXPORT FILE (AGEXPIMP)
- 1.b) Print A/R Void Invoice Report: VOIDED INVOICE EXPORT FILE (AGEXPIMP)

Header Record

Description	Type	Length	DEC	Position	Comments
Record Code*	N	1	0	1-1	1=Header
Retailer IC Code*	N	13	0	2-14	Numeric, zero filled
Retailer Batch ID*	N	7	0	15-21	Sequential #, zero filled
Retailer Extract Date*	D	8		22-29	CCYYMMDD
Filler	A	342		30-371

Detail Record

Description	Type	Length	DEC	Position	Comments
Record Code*	N	1	0	1-1	4=Detail
Retailer IC Code*	N	13	0	2-14	Numeric, zero filled
Retailer Batch ID*	N	7	0	15-21	Sequential #, zero filled
Retailer Transaction Date*	D	8		22-29	CCYYMMDD(Invoice Date)
Retailer Shipment Date*	D	8		30-37	CCYYMMDD (Delivery Date)
Retailer Ship-From Location IC Code*	N	13	0	38-50	Ship from Branch/Office ID
Retailer Bill-to Grower ID*	A	16		51-66	Retailers Customer # Bill-to
Bill-to NAPD/HP ID	A	16	0	67-82	NAPD/HP # for Bill-to
Bill-to Grower Name*	A	30		83-112	Customers Name
Retailer Ship-to Grower ID*	A	16		113-128	Retailers Customer # Ship-to
Ship-to NAPD/HP ID	A	16	0	129-144	NAPD/HP # for Ship-to
Ship-to Grower Name*	A	30		145-174	Name Required if Ship-to
Retailer Invoice Number*	A	20		175-194	Invoice/Document #
Retailer Invoice Line #*	N	5	0	195-199	Invoice Line Item #
Retailer Item Number*	A	20		200-219	Retailers Product #
Retailer Product Description*	A	30		220-249	Retailers Product Description
Retailer Type of Invoice*	A	2		250-251	SS=Sale (+) or SD=Credit (-)
Retailer Quantity*	N	11	4	252-262	No sign, 4 decimals
Lot Number	A	10		263-272	Manufacturers Lot #
Retailer Unit of Measure*	A	2		273-274	Retailers UOM – GA, LB, etc.
Line Item Dollar Extension*	N	9	2	275-283	Zero Fill, No Sign, 2 decimals
Applied Acres	N	10	0	284-293	Zero Fill, No Sign, 0 decimals
Filler	A	78		294-371

Footer Record

Description	Type	Length	DEC	Position	Comments
Record Code*	N	1	0	1-1	9=Footer
Retailer IC Code*	N	13	0	2-14	Numeric, zero filled
Retailer Batch ID*	N	7	0	15-21	Sequential #, zero filled
Retailer Extract Date*	D	8		22-29	CCYYMMDD
Retailer Name*	A	35		30-64
Number of Detail Records*	N	5	0	65-69	Zero Fill, No decimals
Quantity Hash Total*	N	15	4	70-84	Zero Fill, No Sign, 4 decimals
Line Extension Hash Total*	N	15	2	85-99	Zero Fill, No Sign, 2 decimals
Filler	A	272		100-371

Mandatory Data

1.c) Print Name/Address Report: NAME/ADDRESS Export File (AGEXPIMP)

Description	Type	Length	DEC	Position	Comments
Local ID	AN	16		1-16	Retailer’s grower ID
Retailer ID	N	13		17-29	Retailer IC number
HP ID	AN	16		30-45	NAPD/HP ID (optional)
Name	A	50		46-95	Grower’s name
Legal Name	A	50		96-145	Grower’s legal name
Address1	AN	35		146-180	Grower’s address, first part
Address2	AN	35		181-215	Grower’s address, second part
City	A	30		216-245	Grower’s city
State	A	2		246-247	Grower’s state
Zip	AN	9		248-256	Grower’s zip code
County	A	35		257-291	Grower’s county
Country	A	35		292-326	Grower’s country
Telephone	AN	15		327-341	Grower’s telephone number
Fax Number	AN	15		342-356	Grower’s fax number
Modified Date	D	8		357-364	System date (CCYYMMDD

1.d) Print Inv Status Report: INVENTORY ITEM EXPORT FILE (AGEXPIMP)

Description	Type	Length	DEC	Position	Comments
Product Code	AN	20		1-20	Retailers Product Code
Description	AN	30		21-50	Retailers Product Description
Package Size	AN	25		51-75	Retailer’s Package Size
Unit of Measure	AN	2		76-77	Retailer’s Unit of Measure
UOM Conversion Factor	N	8	4	78-85	Conversion factor (optional)
Price	N	9	2	86-94	Retailer’s price per Sale UOM
Date	D	8		95-102	Transaction date (CCYYMMDD)
Crop Code	AN	2		103-104	(optional)
Comment	AN	43		105-147	(optional)
Manufacturer ID	AN	20		148-167	(optional)
Retailer IC Code	N	13	0	168-180	Retailer’s IC Code

Address1

Grower's street address or PO box number

Address2

Grower's street address or PO box number that exceeded the length provided in the address1 field

Applied Acres

Number of acres the retailer custom applied

Bill-to Grower Name

Name of the grower who is charged for the product

Bill-to NAPD/HP ID

The number assigned by Harvest Partners for grower rebate programs to the grower who is charged for the product

City

Grower's city location

Comment

Space allowed for retailer to provide additional instructions or comments

Country

Grower's country location

County

Grower's county location

Crop Code

2 digit number set by Carlson Marketing to identify the crop

Date

Date the transaction takes place

Description

Retailers Product Description

Fax Number

Grower's fax number including the area code

Filler

Blank space that fills the empty positions in a field

HP ID

The number assigned to a grower by Harvest Partners for grower rebate programs

Legal Name

The first and last name or the corporation name of the grower

Line Extension Hash Total

Grand total of all Line Item Dollar Extensions

Line Item Dollar Extension

Total dollar amount per line number on an invoice

Local ID

The number assigned by the retailer to a grower

Lot Number

Number assigned by the manufacture to a manufacturing unit of product

Manufacture ID

The number assigned to a product by the manufacturer

Modified Date

The date (CCYYMMDD)after the initial submission date that the customer or product file was changed

Name

The first and last name or the corporation name of the grower

Number of Detail Records

The total number of detail records in the batch

Package Size

Package size in which the retailer sells a product

Price

The amount the retailer charges per UOM for a product

Product Code

The number assigned by the retailer to a product

Quantity Hash Total

Grand total of all retail quantities for the batch

Record Code

"The code that identifies the type of record as a header (1), detail (4), or footer (9) "

Retailer Batch ID

The sequential number assigned to a batch of records

Retailer Bill-to Grower ID

Number assigned by the retailer to identify the grower who is charged for the product

Retailer Extract Date

The date (CCYYMMDD) a batch of data was exported

Retailer IC Code

The 13 digit industry common number used to identify a retailer

Retailer ID

The 13 digit industry common number used to identify a retailer

Retailer Invoice Line #

The line number assigned by the retailer to items on an invoice

Retailer Invoice Number

The number assigned by the retailer to a transaction for a customer

Retailer Item Number

The number assigned by the retailer used to identify a product

Retailer Name

Business name of the retailer

Retailer Product Description

The description used by the retailer to identify a product

Retailer Quantity

The quantity sold by the retailer

Retailer Ship-From Location IC Code

The 13 digit industry common number used to identify a retailer where the product is located

Retailer Ship-to Grower ID

Number assigned by the retailer to identify the grower who receiving the product

Retailer Shipment Date

Date the product was shipped to the grower (CCYYMMDD)

Retailer Transaction Date

Invoice date of purchase (CCYYMMDD)

Retailer Type of Invoice

Two letter code that indicates a Sale (SS) or Credit (SD)

Retailer Unit of Measure

"Unit of Measure (GA, LB, OZ) used by the retailer to sell a product"

Ship-to Grower Name

Name of the grower who is receiving the product

Ship-to NAPD/HP ID

The number assigned by Harvest Partners for grower rebate programs to the grower who received the product

State

Grower's state location

Telephone

Grower's telephone number including the area code

Unit of Measure

"Unit of Measure (GA, LB, OZ) used by the retailer to sell a product"

UOM Conversion Factor

Number used to convert the retailer's unit of measure into the correct manufacture unit of measure

Zip

Grower's zip code (6 digit zip code plus 4 digit extension)

2. Are retailers able to track inventory within AGRIS? If so, to what level (does it include bookings)?

Answer: Yes, retailers can track inventory extensively within AGRIS.
- Bookings are done at the item-specific level.
- Prepays may be done at the item-specific, item description, product category, generic, invoice type, and Sales Order levels.
- Sales Orders
- Tracking of Inventory can shown as On-Hand, Purchases, Sales, Available to sell (custom calculation per merchant). and the traditional POSITION. All of these can be tracked in different units of measure.
- Transactions that support tracking of inventory in AGRIS include Purchase Orders, Stock Additions, Transfers, Vouchers, Bookings, Prepays, Sales Orders, Delivery Tickets, Sales Invoices and Product Returns. These, in addition to Stock Adjustments and Physical Counts are tracked in an Inventory Audit routine.
- Items can also be tracked by serialized inventory, lot number and container filled/used tracking (Example Chemical totes).
See the “EXPAND Product Master File Format” above for inventory information that AGRIS sends to AgriMine.

3. Is there a certain AGRIS software version the customers must be on in order to send transactions to AgriMine?

Answer: The current / most recent release is a best practice. AGRIS has supported various levels of the AgriMine File Translation since AGRIS V9 (released in 2000).

4. Is there anything required to send inventory data to AgriMine? Anything different than what's required for point-of-sale data?

Answer:
- The AGRIS integration requires a job processor (i.e., AGRIS Report Stream) to execute the transfer. This can be automated as a daily batch. It also requires an internet connection to place the AGRIS data on an FTP site.
- See the “EXPAND Product Master File Format” above for inventory information that AGRIS sends to AgriMine.

5. Is there a cost (up-front and/or on-going) associated with sharing inventory data?

Answer: The AGRIS retailer on maintenance pays no extra license fee for the AgriMine File Translation Extended Option. The retailer may need services from Greenstone to setup the AgriMine File Translation which may be a billable support call.

C. Setup Information

C.1. Verify that the Extended Option is set to “Y” / On.

Navigate to Maintenance > Dataset Maintenance > Select the applicable dataset > Extended Options > CFT Communications.
Enter “Y” in the Agrimine (#5) Extended Option
Select Save.

C.2. Configure the File Translations.

Navigate to Packages > Communications (CFT) > File Translations > Agrimine.