Stock Sheet

The Stock Sheet shows every product on one sheet, like a spreadsheet. Use it to fix a misspelled medicine name, a missing salt, the wrong company, a rack or a price where you see it, without opening each product. You can also count the shelf from the same sheet. It works the same on medipos.pk and in the Windows app.

Open the sheet

Go to Inventory → Stock Sheet. Search by name, salt or barcode, tick In stock only to hide products with no stock, and choose how many Rows to show on a page (25, 50, 100 or 200).

Each row shows the medicine, its salt, form, pack (for example Box 100 · Strip 10 · Tablet), company, rack, reorder level, sale price, stock, value and last supplier. The cost value shows under the value, and the cost of one unit when you point at the price. Point at a cell that is cut short to see all of it. Below the sheet you see the totals for the page and for every product that matches the search.

On the web, click Full width to give the sheet the whole screen; click Exit full width to bring the menu back. In the Windows app the menu folds to its icons while the sheet is open.

To open a product's page, point at its row number on the web, or right-click the row in the Windows app.

Edit a cell

1. Click a cell, or move to it with the arrow keys.
2. Start typing, or press Enter (F2 in the Windows app), to edit it.
3. Press Enter to save and go to the cell below, or Tab to save and go right. Esc cancels.

Home and End go to the first and last cell of the row, and Page Up and Page Down move ten rows. From the search, Down or Enter goes into the sheet.

The cell turns green when it is saved and red when MediPOS refused the change. A red cell goes back to what it was, and a message says why, for example The name cannot be empty.

You can edit these cells:

• Medicine: the product name.
• Salt: the generic, for example Paracetamol 500mg.
• Form: tablet, syrup, capsule and so on.
• Company: type the company name. If it is not in the list yet, MediPOS adds it as your own.
• Rack: where it sits, for example A-3.
• Reorder below: in the base unit (tablets, bottles…). See Low stock and reorder.
• Sale price: the price of the unit the medicine is sold by. The other packs priced by rate follow it; a pack whose price you fixed by hand keeps its own.

Every change is recorded in the audit log, and a price change shows as a price change.

Pack sizes, cost and supplier are not edited on the sheet. Cost and supplier come from your purchase bills. Pack sizes change on the product page, and only until the product has stock history (see Units, prices and barcodes).

Count the shelf

1. Go to the Stock column on the web, or the Counted column in the Windows app, and type what is on the shelf, in the base unit.
2. A medicine with several batches opens a box: type each batch. Leave a batch empty to skip it.
3. Counted rows are marked green with a tick. The bar above the sheet says how many products are counted.
4. When you are done, click Post count. Every counted product's stock becomes what you counted, through one stock correction, as in Stock counts.

Nothing changes until you post. Start counting over drops what was counted and leaves the stock as it was. The count also shows under Inventory → Stock counts as Stock Sheet.

The sheet counts the branch's main store. A medicine with no stock there cannot be counted here; stock you find for it goes in as opening stock.

Who can do what

• Viewing the sheet needs View products.
• Editing cells needs Manage products, and changing a price also needs Change product prices.
• Counting needs Run stock counts.
• Cost and cost value show only to staff who can see costs.

See Team and roles.

Questions

I fixed a name. Do old bills change?

No. Bills keep the name they were printed with. New bills, the POS search and reports use the new name.

Can I undo a price change?

Type the old price back. The audit log shows both changes.

Why is the page total a few paisa off the total for all products?

The page total adds each row's rounded value; the total for all products is worked out in one go and rounded once.