Support #11004
openUpgrade Vendor Purchase Order & Batch Stocking API
Status:
Resolved
Priority:
Normal
Assignee:
Target version:
Start date:
09/22/2026
Due date:
09/30/2026 (5 days late)
% Done:
90%
Estimated time:
24:00 h
Spent time:
Description
Capture MFD, Expiry Date, Batch Number, and Bin Location during inbound inventory entry.
Warehouse stock ledger tracks quantities grouped by Batch ID and Expiry Date.
Subtasks
Related issues
Updated by Yalavarthi Thriveni 13 days ago
- Subject changed from Maintain Manufacturing Date (MFD), Expiration Date (EXP), supplier warranty at the time of vendor purchase with different bar code label generation per variants if product as multiple variants to Upgrade Vendor Purchase Order & Batch Stocking API
- Description updated (diff)
Updated by Yalavarthi Thriveni 8 days ago
- Parent task changed from #10821 to #11096
Updated by Yalavarthi Thriveni 8 days ago
- Parent task changed from #11096 to #10821
Updated by Yalavarthi Thriveni 8 days ago
- Parent task changed from #10821 to #11096
Updated by Yalavarthi Thriveni 8 days ago
- Target version set to Sprint (09/28/2026 - 10/02/2026)
Updated by Yalavarthi Thriveni 8 days ago
- Due date set to 09/30/2026
- Estimated time set to 24:00 h
Updated by Teja Sriram Sangani 7 days ago
- Status changed from New to In Progress
- % Done changed from 0 to 20
- Performed R&D on the current Vendor Invoice AI extraction and product-matching flow.
- Analyzed the possibility of selecting or creating product variants from extracted invoice line items.
- Identified that the current Create Product flow opens a basic modal instead of the existing full Create Product screen.
- Reviewed the changes required to connect invoice product creation with the actual Create Product screen and variant matrix.
- Analyzed the impact of adding variant/SKU information to the invoice extraction and product mapping process.
- Reviewed the impact on Stock Batch and inventory updates, since stock is currently maintained only at the parent product level.
- Analyzed the possible impact on POS inventory and identified the required changes for supporting variant-level stock without affecting existing products.
Updated by Teja Sriram Sangani 4 days ago
- % Done changed from 20 to 70
- Implemented variant-specific stock management with variant ID, SKU, title, attributes, stock updates, and FIFO batch tracking.
- Added detailed stock-in audit history with variant information, box quantity, and received units.
- Enhanced vendor invoice product search and selection to support product names, variant SKUs, and variant titles.
- Added inline product/variant switching, variant badges, and active-variant filtering in the vendor invoice flow.
- Fixed unmatched product card cleanup and improved variant matrix handling to include only enabled variants.
- Fixed Each Box Price calculation and added dynamic recalculation between Weight, Price/Unit, and Each Box Price, with support for higher-value transactions.
- Added calculated box price display to unmatched product cards and improved invoice pricing consistency.
- Added stock batch expiry date to the API and Product Purchase Information table, including formatted dates and an Expired status badge.
Updated by Teja Sriram Sangani 3 days ago
- % Done changed from 70 to 90
- Updated product expiry type handling to fetch and assign the correct expiry type from the product category on the Create Vendor Invoice screen.
- Enhanced backend product retrieval to include category name and expiry type, with a default expiry type of "Date" when not configured.
- Updated frontend category matching to support case-insensitive category ID and name matching.
- Fixed the Vendor Invoice date filter to use `createdAt` instead of `dueDate` for start and end date filtering.
- Updated invoice filtering to ensure pagination, statistics, and vendor totals reflect the selected invoice creation date range.
- Added an Expire Date column to the expanded invoice products table.
- Updated the expiry date display to use the invoice item expiry date or product expiry date, with an N/A fallback when unavailable.
- Added support for displaying expiry type labels where applicable.
- Updated backend product population to include `expiryDate` and `expiryType`.
- Updated Vendor Invoice TypeScript definitions to include `expiryDate`, `expiryType`, `expiryDays`, and `variantTitle`.
- Ran the frontend production build and verified that it completed successfully with zero errors.
Updated by Teja Sriram Sangani about 14 hours ago
- Status changed from In Progress to Resolved