On this page
6.13Stock and Sale Statement for a Company
Stockists and distributors send each company a statement: opening, purchase, sale and closing of its items. The Stock Report makes it with a few clicks.
- Press Ctrl+U. Keep From Date on the first day of the financial year and set To Date to the last day of the month.
- Click Search. Keep Stock Report as Per on Item Name. In Search By choose ItemCompanyName and type the company in Search For What.
- Keep Qty + Free ticked so free goods are counted. Tick Only Show Items Sold in this Period if the company wants only the items that moved.
- Click Search. Read Op.Qty, Pr.Qty, Sale Qty and Cl.Bal., then click Excel and send the file.
With the year's first day as From Date, the purchase and sale columns show the year so far, and the closing stock is right. If the company asks for one month's sale alone, run the report to the end of this month and to the end of last month, and take the difference in Sale Qty.
A ready statement: Stock & Sales Analysis
Stock Reports → Stock & Sales Analysis (just below Stock Report) makes the same statement in one screen, with the company or supplier name and the period in the heading, ready to print or send.
- Set From date and To date.
- Choose the manufacturer in Item company (manufacturer), or the party in Supplier (party we bought from). Leave the other box on All.
- Tick Include zero-stock, no-movement items only if the company wants every item, even those that did not move. Press Show report (Enter).
- Each item shows Opening Qty, Opening Value, Purchase Qty, Purchase Value, Sale Qty, Sale Value, Closing Qty and Closing Value, with a TOTAL row.
- Print (Ctrl+P), PDF or Excel (Ctrl+E). The file name carries the company and the dates.
Read every step in the guide: Stock Management, section 6.13
Questions and answers
The company wants a monthly stock and sale statement. How?
Stock Report from the year's first day to the month end, Search By ItemCompanyName with the company's name, then Excel (6.13).
Is there a printable stock and sale statement for one supplier?
Yes. Stock Reports → Stock & Sales Analysis → choose the Supplier (or the Item company) and the dates → Show report → Print, PDF or Excel (6.13).
How do I give a company's representative his near-expiry list?
Stock Reports → Expiry Register → 90 Days → Search → type the company name → Search → Print (6.12).
A company recalled one batch. How do I find who bought it?
Stock Reports → Sub Item Wise Stock → Item Name → batch number (or its barcode) in Sub Item → dates → OK. Every customer of that batch is listed; double-click to open the bill (6.3).