How to Use the Stock Onhand Report in Axanta ERP 

This document provides a step-by-step guide to accessing, customizing, and exporting the Stock Onhand Report in Axanta ERP. 

1. Accessing the Stock Onhand Report

• From the main Axanta dashboard, navigate to and click the Inventory module

​.

• In the Inventory dashboard, click the inquiries and Select Stock Onhand from the dropdown menu bar.

​

2. Setting Report Parameters

• A pop-up window appears, allowing you to configure the report before running it.

​

• Show by (Report Type):
  • Summary: A high-level view of products and their quantities. 
  • Detail (Default): A comprehensive report including lot numbers, cost price, etc. 
  • As Of Date: Use this to run the report for a specific historical.

​

• Show by (Unit of Measure):
  • Base Unit (Default): The smallest unit of measure for the product

​.

• • Reporting Unit: An alternative unit (e.g., "case" or "box"). 

• Filters: You can narrow your report by specific criteria like:
  • Warehouse 
  • Products 
  • Categories, Brands, Suppliers, etc.
  • Once your parameters are set, click the View button to generate the report

​.

3. Working with the Report

By default, the report opens in a "List View," which is a grid or spreadsheet layout

​

Customizing Columns

You can change which data columns are visible:

1. Click the vertical three-dot icon (Manage Columns) in the top-right of the report header. 
2. Check or uncheck the boxes for the fields you want to add or remove (e.g., adding the "Brand" column).