Multiple Inventory Management Issues

1. Serial Number-Wise Inventory at Godown Level

Currently, serial number-wise inventory maintenance is available only at the main business location and not at the godown level.

Requirement:

• Enable serial number-wise inventory management for all godowns/locations.

• We operate multiple godowns that directly deliver goods to wholesale customers, while the main location serves retail customers.

• It is essential for us to maintain serial number-wise inventory across all locations.

2. Stock Transfer Between Godowns for Serial Number-Wise Inventory

At present, stock transfers between godowns are possible only for inventory that is not maintained serial number-wise.

Requirement:

• Enable stock transfer functionality for serial number-wise inventory.

• The system should allow transferring specific serial numbers from one godown to another while maintaining complete inventory traceability.

3. Product Subcategory Management

While the application currently allows product categorization by brand (e.g., Samsung, LG, Onida), there is no provision for creating subcategories.

Requirement:

• Introduce a subcategory feature.

Example Structure:

• Category: Samsung

  • Subcategory: LED

    • 32-inch – Model Number

    • 42-inch – Model Number

• Category: Samsung

  • Subcategory: AC

    • Model Number

• Category: Samsung

  • Subcategory: Refrigerator

    • Model Number

This structure is necessary for effective product organization and inventory management.

4. Stock Value Reporting with Category/Subcategory Filters

The current application does not provide sufficient flexibility to view stock values for selected groups of products.

Requirement:

• Enable filtering by Category and Subcategory.

• Allow users to view stock values for only the filtered products.

• Provide the flexibility to select multiple categories and subcategories as required.

5. Custom User Roles and Permissions

Currently, user access is restricted to predefined roles such as:

• Stockist

• Partner

• Salesman

• Delivery Boy

Requirement:

• Introduce a customizable role/permission system.

• Allow administrators to define specific rights based on business requirements.

Practical Challenge: In our case, a stockist performs direct deliveries from the godown but cannot account for sales under the Stockist role. As a workaround, we are forced to assign Partner-level access, which exposes business information that we do not want the user to view.

Every business has its unique and practical challenges and the user access can’t be given on predefined roles for each situation.

A customizable permissions framework would resolve this issue and provide better security and operational control.