Inventory
Inventory reports provide insights into the stock levels, adjustments, and packing history of your products. Use these reports to monitor inventory performance, identify discrepancies, and make informed decisions about stock management. This section consists of seven reports:
- Inventory Summary
- Stock Summary
- Non-Compliant Items
- Assembly Details
- Inventory Adjustment Summary
- Inventory Adjustment Details
- Packing History
Inventory Summary
This report gives you an overview of the total inventory available in your store. It helps you monitor stock levels, identify categories that need attention, and understand how your inventory is distributed across items.
Here’s how you can view this report:
- Click Reports on the left sidebar.
- Select Inventory Summary under Inventory.
| Fields | Description |
|---|---|
| Item Name | Name of the item. |
| SKU | Stock Keeping Unit of the item. |
| Reorder Level | Minimum stock reorder level defined for the item. |
| Quantity Ordered | Total quantity of the item that has been ordered. |
| Quantity In | Quantity of the item received or added to inventory. |
| Quantity Out | Quantity of the item sold or removed from inventory. |
| Stock on Hand | The current quantity available in stock. |
| Committed Stock | Quantity reserved or allocated for pending orders. |
| Available for Sale | Net quantity available for customer purchase after accounting for committed stock. |
| Usage Unit | The unit of measurement for the item (e.g., pieces, units, kg). |
Stock Summary
This report gives you a quick summary of the current stock position of your items. It helps you understand which items are available, which are running low, and what needs to be replenished.
Here’s how you can view this report:
- Click Reports on the left sidebar.
- Select Stock Summary under Inventory.
| Fields | Description |
|---|---|
| Item Name | Name of the product or item. |
| SKU | Unique SKU of the item. |
| Opening Stock | Stock quantity at the beginning of the selected period. |
| Quantity In | Total quantity received or added to inventory during the period. |
| Quantity Out | Total quantity sold or removed from inventory during the period. |
| Closing Stock | Stock quantity at the end of the selected period. |
Non-Compliant Items
This report lists items that do not comply with the ONDC protocol requirements and cannot be listed on buyer applications. Use it to identify items that need corrections to be available for sale on buyer platforms.
Note: It can take up to 24 hours for items to be available on a buyer application after updates. The duration can vary depending on the buyer applications.
Here’s how you can view this report:
- Click Reports on the left sidebar.
- Select Non-Compliant Items under Inventory.
| Fields | Description |
|---|---|
| Item Name | Name of the item that is non-compliant. |
| Buyer App | The buyer application where the item failed compliance. |
| Rejection Reason | The specific reason why the item does not comply with ONDC protocol requirements. |
| Description | Additional details about the non-compliance issue. |
| Last Sync Time | Date and time of the last synchronization attempt with the buyer application. |
| Outlet Item ID | Unique identifier for the item at the outlet level. |
| BAP ID | Buyer App Provider ID linking to the buyer application. |
| Provider ID | Unique identifier for your store as a provider. |
| Organization ID | Organization identifier in the ONDC network. |
| Item Status | Current status of the item (e.g., active, inactive, or pending). |
| Provider Name | Name of your store or organization. |
| Item Quantity | Current inventory quantity of the item. |
Group By Options
You can organize the Non-Compliant Items report by grouping the data using any of the following columns:
- Item Name - Group items by their names to see all non-compliant items together.
- Buyer App - Group by buyer application to view non-compliance issues organized by which platform has the issue.
- Outlet Item ID - Group by outlet item identifier to organize items by their unique identifiers at the outlet level.
- Item Quantity - Group by quantity to view items organized by their current inventory levels.
Click Group By on the report to select your preferred grouping option and reorganize the data for easier analysis.
Assembly Details
This report gives you the details of assembled items and their component usage. It helps you track how inventory is consumed while creating bundled or assembled products and monitor assembly transactions.
Here’s how you can view this report:
- Click Reports on the left sidebar.
- Select Assembly Details under Inventory.
| Fields | Description |
|---|---|
| Transaction# | Unique identifier for the assembly transaction. |
| Assembly Name | Name of the assembled item created. |
| Quantity Assembled | Total quantity of the assembled item produced. |
| Component Name | Name of the component used in the assembly. |
| Quantity Consumed | Quantity of the component consumed in the assembly. |
| Date | Date on which the assembly transaction was created. |
| Status | Current status of the assembly (e.g., Assembled, Confirmed, Draft). |
| Total Cost (BCY) | Total cost of the assembly in base currency. |
Inventory Adjustment Summary
This report summarizes the stock adjustments made in your inventory over a selected period. It helps you track changes such as increases, decreases, or corrections in inventory quantities with their financial impact.
Here’s how you can view this report:
- Click Reports on the left sidebar.
- Select Inventory Adjustment Summary under Inventory.
| Fields | Description |
|---|---|
| Reference Number | Unique reference number for the inventory adjustment transaction. |
| Date | Date on which the inventory adjustment was made. |
| Status | Current status of the adjustment (e.g., Draft, Adjusted). |
| Inventory Adjustment | Reason for the inventory adjustment (e.g., Inventory Revaluation, Quantity Adjustment). |
| Adjustment Type | Classification of the adjustment (e.g., Quantity, Value). |
| Quantity Increased | Total quantity that was increased in this adjustment. |
| Quantity Decreased | Total quantity that was decreased in this adjustment. |
| Value Increased | Total value increase from adjustments in the selected period. |
| Value Decreased | Total value decrease from adjustments in the selected period. |
Inventory Adjustment Details
This report provides the detailed log of inventory adjustments. Use it to review the exact changes made to stock levels and the financial impact of each adjustment.
Here’s how you can view this report:
- Click Reports on the left sidebar.
- Select Inventory Adjustment Details under Inventory.
| Fields | Description |
|---|---|
| Reference Number | Unique reference number for the inventory adjustment transaction. |
| Date | Date and time when the adjustment was made. |
| Status | Current status of the adjustment (e.g., Draft, Confirmed). |
| Inventory Adjustment | Reason for the adjustment (e.g., Inventory Revaluation, Quantity Adjustment). |
| Adjustment Type | Classification of the adjustment (e.g., Quantity, Value). |
| Product Name | Name of the product or item that was adjusted. |
| Quantity Adjusted | Total quantity that was adjusted for the item. |
| Value Adjusted | Total value change from the adjustment in base currency. |
Packing History
This report tracks the packing activity for your orders. It helps you review which orders were packed, their tracking details, and the current status of shipments.
Here’s how you can view this report:
- Click Reports on the left sidebar.
- Select Packing History under Inventory.
| Fields | Description |
|---|---|
| Package# | Unique package number for the shipment. |
| Date | Date when the order was packed. |
| Quantity | Total number of units packed in the shipment. |
| Tracking Number | Tracking number associated with the shipment for delivery monitoring. |
| Sales Order# | Unique sales order ID for the packed order. |
| Status | Current status of the package (e.g., Delivered, Shipped, Pending). |
You can use this report to monitor the packing process and quickly identify shipment status and delivery information.