Skip to main content

Stock Report

Stock Report​

note

This report provides a complete overview of stock movement within a given period. It helps the Accounts and Stores teams track opening balances, inward and outward movements, and closing balances both in terms of quantity and value.

1.1 Search for Stock Report​

Step 1: Access the Report Section

  • Navigate to the main left-side menu
  • Go to Accounts → Reports → Stock Report
  • This opens the search filter screen

Step 2: Apply Search Filters

The filters are on a single line at the top of the screen:

  • From Date / To Date: Date pickers to define the reporting period. Both are mandatory. When an opening balance has been uploaded, the screen opens with From Date set to the latest opening balance date and To Date set to today.
  • Product Type: Dropdown to select one or more product types (mandatory)
  • Search Button: Displays stock data based on the applied filters. It is enabled once all three filters are filled.
  • Clear Button: Resets all filters to default values
Date limits

From Date cannot be earlier than the latest opening balance date, and To Date cannot be later than today. A note under the filters shows the opening balance date in use.

Step 3: Generate the Report

  • Click Search to display stock data for the selected period
  • Click Clear to reset all filters

1.2 View Report Results​

After clicking Search, the screen shows summary cards and the results table.

Summary cards

Four cards, Opening, Inward, Outward and Closing, show the total quantity and the tonnage (t) of the rows currently shown in the table. They change when you search or filter the table.

Results table

ColumnDescription
#Serial number of the row
ProductProduct name, with its product type, category and sub category on the line below
Product No / RevProduct number, with the revision on the line below
OpeningStock at the beginning of the period
InwardStock received or produced during the period (shown with +)
OutwardStock dispatched or consumed during the period (shown with −)
ClosingStock at the end of the period (Opening + Inward − Outward)

The last row of the table shows the Total for the rows shown and the number of parts counted.

Table tools (above the table):

  • Search field: Filters the rows by product, product number or revision
  • Qty / Tonnage / Both: Chooses what the Opening, Inward, Outward and Closing columns show: the quantity, the weight in tonnes, or the quantity with the tonnage below it
  • Hide zero rows: Hides the products whose opening, inward, outward and closing are all zero. The button then shows how many rows are hidden; click it again to show them.
  • Clear Filters: Removes the table search, column filters and sorting
  • Each column header can be sorted and filtered

If nothing matches, the table shows No records found for the selected criteria.


1.3 View the Transactions Behind a Figure (Breakdown)​

The Opening, Inward and Outward quantities of each product are links. The breakdown uses the same calculation as the report (see 1.5), so it always adds up to the figure you clicked. Use them to see which transactions make up a figure.

Step 1: Open the breakdown

  • Set the table to Qty or Both (the links are on the quantities)
  • Click the Opening, Inward or Outward quantity of a product
  • A window opens with the title Opening Balance Breakdown, Inward Breakdown or Outward Breakdown, the product type and the report period

Step 2: Read the breakdown

  • Figure cards: The top of the window shows the Opening Balance, Inward, Outward and Closing quantities of the product. The figure you are viewing is highlighted. Click Opening Balance, Inward or Outward to switch to that figure without closing the window
  • Category buttons: Each category (for example Purchase Inward / Return, Sales Invoice, Non Returnable DC, Material Consumption, Production / Internal Transfer) shows its total quantity and number of documents. Point at a category to see the document count. Click a category to list only its documents, or All to list everything. The totals cover all pages.
  • Documents table: Each row is one document (GRN, invoice, DC, etc.) with its net quantity. All the entries of the same document (stage moves, approvals, returns, cancellations and reversals) are added into that one row.
