Evergreen farms (pos)

• Reviewed the existing Vendor Details page and analysed how product, variant, stock batch and vendor invoice data is stored for each vendor.
• Modified the Products section in the admin Vendor Details screen, keeping the existing columns and adding a Purchased Qty column.
• Added a dropdown for each product showing its variants with SKU, purchased qty, sold/used qty, qty left, current stock and purchase price.
• Displayed the latest purchase price paid to the vendor along with the average price, and used a labelled catalog price when no purchase price is recorded.
• Updated the vendor history API to combine stock batches, vendor invoice lines, opening stock and old stock records so older data is not missed.
• Added handling to avoid double counting stock and to exclude expected stock and batches cleared after draft invoice deletion.
• Added unit tests for the new logic; all 13 tests and the production build are passing.
• Identified an issue where creating a vendor invoice appears to overwrite the variant selling price with the unit cost; this needs confirmation on real data and has not been fixed yet.
• Pending: testing with real vendor data, confirming the selling qty and opening stock rules, and committing and deploying the frontend and backend.