Inventory Reports (1)

Inventory Reports enable the user to view information about items and their inventory status, valuation and so on. Since there are quite a lot of inventory reports, the entire topic will be split into two blogs. The first set of inventory reports that we are going to discuss about are: -

 

·       Items List: - This report helps the user to view a list of items, generated as per the defined selection criteria. Some of the fields that appear in this report are, In-stock, Barcode, Inventory UoM, and Last Purchase Price.

·       Last Prices Report: - This report displays the last purchasing and sales price of an item, either for a specific business partner or for all business partners.

·       Inactive Items: - This report is used find out the list of items that have not been used in a transaction since a specified date. The selection criteria for this report includes item no., date range, item group, and item properties.

·       Inventory Posting List: - This report makes the overview of all the posting made in the system accessible to the user, based on various selection criteria and sort option. The selection criteria for a specified warehouse is as follows: - Item, Business Partners, and other (enables you to specify a selection criterion such as warehouse or sales employee).

·       Inventory Status Report: - This report is used to assess the planned inventory transaction for a specific item with respect it the defined selection criteria. The report shows available, ordered, committed, and in-stock quantities and their related open marketing documents.

·       Inventory in Warehouse Report: - This report lists the current inventories by warehouses based on the information provided by the user in documents like Sales orders or transfer requests. To know the precise inventory level in your warehouse, it is essential to record the correct warehouse in every single document.