> 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/item-landed-cost-by-store-report.md).

# Item Landed Cost by Store Report

### What is the Item Landed Cost by Store Report?

The Item Landed Cost by Store Report provides a store-wise overview of item costs and inventory quantities, helping businesses track landed costs and evaluate inventory valuation across different stores. The report includes information such as item quantities, amounts in home currency, and store-level landed costs, allowing users to analyze cost variations across stores.

This report addresses the requirement to generate a report containing the last landed cost and average cost of items that can be exported to CSV. Users can customize the report to display relevant item details and cost information, making it easier to review inventory costs and use the data for further analysis.

### Running and Customizing the Item Landed Cost by Store Report

To access and work with the Item Landed Cost by Store Report in XoroERP, navigate to **Menu > Reports > Operation > Item Landed Cost by Store** Report.

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2F8aOdxWRmSogMLxMOfzHd%2Fimage.png?alt=media&amp;token=a6832604-128e-4833-9169-1aaef836ee5f" alt=""><figcaption></figcaption></figure>

### Report Filters

The report provides several filters that allow users to narrow down the data based on their business requirements. These filters are located at the top of the report.

* **Period:** Filters the report based on a predefined period or a custom date range. Users can select a period such as Today or specify custom From and To dates.
* **Item Number:** Allows users to search for a specific item using its unique item number or SKU.
* **Description:** Allows users to search for items using their descriptions.
* **Brand:** Filters the report by product brand.
* **Category:** Filters the report by item category.

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2FC6g8XkhkfKUsxqyxZfH3%2Fimage.png?alt=media&amp;token=c22b22ca-ccba-4bec-ac71-4e9d1d0c1243" alt=""><figcaption></figcaption></figure>

After selecting the required filters, click the Refresh icon in the top-right corner of the report to apply the changes.

### Item Landed Cost by Store Report Fields

The report provides item and cost-related information grouped by store, allowing users to review inventory quantities and costs across different locations.

| Field                   | Description                                                                                                              |
| ----------------------- | ------------------------------------------------------------------------------------------------------------------------ |
| Store                   | Displays the store associated with the item and its inventory cost information.                                          |
| Category                | Displays the category assigned to the item.                                                                              |
| Brand                   | Displays the brand associated with the item.                                                                             |
| Item                    | Displays the item associated with the inventory and cost details.                                                        |
| Qty                     | Displays the item quantity associated with the selected store and reporting criteria.                                    |
| Amount Home Currency    | Displays the item amount expressed in the home currency.                                                                 |
| Store Level Landed Cost | Displays the landed cost associated with the item at the respective store level.                                         |
| Average Cost            | Displays the average cost of the item, which can be added to the report layout through the Fields option when available. |
| Last Landed Cost        | Displays the most recent landed cost of the item, if available among the report's fields.                                |

### Toolbar

The toolbar provides options for managing, customizing, and exporting the report.

#### File

* **Save My Layout:** Saves the current report layout for future use.
* **Restore Layout:** Restores the previously saved report layout.
* **Restore Filters:** Removes applied filters and restores the default filter settings.
* **Save as New:** Saves the current report configuration as a new report.

#### Tools

* **Expand All:** Expands all grouped data within the report.
* **Collapse All:** Collapses all expanded groups for a simplified view.
* **Fill Group Cells:** Repeats grouped values in blank cells to improve readability.
* **Hide Group Cells:** Hides repeated grouped values for a cleaner report layout.

#### Export

* **Grid:** Displays the report data in a tabular format.
* **Chart:** Displays the report data graphically for easier visualization and analysis.
* **Export:** Allows users to export report data in a supported format. Users can select CSV, where available, to download the report data for further analysis.

### Layout and Formatting Options

The Format, Options, and Fields buttons allow users to customize the appearance and structure of the report.

#### Format

The Format window allows users to customize how values are displayed within the report. Users can select which value to format, adjust text alignment, configure thousand and decimal separators, specify currency symbols and their formatting, display custom values for null fields, and choose whether values should be displayed as percentages.

The window also supports conditional formatting based on predefined conditions, allowing users to highlight important values.

#### Options

The Options window allows users to configure how the report is displayed.

Available options include:

**Grand Totals:** Configure how grand totals are displayed.

* Do not show grand totals
* Show grand totals
* Show for rows only
* Show for columns only

**Subtotals:** Control how subtotals appear within grouped data.

* Do not show subtotals
* Show subtotals
* Show subtotal rows only
* Show subtotal columns only

**Layout:** Choose the report layout.

* Compact Form
* Classic Form
* Flat Form

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2Fl4A6Gm9il3bFiSI93M6j%2Fimage.png?alt=media&amp;token=332bb8bc-4678-4bac-959e-4c980843722f" alt=""><figcaption></figcaption></figure>

After making the required changes, click Apply to update the report.

#### Fields

The Fields option allows users to customize which [fields](#item-landed-cost-by-store-report-fields) appear in the report.

**Calculated Value:** The Add Calculated Value option allows users to create a calculated field using available report values and supported operators.

To configure a calculated value:

1. Open the Fields window.
2. Click Add Calculated Value.
3. Enter a name for the calculated value.
4. Drag the required values into the formula area.
5. Use the available mathematical or logical operators to construct the formula.
6. Click Apply to save the calculated value.

{% hint style="info" %}
This option can be used to create additional calculations from available report fields. However, it does not independently retrieve the last landed cost or average cost if the underlying data is not available in the report.
{% endhint %}

### Exporting the Report to CSV

To export the report for further analysis:

1. Open the Item Landed Cost by Store Report.
2. Apply the required filters, such as Period, Item Number, Description, Brand, and Category.
3. Click Fields and add the required item and cost fields, including Average Cost and Last Landed Cost if available.
4. Click Apply to update the report layout.
5. Review the report data to ensure the required information is displayed.
6. Use the Export option to export the report in CSV format, if supported.

The exported file can then be opened in spreadsheet applications for further analysis, reporting, or recordkeeping.

### Report Access and Permissions

Access to reports in the Reporting Library is controlled through the **Access Manager** module. If the report is not visible or cannot be accessed, verify the permissions assigned through the user's Role, Custom Access, or Profile settings in Access Manager. Available reports and report-related actions may vary depending on the user's assigned access privileges.


---

# 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 by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.xorosoft.com/xoroerp-1/reports/operation/item-landed-cost-by-store-report.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.
