Bug 621

Summary: Database Error Occurs When Updating Product Selling Price with a Large Numeric Value
Product: Smartwas Reporter: Raghul (Raghul)
Component: Master DataAssignee: Arun (Arun)
Status: OPEN ---    
Severity: Medium    
Priority: Normal    
Version: unspecified   
Hardware: PC   
OS: Windows   
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

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.