Department Stock Statement

The Department Stock Statement lists every item with its technical name, trade name, manufacturer and packing, and the stock you opened the period with, what came in, what went out and what is left. Print it as the Stock Report to show an inspector or licensing officer what you hold. It is the statement under Department Reports, next to Form X, Appendix B and Form N.

Open the report

Press Alt+5 for Stock Reports, then N for Department Reports, then 5 for Stock St. It opens for the financial year from its first day to today, for all categories, with one line for each item.

Acephate 75 Sp, first in the list, opened with 40, took in 242, sent out 280 and has 2 left.

What it lists

One line for each item that has stock or movement in the period. An item is left out when its opening stock, every movement, any damage and its closing stock are all nil. Tick Zero balances to list it anyway.

The movements are the same ones the Stock Ledger lists:

• purchase bills, sale bills, sales returns and purchase returns, on the date each bill is posted;
• goods received or delivered on a challan (Goods In / Out, 1 P), on the date of the entry;
• damage and breakage entered in 1 V.

The item’s opening stock (3 G) is the starting point; the movements before the From date are added to it to give the period’s opening.

Columns

The line under the grid counts the items and adds up Opening, Inward, Total, Outward and Closing. Columns hides any column except the trade name; the print leaves them out too.

Choices

The usual order is by trade name, then by packing. Click a column title to sort by it, and click again to reverse. Shift+click another title to sort within the first. Every choice is kept in the page address, so Copy link gives a link that opens the same statement.

The choices above the list.

How the figures are worked out

For each item (purchases and sales here include goods received and delivered on a challan):

• Opening = the item’s opening stock + purchases + sales returns − sales − purchase returns − damage, counting only what was posted before the From date.
• Inward = purchases + sales returns, posted from the From date to the To date, both days included.
• Outward = sales + purchase returns + damage, posted from the From date to the To date.
• Total = Opening + Inward.
• Closing = Total − Outward.

For Acephate 75 Sp 500 Gm in the screenshot: 40 + 242 = 282, and 282 − 280 = 2. Inward is 240 purchased plus 2 returned by a customer; Outward is 273 sold, 4 returned to the supplier and 3 damaged.

The line of one item, found with Find.

The totals are the sums of each column over the items listed. The quantities are always in units (packs), as on the bills; the status line says so.

Summary

Summary hides every figure but the closing stock and leaves out the items with nothing left (unless Zero balances is ticked). The total is the sum of the closing stocks, the same as without Summary (1,336).

Summary shows the closing stock only.

Open, mark, print and export

• Enter on an item opens its Stock Ledger for the same period.
• F2 marks an item and F8 marks them all. F10 then prints only the marked items, and the print says Marked items only.
• F10 prints the statement as it is on the screen, as the STOCK REPORT of your company, with the category (* All when none is chosen), the period and your choices under the title: Summary, Items with zero balances included and the Find text.
• F12 saves it as an Excel workbook.
• Type letters in the list to jump to the item whose trade name begins with them.
• Alt+Enter gives the whole window to the list.

The top of the print for the pesticides category.