SELECT * FROM `crm_stock_ledger` WHERE `transaction_date` > '2019-05-04' AND product_id=3203
15 ENTRIES
COST RATE=4867.873
UPDATE `crm_stock_ledger` SET cost_rate="4707.34" WHERE `transaction_date` > '2019-05-04' AND product_id=3203
Part number: ENV-HVD5F-30R-20
product id: 3203
In store rate is: 6057.776
changed to 4707.34