Subversion Repositories SmartDukaan
(root)//trunk/profitmandi-dao/src/main/resources/sql/backfill_receipt_origin_20260918.sql – Rev 37713
Directory listing | Details | Blame | View Log | RSS feed
Last modification
- Rev 37713 – 20 d 4 h
- Author: amit
- Log message:
- fix(warehouse): record the order's own vendor when a receipt line carries no origin
- r37694 took the origin only from lineitem.origin_vendor_id, which exists on orders raised from that revision onward, so goods arriving on older open orders landed with a cost but no vendor - 282 rows on the first day
- A purchase from an outside vendor now falls back to that supplier; internal movements are unchanged and an unknowable origin still stays NULL
- sql/backfill_receipt_origin_20260918.sql repairs the 282 already received (run on prod 2026-09-18; bak warehouse._bak_receipt_origin_20260918); in-stock unknown 895 -> 648
