> For the complete documentation index, see [llms.txt](https://docs.xorosoft.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.xorosoft.com/xoroerp-1/reports/operation/inventory-valuation-summary/inventory-valuation-summary-fields.md).

# Inventory Valuation Summary Fields

The Inventory Valuation Summary report provides insights into the current value and cost of each item in the system.  The insights gleaned from this report enable businesses to optimize inventory levels, identify slow-moving items, adjust pricing strategies, and enhance overall profitability.

{% hint style="info" %}
To access the report, go to **Menu > Reports > Operation > Inventory Valuation Summary**
{% endhint %}

On selecting the option, the system prompts you to choose a document template. Select the "Inventory Valuation Summary" report template from the "Select Document Template" dropdown and click "Print Preview" to open the report.

<figure><img src="/files/CW5QVIJHBQWdb0Fc3PRj" alt=""><figcaption></figcaption></figure>

### **Generating the Inventory Valuation Summary**

The valuation report is displayed for a single item. To generate the Inventory Valuation Summary report for a specific item, enter the item number in the designated "Item Description" column on the right-hand side of the report interface and press enter.&#x20;

<figure><img src="/files/nmrhP8g3tZTUD9x3IDxk" alt=""><figcaption></figcaption></figure>

#### Inventory Valuation Summary Fields

<table><thead><tr><th width="170">Field</th><th>Description</th></tr></thead><tbody><tr><td>Item</td><td>This field shows the unique identifier for the item.</td></tr><tr><td>Description</td><td>This field displays the description of the item.</td></tr><tr><td>Standard Cost</td><td>This field shows the standard cost of the item.</td></tr><tr><td>Standard Price</td><td>This field shows the standard price of the item.</td></tr><tr><td>On Hand</td><td>This field shows the on hand quantity of the item currently in stock.</td></tr><tr><td>Asset</td><td>This field shows the total value of the item in stock based on the standard cost.</td></tr><tr><td>Markup %</td><td>This field displays the percentage increase from the standard cost to the standard price. It is calculated as: Markup % = ((Standard Price - Standard Cost) / Standard Cost) *100.</td></tr><tr><td>Margin %</td><td>This field displays the profit margin as a percentage of the selling price. It is calculated as: Margin % = ((Standard Price - Standard Cost) / Standard Price) *100.</td></tr><tr><td>Average Cost</td><td>This field shows the average cost of the item.</td></tr></tbody></table>

### Diving Deeper with the Inventory Valuation Detail Report

For more detailed information on an item's valuation, the Inventory Valuation Detail report is available. By clicking on the item number in the summary report, users can access all transaction details associated with the item. This includes every transaction that has influenced the current valuation.

<figure><img src="/files/IwgzEEl51zcJm1BNoCFS" alt=""><figcaption></figcaption></figure>

#### Inventory Valuation Detail Fields

<table><thead><tr><th width="154">Field</th><th>Description</th></tr></thead><tbody><tr><td>Store</td><td>This field shows the store associated with the transaction.</td></tr><tr><td>Item</td><td>This fields shows the unique identifier of the item. </td></tr><tr><td>Txn Type</td><td>This field shows the type of transaction, such as Item Receipt, Invoice, Inventory Adjustment, etc.</td></tr><tr><td>Reference No</td><td>This field shows the reference number associated with the transaction for easy tracking purposes, such as the Item Receipt number, Invoice number, etc.</td></tr><tr><td>Source Ref No</td><td>This field shows the source reference number of the transaction.</td></tr><tr><td>Date</td><td>This field shows the date of the transaction.</td></tr><tr><td>Entity Name</td><td>This field displays the name of the entity (customer, vendor or store) associated with the transaction </td></tr><tr><td>Qty</td><td>This field shows the item quantity involved in the transaction.</td></tr><tr><td>Cost</td><td>This field shows the amount of the transaction.</td></tr><tr><td>On Hand</td><td>This field shows the current on-hand quantity of the item.</td></tr><tr><td>Asset</td><td>This field shows the current asset value of the item.</td></tr><tr><td>Avg. Cost</td><td>This field shows the average cost of the item.</td></tr></tbody></table>

Furthermore, users can click on the transaction record to view the journal entry details associated with the transaction.

<figure><img src="/files/vdLox6PdeQSQ3WJd1DaP" alt=""><figcaption></figcaption></figure>

### Report Header Icons

* **Refresh:** This allows you to refresh the search results after changing the search criterion.
* **Toggle Print View:** This feature enables you to switch the display mode specifically for printing the report. When activated, it adjusts the formatting and layout of the report to optimize its appearance when printed out.
* **Toggle Parameter Area:** This functionality enables you to switch the parameter area's visibility, located on the right side of the Income Statement By Class Window. Toggling this setting allows you to show or hide the parameter options, giving you more control over the display and customization of the Income Statement By Class details.
* **Download:** This versatile feature allows users to export and download data in various file formats, providing a summarized overview for quick reference. Options include CSV, TXT, MS-Word, MS-Excel, PDF, and MS Excel (.xlsx), catering to diverse user preferences and use cases.
* **Advanced Search:** The Advanced Search option elevates customer information retrieval to a sophisticated level. Users can delve into a nuanced search by specifying criteria facilitating precise and tailored searches.
* **Zoom In and Zoom Out:** These features in XoroERP's reporting module allow users to adjust the view of the report according to their preferences. Zooming In increases the size of the report elements, making them easier to read and analyze, while Zooming Out decreases the size for a broader view. These options are particularly useful when dealing with detailed reports or when users need to focus on specific sections of the report.
* **Toggle Full Page Width:** This feature enables users to toggle between displaying the report at its full page width or adjusting it to fit the screen width. When toggled to Full Page Width, the report expands to utilize the entire width of the viewing area, ensuring that all elements are fully visible and enhancing readability. On the other hand, toggling off Full Page Width may be useful for viewing multiple reports simultaneously or when a narrower view is preferred for better organization of the workspace.

### Inventory Valuation Summary (All)

The **Inventory Valuation Summary (All)** reporting template provides a consolidated view of inventory valuation information for all items in the system. This report can be used to review inventory quantities, inventory costs, asset values, and profitability metrics across the entire inventory catalogue.

To generate the report:

1. Navigate to **Menu → Reports → Operation → Inventory Valuation Summary**.
2. In the **Select Reporting Template** window, choose **Inventory Valuation Summary (All)** from the **Select Document Template** dropdown.
3. Click **Print Preview**.

This report is particularly useful when users want to view current inventory quantities along with the associated inventory costs and overall inventory value for all items in a single report.

For transaction-level valuation details, users can click an item number to drill down into the **Inventory Valuation Detail** report and review the transactions that contributed to the item's valuation.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.xorosoft.com/xoroerp-1/reports/operation/inventory-valuation-summary/inventory-valuation-summary-fields.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.