clientflow_backend/VERSION_NOTES_v4926_6_3.md

v4926.6.3 — Jasmin opportunity item price upsert hotfix

Fixes re-import/backfill of Jasmin quotation details when an opportunity item already exists from a previous import with zero values.

Changes

• Updates existing opportunity_items matched by:
  • metadata->>'source_system' = 'jasmin'
  • metadata->>'source_document'
  • metadata->>'source_line_id'
• Rewrites quantity, unit_price, and total_price using current Jasmin line values.
• Merges metadata with price_source = jasmin_document_line.
• Keeps rejected/cancelled items rejected/cancelled.
• Makes jasmin_lines_imported count updated lines as well as newly inserted lines.

Expected for ORC.ORC2026.156 after rerun

• opportunities.value_amount = 244.77
• commercial_documents.amount = 199.00
• commercial_documents.total_amount = 244.77
• commercial_document_lines.unit_price = 199.00
• commercial_document_lines.total_amount = 244.77
• opportunity_items.unit_price = 199.00
• opportunity_items.total_price = 244.77