Project

General

Profile

Edit Copy Actions

Feature #5398

open

Implement Vendor-wise Stock Batches for Product Inventory

Added by Yalavarthi Thriveni 2 months ago. Updated 24 days ago.

Status:
New
Priority:
High
Start date:
11/28/2025
Due date:
12/29/2025 (31 days late)
% Done:

88%

Estimated time:
(Total: 18:00 h)
Spent time:
(Total: 6:00 h)

Description

As an Inventory Manager
I want the system to maintain stock in batches based on vendor purchase price and quantity
So that each batch of inventory reflects its own cost, and sales/consumption deduct stock from the correct vendor batch instead of overwriting purchase price globally.

Business Requirements

Each incoming purchase should create a separate Stock Batch with:

Vendor

Purchase Price

Quantity Received

Quantity Remaining

Received Date

Product’s global purchasePrice and qty must not be overwritten when new stock arrives.

Sales/consumption flows must deduct quantity in FIFO order (oldest batch first) or based on future custom rules.

UI should show all batches for a product with vendor, price, and remaining qty.

Sale price should reflect the active batch (optional rule).

API should handle stock receipts, consumption, and retrieval of batches.

Adding stock creates a new batch record, not updating existing product purchase price.

When quantity is consumed, it is deducted from the earliest batch with remaining quantity.
System must show correct remaining qty per batch after sales.
Product total quantity updates correctly as the sum of batch qtys.
UI displays all batches for each product.
No overwrite of older purchase prices when new vendor stock arrives.
Batch history visible (who created, when).
API responses follow consistent schema.

Add

Subtasks 8 (2 open6 closed)

Feature #5399: Create Stock Batch Schema & EndpointsClosedTeja Sriram Sangani11/29/202511/29/2025

Delete link to subtaskActions
Feature #5401: API to List Batches for a ProductClosedTeja Sriram Sangani12/10/202512/10/2025

Delete link to subtaskActions
Feature #5405: API Validation & Error HandlingClosedTeja Sriram Sangani11/28/202511/28/2025

Delete link to subtaskActions
Feature #5406: Integrate the Vendor invoice list api with accordion UIRejectedDivya Inapakurthi12/29/202512/29/2025

Delete link to subtaskActions
Feature #5407: UI – Product Batch List Table in the product details page ResolvedSravani Rangannapalem12/29/202512/29/2025

Delete link to subtaskActions
Feature #5408: UI – Update Product Detail SummaryClosedSai Priyatham Sadineni12/01/202512/01/2025

Delete link to subtaskActions
Feature #5409: UI – Sale/Order/Invoice Flow Batch Allocation ViewClosedTeja Sriram Sangani12/01/202512/01/2025

Delete link to subtaskActions
Feature #5410: UI – Payment History In Vendor Invoice ResolvedSravani Rangannapalem12/01/202512/22/2025

Delete link to subtaskActions

Add

Related issues

Actions #1

Updated by Yalavarthi Thriveni 2 months ago

  • Subtask #5399 added
Actions #2

Updated by Yalavarthi Thriveni 2 months ago

  • Subtask #5400 added
Actions #3

Updated by Yalavarthi Thriveni 2 months ago

  • Subtask #5401 added
Actions #4

Updated by Yalavarthi Thriveni 2 months ago

  • Subtask #5402 added
Actions #5

Updated by Yalavarthi Thriveni 2 months ago

  • Subtask #5403 added
Actions #6

Updated by Yalavarthi Thriveni 2 months ago

  • Subtask #5405 added
Actions #7

Updated by Yalavarthi Thriveni 2 months ago

  • Subtask #5406 added
Actions #8

Updated by Yalavarthi Thriveni 2 months ago

  • Subtask #5407 added
Actions #9

Updated by Yalavarthi Thriveni 2 months ago

  • Subtask #5408 added
Actions #10

Updated by Yalavarthi Thriveni 2 months ago

  • Subtask #5409 added
Actions #11

Updated by Yalavarthi Thriveni 2 months ago

  • Subtask #5410 added
Actions #12

Updated by Yalavarthi Thriveni about 2 months ago

  • Subtask deleted (#5402)
Actions #13

Updated by Yalavarthi Thriveni about 2 months ago

  • Assignee set to Yalavarthi Thriveni
  • Target version changed from Sprint 1 to Sprint2(12/08/2025 - 12/19/2025)
Actions #14

Updated by Yalavarthi Thriveni about 1 month ago

  • Target version changed from Sprint2(12/08/2025 - 12/19/2025) to sprint3(12/22/2025 - 01/02/2025)
Actions #15

Updated by Yalavarthi Thriveni 24 days ago

  • Target version changed from sprint3(12/22/2025 - 01/02/2025) to Sprint4 (01/05/2025 - 01/16/2025)
Actions #16

Updated by Yalavarthi Thriveni 24 days ago

  • Subtask deleted (#5400)
Actions #17

Updated by Yalavarthi Thriveni 24 days ago

  • Subtask deleted (#5403)
Edit Copy Actions

Also available in: Atom PDF