Updated Articles

  1. Using Access 2000 to Create SQL Statements

    Q.  Can a user write a select query using Access 2000 and paste it into the Agvance query utility? A.  Yes, Access 2000 forces users into the SQL syntax, so queries generated from Access should run without error in Agvance's query utility. ...
  2. Printing Agvance Reports in PDF Format

    To export a report from Agvance to a PDF file, follow the following steps: Preview a report in Agvance. Select the Export Report icon at the top of the screen. Select Acrobat Format (PDF) as the Format . Select a location to save the...
  3. Location Setting for Applicators

    Q.  An Agvance user does not have access to applicators when invoicing. Is there a setting I need to change? A.  Applicators can be set to a specific location in Agvance but they do not have to be attached to a location. Depending on the level ...
  4. Changing Units of Measure on Existing Products

    Q.  I have set up a product in my inventory with the wrong unit of measure. How do I change the product so it is setup with the correct units of measure? A.  After an inventory product is established and online balances have been captured, edit...
  5. Using Department Categories in Agvance

    Department categories are used to link products that are in separate departments. Categories can also be used as a filtering tool on some reports. Following is a list of most of the areas where categories are used in Agvance: Product Selection...
  6. Fixing Path to Prior Year Data in Agvance

    If prior year data is moved or if it is restored into a different folder, edit the pointer that Agvance uses to locate the prior year data. Because Agvance uses the folder name as the database name, there are several naming rules that need to be f...
  7. Dual Monitors and Agvance Running as a Published App (Citrix or Server 2008)

    Q.  Users with dual monitors may experience an issue with Citrix published applications or Server 2008 RemoteApps where the application will always open on the same monitor, and the user is unable to drag it to the other monitor. A.  Terminal S...
  8. Copy Image to Another Machine on the Network

    Q.  I would like to have an additional copy of my daily image from Agvance to be saved to another machine on the network as an additional safety measure. What is the best way to do that? A.  Ask your hardware tech to create a batch file that co...
  9. Computer Cleaning Tips & Tricks

    Case What you use to clean your case is pretty much up to you. If it's really dirty, spray a little Windex or some other all-purpose cleaner onto a soft cloth to remove dust and dirt. Follow that up with a little Pledge to shine it up. Never sp...
  10. Logging Off Terminal Server Users

    Sometimes an error message occurs at a WAN (Wide Area Network) location which forces you to log off a user from the Terminal Server. Follow these instructions for logging off a user from Terminal Services: Go to Start / Settings / Control Pane...