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...

Options within the Inventory Book report, found at Accounting / Accounting Reports / Inventory / Inventory Status,  allow additional information to be included or excluded to tailor the report to fit specific needs. Include Over-received PO...

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. The Unprocessed Purchase Receipt Valuation report found at Accounting Reports / Inventory / Purchase will display this value. If the Product is in an Esti...

When questions or concerns arise around Product Costs there are two different areas that can offer research assistance. The Product Cost Audit report, found at Accounting Reports / Inventory / Inventory Status and the Audit Costs button on the...

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 the Inv...

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...

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 differences b...

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(s) were in. To...