> For the complete documentation index, see [llms.txt](https://kb.logicerp.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kb.logicerp.com/logic-erp-learning-hub-tutorials-and-best-practices/reports-queries/customer-+-item-sale-analysis/abc-sale-analysis-stock-norm-and-production-plan/abc-sale-analysis-stock-norm-and-production-plan-configuration.md).

# ABC Sale Analysis, Stock Norm & Production Plan - Configuration

The configuration of the **ABC Sale Analysis, Stock Norm & Production Plan** report holds your stocking policy: how far back to look at sales, what counts as a sale, how products are split into categories and how many days of stock each category gets, which stock counts as available, and how the production quantity is rounded. You can keep several configurations and pick one when you run the report. Every setting has a short explanation shown below the list when you select it. For how the report uses these settings, see the [User Guide](https://kb.logicerp.com/logic-erp-learning-hub-tutorials-and-best-practices/reports-queries/customer-+-item-sale-analysis/abc-sale-analysis-stock-norm-and-production-plan/abc-sale-analysis-stock-norm-and-production-plan-user-guide.md).

***

### **Step 1: Open the configuration**

* Navigate to **Reports/Queries\Customer + Item Sale Analysis** and click on "ABC Sale Analysis, Stock Norm & Production Plan".
* Click **Configuration**. The **ABC Wise Stock Norm & Production Plan** window opens.
* Pick a configuration from the list to change it, or type a new name to start one. Names are saved in capital letters.

**Type the name of a new configuration first, then move out of the name box.** The window then fills in the starting policy — categories A, B and C at 10, 20 and 30 days, three months of sales, returns netted off, inter-branch transfers excluded — and anything changed before that is replaced.

***

### **Step 2: Report Consolidation**

| Setting      | What it does                                                                                                                                                                                                  |
| ------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Category** | Starts a fresh break at each change of category in the **printed** report. It does not change the screen or the Excel export, and adds no subtotal — use **Category Total** under **Report Totals** for that. |

***

### **Step 3: Item Consolidation — what one row stands for**

Tick at least one; each ticked item shows its column and becomes part of the row. A new configuration starts with **Item Name** ticked — one row per product.

| Setting                 | What it does                                                  |
| ----------------------- | ------------------------------------------------------------- |
| **Pack / Size**         | Each size is ranked and produced separately                   |
| **Item Name**           | One row per item — the normal choice                          |
| **Item Name W/o Shade** | All shades of a product on one row, planned together          |
| **Company**             | Rolls the report up to the company                            |
| **Group**               | Rolls the report up to the item group                         |
| **Shade**               | Adds the shade to the row — only useful where shades are kept |

Two things to know:

* The categories are shares of the **rows**, so ticking more items here changes the A / B / C split.
* At **Company** or **Group** level, a company or group that sold anything brings in **all** its stock, so **HO Stock** is much larger than at item level. That is correct for the level, not an error.

***

### **Step 4: Item Totals**

**Pack / Size**, **Item Name**, **Item Name W/o Shade**, **Company**, **Group** and **Shade** — each sets a break at every change of that level in the **printed** report. The rows are in rank order, so a break groups cleanly only for a level that is also ticked under **Item Consolidation**.

***

### **Step 5: Report Options**

| Setting                              | What it does                                                                                                                                                                                                               |
| ------------------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Classification Scope**             | **Whole Company** (default) ranks every product together. **Within Item Group** ranks each item group separately, so each group gets its own A, B and C.                                                                   |
| **Item Group Level For Scope**       | Which item group level to rank within, when **Classification Scope** is **Within Item Group**. Pick a level that divides the range usefully.                                                                               |
| **Include Zero Sale Items**          | Adds products with no sale in the period, as the last category with nothing to produce. Tick it to make **HO Stock** agree with a stock report; untick it to plan production, because it also changes the A / B / C split. |
| **Suppress Zero Production Rows**    | Hides rows that need no production, turning the report into a work list.                                                                                                                                                   |
| **Show Surplus As Negative**         | Shows stock above the buffer as a negative production figure instead of zero.                                                                                                                                              |
| **Show Avg Daily Sale Column**       | Shows **AVG DAILY QTY**. Ticked in a new configuration.                                                                                                                                                                    |
| **Show Required Buffer Qty Column**  | Shows **REQD BUFFER QTY** — average daily quantity × buffer days, the figure stock is taken off. Ticked in a new configuration.                                                                                            |
| **Qty Decimals**, **Value Decimals** | Decimal places for quantity and value columns, 0 to 8 — 2 in a new configuration. Display only: it does not change how the production figure is rounded.                                                                   |

***

### **Step 6: Sales Period**

| Setting                                | What it does                                                                                                                                                                                                                                                           |
| -------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Sale Period Basis**                  | **Last N Months** (default), **Last N Days**, **Last N Complete Months** (whole months up to the end of the previous month, so a half-finished month does not lower the daily average), or **Report Date Range** (the **From** and **To** dates on the report screen). |
| **Sale Period Months**                 | Months of sales for **Last N Months** and **Last N Complete Months**, from 1 to 8 — 3 in a new configuration.                                                                                                                                                          |
| **Sale Period Days**                   | Days of sales for **Last N Days** — 90 in a new configuration.                                                                                                                                                                                                         |
| **Period End Basis**                   | The date the period ends at: **Report Date** (default, the report's **To** date), **System Date** (today — suits a configuration run unattended), or **Last Complete Month End**. Not used with **Report Date Range**.                                                 |
| **Days Divisor Basis**                 | What the period's sale quantity is divided by to get the average daily quantity: **Actual Days In Window** (default), **Fixed Days**, or **Selling Days Only** (only the dates that had a sale).                                                                       |
| **Fixed Days Divisor**                 | The number of days used with **Fixed Days** — 90 in a new configuration.                                                                                                                                                                                               |
| **Ignore Period Before Item Creation** | Divides a newly created product by the days it has existed, rather than the whole period.                                                                                                                                                                              |

***

### **Step 7: Sale Value Definition**

| Setting                            | What it does                                                                                                                                                                                                                                                                                                                                    |
| ---------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Sale Value Basis**               | The value used for ranking: **Net Amount** (default), **Gross Amount**, or **UD Net Amount**, built from the parts ticked under **UD Net Amount** below. **UD Net Amount** takes longer to run.                                                                                                                                                 |
| **Rank Products On**               | **Sale Value** (default) or **Sale Qty**. The buffer is always worked out in quantity, whichever you choose.                                                                                                                                                                                                                                    |
| **Net Off Sale Returns**           | Ticked (new configuration): returns are subtracted from sale quantity and value. Unticked: returns are left out altogether. A return in the period against an invoice from before it can leave a product with a positive quantity and a negative value.                                                                                         |
| **Include Free / Repl / Sample**   | Counts free, replacement and sample quantities as demand. They raise the quantity, not the value.                                                                                                                                                                                                                                               |
| **Exclude Inter Branch Transfers** | Stops an issue from head office to a branch being counted as demand alongside the branch's own sale. Ticked in a new configuration.                                                                                                                                                                                                             |
| **Include Challan Not Invoiced**   | Adds sale challans that were set not to update stock.                                                                                                                                                                                                                                                                                           |
| **Sale Branch Scope**              | Whose sales drive demand: **All Branches** (default), **Head Office Branches Only**, or **Selected Branches**. Branches picked on the report screen narrow the sales only with **All Branches**. With **Head Office Branches Only** and no head office branches selected, all branches are used. The same scope applies to pending sale orders. |
| **Select Sale Branches**           | Opens the branch selection, for **Selected Branches**.                                                                                                                                                                                                                                                                                          |
| **UD Net Amount**                  | Opens the **Net Amount** window, where you tick the parts that make up the value — gross value, discounts, taxes, freight and so on. Nothing is ticked in a new configuration; tick every part to get the bill's net amount. With nothing ticked, the report uses **Net Amount**. Used only when **Sale Value Basis** is **UD Net Amount**.     |

***

### **Step 8: ABC Classification**

| Setting                   | What it does                                                                                                                                                                                                                                                                                                                                                                                                     |
| ------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **ABC Bands**             | Opens the **ABC Bands** window — one row per category, with **Upto %**, **Category** and **Buffer Days**. A new configuration starts with A up to 10 at 10 days, B up to 50 at 20 days, and C up to 100 at 30 days. Add rows for D, E and so on; press Delete to remove a row. On **OK** the rows are sorted by **Upto %**, and the **last category always takes everything that is left**, whatever its figure. |
| **Classification Method** | What the **Upto %** figures mean: **Percent Of Item Count** (default — a share of the ranked list), **Cumulative Value Share** (a share of sales value; the product that crosses the line stays in the band), or **Fixed Item Count** (a number of products).                                                                                                                                                    |
| **Band Boundary Basis**   | **Cumulative** (default): the figures are running totals — 10, 50, 100. **Incremental**: they are band sizes — 10, 40, 50.                                                                                                                                                                                                                                                                                       |
| **Round Boundary Up**     | With **Percent Of Item Count**, rounds a part-product cut-off up — 10% of 1234 products gives 124, not 123. Ticked in a new configuration.                                                                                                                                                                                                                                                                       |
| **Tie Break On**          | **Item Code** (default), **Item Name** or **Higher Qty** — keeps two products with the same figure in the same order on every run.                                                                                                                                                                                                                                                                               |
| **Show Only Category**    | **All Categories** (default), or one category, so you can print just the A items. The list shows every category, but a configuration with a category after the eighth chosen here cannot be saved.                                                                                                                                                                                                               |

The window shows "Invalid value" for a row whose **Upto %** is blank or zero, and "Duplicate value" when two rows have the same one. Category names cannot contain # or \~.

***

### **Step 9: Head Office Stock — which stock counts**

| Setting                             | What it does                                                                                                                                                                                                                                            |
| ----------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Select HO Branches**              | Opens the branch selection for your head office branches — usually the warehouses that feed production. **With none selected, stock and work in progress from every branch are counted.** Branches picked on the report screen do not narrow the stock. |
| **Stock Source Basis**              | **Current Stock** (default): today's stock, whatever the report date, with the deductions below. **Stock As On Date**: the total on hand at a date, without the deductions.                                                                             |
| **Stock As On Basis**               | The date for **Stock As On Date**: **Report Date** (default), **Sale Period End** or **System Date**.                                                                                                                                                   |
| **Include Master Free Stock**       | The main stock figure. Ticked in a new configuration.                                                                                                                                                                                                   |
| **Include Bin Stock**               | Bin stock, added to the master stock. Ticked in a new configuration. Keep at least one of the two ticked.                                                                                                                                               |
| **Filter On Godowns**               | Opens the godown selection, to count only chosen godowns. It narrows the **sales** counted as well as the stock.                                                                                                                                        |
| **Less Reserved Stock**             | Takes off stock reserved against orders, so the buffer is measured on free stock.                                                                                                                                                                       |
| **Less Stock Allocated Against SO** | Takes off the **same** reserved figure as **Less Reserved Stock**. **Tick only one of the two**, or it is taken off twice.                                                                                                                              |
| **Less Pending DO Qty**             | Takes off stock committed to delivery orders not yet despatched.                                                                                                                                                                                        |
| **Show Stock Value Column**         | Adds **STOCK VALUE**, priced at the product's average selling rate in the period (sale value ÷ sale quantity). A product with no sale has no value.                                                                                                     |

With **Stock As On Date**, the configuration cannot be saved while **Include Bin Stock** or any **Less…** option is ticked. **Include Bin Stock** is ticked in a new configuration, so untick it first.

***

### **Step 10: Production Requirement**

The production figure is the required buffer, plus pending sale orders if ticked, less **HO Stock**, less work in progress if ticked. It is then rounded, the minimum is applied, and a surplus is shown as zero or as a negative.

| Setting                          | What it does                                                                                                                                                                                     |
| -------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| **Less WIP Qty**                 | Takes off production entered but not yet through its last process, and shows **WIP QTY**. Leaving it off overstates what needs making.                                                           |
| **Add Pending SO Qty**           | Adds undelivered sale orders on top of the buffer, and shows **PENDING SO QTY**.                                                                                                                 |
| **Floor Production At Zero**     | Shows zero instead of a negative when stock is above the buffer. Ticked in a new configuration. A negative still appears when **Show Surplus As Negative** is ticked, or when both are unticked. |
| **Round Production To**          | **None** (default), **Whole Number**, or **Multiple Of** the **Rounding Multiple**, for goods made in fixed batches. Rounding is always up.                                                      |
| **Rounding Multiple**            | The batch size used with **Multiple Of**.                                                                                                                                                        |
| **Minimum Production Qty**       | Requirements below this, after rounding, are shown as zero.                                                                                                                                      |
| **Show Production Value Column** | Adds **PRODUCTION VALUE**, priced the same way as **STOCK VALUE**.                                                                                                                               |

***

### **Step 11: Item Filters**

| Setting                        | What it does                                                                                                                              |
| ------------------------------ | ----------------------------------------------------------------------------------------------------------------------------------------- |
| **Exclude Discontinued Items** | Leaves out products marked inactive — otherwise a discontinued product that sold earlier in the period is given a production requirement. |
| **Exclude Non Stock Items**    | Leaves out products not kept in stock — otherwise their whole buffer shows as production to be done.                                      |

***

### **Step 12: Report Totals**

| Setting            | What it does                                                                                                            |
| ------------------ | ----------------------------------------------------------------------------------------------------------------------- |
| **Category Total** | A subtotal at the end of each category — how much production each category accounts for. Ticked in a new configuration. |
| **Grand Total**    | A total for the whole report. Ticked in a new configuration.                                                            |

***

### **Step 13: Extra Group Options**

* **Extra Item Groups** — adds your own item group levels as extra columns. Each level chosen also becomes part of the row, so it changes the row count and the A / B / C split.

***

### **Step 14: Save**

* Click **Save** and answer **Yes**. The window closes, and the configuration is used the next time the report is run with it.
* The window checks the settings before saving and explains anything missing — for example "Select at least one Item Consolidation option - it defines the report grain." or "Sale Branch Scope is Selected Branches - select the sale branches."
* You need rights to modify configurations. On the web the configuration can be viewed but not saved.


---

# 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://kb.logicerp.com/logic-erp-learning-hub-tutorials-and-best-practices/reports-queries/customer-+-item-sale-analysis/abc-sale-analysis-stock-norm-and-production-plan/abc-sale-analysis-stock-norm-and-production-plan-configuration.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.
