> 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/configuration/application/app-config/inventory/show-sales-history-data-in-inventory-snapshot-and-short-inventory-planner.md).

# Show Sales History Data in Inventory Snapshot and Short Inventory Planner

### **What is Show Sales History Data in Inventory Snapshot and Short Inventory Planner?**

The **Show Sales History Data in Inventory Snapshot and Short Inventory Planner (SIP)** feature enables businesses to view historical sales quantities directly within the Inventory Snapshot and Short Inventory Planner modules.

When enabled, a **Sales History Qty Sold** column becomes visible in both modules. This allows users to see how many units of an item were sold without navigating away from inventory planning screens.

This feature is designed for inventory planners, purchasing teams, and operations managers who require quick visibility into past demand trends to make informed replenishment decisions and avoid stock imbalances.

***

### **Key Benefits:**

* Provides immediate access to historical sales quantities within planning modules
* Improves demand forecasting and reorder decision-making
* Reduces the need to navigate between modules for sales analysis
* Helps prevent overstocking and stockouts
* Enables faster operational planning using real sales data

***

### **Configuration Details:**

**Configuration Name:** Show Sales History Data in Inventory Snapshot & Short Inventory Planner

**Configuration Location:** Menu → App Config → Inventory → **Show Sales History Data in Inventory Snapshot & Short Inventory Planner**

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2Fz0DmRQFYOIzvTiseGBlC%2Fimage.png?alt=media&amp;token=f8f8a339-7f35-4b1e-8a66-13b25e4646d9" alt=""><figcaption></figcaption></figure>

***

### **Functionality:**

1. Functionality **When App Config is Disabled**:&#x20;

* The **Sales History Qty Sold** column is not displayed in the Item Inventory Snapshot and Short Inventory Planner (SIP) modules.&#x20;
* Users cannot view historical sales data directly within these modules. Historical sales information remains accessible only through the **Sales History tab within the Item Details sub form**. The Item Details sub form can be opened by double-clicking an item in the Item Centre.

2. Functionality **When App Config is Enabled**:&#x20;

* A new column, **Sales History Qty Sold**, is now visible in the **Item Inventory Snapshot** and **Short Inventory Planner (SIP)** modules. This column displays the total quantity sold for each item.
* When a user clicks on the Sales History quantity value, a detailed **Sales History** sub form opens.

  The Sales History sub form can also be accessed through the following steps:

  * Double-click an item in the Item Centre.
  * The Item Details page opens.
  * Navigate to the **Sales History** tab.

  With this enhancement, XoroERP provides consistent and centralized access to item-level sales history across the system.

***

### **Sales History Sub Form Details:**

* The Sales History sub form displays detailed transaction records with the following columns:

<table><thead><tr><th width="374">Column Name</th><th>Description</th></tr></thead><tbody><tr><td>Date</td><td>The transaction date when the item was sold.</td></tr><tr><td>Store</td><td>The store location where the sale was processed.</td></tr><tr><td>Customer</td><td>The name of the customer associated with the transaction.</td></tr><tr><td>Item Number</td><td>The unique identifier of the item sold.</td></tr><tr><td>Order Type</td><td>The type of sales document (e.g., Invoice, Credit Memo).</td></tr><tr><td>Ref Number</td><td>The related document number, such as the Invoice Number or Credit Memo Number.</td></tr><tr><td>Rep</td><td>The sales representative associated with the transaction.</td></tr><tr><td>Unit Price</td><td>The selling price per unit of the item.</td></tr><tr><td>Qty</td><td>The quantity of the item sold in the transaction.</td></tr><tr><td>Total</td><td>The total sales amount for the transaction (Unit Price × Qty).</td></tr><tr><td>Currency</td><td>The currency in which the transaction was recorded.</td></tr><tr><td>Customer PO</td><td>The Customer Purchase Order number associated with the Sales Order, if available.</td></tr></tbody></table>

* A **Total summary row** is displayed at the bottom of the grid showing Total Quantity and Total Sales Amount.

***

### **Additional Functionalities within Sales History Sub Form:**

* **Customer Search Field:**\
  A dropdown search field allows users to filter sales history by customer. Users can type to search by name, email, or phone number.
* **Create New Customer Option:**\
  The dropdown includes an **Add New Customer** option. Selecting this option redirects the user to the Create Customer page.
* **Print Functionality:**\
  Users can print the sales history records directly from the sub form.

***

### **How it Works:**

**Step 1:** Enable the app configuration **“Allow Historical Data in Inventory Snapshot & Short Inventory Planner (SIP)”**.

**Step 2:** Navigate to either Item Inventory Snapshot or Short Inventory Planner.

**Step 3:** The **Sales History Qty Sold** column is visible in the grid.

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2FYVkEahB5WEN1x9P91xXO%2Fimage.png?alt=media&amp;token=8a7a4983-618f-4667-92b7-31d0ba9567f8" alt=""><figcaption></figcaption></figure>

**Step 4:** Click on the Sales History quantity value to open the Sales History sub form for detailed transaction records.

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2FGuwnmPryy64il7UoFwAs%2Fimage.png?alt=media&amp;token=5068ca46-a9f4-4477-bb87-bda2a7af11db" alt=""><figcaption></figcaption></figure>

**Step 5:** Use the customer filter, review historical transactions, or print the records as needed.

<figure><img src="https://3188343778-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkf8DNCjEfcSm64PCPcmf%2Fuploads%2FFlXDqVRfCdxcPNfSdf6o%2Fimage.png?alt=media&amp;token=c96f1603-ed51-4919-a778-11ec0ab13d02" alt=""><figcaption></figcaption></figure>

***

### **Operational Notes and Best Practices:**

* Use the Sales History Qty Sold column to compare historical demand against:
  * On Hand quantity
  * Available quantity
  * Incoming purchase orders
  * Short quantities
* When planning replenishment, review both current stock levels and historical sales data to make balanced purchasing decisions.
* Use the customer filter within the Sales History sub form to analyse purchasing behavior of specific customers when required.

***

### **Conclusion:**

The **Show Sales History Data in Inventory Snapshot and Short Inventory Planner** feature enhances inventory planning by embedding historical demand visibility directly into operational modules.

By making past sales quantities easily accessible within planning screens, this feature empowers businesses to make more accurate reordering decisions, reduce inventory risk, and improve overall supply chain efficiency. When enabled, it provides faster insights without requiring users to navigate across multiple modules, ensuring more confident and data-driven inventory management.


---

# 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/configuration/application/app-config/inventory/show-sales-history-data-in-inventory-snapshot-and-short-inventory-planner.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.