Inventory reports

Low stock

The low stock report is used to monitor the amounts of product that are currently in your warehouse. And alert you in case that the number of products comes lower this low stock value. This is a great tool for any warehouse worker. EasyERP reports module allows you to always know the exact quantities of items in your warehouse, so you do not forget to purchase or produce some more. So, let us guide you through the columns that are available in this report:

    • Product  - in this column you will see a name of the product or product variant
    • SKU -  stock keeping unit of the product or the variant
    • Available Stock - the number in this column shows how many products are currently in your warehouses
    • Low Alert level - data in these columns inform you what is the minimum stock level you, or your employee, have set for the current product
    • Atm. low - this value represents how many items you have to sell before you hit the minimum stock level. Basically, this is the result of subtracting of low stock value from available stock
    • Awaiting - a number of products that are currently listed in purchase orders.

Incoming stock

EasyERP reports module also has the incoming stock report that allows you to investigate more closely how many products will be delivered and get some additional data about them. Let us guide you through every column that is present in this report:

  • Product - in this column you see a name of the product that is being purchased
  • Variants - information in this column is the name of variant of product
  • SKU - stock keeping unit of the product or the variant
  • PO - identifying number of the purchase order
  • Stock on hand - the number in this column shows how many products are currently in your warehouses
  • Incoming stock - a number of products that are currently listed in purchase orders
  • Total cost - this value shows the total cost of incoming products.

Product listing

This kind of report gives you more detailed information about what items are listed through your integration channels. And the amount was sold in the selected time period. Using EasyERP reports module you can further analyze what items are selling better on which channel. So the available columns to select from in this report are:

  • Variant - this field will display the name of the item that is being listed
  • SKU - stock keeping unit of the mentioned item
  • Sales channel - what integration channel was used for export or import of the products. In this column, you will see an icon of the marketplace and a name of the integration channel
  • Listing Price - number in this column shows the price that is displayed on the marketplace
  • Unit Sold - number of the items sold through this particular integration channel
  • Date linked -  the date when the item was imported or exported.

Stock details

Stock details report is the kind of report that will be most useful for warehouse workers. This kind of report gives you full information about quantity and location of products. Let’s have a look at all possible columns for stock details report and what data can be displayed in them:

  • SKU - stock keeping unit of the product or the variant
  • Product name - in this column you will see the name of the product
  • Options - here you can see all active options for the current product. Active means that there is currently an item with that option
  • Warehouse - in this column warehouse name, where the item is located, will be displayed
  • Received date - when the item was received in the warehouse
  • PO ref - this is a reference to the purchase order for the current item
  • Aisle, Bay, Shelf, Bin - this is the exact coordinates of the item, so you can easily locate it in your warehouse
  • In Stock - how many items currently are in your warehouse, including those that are currently preparing to be shipped
  • Low Stock - the minimum amount of items, this value is set manually for each product
  • Allocated - amount of items that are currently preparing for shipment or transferring from one warehouse to another
  • On hand - this number shows how many items are available for sale, in other words, this is In stock value subtracted by allocated value
  • Unit cost - data in this column represents the sum that you have paid for the item
  • Total cost - the total value of the item, including unit cost, shipping cost, and bank expenses.