For the complete documentation index, see llms.txt. This page is also available as Markdown.

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.


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.