Packing Wise Stock

Packing Wise Stock answers “how many packs of each size do I hold?” It lists the closing stock of every item on a date, under its packing, or under its manufacturer or technical name, with the packings they carry. Use it to count shelves by pack size, to check one company’s stock, or to see all the stock of one active ingredient.

Open the report

Press Alt+5 for Stock Reports, then I. The report opens as on today, in Alphabetical order: a heading for each packing, with its products under it.

Each packing is a heading with the number of products and the units in stock. The totals line is under the grid.

What it lists

One line for each item that has stock above zero on the date, with its packing. A product sold in several packings has one line for each packing, because each pack size is its own item.

• Items with no stock, or with negative stock, are left out.
• The stock includes the date itself: bills and other movements dated the As on date are counted.
• The quantities are in units, which is packs, as the items are counted in your books.

Columns

The status line gives the number of items, the number of groups and the unit of the quantities.

Choices

Changing the Order clears the Manufacturer and Technical choices and any sort. Click a column title to sort by it, and click again to reverse; the lines are sorted within their group. 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

Cl. stock is the stock on the date, worked out for each item as in the Stock Statement: the item’s opening stock, plus the units bought and the units customers returned, minus the units sold, the units returned to suppliers and the units written off as damage, all dated up to and including the As on date. Goods received on a challan count from the date of the entry; when the bill follows, only the quantity not already received is added.

• A heading adds up the Cl. stock of its items, and the totals line adds up every item listed.
• Packings are in plain character order, not number order: 1 KG, 1 LTR, 10 GM, 100 GM, 25 KG. In Alphabetical order, the items under a packing are in name order. A company’s or technical name’s items are in packing order, then name order.
• An item without a packing is listed under (No packing), one without a manufacturer under (No manufacturer), and one without a technical name under * UNDEFINED GROUP. Headings are in character order, capitals and small letters alike, and the heading for items without a value comes first, so * UNDEFINED GROUP is at the top.
• Click Cl. stock first to put the headings in order of their totals too.

28 items with stock, in 14 packings.

Company wise

Choose Order Company wise for a heading for each manufacturer. The Packing column shows each product’s pack size.

Deccan Agrotech’s four items add up to 77 units: 14 + 14 + 7 + 42.

Technical wise

Choose Order Technical wise for a heading for each technical name, such as ACEPHATE 75% SP. Items with no technical name are together under * UNDEFINED GROUP.

The items with no technical name come first, then each technical name.

Open, mark, print and export

• Enter on an item opens its Stock Ledger, from the first day of the financial year to the As on date.
• Type the first letters of a name to jump to it.
• F2 marks an item and F8 marks them all. F10 then prints only the marked items.
• F10 prints the report, titled PACK WISE STOCK STATEMENT, with the As on date (as “As On : 18-10-2026”) and your choices in its heading. Group headings print in capitals.
• F12 saves it as an Excel workbook.
• Alt+Enter gives the whole window to the list.