Wholesale / Retail Stock Movement

A fertilizer dealer who holds both a wholesale and a retail licence keeps two stocks of the same product: the wholesale stock that is sold to other dealers and the retail stock that is sold over the counter to farmers. This report follows one of those two stocks, called a pool, for each item over a period: what it opened with, what came in, what moved between the pools, what went out and what is left.

Open the report

Press Alt+5 for Stock Reports, then Z for More Stock Reports and B. The report opens for the financial year from its first day to today, for the Whole sale pool, all categories, in units. Choose the fertilizer category in Category to list only fertilizers, as in the screenshots.

Dap 18-46-0 opened with 40 wholesale bags, 800 came in on purchase bills, 356 went out on sales and 290 were transferred to the retail pool, which leaves 194.

What it lists

One line for each item that had inward stock, outward stock or a transfer in the pool during the period. An item that only holds stock, with none of these in the period, is left out even though it has an opening and a closing stock. Items come in name order, or in register page order with the Order choice.

The report reads stock by pool. A stock entry counts in a pool in one of two ways:

• the pool given to it in Stock Transfer / Godowns (3 J), where each stock entry of an item (the opening stock, a bill line, goods in or out) can be given to the wholesale or the retail pool, part by part;
• or, for the rest of a bill line, the sale type of its bill book (the W/R choice of the book in 8 C).

Stock that has no pool counts in neither pool, so it appears in neither pool of this report. When some entries have no pool, the help of the report (the ? beside its title) says how many.

What each column reads:

• Inward: purchases and sales returns in the pool, and goods received (1 P).
• Outward: sales and purchase returns in the pool, and goods delivered (1 P).
• Transfer in and Transfer out: transfers (3 J Transfers) that give the pool its stock or take stock from it. A transfer between two godowns within the same pool counts in both columns of that pool, so its Closing does not change.

A bill counts on the day it is posted: a sale or a purchase return on the bill date, a purchase or a sales return on the date in its Recd. field. Goods received or delivered count on their own date. A bill made from goods already received or delivered counts only the units those goods did not cover. A transfer between godowns with no pool given is left out; the help of the report says how many there are.

Damage and breakage entered in 1 V are not read by this report.

Columns

The line under the grid counts the items and adds up each column. The status line says how many items are listed and the unit of the quantities.

Choices

Click a column title to sort by it, and click again to reverse. Every choice is kept in the page address, so Copy link gives a link that opens the same report.

The choices above the grid.

How the figures are worked out

For each item, in the chosen pool:

• Opening = the opening stock given to the pool + everything that came in, went out or was transferred in or out of the pool before the From date.
• Inward, Outward, Transfer in, Transfer out = the same movements dated from the From date to the To date, both days included.
• Total available = Opening + Inward + Transfer in.
• Closing = Total available − Outward − Transfer out.

In units, each of Opening, Inward, Outward, Transfer in and Transfer out is rounded to a whole unit before Total available and Closing are made.

For Dap 18-46-0 in the whole sale pool: 40 + 800 + 0 = 840 available, and 840 − 356 − 290 = 194 left. The retail pool gets the 290 as Transfer in:

The same items in the retail pool. Dap 18-46-0 opened with 20 bags, received 290 by transfer, 300 went out on sales and 10 are left. The 194 in whole sale and the 10 here are the 204 bags the item has in all.

Because a transfer only moves stock from one pool to the other, the closing stocks of the two pools add up to the stock the item has, as long as all its stock has been given to a pool and apart from damage and breakage.

Tonnes

With Qty in set to Tonnes, every figure is the units multiplied by the item’s pack size in kilograms or litres and divided by 1,000, rounded to three decimals. A 50 Kg bag counts as 0.05 tonne.

Dap’s 290 bags transferred in are 14.5 tonnes, and its 10 bags left are 0.5 tonne.

A later period

When From is later in the year, what happened before it becomes the opening.

From 01-09-2026, Dap’s wholesale opening is 191, the stock it had on 31-08-2026. The closing stock, 194, is the same as for the whole year.

Open, print and export

• Enter on an item opens its Stock Ledger for the same period. The ledger shows both pools.
• Items cannot be marked.
• F10 prints the report as it is on the screen, headed STOCK DAILY MOVEMENT STATEMENT, with the category and, for a category whose name starts with Fert, the fertilizer licence numbers from Company Details, then the period, the pool and the unit. A line Order : Page or Find : is added when you chose them. The print adds the page number beside the serial number.
• F12 saves it as an Excel workbook.
• Alt+Enter gives the whole window to the list.

The print of the whole sale pool from 01-09-2026, with the register page beside each serial number.