Overview
The Eleview Export and Import feature generates a file which is saved to a designated folder and can be sent to Eleview for review. The file will be processed, and a results file will be created showing all the records sent as well as any errors identified. This file can then be imported into Agvance where the issues can be addressed.
When creating an export, the settlements are marked as “Processed” in Agvance so they will not be sent to Eleview again. Any errors identified in the Eleview review file will need to be downloaded and saved in the same file path as the export file. Once the review file is imported into Agvance, any settlements that have issues identified will be reverted back to an “Unprocessed” state so they can be corrected and processed again later.
Setup
Canadian customers can access the Eleview Export/Import at Grain / Transfers / Export / Canadian Wheat Growers and Grain / Transfers / Import / Canadian Wheat Growers.
In order to process properly, complete the Setup tab information prior to the first export. This setup is saved in the user profile, so it is recommended the same user perform the export/import each time.
Export Path – Indicate where the file will be created and saved. It is recommended to create a folder specifically for the export so it can be easily found and accessed by other users if issues arise. This path will be entered in the Eleview program.
Export File Name – It is recommended to use the last settlement date as part of the file name.
NOTE: The file name will need to be a new name with each export.
Batch ID – Will begin at 1 and increase incrementally as more files are created. This designates each batch that is created.
Eleview ID – Your company Agri-eBusiness (AEB) identifier.
Producer ID Xref – Agvance Customer profile’s XRef label used to reference the Grower’s ID found in Agri-eBusiness database used by Wheat Growers.
Commodity Pools – Select the and the Pool ID it will be cross-referenced to for use in reporting.
Commodity XRefs – Select the and the Eleview equivalent it will be cross-referenced to. The Minimum Moisture % Charged column is used to enter the minimum moisture percentage for calculating drying per commodity. Anything equal to or below this percentage will not have drying charges in the file.
Grade Factor XRefs – Select the and the Eleview equivalent it will be cross-referenced to. Currently Grade, Moisture and Protein are all required Grade Factors.
Deduction XRefs – In the column, select all Agvance Grain Settlement Deductions and the Eleview deduction equivalent they are to be cross-referenced to. ALL deductions must be mapped with a Wheat Grower specific ID or the option of Other.
Export Process
When entering the Settlement Start and End Dates, Agvance will use the date the settlement was entered rather than the actual date of the settlement. This allows the settlement to be backdated without causing reporting issues.
Settlement Start Date – use the last known import date if all were imported correctly. If there were any errors on the last import date, enter a date that will capture any corrected settlements that need to be reported.
Settlement End Date – use the current date or the date you would like to process settlements up to.
On the Setup tab, update the Export File Name. It is recommended to use the last settlement date as part of the file name. Select Export to create a file. Once the file is saved, it is ready to be sent to Eleview using Eleview software.
Export File Notes
Canadian Wheat Growers Fee per Tonne - In the exported file, the Fee Per Tonne is the rate of the Agvance Grain Tax deduction instead of calculating the actual amount.
Canadian Wheat Growers Ontario Customers - The export only includes Settlements for Ontario customers with ON in the State on the Profile tab of the Customer File.
Canadian Wheat Growers Report of Missing Producer ID - The program scans all records in the file for a producer ID which is entered as the Producer ID Xref. If customers are missing this information, a message displays during the export listing these customers along with the option to stop the import or to continue. The message may be printed. If continue is selected, customers missing producer IDs are omitted from the file.
Canadian Wheat Growers Reversals of Settlements - When reversing a Settlement containing Settlement Contract sources, it correctly negates the original Settlement.
Import Process
In the Eleview program, a results folder must be set up which will be accessible by Agvance. Once Eleview has completed the review of an exported file, a results file will be sent with a name similar to the example shown below. The first two letters denote the month the original file was sent. The next two numbers denote the day of the month. This file should be saved to the Eleview results folder.
Once downloaded to the Eleview folder, it can be imported into Agvance at Grain / Transfers / Import / Import Canadian Wheat Growers.
Using the search tool, locate the results file to be imported. It should contain today’s month/day in the file name. Select Import.
A message will display indicating the number of records “unchecked”. These are the records that were NOT accepted by Eleview and require additional research to correct the issue and be resubmitted.
Errors
Currently Agvance does not have a report listing the records rejected by Eleview. However, the results file can be reviewed as either a .CSV or .TXT file and contains the original information submitted as well as any error codes. If an error code is included in the record, it will be near the end of the record.
Contact SSI for a current list of error codes if needed.
The example below shows records PD,11 and PD,12 which are error 75. They are missing the AEB number which should be located prior to the commodity as on record PD,10.
