Inventory Reports

Inventory Reports

This application generates the reports related to the inventory management transactions.
The reports can be viewed on screen, printed, saved in PDF or sent to Excel.
To generate the reports, perform the following steps:
Go to: Administration (Back Office) → Inventory Management → Inventory Reports
Select the report to be issued by clicking on the report name.
Select the appropriate filters.
Click on the Show button.
When the reports are issued in PDF format and displays , you can drill down into the report.

The reports that can be generated are listed below:
Report
Description (Report/Field)
Inventory Catalog
Displays product information, the fields used to filter the information are:
  1. Price Type: Choose between cost, sale or both.
  2. Show Stocks: Select with, without or all items.
  3. Show Products: Indicate if only the active products or all.
Taking Physical Inventory - Format.
Format used for taking physical inventory, the fields used to filter the information are:
  1. Show Products: indicate whether only active products or all.
Valuation of Existence in Inventory.
It issues the inventory value at the end of the month, the fields used to filter the information are: 
  1. Year and Month: Capture with format yyyy/mm of the period to consult.
  2. Show Stock: Select between with stock or all products.
  3. Highlighted Cost: Enter the amount of the cost to be highlighted.
  4. Group by: Indicate how the products will be grouped: group, subgroup, both or none.
  5. Filter Cost: Select Yes or No to display only the products that exceed the amount entered in the "Highlight Cost" field.
  6. Report Format: Define the way the report is presented:
    1. Normal: Displays the text with rich formatting.
    2. Export: Displays the text without rich formatting.
Slow Moving Items
Generates the information of the items with slow transaction of a period, the fields used to filter the information are:
  1. Date from: indicates the start date dd/mm/yyyy or click on the calendar.
  2. Date to: indicates the end date, dd/mm/yyyy or click on the calendar.
  3. Items Without: Select without transactions, receipts, issues or all.
  4. Show Stocks: Select between with stock or all products.
  5. Show Expirations: Determine if you want to show only the items that have expiration indicated or all.
  6. Highlight Cost: Enter the amount of the cost to be highlighted.
  7. Filter Cost: Select Yes or No to show only the products that exceed the amount entered in the "Highlight Cost" field.
Existence, Maximum, Minimum and Projections.
Displays the maximum, minimum and projected stock of items for a period, the fields used to filter the information are:
  1. Date from: Indicates the start date, dd/mm/yyyy. Or click on the calendar.
  2. Date to: Indicates the end date dd/mm/yyyy. Or click on the calendar.
Incoming, Outgoing, Adjustments and Returns - Units.
It issues the information of incoming, outgoing, adjustments and returns in units of the open period, you select how the report will be issued, PDF or Excel.
Accumulated Incoming and Outgoing - Cost
It issues the information of incoming, outgoing, adjustments and returns in cost of the open period, you select how the PDF or Excel report will be issued.
Accumulated Incoming and Outgoing - Units and Cost
It issues the information of accumulated incoming and outgoing in units and in cost for the open period, you select how the PDF or Excel report will be issued.
Accumulated Incoming and Outgoing - Cost
It issues the information of accumulated incoming and outgoing in cost for the open period. Select how the report will be issued, PDF or Excel.
Adjustments to Products
Displays the adjustments to the products of the open period. Select how the PDF or Excel report will be issued.
Printing of the Kardex
Displays the transactions (incoming, outgoing, adjustments, etc.) of an item or group of items in a given period, the fields used to filter the information are:
  1. Date from: indicates the start date dd/mm/yyyy. Or click on the calendar.
  2. Date to: indicates the end date, dd/mm/yyyy. Or click on the calendar.
  3. Inventory Type: Select the type of inventory to be consulted.
  4. Group: Select a group of products or all.
  5. Subgroup: Define a subgroup or all.
  6. Group by: Indicate how the products will be grouped: group, subgroup, both or none.
  7. Product Name: Enter the name of the product for which the kardex will be issued or leave blank to select all.

** When generating the report to Excel it is generated under the .xls option.  If you require the file size to be smaller, you should use the "Binary Excel Worksheet" format, which allows you to keep the characteristics of the Excel file, with approximately 10% of the size that is generated under the .xls option.

Once generated, proceed to "Save As" by choosing the .xlsb option as indicated in the image below.





    • Related Articles

    • Inventory Management

      Inventory A set of tangible goods held for internal use in the production process, such as raw materials, products in process, packaging materials, etc., or spare parts for maintenance that are consumed in the operating cycle or those intended for ...
    • Inventory Catalog

      In this application the general information that identifies the products is registered, modified, deactivated, and searched. Go to: Administration (Back Office) → Inventory Control → Inventory Catalog. The initial screen shows the following sections: ...
    • Warehouse Incoming Reports

      In this application, reports are generated for Inventory Incoming operations. The reports can be viewed on screen, printed, saved in PDF or sent to Excel. Warehouse Incoming - Register Format Displays the incoming in the register format for that day, ...
    • Warehouse Outgoing Reports

      This application generates the reports related to inventory outgoing operations. The reports can be viewed on screen, printed, saved in PDF or sent to Excel. Warehouse Outgoing - Register Format Displays the outgoing in register format of the day, to ...
    • Bank Reports

      This application allows you to generate reports of the transactions of bank accounts used by the company. The reports can be viewed on screen, printed, saved in PDF or Excel. When PDF reports are issued, you can drill down into the report by showing ...