Stock reports: balance, movements and ageing

OLY ERP has standard stock reports. They read from every submitted stock document, so they are always up to date. Use them to answer questions like "how much corn grits do we have?" or "why did the finished goods drop yesterday?"

Before you start

• You need the Stock User role, or another role your admin has given report access to.
• Only submitted documents appear in reports. Drafts do not count.

Steps

Open and filter a report

1. Go to Stock in the sidebar. Scroll down to the Reports section, or type the report name in the search bar.
2. Set the filters at the top: Company, From Date, To Date, Warehouse, Item or Item Group.
3. The report refreshes when you change a filter.
4. To export, click the menu (three dots) and choose Export. Choose Excel or CSV.
5. To print or save as PDF, use Print from the same menu.

Which report to use

Example: check corn grits

1. Abebe opens Stock Balance, sets Item to "RM-CORN-GRITS" and the dates to this month.
2. He sees 1,230 Kg in "Raw Materials - EF".
3. To see why it is lower than last week, he opens Stock Ledger with the same item and dates. Each line links to the source document. Click it to open the document.

Good to know

• Quantities are always in the stock unit (Kg, Pack, Roll), not in Bags or Cartons.
• The value in the reports uses the valuation rate. Your accountant uses this to check the stock accounts at month end.
• To share figures with a manager who has no stock access, export the report to Excel and send the file.
• If a number looks wrong, check for a draft document that was never submitted.

Related

• Count stock and fix differences (stock reconciliation)
• Batches and expiry dates
• Print, email and export documents and lists
• Buying reports: what you owe and what you bought