Most Powerful Open Source ERP

How To Export Stock Report

How To showing how to export stock report
  • Last Update:2019-02-19
  • Version:004
  • Language:en

Introduction

In ERP5, stock quantities are calculated in real time by summing all incoming movements, for example purchase packing lists and by subtracting all outgoing movements, for example sales packing list, consumptions from production or disposal.

Table of Contents

  • Introduction
  • Stock Management in ERP5
  • Steps
  • Related Articles

    Stock Management in ERP5

    You can check each product's quantities in real time. In ERP5, there are three simulation period for stock: Current, Available, Future. 

    If you go to any product's view in Product Module, click on Stock Tab, you will see the stock of this three simulation period for this product on this day:

    Current stock: by the day, the quantity of the product after all the related movement with state Delivered are considered. 

    Available stock: by the day, the quantity of the product after all the related outgoing movement with Confirmed state are considered.

    Future stock: by the day, the quantity of the product after all the related incoming movement with Confirmed state are considered.

    From the inventory module, you can export a stock report by choosing one of this simulation period. This report gives you a list of all products which are registered to be in stock.

    Steps

    The procedure to export a stock report goes as follows:

    Go into Inventory Module, click on Report icon:

    Fill in the parameters:

    Site: physical stocking point

    Section Category: ownership of the stock

    At Date: stock quantity for a certain date

    Simulation Period: Current or Available or Future

    Format: report format

    Besides, you can pick up the following criterias depends on your preference:

    Don't Display Positive Stock

    Don't Display Negative Stock

    Don't Display Zero Stock

    Detailed Report of Items

    After defining your parameters for the report, click on "Stock Report" to export.