25 lines
1022 B
Markdown
25 lines
1022 B
Markdown
# 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`
|