Articles
Benefits of Hosting Your Agvance in the Cloud
Our Agvance servers in the AWS environment give you access to Agvance programs and data using Remote Desktop Protocol (RDP). As an additional benefit, using Agvance servers gives you access to Agvance SKY to access data from anywhere using an Inter...
Changing an Agvance Hosted Password
Occasionally, Agvance Hosted passwords will need changed or reset. An Agvance Hosted user can accomplish this by following the steps below. While logged into the Agvance Hosted server, select CTRL + ALT + END on the keyboard. Select Change a ...
KwikTag Overview
KwikTag is a document imaging system that gives the ability to scan and electronically store various Agvance transactions and documents.
Logging In
To access KwikTag, in a web browser, enter the URL provided by KwikTag. This IP address all...
How to Find the Agvance SQL Server Version
Agvance 7.0 requires SQL Server 2014 or higher.
Q. How do I determine what SQL Server version Agvance is using? A. From within one of the core Agvance modules, select Help / About . The SQL Server version controlling the Agvance d...
API Security
Agvance API Security is set up and maintained per Agvance user with access to the API. Setup In the Admin Utilities , for databases with an API Database ID established as well as valid connection information set up in the API, go to Hub / API Se...
Setting up AgvAgent for Email
Agvance Agent can be set up to enable emailing of tasks/reports. AgvAgent only works as a scheduled batch if full SQL is used. Without the full version of SQL, the scheduled batches will not run and emails will not be sent. User Email Addresses ...
Connecting a Mac System to an Agvance Hosted Server
On the Mac Computer, go to the App Store. Search for the Microsoft Remote Desktop app and select Get . Once the app has downloaded, the following window displays. Select the Plus and choose Add PC . Enter the server information and sel...
Instructions for Emailing via Bulk Email Service
Errors are occurring when sending documents using a company's existing mail service provider. To help address this situation as quickly as possible, SSI researched and tested a way to allow companies to use a bulk email service instead of their ex...
Agvance Report Agent User Document
Use Agvance Report Agent to run or email multiple reports/tasks at a scheduled time or on-demand with the click of a button. This Agvance Agent is helpful for large reports that run on a regular basis and some Accounting and Grain reports can be r...
Adding a Customer - Error: There is no row at Position 0.
Q. When adding a new customer, an error message displays: Error: There is no row at position 0 . A. On the Miscellaneous Info tab, double-click in the State Code box or the Adj Code box and choose Select . It will give the error if the...
Agvance Custom Report Export
Q. Why does one Agvance report have different information than an Agvance Custom Export report? A. Because of the complexity of this area, limited support is offered. A message displays indicating the information being exported is raw data reco...
Agvance Scheduled Task Requirements
Although not specifically designed to run unattended from a Windows Scheduled Task, some work has been done to allow certain features in Agvance to be run from a Windows Scheduled Task. However, there are some limitations and requirements that MUST...
Agvance Report Agent Schedulable Events
Q. Is there a list of reports that work with the Agvance Report Agent? A. Load / Save Sets That Can Be Scheduled Using AgvAgent Hub Transfer AgKnowlogy Export Utilities Edit Product Pricing/ Replicate Prices Transfer to Field His...
Required Product on Containers
Q. I am trying to enter a transaction (Blend Ticket, Delivery Ticket, purchase documetrnt, Invoice), and I am getting a message that one of the products requires a container. I have checked all of my containers, and this product is not marked as r...
Using PDF Print Driver for Agvance Documents
To send documents (Invoice, Delivery/Blend Ticket, map, etc.) via email, download a PDF print driver (everal companies offer free PDF drivers). Once installed, select the PDF driver at the Print Document screen. These documents can be sent in a PD...
Remote Printing Using a Public IP Address
The steps below detail how to set up a printer in one location in such a way that users at a different location can print to the printer over the Internet using a public IP address. This is sometimes necessary when using a mobile device that needs t...
Wireless Signal Interference
Q. What devices can interfere with a wireless networking signal? A. Wireless networks operate through radio signals at a frequency of 2.4 gHz, so anything else that produces a signal on the same frequency can cause interference. Microwave ovens...
Dual Monitors - Advantage and Caveat
Overview Several Agvance modules are optimized with the use of dual monitors – Mapping and Dispatch for example. The advantage of dual monitors is that by dragging selected Agvance windows to the secondary monitor, there are now two unique views of...
Copy Roles/User Profiles
The Copy Roles/User Profiles utility allows the option to duplicate Roles and Users in datasets where they were not originally included. Copying Roles from the current year dataset will ensure that all the Users’ corresponding Roles will be availabl...
Agvance Move Databases Utility
When a new data server is purchased, all Agvance datasets must be moved to the new server. Most Agvance customers have several related datasets. The primary database is typically stored in \AVDATA on the SQL server. Additionally, there are generally...
Calendar Displays Incorrectly or Automation Error While Using Calendar in Agvance
Q. The following error occurred while trying to use the drop-down calendar function in Agvance: ‘Error -2147319765 – Automation Error Element not Found’ Another symptom of this issue is the calendar displays the days of the week in the wron...
Batch Edit Customers
The Batch Edit Customers function in Admin Utilities is used to edit several areas of the Customer file without opening Customer files one at a time. Multiple Customers can be selected to edit at the same time.
To access the utility, go to H...
OKI Data Printer Setup
The following describes how to configure OkiData 320 Microline printers with USB connections to print Wide-3 format Agvance Grain Scale Interface Scale Tickets. This article can also be used as a general guide for setting up these printers for other...
Terminal Services - Disconnect vs. Logoff
The following covers the difference between disconnecting and logging off a Terminal Services, Citrix, or Remote Desktop session.
It is important to understand that when working in a remote session, the session and all applicat...
Terminal Services and Roaming Profiles
Q. Can roaming profiles be used to keep profiles uniform across all terminal servers in the server farm? Are there any restrictions on the use of roaming profiles? A. Terminal Services Roaming Profiles are almost a necessity with a server farm....
Definition of Server Path
In the past, Agvance used a naming convention that included the server name in the path to the data (e.g. \server\drvc\data\avdata\agvance.mdf). However, this caused issues when network problems caused delays in resolving the server's name, causing ...
Windows Installer Internal Error 2755
Q. Windows Installer Internal Error 2755 occurred while installing Agvance. How can this be resolved? A. This error only happens when trying to install on Terminal Services using a remote connection. It is caused by a bug in Windows Installer/T...
Clear Browser Cache
When a web-based application gets an update, best practice is to clear the browser's cache. Below are instructions on how to clear browser cache on Google Chrome.
With Google Chrome open, press F12 on the keyboard. The Developer Tools...