Overview
The Transfer Scale Tickets function can be found in Agvance Grain Operations / Scale Ticket Interface under Operations / Transfer Scale Tickets.
Setup
Agvance can receive files with an extension of .dbf, .txt or .fil from the CompuWeigh system. Once you determine which file type you want to receive, follow the corresponding setup instructions below.
Setup for receiving .dbf files
When the Transfer Scale Tickets window is opened, it defaults to the Import Scale Tickets tab. Select the Receive Transfer File tab and then select the Import Transfer File Type named CompuWeigh (.dbf).
Click on the button next to the Transfer File text box and browse to find the drive/folder that contains the CompuWeigh file (a common file name is Fromgms.dbf). Select the file you want to import.
Enter the grade factor from CompuWeigh that represents the dockage if a grade factor is used to represent dockage percent in CompuWeigh. Click on the Import Transfer File button. This will transfer the CompuWeigh scale tickets into the Agvance Scale Ticket Interface.
Setup for receiving .txt files
When the Transfer Scale Tickets window is opened, it defaults to the Import Scale Tickets tab. Select the Receive Transfer File tab and then select the Import Transfer File Type named CompuWeigh (.txt).
Click on the button next to the Transfer File text box and browse to find the drive/folder that contains the CompuWeigh file. Select the file you want to import.
Enter the grade factor from CompuWeigh that represents the dockage percent if a grade factor is used to represent dockage percent in CompuWeigh. Click on the Import Transfer File button. This will transfer the CompuWeigh scale tickets into the Agvance Scale Ticket Interface.
Setup for receiving .fil files
Note: Customer Cross Reference and the Commodity Cross Reference must be setup before doing this CompuWeigh file import.
When the Transfer Scale Tickets window is opened, it defaults to the Import Scale Tickets tab. Select the Receive Transfer File tab and then select the Import Transfer File Type named Format 1 (.fil).
Click on the button next to the Transfer File text box and browse to find the drive/folder that contains the CompuWeigh file. Select the file you want to import.
Check the Add Location Number as part of the Ticket Number option if you want the location number to be prepended to the scale ticket number that is created in Agvance. If you check this option, you will be given the option to determine the Length of the Location to Prepend. Specify how many characters of the 3 digit location number from each ticket in the .fil file you want to prepend. For example, if you select ‘1,’ only the third digit of the location number will be used. If you select 2, the second and third digits of the location number will be used.
Check the Do not import Bins option if you do not want to import bins.
Enter the grade factor from the CompuWeigh system that represents the dockage percent.
Enter the customer cross reference that ties to the customer IDs used in the CompuWeigh system. This cross reference is setup in the Hub at Setup/Company Preferences/Customer tab. If the same customer IDs are used, select Agvance ID .
Enter the commodity cross reference that ties to the commodity IDs used in the CompuWeigh system. This cross reference is setup in Grain at Setup/Preferences/General tab.
Comment Options:
To import the Comment for each ticket, enter 03. This is the line identifier in the CompuWeigh file that represents the comment. If you do not want to import comments, select None.
To import the Weighmaster name for each ticket, enter 01. This is the line identifier in the CompuWeigh file that represents the Weighmaster name. If you do not want to import Weighmaster name, select None.
Grade Factor Cross References - enter the CompuWeigh grade factors in the Xref GF column that correspond to the Agvance grade factors.
Click on the Import Transfer File button. This will transfer the CompuWeigh scale tickets into the Agvance Scale Ticket Interface.
Import
After the scale tickets have been transferred, select the Import Scale Tickets tab. The list of scale ticket types is now visible and displays the number of tickets available to be imported.
Only one scale ticket type can be imported at a time. Select the type. Optionally, the un-transferred tickets can be individually selected or they can all be imported.
With the Validate All Tickets on Import to Grain Documents selected, each scale ticket type will display the CompuWeigh tickets in an Agvance grain form to allow the user to verify that the data is correct and to make any necessary changes. (Validation is recommended.)
As the records are transferred with the validation checked, you will have the option to alter any or all of the data as it is reviewed at the import window. Click on Import to create a scale ticket, shipment or commodity transfer in Agvance Grain.
