Bug 621 - Database Error Occurs When Updating Product Selling Price with a Large Numeric Value
Summary: Database Error Occurs When Updating Product Selling Price with a Large Numeri...
Status: OPEN
Alias: None
Product: Smartwas
Classification: Unclassified
Component: Master Data (show other bugs)
Version: unspecified
Hardware: PC Windows
: Normal Medium
Assignee: Arun (Arun)
URL:
Depends on:
Blocks:
 
Reported: 2026-10-29 16:53 UTC by Raghul (Raghul)
Modified: 2026-10-29 16:53 UTC (History)
0 users

See Also:
Associated Test Case ID:
Triaged By: ---
Root Cause Analysis (RCA):
Resolution Summary / Fix Details:
Impact Area:


Attachments
Database Error Occurs When Updating Product Selling Price with a Large Numeric Value (240.91 KB, image/png)
2026-10-29 16:53 UTC, Raghul (Raghul)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Raghul (Raghul) 2026-10-29 16:53:04 UTC
Created attachment 460 [details]
Database Error Occurs When Updating Product Selling Price with a Large Numeric Value

In Master Data → Product, when the user opens an existing product and attempts to update the selling price with an excessively large numeric value, the application fails to save the price and displays a database error: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'selling_price' at row 1. The application does not validate the maximum permitted selling price before submitting the data.