ColumnDescription
#Serial number
DateFirst date of the document. Point at it to see the date range and the number of ledger entries added into the row
CategoryThe category the document is counted under. The dot is green for stock in, red for stock out, purple for net movements and blue for the opening stock
TransactionType of transaction
Reference NoDocument number of the transaction (GRN, invoice, DC, etc.)
Supplier / CustomerThe supplier or customer of the document, when there is one
Stage / StatusEach stage and status the document moved through, one per line. Approved / accepted is green, hold / rework / defect is amber, rejected / scrap / cancelled is red. Up to three are shown; +N more means there are more, and pointing at the cell lists them all
RemarksRemarks entered on the transaction
Created ByUser who made the entry
QuantityNet quantity of the document
  • The table is paged (25, 50 or 100 per page). The footer shows the total for This page when there is more than one page, and the Total (or Category total) with the number of documents.
  • Click Close to return to the report.
How to read the quantities
  • Each row is one document with its net quantity after stage moves, returns, cancellations and reversals. A negative quantity reduces the figure.
  • For Opening Balance, the list starts with the opening stock uploaded on the opening balance date, followed by every stock movement from that date up to the day before the From Date.
  • The breakdown total equals the figure you clicked. If stock moved after you searched, a warning says the breakdown no longer matches the report figure. Click Search on the report again to refresh it.

Messages you may see:

  • No transactions make up this figure. The figure is zero or nothing matches the selected category.
  • Could not load the transactions for this figure. Close the window and try again.

1.4 Export Options​

  • Export Excel: Exports the report into an Excel file. The button appears at the right of the filter line once a search has been made, and is disabled when the table has no rows. For parts, the Sub Category column also shows the part class (Parent, Child or Standalone).

1.5 How Stock Is Calculated​

The report counts only the actual stock coming in and going out. Work in progress (WIP) is not counted. A note under the filters says so when the results are shown.

How parts are counted

Each part is placed in one class, based on the parent–child mapping in the part master. The class is shown under the product name.

ClassWhich partsInwardOutward
ChildParts mapped as a child of another partGRN inwardConsumed in a work order, moved out of a work order, invoice, customer job work DC, non returnable DC
ParentParts that have child parts mapped to them (including sub-assemblies)GRN inward, Final Inspection approvedInvoice, customer job work DC, non returnable DC, its own material sent into production
StandaloneParts with no parent–child mappingGRN inwardInvoice, customer job work DC, non returnable DC

For every class:

  • GRN inward includes Purchase Inward, Miscellaneous Inward, Customer Job Work Inward and Internal Material Inward. Production Inward is not counted.
  • Scrap is counted as outward.
  • Stock adjustments are counted as inward when they add stock and as outward when they reduce it.
  • Returnable DC is still our stock, so it is not counted as outward.
  • Draft invoices are counted, because their stock has already moved.
  • Rejections from production of parent and child parts were never counted as inward, so sending them out on a non returnable DC is not counted as outward.
  • Returns, cancellations and edits reduce the figure they belong to. If a figure turns the other way within the period (for example, a GRN reduced after it was received), it is shown on the other side.

Reading the figures

  • Point at an Inward or Outward quantity to see what it is made of (for example GRN Inward: 100, WO Consumed (CNS): 10).
  • Click the Opening, Inward or Outward quantity to open its breakdown (see 1.3). For a part, the window shows the part's class in its header, and the categories are the movements above (for example GRN Inward, Final Inspection Approved, WO Consumed (CNS), Invoice). The opening breakdown lists only the opening stock that belongs to the part's class (for a child part, the stock in stores and in work orders).
  • The Closing stock of one period is the Opening stock of the next period, so the figures agree for any date range.
  • Product types other than parts (tools, holders, products, instruments) count every stock ledger movement, as before.

Notes​

  • A red warning may appear if exchange rates are unavailable
  • Some parts may be excluded if supplier or product details are missing
  • Ensure correct date range and product type selection for accurate data visibility
  • Exported Excel files retain the same column structure as displayed on-screen
  • To check how a figure was arrived at, click it and review the breakdown (see 1.3)

That’s it! You’ve successfully learned how to Search, View, Break Down, and Export the Stock Report in the DMeX application.For further assistance, please contact the DMeX Support Team.