Inventory Consumption for Invoices and Returns

Report Overview

To begin using this report, you must first activate the “Requisitions for Sales Invoices” feature. This feature allows the inventory movement related to a sales invoice to be reflected in a separate inventory requisition, which can be approved or rejected.

This report displays all movements for invoices that have corresponding inventory requisitions, categorized by product. It allows you to review the invoiced quantities, the quantities actually consumed, and the remaining quantities.

Steps to Display the Inventory Consumption Report for Invoices and Returns

1. Click on “Reports” from the main menu
2. Click on “Store Reports“.
3. From the “Inventory Reports” column, click “View” on the “Inventory Consumption for Invoices and Returns” report.
4. After the report is displayed, you can apply additional filters, including:
   • Products: This field allows you to specify a single product or a group of products to display their movements in the report.
   • Product Code: This field allows you to filter by a single product code to display its specific movements.
   • Client: You can select one or more clients to display their invoices and inventory movements.
     • If no specific client is selected, the system will display the report for all clients.
5. After modifying the filters, click “View Report“.
6. You can print the report by clicking on “Print” or export it to a CSV, EXCEL, or PDF file using the export options.

Displaying Report Data

After displaying the report, a table will be shown containing several columns with the total movements for each product, as follows:

• Product Code: Displays the product code.
• Product Name: Displays the product name listed on the invoice.
• Client Name: Displays the name of the client associated with the invoice.
• Invoices Total: Displays the total quantities of invoices issued for this product to the selected client.
• Requisition Total: Displays the total quantities of inventory permits confirmed for these invoices.
• Difference: Displays the difference between the invoiced quantities and the requisitions quantities.
• Refunded Invoices Total: Displays the total quantities of refunded invoices issued for this product to the selected client.
• Refunded Requisitions Total: Displays the total quantities of inventory requisitions generated by the refunded invoices.
• Difference: Displays the difference between the refunded invoice quantities and their corresponding inventory requisition.
• Total Difference: Displays the total difference between total sales and total refunds.