Product Setup

Articles

Product Setup in the Hub
Inventory products and services (such as custom application) are entered in the Product file. In order to group them logically, Products are stored in Departments. Examples of departments are Dry Fertilizer, Liquid Fertilizer, Chemicals, Application...
Cost Calculation on Manufactured Formulas
The cost of a Manufactured Formula is calculated from the costs on the raw materials that make the Manufactured Formula. Whether the program uses Average, Last, Estimated Average, or Replacement Cost is determined by what is set at  Accounting ...
Moving Products between Departments
Products may be moved into different departments either by editing the product and selecting a different department or by using the Batch Edit Products utility found at Hub / Utilities / Admin Utilities / Hub . There are a couple of things to c...
California High VOC Regulations
Regulations, effective November 1, 2013 in California (San Joaquin Valley), add additional requirements and responsibilities for chemical dealers selling certain high-VOC (Volatile Organic Compound) pesticides to agricultural users. Dealers must det...
Pricing Labels for Shelving Units
Agvance has an alternative product label for use with shelving units that displays the product name and price more prominently than our standard labels. The dimensions of the labels are 1.25" tall by 2" to 3" wide. These new labels ha...
Changing IDs and/or Names
The  Product Name and/or  Product ID may be edited at any time. The changes filter through the database so the history follows the changes and maintains the integrity of the data. A couple of things to note if changes are made: When r...
Setting Up and Tracking Consignment Products
Vendors will sometimes supply a dealership with product and bill them monthly for the portion of the product that is sold. Below is how to set up and manage that product. Add the product and mark the Consignment checkbox on the Profile tab. Thi...
Product Cost Calculation
Last Cost Last Cost is the last price paid for a product on a Purchase Invoice or the most recent cost of a manufactured product. Last Cost is updated when: A Purchase Invoice increases inventory. Manufacturing of product takes place result...
Units of Measure Conversion
Navigate to Hub / Setup / Unit of Measure Conversion . The Foreign Unit multiplied by the Conversion Factor equals the Agvance Unit . The Agvance Unit divided by the Conversion Factor equals the Foreign Unit . This tool can be used to c...
Ratio Wizard
This feature automatically calculates the Rate to Blend Ratio , Blend to Inventory Ratio , Billing Divisor , and Package Size (if the product density and the proper units for this item have been provided) when setting up a product. After calcul...
Product Setup Examples
These tables might help with the task of assigning the various units associated with each product. Although a bit tedious to enter, these are critical to the calculation of correct quantities of product displayed on Blend Tickets, Delivery Tickets, ...
Regulation of Restricted Product
Agvance has some advanced options available to help regulate distribution of restricted products. These rules are complicated by the fact that laws vary widely from state to state. There are two major types of checking that can be invoked from withi...
 Manufactured Formula
Edit a Product at File / Open / Product and choose Manufactured Formula . Overview Standard blends that are either stockpiled or custom blended for resale should be set up with a recipe in the Manufactured Formula window. All raw mat...
Multiple Product Setup for Blending and Planning Process
Prepare multiple products at once for use in Agvance Blending and Planning. Navigate to Hub / Utilities / Admin Utilities . In the Agvance Utilities module, navigate to Hub / Batch Edit Products .  Choose Select on the Edit Product Info...
Single Product Setup for Blending and Planning Process
Prepare a single product for use in Agvance Blending and Planning. Navigate to Hub / File / Open / Products . Note: This can also be done at Accounting / File / Open / Products .  On the Select a Product window, choose the desired prod...
Updating Chemical Database Products
Overview Chemical Database product information can be easily updated in Agvance manually or by using the Agvance Agent tool. This utility incorporates the Save Sets/Load Sets functionality found on several reports in Agvance.  Note: Agvance...
 Federal and State Permits In Agvance
Federal Permits in Agvance are designed to help with the regulation and sale of Restricted Use Products to customers as defined by the EPA. Each state manages their own certified pesticide applicator licenses. In the majority of the states/cases, st...
Ammonia Grower Certification
Illinois is now requiring growers to obtain an Ammonia Grower Certification to handle Ammonia as well as ammonia products. With this new certification, Agvance is storing this data for easy reference of expired certifications. The following indicate...
Product Attributes Show in List
Product Attributes shown in the Add/Edit Product  window and Product Multi-Select window will only be those explicitly marked to display at Hub / Setup / Company Preferences on the Product tab.  Select Product Attributes then add...