Inventory Reports

Reporting of Restricted Use Pesticide sales for the state of New York requires Products and Customers to be set up so the report can return the values required by New York State Department of Environmental Conservation. Setup Set a Location as th...

The options on the  Report Criteria window of the Inventory Book Report allow additional information to be included to tailor the report to fit specific needs. The options and uses are as follows: Include Over-received PO Quantities &ndash...

The Slow Moving Inventory report displays Products that have sold less than the Beginning Amount on Hand quantity if the Total Cost of the current Company Owned quantity is higher than the amount entered in the Total Cost Over field. Setup ...

There are specific rules set up to determine how a Purchase Receipt is valued in Agvance. If the product is in an estimated cost department, then the program will value the product on the Unprocessed Purchase Receipt Valuation report using the Purch...

The Product Cost Audit report, found at  Accounting Reports / Inventory / Inventory Status or by using the  Audit Costs button on the  Pricing  tab of the  Product Information  window, retains six months of transactio...

The Inventory Position Gross Margin report reviews sales, purchases, and margins for a specific fiscal month range. This report is located at  Accounting Reports / Inventory / Inventory Position . Setup Definitions for the headings used on th...

The Inventory Detail Recap report shows a high-level summary of product activity reflecting the movement of inventory. Navigate to Accounting Reports / Inventory / Inventory Position / Inventory Detail Recap . The headings on the report are as foll...

The Dormant Product Report displays products with no activity and/or no sales activity for a specific period of time. Navigate to Accounting / Accounting Reports / Inventory / Inventory Status / Dormant Products . Set up the necessary Report Crit...

The Product Price Audit report displays price changes made using Edit Product Pricing , Edit Product Pricing Using Formulas or at the Product Pricing tab. This report can be filtered by product, date range, price levels, and optionally by a dol...

When printing Product Labels, choose to include or exclude information to display on the label. Navigate to the Bar Code / Price Labels report found at Accounting / Accounting Reports / Inventory / Products. Designate the Product Labels criter...

The Position Analysis report is available at Accounting Reports / Inventory / Inventory Position. This report helps determine the net inventory position on Products (approximates an amount available for sale) and values that inventory. It also ass...

The Purchase Order Change Log report displays details of edits made to Purchase Orders. Navigate to the Purchase Order Change Log report at Accounting / Accounting Reports / Inventory / Purchase / Purchase Order Change Log . Designate the Purchas...

The Inventory Statements report is found at Accounting Reports / Inventory / Inventory Status . On Hand In the Select Style section, choose On Hand . Select any other additional criteria then choose to Print, Preview , or create a PDF File...

The Maximum / Average Daily Inventory report is used as an aid for completing the Sara Tier II report form. This report is found at Accounting Reports / Inventory / Maximum Average Daily Inventory and helps determine the maximum inventory of...

The Purchase Order Detail Received and Purchase Order Detail Processed reports accessible at Accounting Reports / Inventory / Purchase are valuable tools in reconciling Purchase Orders with Vendor Statements.  An explanation of the difference...

Q.  I am running my Re-Order report and there are products below the reorder level but they are not showing on the Re-Order Report. A.  In this instance, the  Inventory This Departmen t is not checked for the department the product...